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

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
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

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

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

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
...