[MDEV-40019] Xmlisvalid shows wrong result if calling it multiple times from query with UNION ALL - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: None
Fix Version/s: 13.1.1
Component/s: XML
Labels:
None

Bug Category:
Can result in hang or crash
Sprint:
Q3/2026 Server Maintenance

Description

bb-13.1-mdev-37262-hf b75702097e55151cfb

SELECT XMLISVALID('<sc><kfjfn>56.4E3</kfjfn></sc>', '<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"><xs:element name="sc"><xs:complexType><xs:sequence><xs:element name="kfjfn" type="xs:double"/><xs:element name="ugrx" type="xs:decimal" minOccurs="0"/></xs:sequence></xs:complexType></xs:element></xs:schema>') AS a;

SELECT XMLISVALID('<sc><kfjfn>56.4E3</kfjfn></sc>', '<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"><xs:element name="sc"><xs:complexType><xs:sequence><xs:element name="kfjfn" type="xs:double"/><xs:element name="ugrx" type="xs:decimal" minOccurs="0"/></xs:sequence></xs:complexType></xs:element></xs:schema>') AS a

UNION ALL

SELECT XMLISVALID('<sc><kfjfn>56.4E3</kfjfn></sc>', '<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"><xs:element name="sc"><xs:complexType><xs:sequence><xs:element name="kfjfn" type="xs:double"/><xs:element name="ugrx" type="xs:decimal" minOccurs="0"/></xs:sequence></xs:complexType></xs:element></xs:schema>') AS a

UNION ALL

SELECT XMLISVALID('<sc><kfjfn>56.4E3</kfjfn></sc>', '<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"><xs:element name="sc"><xs:complexType><xs:sequence><xs:element name="kfjfn" type="xs:double"/><xs:element name="ugrx" type="xs:decimal" minOccurs="0"/></xs:sequence></xs:complexType></xs:element></xs:schema>') AS a

UNION ALL

SELECT XMLISVALID('<sc><kfjfn>56.4E3</kfjfn></sc>', '<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"><xs:element name="sc"><xs:complexType><xs:sequence><xs:element name="kfjfn" type="xs:double"/><xs:element name="ugrx" type="xs:decimal" minOccurs="0"/></xs:sequence></xs:complexType></xs:element></xs:schema>') AS a

UNION ALL

SELECT XMLISVALID('<sc><kfjfn>56.4E3</kfjfn></sc>', '<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"><xs:element name="sc"><xs:complexType><xs:sequence><xs:element name="kfjfn" type="xs:double"/><xs:element name="ugrx" type="xs:decimal" minOccurs="0"/></xs:sequence></xs:complexType></xs:element></xs:schema>') AS a

UNION ALL

SELECT XMLISVALID('<sc><kfjfn>56.4E3</kfjfn></sc>', '<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"><xs:element name="sc"><xs:complexType><xs:sequence><xs:element name="kfjfn" type="xs:double"/><xs:element name="ugrx" type="xs:decimal" minOccurs="0"/></xs:sequence></xs:complexType></xs:element></xs:schema>') AS a

UNION ALL

SELECT XMLISVALID('<sc><kfjfn>56.4E3</kfjfn></sc>', '<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"><xs:element name="sc"><xs:complexType><xs:sequence><xs:element name="kfjfn" type="xs:double"/><xs:element name="ugrx" type="xs:decimal" minOccurs="0"/></xs:sequence></xs:complexType></xs:element></xs:schema>') AS a

UNION ALL

SELECT XMLISVALID('<sc><kfjfn>56.4E3</kfjfn></sc>', '<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"><xs:element name="sc"><xs:complexType><xs:sequence><xs:element name="kfjfn" type="xs:double"/><xs:element name="ugrx" type="xs:decimal" minOccurs="0"/></xs:sequence></xs:complexType></xs:element></xs:schema>') AS a

UNION ALL

SELECT XMLISVALID('<sc><kfjfn>56.4E3</kfjfn></sc>', '<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"><xs:element name="sc"><xs:complexType><xs:sequence><xs:element name="kfjfn" type="xs:double"/><xs:element name="ugrx" type="xs:decimal" minOccurs="0"/></xs:sequence></xs:complexType></xs:element></xs:schema>') AS a

UNION ALL

SELECT XMLISVALID('<sc><kfjfn>56.4E3</kfjfn></sc>', '<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"><xs:element name="sc"><xs:complexType><xs:sequence><xs:element name="kfjfn" type="xs:double"/><xs:element name="ugrx" type="xs:decimal" minOccurs="0"/></xs:sequence></xs:complexType></xs:element></xs:schema>') AS a

...
SELECT XMLISVALID('<sc><kfjfn>56.4E3</kfjfn></sc>', '<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"><xs:element name="sc"><xs:complexType><xs:sequence><xs:element name="kfjfn" type="xs:double"/><xs:element name="ugrx" type="xs:decimal" minOccurs="0"/></xs:sequence></xs:complexType></xs:element></xs:schema>') AS a
UNION ALL
SELECT XMLISVALID('<sc><kfjfn>56.4E3</kfjfn></sc>', '<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"><xs:element name="sc"><xs:complexType><xs:sequence><xs:element name="kfjfn" type="xs:double"/><xs:element name="ugrx" type="xs:decimal" minOccurs="0"/></xs:sequence></xs:complexType></xs:element></xs:schema>') AS a
UNION ALL
SELECT XMLISVALID('<sc><kfjfn>56.4E3</kfjfn></sc>', '<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"><xs:element name="sc"><xs:complexType><xs:sequence><xs:element name="kfjfn" type="xs:double"/><xs:element name="ugrx" type="xs:decimal" minOccurs="0"/></xs:sequence></xs:complexType></xs:element></xs:schema>') AS a
;
a
1
1
1
0
1
1
1
1
1
0

Attachments

Issue Links

is caused by

MDEV-37262 XMLISVALID() schema validation function

In Testing

Activity

People

Assignee:: Alexey Botchkov

Reporter:: Alice Sherepa

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2026-06-12 15:51

Updated:: 2026-07-16 17:02

Resolved:: 2026-07-16 17:02

Time Tracking

Estimated:

1d 34m

Remaining:

Logged:

4.75h

Git Integration

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