[BUG] 4.7: MySQL : Alter Add Key Encountered unexpected token: "comment" "COMMENT"

[linux2014linux]

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

Failing SQL Feature:

  net.sf.jsqlparser.JSQLParserException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "comment" "COMMENT"
    at line 1, column 51.

Was expecting one of:

    ","
    "DEFERRABLE"
    "DISABLE"
    "ENABLE"
    "NOT"
    "NOVALIDATE"
    "USING"
    "VALIDATE"
    <EOF>
    <ST_SEMICOLON>


	at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:315)
	at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:116)
	at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:85)
	at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:62)

SQL Example:

    alter table `student` add key `idx_name` (`name`) comment 'index name';

Software Information:

• JSqlParser version 4.7
• MySQL

[linux2014linux]

@manticore-projects @jxnu-liguobin Release 4.7 still don't parse sql:

    alter table `student` add key `idx_name` (`name`) comment 'index name';

[manticore-projects]

The changes and improvements are in JSQLParser 4.8 SNAPSHOT only and I would like to advise to use the snapshot version.

[linux2014linux]

The changes and improvements are in JSQLParser 4.8 SNAPSHOT only and I would like to advise to use the snapshot version.

Ok, I should use it which mvn version.

[manticore-projects]

Ok, I should use it which mvn version.

Unfortunately there is still no Maven Snapshot published (since @wumpz has time constraints).
But you can download the SNAPSHOT JAR file from here: https://manticore-projects.com/JSQLParser/index.html