Overview
ISO/IEC 9075-14:2016/Cor 2:2022 is Technical Corrigendum 2 to the SQL/XML part of the international SQL standard (ISO/IEC 9075‑14). Published in June 2022 by ISO/IEC JTC 1/SC 32, this corrigendum provides corrections, clarifications and normative adjustments to the XML‑related specifications for SQL (commonly called SQL/XML). It updates syntax rules, normative text, mapping rules between SQL and XML Schema datatypes, XQuery formal type handling, and Information Schema conformance requirements.
Key Topics and Requirements
- Clarification of XML value equivalence: Adds normative reference to Subclause 10.7 (“Determination of equivalent XML values”) to define when two XML values are equivalent.
- XML cast semantics: Fixes ambiguity in the , specifying an augmented XQuery variable
$TEMP with formal type "xs:anyAtomicType+" and value AV for cast processing.
- Syntax-rule corrections: Multiple syntactic fixes in table references and query expression transformations to correct parsing and rule structure.
- Predicate definitions and determinism: Inserts missing syntax rules for
including definitions for and ``, and notes on when an XML predicate result is considered deterministic or implementation‑defined.
- SQL-to-XML mappings: Corrects mapping rules (including timezone text regex for XML timezone representation) and restructures mapping logic for SQL tables, schemas and catalogs to XML elements.
- XQuery type determination: Adjusts rules that determine XQuery formal type notation when XML(DOCUMENT(XMLSCHEMA)) or XML(CONTENT(XMLSCHEMA)) are involved.
- Information Schema conformance rules: Adds conformance rules that restrict use of certain INFORMATION_SCHEMA view columns when features for registered XML schemas (Basic X160 and Advanced X161) are not present in a conforming implementation.
Applications and Who Uses It
- Database implementers and vendors use this corrigendum to update SQL/XML behaviour in RDBMS products and ensure correct XQuery interfacing, casts and schema mappings.
- Standards and compliance engineers rely on the corrections for validating conformance to ISO/IEC 9075‑14 and for interoperability testing between SQL/XML implementations.
- Data architects and integrators mapping relational data to XML (or vice versa) benefit from clarified mapping and predicate semantics.
- Tooling vendors (SQL parsers, ORM layers, XML processing tools) apply the corrected syntax and type rules to avoid ambiguous behavior.
Related Standards
- ISO/IEC 9075 series (SQL) - especially ISO/IEC 9075‑14:2016 (original SQL/XML specification)
- W3C XML Schema and XQuery specifications (referenced by SQL/XML mappings and type rules)
- Work prepared by ISO/IEC JTC 1/SC 32, Data management and interchange
Keywords: ISO/IEC 9075-14, SQL/XML, Technical Corrigendum, XML mapping, XQuery, Information Schema, database standards, SQL to XML.