Support "RETURNING INTO" part of Insert/Update/Delete statement

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>"

Greetings.

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

Do we have a rough date on when this feature can be added or which version? Thanks!

Tomorrow evening, Version 5.0 SNAPSHOT.

refactor: RETURNING clause

Done via 4fb1cfb with PR #1778

Assorted Fixes #8 (#1807)

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

Navigation Menu

Repository navigation

Support "RETURNING INTO" part of Insert/Update/Delete statement #1780

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Support "RETURNING INTO" part of Insert/Update/Delete statement #1780

Description

Activity

manticore-projects commented on May 4, 2023

ZhengguanLi commented on May 11, 2023

manticore-projects commented on May 11, 2023

manticore-projects commented on May 16, 2023

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions