Description

ZhengguanLi

opened on May 4, 2023

Issue body actions

Hello,

We are using JSqlParser to parse Oracle PL/SQL statement, and the statement with returning ... into ... can't be parsed. For example: begin insert into table (col1) values (sysdate) returning id into new_id; commit; end. Please add support of RETURNING INTO clause in INSERT/UPDATE/DELETE statement.

Encountered unexpected token: "into" "INTO"
    at line 1, column 57.

Was expecting one of:
    "&"
    "::"
    "<<"
    ">>"
    "["
    "^"
    "|"
    "<ST_SEMICOLON>"

Activity

1. manticore-projects commented on May 4, 2023

   

   manticore-projects

   on May 4, 2023

   Contributor

   More actions

   Greetings.

   INSERT INTO ... RETURNING ... is actually supported but without the the Oracle specific RETURNING ... INTO ....
   I will add it.

   Reacted by ZHENGGUAN LI
2. manticore-projects

   self-assigned this

   on May 4, 2023
3. manticore-projects

   added

   bug

   on May 4, 2023
4. ZhengguanLi commented on May 11, 2023

   

   ZhengguanLi

   on May 11, 2023

   Author

   More actions

   Do we have a rough date on when this feature can be added or which version? Thanks!
5. manticore-projects commented on May 11, 2023

   

   manticore-projects

   on May 11, 2023

   Contributor

   More actions

   Tomorrow evening, Version 5.0 SNAPSHOT.
6. manticore-projects

   added a commit that references this issue on May 16, 2023

   refactor: RETURNING clause

   This issue will close once commit 4fb1cfb is merged into the 'master' branch.

   4fb1cfb
7. manticore-projects commented on May 16, 2023

   

   manticore-projects

   on May 16, 2023

   Contributor

   More actions

   Done via 4fb1cfb with PR #1778
8. manticore-projects

   closed this as completedin 41b6fceon Jun 1, 2023
9. manticore-projects

   closed this as completedin #1778on Jun 1, 2023
10. manticore-projects

    added a commit that references this issue on Jun 15, 2023

    Assorted Fixes #8 (#1807)

    This issue will close once commit a815f5f is merged into the 'master' branch.

    a815f5f
11. manticore-projects

    added a commit that references this issue on Jun 27, 2023

    Backslash Quotation of Single-Quote `'\\''` (#1813)

    This issue will close once commit c79dfff is merged into the 'master' branch.

    c79dfff

Issue actions