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, Q3/2026 Server Development, Q4/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.
      not to be implemented in the step1 - the Schema related methods and the data functions (ExistsNode, Extract, GetCLOB/BLOB)

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 29d
                  29d
                  Remaining:
                  Time Spent - 27d 3h Remaining Estimate - 1.5d
                  1.5d
                  Logged:
                  Time Spent - 27d 3h Remaining Estimate - 1.5d Time Not Required
                  27d 3h

                  Git Integration

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