Skip to content
New issue

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

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

Already on GitHub? # to your account

[BUG] JSQLParser 4.9 : MySQL 8.0 : unable to parse: ALTER TABLE ... ADD INDEX #2122

Open
sachandrasekaran opened this issue Dec 12, 2024 · 2 comments
Labels
DDL DDL statement related MySQL MySQL specific issue Sponsor needed

Comments

@sachandrasekaran
Copy link

Always check against the Latest SNAPSHOT of JSQLParser and the Syntax Diagram

Failing SQL Feature:

  • unable to parse: ALTER TABLE .. ADD INDEX fAdd for composite index
  • Example: ADD INDEX fAdd ((b + c)) , ADD INDEX fCoalesce ((COALESCE(PK, b)))

SQL Example:

  • Simplified Query Example, focusing on the failing feature

ADD INDEX fAdd ((b + c)),
ADD INDEX fCoalesce ((COALESCE(PK, b)));
```

Software Information:

  • JSqlParser 4.9
  • Database (MySql 8.0)

Tips:

Please write in English and avoid Screenshots (as we can't copy and paste content from it).
Try your example online with the latest JSQLParser and share the link in the error report.
stacktrace.txt

Do provide Links or References to the specific Grammar and Syntax you are trying to use.

@sachandrasekaran
Copy link
Author

Parser issue SQL -

ALTER TABLE PPK_OLPN
ADD INDEX fAdd ((b + c)),
ADD INDEX fCoalesce ((COALESCE(PK, b)));

@sachandrasekaran
Copy link
Author

@manticore-projects manticore-projects added MySQL MySQL specific issue DDL DDL statement related Sponsor needed labels Dec 12, 2024
# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
DDL DDL statement related MySQL MySQL specific issue Sponsor needed
Projects
None yet
Development

No branches or pull requests

2 participants