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

[MDEV-19148] sql_mode="oracle" does not support xmltype data type Created: 2019-04-02  Updated: 2019-07-10

Status: Open
Project: MariaDB Server
Component/s: Data types
Affects Version/s: None
Fix Version/s: None

Type: Technical task Priority: Major
Reporter: Manjot Singh (Inactive) Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: Compatibility


 Description   

xmltype should become longtext

MariaDB [test]> CREATE TABLE warehouses(
 
    ->   warehouse_id NUMBER(3),
 
    ->   warehouse_spec XMLTYPE,
 
    ->   warehouse_name VARCHAR2(35),
 
    ->   location_id NUMBER(4));
 
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'XMLTYPE,
 
  warehouse_name VARCHAR2(35),
 
  location_id NUMBER(4))' at line 3

XML related functions need to be available to support Oracle Migrations

SELECT RTRIM (XMLAGG (XMLELEMENT(e, stn.DOP || ' ')  ORDER BY stn.dop).EXTRACT ('//text()'), ',') AS dop FROM Tab;

Oracle Docs:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions215.htm
https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions220.htm
Generated at Thu Feb 08 08:49:25 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.