[MDEV-20033] sql_mode="oracle" does not support INSERT INTO ... RETURNING - Jira

Details

Type: Technical task
Status: Closed (View Workflow)
Priority: Major
Resolution: Duplicate
Affects Version/s: None
Fix Version/s: N/A
Component/s: Data Manipulation - Insert
Labels:
- Compatibility

Description

This is commonly used in Oracle PL/SQL code to return a value from the INSERT, UPDATE & DELETE statements.

Oracle Doc: https://docs.oracle.com/cd/B28359_01/appdev.111/b28370/returninginto_clause.htm#LNPLS01354
and
https://docs.oracle.com/cd/B12037_01/appdev.101/b10807/13_elems025.htm

Attachments

Issue Links

duplicates

MDEV-10014 Add RETURNING to INSERT

Closed

relates to

MDEV-5092 Implement UPDATE with result set

In Review

MDEV-12326 Implement multiple-table UPDATE/DELETE returning a result set

Open

MDEV-3814 Implement DELETE with result set (mwl #205)

Closed

Activity

Ascending order - Click to sort in descending order

Faisal Saeed (Inactive) created issue - 2019-07-10 17:24

Vicențiu Ciorbaru made changes - 2019-07-10 19:51

Field	Original Value	New Value
Link		This issue relates to ~~MDEV-10014~~ [ ~~MDEV-10014~~ ]

Alexander Barkov made changes - 2019-09-10 04:24

Labels

Compatibility

Faisal Saeed (Inactive) made changes - 2019-09-23 16:47

Description

This is commonly used in Oracle PL/SQL code to return a value from the INSERT statement.

Oracle Doc: https://docs.oracle.com/cd/B12037_01/appdev.101/b10807/13_elems025.htm

This is commonly used in Oracle PL/SQL code to return a value from the INSERT, UPDATE & DELETE statements.

Oracle Doc: https://docs.oracle.com/cd/B28359_01/appdev.111/b28370/returninginto_clause.htm#LNPLS01354
and
https://docs.oracle.com/cd/B12037_01/appdev.101/b10807/13_elems025.htm

Sergei Golubchik made changes - 2019-09-24 15:31

Component/s		Data Manipulation - Insert [ 10101 ]
Fix Version/s		N/A [ 14700 ]
Resolution		Duplicate [ 3 ]
Status	Open [ 1 ]	Closed [ 6 ]