ISO/IEC 9075-14:2016/Cor 2:2022

Information technology — Database languages — SQL — Part 14: XML-Related Specifications (SQL/XML) — Technical Corrigendum 2

Technologies de l'information — Langages de base de données — SQL — Partie 14: Spécifications relatives au XML (SQL/XML) — Rectificatif technique 2

General Information

• Status: Published
• Publication Date: 23-Jun-2022
• ICS: 35.060 - Languages used in information technology
• Technical Committee: ISO/IEC JTC 1/SC 32 - Data management and interchange
• Drafting Committee: ISO/IEC JTC 1/SC 32 - Data management and interchange
• Current Stage: 9599 - Withdrawal of International Standard
• Completion Date: 01-Jun-2023

Relations

• Revised: ISO/IEC 9075-14:2023 - Information technology — Database languages SQL — Part 14: XML-Related Specifications (SQL/XML)
• Effective Date: 11-Feb-2023

Standards Content (Sample)

INTERNATIONAL STANDARD ISO/IEC 9075-14:2016
TECHNICAL CORRIGENDUM 2
Published 2022-06
INTERNATIONAL ORGANIZATION FOR STANDARDIZATION • МЕЖДУНАРОДНАЯ ОРГАНИЗАЦИЯ ПО СТАНДАРТИЗАЦИИ • ORGANISATION INTERNATIONALE DE NORMALISATION
INTERNATIONAL ELECTROTECHNICAL COMMISSION • МЕЖДУНАРОДНАЯ ЭЛЕКТРОТЕХНИЧЕСКАЯ КОМИССИЯ • COMMISSION ÉLECTROTECHNIQUE INTERNATIONALE
Information technology — Database languages — SQL — Part 14:
XML-Related Specifications (SQL/XML)
TECHNICAL CORRIGENDUM 2
Technologies de l'information — Langages de base de données — SQL — Partie 14: Spécifications
relatives au XML (SQL/XML)
RECTIFICATIF TECHNIQUE 2
Technical Corrigendum 2 to ISO/IEC 9075-14:2016 was prepared by Joint Technical Committee
ISO/IEC JTC 1, Information technology, Subcommittee SC 32, Data management and interchange.
ICS 35.060 Ref. No. ISO/IEC 9075-14:2016/Cor.2:2022(E)
©  ISO/IEC 2022 – All rights reserved
Published in Switzerland

---------------------- Page: 1 ----------------------
ISO/IEC9075-14:2016/Cor.2:2022(E)
4 Concepts
4.2 XML
4.2.3 CharacteristicsofXMLvalues
1. Rationale:Replacenon-normativetextwithrequirednormativetext.
AddthefollowingparagraphtotheendoftheSubclause.
TwoXMLvaluesareregardedasequivalentasspecifiedinSubclause10.7,“Determinationof
equivalentXMLvalues”.
6 Scalarexpressions
6.6
1. Rationale:Correctanambiguity.
ReplaceGeneralRule4)g)with:
4) .
g) LetXSCandXDCbeaugmentedwithanXQueryvariable$TEMPwhoseXQueryformal
typenotationis“xs:anyAtomicType+”andwhosevalueisAV.
2. Rationale:Correctanerrorintherulestructuring.
ReplacetheleadtextofGeneralRule4)i)viii)2)with:
4) .
i) .
viii) .
2) IfSQLTisTIMEWITHTIMEZONE,then:
Case:
7 Queryexpressions
7.1
1. Rationale:Correctanincorrectsyntactictransformation.
ReplaceSyntaxRule5)h)with:
5) .
2 © ISO/IEC 2022 – All rights reserved

---------------------- Page: 2 ----------------------
ISO/IEC9075-14:2016/Cor.2:2022(E)
h) TPisequivalenttothe
LATERAL
 ( XNDC
SELECT SLI AS CN , SLI AS CN , ., SLI AS CN
1 1 2 2 NC NC
FROM XMLITERATE ( XMLQUERY ( XTRP XQAL
RETURNING SEQUENCE BY REF EMPTY ON EMPTY ) )
AS I ( V, N )
 ) AS CORR DCLP
8 Predicates
8.1
1. Rationale:Supplymissingdefinition.
InsertthefollowingSyntaxRules:
1) InsertafterSR1)f) PcontainsaXVPthatsatisfiesoneofthefollowing:
a) XVPdoesnotspecify.
b) XVPspecifiesanthatidentifiesanon-deterministicregis-
teredXMLSchemaandXVPdoesnotspecifyan
ofan.
c) XVPspecifiesanthatidentifiesanon-deterministicXML
namespaceandXVPdoesnotspecifyan.
d) XVPspecifiesanthatidentifiesanon-deterministicglobal
elementdeclarationschemacomponentofaregisteredXMLSchema.
2) InsertafterSR1)f) Pcontainsathatdoesnotconformtoimplemen-
tation-definedrulesenablingtheSQL-implementationtodeducethattheresultofthe existspredicate>isdeterministic.
9 Mappings
9.5 MappingSQLdatatypestoXMLSchemadatatypes
1. Rationale:Correctthesyntax.
ReplaceGeneralRule7)i)ii)with:
7) .
i) .
ii) LettheXMLtextTZbe:
(\+|-)\p{Nd}{2}:\p{Nd}{2}
© ISO/IEC 2022 – All rights reserved 3

---------------------- Page: 3 ----------------------
ISO/IEC9075-14:2016/Cor.2:2022(E)
2. Rationale:Correctthesyntax.
ReplaceGeneralRule7)k)iii)with:
7) .
k) .
iii) LettheXMLtextTZbe:
(\+|-)\p{Nd}{2}:\p{Nd}{2}
9.10 MappinganSQLtabletoanXMLelementorasequenceofXMLelements
1. Rationale:Correctanerrorintherulestructuring.
ReplacetheleadtextofGeneralRule5)a)with:
5) .
a) IfXSLisnotthezero-lengthstring,then:
Case:
9.13 MappinganSQLschematoanXMLelement
1. Rationale:Correctanerrorintherulestructuring.
ReplacetheleadtextofGeneralRule6)a)with:
6) .
a) IfXSLisnotthezero-lengthstring,then:
Case:
9.16 MappinganSQLcatalogtoanXMLelement
1. Rationale:Correctanerrorintherulestructuring.
ReplacetheleadtextofGeneralRule6)a)with:
6) .
a) IfXSLisnotthezero-lengthstring,then:
Case:
4 © ISO/IEC 2022 – All rights reserved

---------------------- Page: 4 ----------------------
ISO/IEC9075-14:2016/Cor.2:2022(E)
10Additionalcommonrules
10.7 DeterminationofequivalentXMLvalues
1. Rationale:Replacenon-normativetextwithrequirednormativetext.
DeleteNote80.
10.21DeterminationofanXQueryformaltypenotation
1. Rationale:Correctanerrorintherulestructuring.
ReplacetheleadtextofSyntaxRule5)c)with:
5) .
c) IfSDisXML(DOCUMENT(XMLSCHEMA)),then:
Case:
2. Rationale:Correctanerrorintherulestructuring.
ReplacetheleadtextofSyntaxRule5)f)with:
5) .
f) IfSDisXML(CONTENT(XMLSCHEMA)),then:
Case:
21InformationSchema
21.15Shortnameviews
1. Rationale:AddmissingConformanceRules.
InsertthefollowingConformanceRules:
5) InsertthisCRWithoutFeatureX160,“BasicInformationSchemaforregisteredXMLSchemas”,
conformingSQLlanguageshallnotreferencethefollowingcolumnsintheviewINFORMA-
TIO
...