[MDEV-20658] sql_mode=oracle does not support XMLAGG(), XMLELEMENT() and EXTRACT() XML functions - Jira

XML

Word

Printable

Details

Type: Epic
Status: Open (View Workflow)
Priority: Critical
Resolution: Unresolved
Affects Version/s: None
Fix Version/s: 14.0
Component/s: XML Functions
Labels:
- Compatibility
- Oracle

Epic Name:
sql_mode=oracle does not support XMLAGG(), XMLELEMENT() and EXTRACT() XML functions
Sprint:
Q1/2027 Server Development
PM Planning:

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

Attachments

Issue Links

is blocked by

MDEV-38691 XMLTYPE: methods - final step

Open

is part of

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

Open

split from

MDEV-41618 Oracle mode: XMLELEMENT() (phase 1 of MDEV-20658)

Open

MDEV-41619 Oracle mode: XMLAGG() (phase 2 of MDEV-20658)

Open

MDEV-41620 Oracle mode: EXTRACT() / XMLTYPE.extract() (phase 3 of MDEV-20658)

Open

Activity

People

Assignee:: Alexey Botchkov

Reporter:: Faisal Saeed (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 7 Start watching this issue

Dates

Created:: 2019-09-24 16:18

Updated:: 2026-10-19 12:03

Time Tracking

Estimated:

Remaining:

Logged:

Not Specified

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.