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
Current Stage
6060 - International Standard published
Completion Date
24-Jun-2022
Ref Project

Buy Standard

Standard
ISO/IEC 9075-14:2016/Cor 2:2022 - Information technology — Database languages — SQL — Part 14: XML-Related Specifications (SQL/XML) — Technical Corrigendum 2 Released:24. 06. 2022
English language
7 pages
sale 15% off
Preview
sale 15% off
Preview

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

Questions, Comments and Discussion

Ask us and Technical Secretary will try to provide an answer. You can facilitate discussion about the standard in here.