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.

Sign up for GitHub

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

Jump to bottom

Error while dropping and adding the same index #50

Open
isgroup-srl opened this issue Dec 21, 2016 · 0 comments
Open

Error while dropping and adding the same index #50

isgroup-srl opened this issue Dec 21, 2016 · 0 comments

Comments

@isgroup-srl
Copy link

isgroup-srl commented Dec 21, 2016 •
edited
Loading

Dropping and adding the same index should happen in two separated queries.

Example:

ALTER TABLE `x` [..], DROP INDEX `y` ON `x`;

ALTER TABLE `x` ADD INDEX `y` (`k`) USING BTREE;

Plus, there should not be the ON clause #49.
stephenreay added a commit to Koalephant/SchemaObject that referenced this issue Oct 28, 2017
@stephenreay
Fix dropping indexes
da029de 
Indexes dropped from an ALTER TABLE statement don't use the `ON` clause.
This should fix mmatuson/SchemaSync#49 mmatuson/SchemaSync#50 and mmatuson/SchemaSync#51
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@isgroup-srl