grammars-v4 icon indicating copy to clipboard operation
grammars-v4 copied to clipboard

[MySQL] Unable to handle VALUES ROW()

Open OnMYLai opened this issue 10 months ago • 1 comments

Following the MySQL doc on insert statement to test with sql:

INSERT INTO abc (a,b,c) VALUES ROW(1,2,3), ROW(4,5,6), ROW(7,8,9)

and the parser threw out error:

line 1:31 no viable alternative at input 'INSERT INTO abc (a,b,c) VALUES ROW'

Trimmed the sql down to only the values part following MySQL doc:

VALUES ROW(1,2,3)

and similar error message occur:

line 1:7 no viable alternative at input 'VALUES ROW'

The one I tested with is the Positive-Technologies one, but judging from the valueList rule on the Oracle one I suspect that would have similar issue.

OnMYLai avatar Dec 30 '24 04:12 OnMYLai