JSqlParser icon indicating copy to clipboard operation
JSqlParser copied to clipboard

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

Open qiuchsh opened this issue 2 years ago • 3 comments

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.

qiuchsh avatar Apr 01 '23 05:04 qiuchsh

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 avatar Apr 01 '23 08:04 manticore-projects

Duplicate #1693

manticore-projects avatar Apr 30 '23 14:04 manticore-projects

support it now? or not?

szx1 avatar May 21 '24 02:05 szx1