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

Description

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.