Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Dump indexes in create_table for generates SQL in one query #23557

Conversation

kamipo
Copy link
Member

@kamipo kamipo commented Feb 8, 2016

Reopen #19994.
#19994 was reverted by d666a5a after beta2 for indexing materialized views.

(See scenic-views/scenic#135 in https://github.com/thoughtbot/scenic)
This PR keeps the old behavior method to address to scenic-views/scenic#135.

By this PR, it generates SQL in one query for each tables in MySQL (related with #20009).

@rails-bot
Copy link

r? @pixeltrix

(@rails-bot has picked a reviewer for you, use r? to override)

@kamipo kamipo force-pushed the dump_indexes_in_create_for_generates_sql_in_one_query branch 4 times, most recently from ab68a2c to 156879c Compare February 13, 2016 20:21
@kamipo
Copy link
Member Author

kamipo commented Feb 13, 2016

r? @jeremy

@rails-bot rails-bot assigned jeremy and unassigned pixeltrix Feb 13, 2016
@kamipo kamipo force-pushed the dump_indexes_in_create_for_generates_sql_in_one_query branch 3 times, most recently from b29f568 to 16c547b Compare February 18, 2016 03:12
@kamipo
Copy link
Member Author

kamipo commented Feb 19, 2016

r? @sgrif

@rails-bot rails-bot assigned sgrif and unassigned jeremy Feb 19, 2016
@kamipo kamipo force-pushed the dump_indexes_in_create_for_generates_sql_in_one_query branch 3 times, most recently from ab0e89c to b8f213a Compare March 2, 2016 00:42
@kamipo kamipo force-pushed the dump_indexes_in_create_for_generates_sql_in_one_query branch from b8f213a to 6847740 Compare March 12, 2016 09:30
@kamipo kamipo force-pushed the dump_indexes_in_create_for_generates_sql_in_one_query branch from 6847740 to 8be8684 Compare April 5, 2016 14:08
@kamipo kamipo force-pushed the dump_indexes_in_create_for_generates_sql_in_one_query branch from 8be8684 to 616947f Compare April 14, 2016 03:43
@jeremy
Copy link
Member

jeremy commented Apr 19, 2016

This looks to me. Rebase master?

@kamipo kamipo force-pushed the dump_indexes_in_create_for_generates_sql_in_one_query branch from 616947f to 2c5cebf Compare April 19, 2016 08:10
@kamipo
Copy link
Member Author

kamipo commented Apr 19, 2016

Rebased on master!

@kamipo kamipo force-pushed the dump_indexes_in_create_for_generates_sql_in_one_query branch from 2c5cebf to d1f3e19 Compare April 19, 2016 22:03
If the adapter supports indexes in create table, it generates SQL
in one query.
@kamipo kamipo force-pushed the dump_indexes_in_create_for_generates_sql_in_one_query branch from d1f3e19 to 74b5112 Compare April 20, 2016 01:24
@jeremy jeremy merged commit 74b5112 into rails:master Apr 20, 2016
jeremy added a commit that referenced this pull request Apr 20, 2016
…rates_sql_in_one_query

Dump indexes in `create_table` for generates SQL in one query
@jeremy jeremy added this to the 5.0.0 milestone Apr 20, 2016
@kamipo kamipo deleted the dump_indexes_in_create_for_generates_sql_in_one_query branch April 20, 2016 19:53
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging this pull request may close these issues.

None yet

6 participants