Skip to content

/ JSqlParser

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

Jump to bottom

ALTER TABLE DROP FOREIGN KEY statement unable to parse #990

Open
pravari1 opened this issue Jun 10, 2020 · 0 comments
Open

ALTER TABLE DROP FOREIGN KEY statement unable to parse #990

pravari1 opened this issue Jun 10, 2020 · 0 comments

Comments

@pravari1
Copy link

@pravari1 pravari1 commented Jun 10, 2020 •
edited

Describe the bug
Unable to parse ALTER TABLE DROP FOREIGN KEY statement.

To Reproduce
Steps to reproduce the behavior:

  1. ALTER TABLE schema_name.table_name DROP FOREIGN KEY example_FK
  2. Parsing this SQL using JSqlParser with this statements
  3. Encountered unexpected token: "FOREIGN" "FOREIGN"
    at line 1, column 84.

Was expecting one of:

"COLUMN"
"CONSTRAINT"
"INDEX"
<S_IDENTIFIER>
<S_QUOTED_IDENTIFIER>

Expected behavior
Should be able to parse statement
System

  • MYSQL 5.7
  • Java 8
  • JSqlParser version 3.2
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
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant
@pravari1
You can’t perform that action at this time.