[BUG] JSQLParser Version 4.6: RDBMS ORACLE : Encountered unexpected token: "INTO" "INTO"

qiuchsh commented 1 year ago

Always check against the Latest SNAPSHOT of JSQLParser and the Syntax Diagram

Failing SQL Feature:

Brief description of the failing SQL feature
Encountered unexpected token: "INTO" "INTO"

SQL Example:

Simplified Query Example, focusing on the failing feature

-- Replace with your ACTUAL example
INSERT ALL INTO t_test(c0, c1, c2) VALUES (?, ?, ?) SELECT 1 FROM dual

Software Information:

JSqlParser version is 4.6
Database is ORACLE
Tips:

Please write in English and avoid Screenshots (as we can't copy and paste content from it). Try your example online with the latest JSQLParser and share the link in the error report. Do provide Links or References to the specific Grammar and Syntax you are trying to use.

manticore-projects commented 1 year ago

Greetings.

Oracle INSERT ALL ... is not supported. I have planned implementation, but stopped working on it since the syntax is weird and off standard and rarely used.

You can provide and sponsor an implementation though.

manticore-projects commented 1 year ago

Duplicate #1693

szx1 commented 5 months ago

support it now? or not?

JSQLParser / JSqlParser