Repository navigation
[BUG] 4.7: MySQL : Alter Add Key Encountered unexpected token: "comment" "COMMENT" #1906
Description
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
Activity
Closed JSQLParser#1906, Add `COMMENT` for `ALTER ADD` and format jjt …
Closed JSQLParser#1906, Add `COMMENT` for `ALTER ADD` and format jjt …
Fix: [MySQL] Add `COMMENT` for `ALTER ADD` (#1919)
linux2014linux commentedon Dec 19, 2023
@manticore-projects @jxnu-liguobin Release 4.7 still don't parse sql:
manticore-projects commentedon Dec 19, 2023
The changes and improvements are in
JSQLParser 4.8 SNAPSHOTonly and I would like to advise to use the snapshot version.linux2014linux commentedon Dec 19, 2023
Ok, I should use it which mvn version.
manticore-projects commentedon Dec 19, 2023
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