Repository navigation
SET clause with alias not parsed #1314
Description
Activity
Greetings.
the
as new(m, n, p,)is MySQL specific and not supported.
Please see the allowed/understood syntax here: http://217.160.215.75:8080/jsqlformatter/_static/railroad_diagram.xhtml#Update@manticore-projects I retested the exact statement from this issue on master
6c726d88, and it now parses and round-trips successfully:INSERT INTO t1 SET a=1,b=2,c=3 AS new(m,n,p) ON DUPLICATE KEY UPDATE c = m+n;
Row-alias support was added in #2383. The resulting
Inserthas three SET assignments,getRowAlias().getName() == "new", alias columnsm, n, p, and one duplicate-key update assignment. BothtoString()andStatementDeParserpreserve the alias and update expression, and their output reparses with the same fields.I checked default parsing and
withUnsupportedStatements(false). Related regression coverage is in InsertTest's row-alias and SET/deparser tests, and the full Gradlecheckpassed.This appears resolved for the reported syntax. Could you consider closing it if there are no remaining failing examples on master?
Reacted by manticore-projects
Describe the bug
I found this query in the MySQL 8.0 Reference Manual page 2678
To Reproduce
1.
INSERT INTO t1 SET a=1,b=2,c=3 AS new(m,n,p) ON DUPLICATE KEY UPDATE c = m+n;2.
CCJSqlParserUtil.parse(query)3. Exception:
Expected behavior
I expected example queries from the MySQL manual to be parsed correctly.
System