Some basic datatypes and functions in oracle compatibility mode do not work (MDEV-19162)

[MDEV-20033] sql_mode="oracle" does not support INSERT INTO ... RETURNING Created: 2019-07-10  Updated: 2023-10-18  Resolved: 2019-09-24

Status: Closed
Project: MariaDB Server
Component/s: Data Manipulation - Insert
Affects Version/s: None
Fix Version/s: N/A

Type: Technical task Priority: Major
Reporter: Faisal Saeed (Inactive) Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: Compatibility

Issue Links:
Duplicate
duplicates MDEV-10014 Add RETURNING to INSERT Closed
Relates
relates to MDEV-5092 Implement UPDATE with result set In Review
relates to MDEV-12326 Implement multiple-table UPDATE/DELET... Open
relates to MDEV-3814 Implement DELETE with result set (mwl... Closed

 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
Generated at Thu Feb 08 08:56:13 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.