[#MDEV-29042] sql_mode ="oracle" does not support CREATE TYPE AS OBJECT/TABLE

Some basic datatypes and functions in oracle compatibility mode do not work (MDEV-19162) [MDEV-29042] sql_mode ="oracle" does not support CREATE TYPE AS OBJECT/TABLE Created: 2022-07-06 Updated: 2022-07-06
Status:	Open
Project:	MariaDB Server
Component/s:	None
Affects Version/s:	None
Fix Version/s:	None

Type:

Technical task

Priority:

Major

Reporter:

Faisal Saeed (Inactive)

Assignee:

Unassigned

Resolution:

Unresolved

Votes:

Labels:

Oracle, oracle

Description

Users can create user-defined data types/structures as OBJECT or a TABLE in "CREATE TYPE AS OBJECT, CREATE TYPE AS TABLE", this is required by some teams doing Migration from Oracle to MariaDB.

https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_8001.htm#:~:text=Use%20the%20CREATE%20TYPE%20statement,the%20CREATE%20TYPE%20BODY%20statements.

Generated at Thu Feb 08 10:05:26 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.

[MDEV-29042] sql_mode ="oracle" does not support CREATE TYPE AS OBJECT/TABLE Created: 2022-07-06 Updated: 2022-07-06