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

Drop index syntax error #51

Open
cpd1992 opened this issue Dec 27, 2016 · 0 comments
Open

Drop index syntax error #51

cpd1992 opened this issue Dec 27, 2016 · 0 comments

Comments

@cpd1992
Copy link

cpd1992 commented Dec 27, 2016

I have found a bug while i drop a index
The patch .sql show the SQL is ALTER TABLE table_name DROP INDEX index_name ON table_name;
I think the correct SQL is ALTER TABLE table_name DROP INDEX index_name
Can anybody repair this issues?
Thanks a lot!
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
@cpd1992