SET clause with alias not parsed

[rptr]

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:

net.sf.jsqlparser.JSQLParserException
	at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:65)
	at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:40)
	Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "AS" "AS"
    at line 1, column 32.
    Was expecting one of:
    "&"
    ","
    "::"
    ";"
    "<<"
    ">>"
    "COLLATE"
    "ON"
    "RETURNING"
    "["
    "^"
    "|"
    <EOF>

Expected behavior I expected example queries from the MySQL manual to be parsed correctly.

System

• MySQL
• Java 8 (OpenJDK)
• JSqlParser 4.1

[manticore-projects]

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