Details
-
New Feature
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
Q1/2026 Server Development
Description
XMLTYPE is use by Oracle for implementing XML database functions. One option is to mimic what Oracle has exactly. Another way is to implement minimal support in the server itself and provide additional features in a stored procedure package. Oracle 19 feature list is here: https://docs.oracle.com/en/database/oracle/oracle-database/19/arpls/XMLTYPE.html
This task is about implementing XMLTYPE methods, the syntax like xmltype_expression.extract(), for example
select xmlelement(e, ename).extract ('//text()') from emp; |
Members and static routines supported by XMLType in Oracle:
Member functions:
- createNonSchemaBasedXML
- createSchemaBasedXML
- existsNode
- extract
- getBlobVal
- getClobVal
- getNamespace
- getNumberVal
- getRootElement
- getSchemaURL
- getStringVal
- isFragment
- isSchemaBased
- isSchemaValid
- isSchemaValidated
- transform
Member procedures:
- schemaValidate
- setSchemaValidated
- toObject
Constructors:
- XMLType
Static functions:
- createXML
As the Step 1 the Member functions, Constructors and the Static functions to be implemented.
Attachments
Issue Links
- blocks
-
MDEV-20658 sql_mode=oracle does not support XMLAGG(), XMLELEMENT() and EXTRACT() XML functions
-
- Open
-
-
MDEV-38690 XMLTYPE: methods - step 2
-
- Open
-
- is blocked by
-
MDEV-37261 Basic XML data type
-
- Closed
-
-
MDEV-37262 XMLTYPE: validation
-
- In Progress
-
- split to
-
MDEV-38690 XMLTYPE: methods - step 2
-
- Open
-
-
MDEV-38691 XMLTYPE: methods - step 3
-
- Open
-