Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-36261

XMLTYPE: methods - step 1

    XMLWordPrintable

Details

    • Q1/2026 Server Development, Q2/2026 Server Maintenance, Q2/2026 Server Development, Q3/2026 Server Maintenance

    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

          Activity

            People

              bar Alexander Barkov
              karlsson Anders Karlsson
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 25d Original Estimate - 25d
                  25d
                  Remaining:
                  Time Spent - 25d Remaining Estimate - 1d
                  1d
                  Logged:
                  Time Spent - 25d Remaining Estimate - 1d
                  25d

                  Git Integration

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