Repository navigation
Failed to parse SQL Server ddl (alter table a_test add c1 int, c2 int, c3 int) #1651
Description
An error is reported when calling （the public static Statement parse(String sql, Consumer consumer) ）method
net.sf.jsqlparser.JSQLParserException: Encountered unexpected token: "c2" <S_IDENTIFIER>
at line 1, column 31.
Was expecting one of:
"ADD"
"ALGORITHM"
"ALTER"
"CHANGE"
"COMMENT"
"DROP"
"MODIFY"
"RENAME"
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:190)
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:63)
Activity
manticore-projects commentedon Oct 24, 2022
Greetings.
The supported
ALTER TABLEsyntax is shown here: https://manticore-projects.com/JSQLParser/_static/JSqlParserCC.xhtml#AlterExpressionIf you wanted to used multiple
ALTER EXPRESSIONs(which is supported), then you would comma-separate them and start each with the Command. E. g.manticore-projects commentedon Nov 12, 2022
No feedback and no further questions asked. Closed.