c067372_ISO_IEC_9075-14_2011_Cor_2_2015.pdf

INTERNATIONAL STANDARD ISO/IEC 9075-142011 TECHNICAL CORRIGENDUM 2 Published 2015-10-01 INTERNATIONAL ORGANIZATION FOR STANDARDIZATION  МЕЖДУНАРОДНАЯ ОРГАНИЗАЦИЯ ПО СТАНДАРТИЗАЦИИ  ORGANISATION INTERNATIONALE DE NORMALISATION INTERNATIONAL ELECTROTECHNICAL COMMISSION  МЕЖДУНАРОДНАЯ ЭЛЕКТРОТЕХНИЧЕСКАЯ КОМИССИЯ  COMMISSION LECTROTECHNIQUE INTERNATIONALE Ination technology Database languages SQL Part 14 XML-Related Specifications SQL/XML TECHNICAL CORRIGENDUM 2 Technologies de lination Langages de base de donnes SQL Partie 14 Spcifications relatives au XML SQL/XML RECTIFICATIF TECHNIQUE 2 Technical Corrigendum 2 to ISO/IEC 9075-142011 was prepared by Joint Technical Committee ISO/IEC JTC 1, Ination technology, Subcommittee SC 32, Data management and interchange. ICS 35.060 Ref. No. ISO/IEC 9075-142011/Cor.22015E ISO/IEC 2015 – All rights reserved Published in Switzerland ContentsPage 7Query expressions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 7.1. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 18Embedded SQL. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 18.3. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 20Ination Schema. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 20.5DOMAINS view. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 20.6ELEMENT_TYPES view. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 21Definition Schema. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 21.1DATA_TYPE_DESCRIPTOR base table. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 iiISO/IEC 2015 – All rights reserved ISO/IEC 9075-142011/Cor.2 2015E Ination technology Database languages SQL Part 14 XML-Related Specifications SQL/XML TECHNICAL CORRIGENDUM 2 7Query expressions 7.1 1.RationaleMake and are not updatable. Insert a new Syntax Rule. 0Insert after SR 20 If specifies or , then the is not generally updatable, not simply updatable, not effectively updatable and not insertable- into. 18 Embedded SQL 18.3 1.RationaleRemove the specification of character set from National Character variables as these already have an implementation-defined character set. Replace Syntax Rule 4 with 4Replace SR 5a Any optional CHARACTER SET specification shall be removed from a , a , a , a , or a . ISO/IEC 2015 – All rights reserved1 20 Ination Schema 20.5DOMAINS view 1.RationaleThe table prefixes were incorrect. Replace the Definition with Definition Add the following columns to the end of outermost select list of the view definition , DTD.XML_PRIMARY_MODIFIER, DTD.XML_SECONDARY_MODIFIER, DTD.XML_SCHEMA_CATALOG, DTD.XML_SCHEMA_SCHEMA, DTD.XML_SCHEMA_NAME, DTD.XML_SCHEMA_NAMESPACE, DTD.XML_SCHEMA_ELEMENT 20.6ELEMENT_TYPES view 1.RationaleThe table prefixes were incorrect. Replace the Definition with Definition Add the following columns to the end of outermost select list of the view definition , DTD.XML_PRIMARY_MODIFIER, DTD.XML_SECONDARY_MODIFIER, DTD.XML_SCHEMA_CATALOG, DTD.XML_SCHEMA_SCHEMA, DTD.XML_SCHEMA_NAME, DTD.XML_SCHEMA_NAMESPACE, DTD.XML_SCHEMA_ELEMENT 2ISO/IEC 2015 – All rights reserved ISO/IEC 9075-142011/Cor.2 2015E 21 Definition Schema 21.1DATA_TYPE_DESCRIPTOR base table 1.RationaleThe column name XML_SCHEMA_SCHEMA was incorrectly spelled. Replace the constraint definition DATA_TYPE_DESCRIPTOR_CHECK_REFERENCES_XML_SCHEMA_NAMESPACES with , CONSTRAINT DATA_TYPE_DESCRIPTOR_CHECK_REFERENCES_XML_SCHEMA_NAMESPACES CHECK XML_SCHEMA_CATALOG NOT IN SELECT CATALOG_NAME FROM SCHEMATA OR XML_SCHEMA_CATALOG, XML_SCHEMA_SCHEMA, XML_SCHEMA_NAME, XML_SCHEMA_NAMESPACE IN SELECT XML_SCHEMA_CATALOG, XML_SCHEMA_SCHEMA, XML_SCHEMA_NAME, XML_SCHEMA_NAMESPACE FROM XML_SCHEMA_NAMESPACES 2.RationaleThe column name XML_SCHEMA_SCHEMA was incorrectly spelled. Replace the constraint definition DATA_TYPE_DESCRIPTOR_CHECK_REFERENCES_XML_SCHEMA_ELEMENTS with , CONSTRAINT DATA_TYPE_DESCRIPTOR_CHECK_REFERENCES_XML_SCHEMA_ELEMENTS CHECK XML_SCHEMA_CATALOG NOT IN SELECT CATALOG_NAME FROM SCHEMATA OR XML_SCHEMA_CATALOG, XML_SCHEMA_SCHEMA, XML_SCHEMA_NAME, XML_SCHEMA_NAMESPACE, XML_SCHEMA_ELEMENT IN SELECT XML_SCHEMA_CATALOG, XML_SCHEMA_SCHEMA, XML_SCHEMA_NAME, XML_SCHEMA_NAMESPACE, XML_SCHEMA_ELEMENT FROM XML_SCHEMA_ELEMENTS ISO/IEC 2015 – All rights reserved3 ISO/IEC 9075-142011/Cor.2 2015E