grammars-v4
grammars-v4 copied to clipboard
[MySQL] Unable to handle VALUES ROW()
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.