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

[MDEV-20658] sql_mode=oracle does not support XMLAGG(), XMLELEMENT() and EXTRACT() XML functions Created: 2019-09-24  Updated: 2019-09-24

Status: Open
Project: MariaDB Server
Component/s: XML Functions
Affects Version/s: None
Fix Version/s: None

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


 Description   

Most oracle applications use xml aggregation functions like XMLAGG() followed by identifying the XML elements XMLELEMENT() and then calling the EXTRACT() method to extract. This is important for Oracle migrations and is in use by many projects which are using XML in Oracle and are trying to Migrate to MariaDB.

select
 
   deptno,
 
   rtrim (xmlagg (xmlelement (e, ename || ',')).extract ('//text()'), ',') enames
 
from
 
   emp
 
group by
 
   deptno
 
;
 
 
 
    DEPTNO ENAMES                                 
---------- ----------------------------------------
 
        10 CLARK,MILLER,KING                      
        20 SMITH,FORD,ADAMS,SCOTT,JONES           
        30 ALLEN,JAMES,TURNER,BLAKE,MARTIN,WARD

Reference: http://www.dba-oracle.com/t_xmlagg.htm
Generated at Thu Feb 08 09:01:11 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.