Details
-
New Feature
-
Status: In Testing (View Workflow)
-
Critical
-
Resolution: Unresolved
-
None
-
Q1/2026 Server Development, Q2/2026 Server Maintenance, Q2/2026 Server Development
Description
With MDEV-37261 we have implemented the XML Datatype.
We should implement the validation function XMLISVALID(string), which only checks if the string has a single root, closed tags, and proper nesting.
The overloaded function XMLISVALID(string,xml_schema) should additionally validate the. string against a XML Schema definition.
The xml_schema of XMLISVALID is either the schema text or the URL of the already registered schema. In this task we only implement textual schema's. Schema registering is for MDEV-39125.
As the complete XMLSchema standard compliance is to
big for a single task, below are limitations for this implementation:
NOT IMPLEMENTED:
- Including / inheriting other schemas.
tags:
<schema> | <include>
<schema> | <import>
<schema> | <redefine>
<schema> | <override> - Namespace control
attributes like:
<schema> | targetNamespace
<schema> | elementFormDefault
<schema> | attributeFormDefault
<schema> | blockDefault
<schema> | finalDefault
- complexContent not validated
- some basic types are not validated (just passed whatever there is)
<list>
<union>
anyURI
QName
NOTATION
normalizedString
language
NMTOKEN
- type facets are not validated. Things like number is too big or the
string is too long.
things like 'minInclusive', 'whiteSpace', 'pattern', 'minLength' etc..
- support global <element> index tags:
<key>
<keyref>
<unique>
Attachments
Issue Links
- causes
-
MDEV-40008 sql_error.cc:357: void Diagnostics_area::set_ok_status after CHECK (XMLISVALID..
-
- Open
-
-
MDEV-40013 Server crashes in XMLSchema_user_type::validate_prepare/XMLSchema_attribute::validate_prepare
-
- Open
-
-
MDEV-40019 Xmlisvalid shows wrong result if calling it multiple times from query with UNION ALL
-
- Open
-
- is blocked by
-
MDEV-37261 Basic XML data type
-
- Closed
-
- relates to
-
MDEV-38690 XMLTYPE: methods - step 2
-
- Open
-
-
MDEV-38691 XMLTYPE: methods
-
- Open
-
-
MDEV-39124 XMLTYPE: allow only well-formed XML
-
- Closed
-
- has action item
-
DOCS-6219 Loading...