Skip to content

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

Open
@sachandrasekaran

Description

@sachandrasekaran

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions