ISO/IEC 9075-1:2016/Cor 1:2022

Information technology - Database languages - SQL - Part 1: Framework (SQL/Framework) - Technical Corrigendum 1

Technologies de l'information — Langages de base de données — SQL — Partie 1: Charpente (SQL/Charpente) — Rectificatif technique 1

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
• Start Date: 01-Jun-2023
• Completion Date: 30-Oct-2025

Relations

• Revised: ISO/IEC 9075-1:2023 - Information technology - Database languages SQL - Part 1: Framework (SQL/Framework)
• Effective Date: 11-Feb-2023

Overview

ISO/IEC 9075-1:2016/Cor 1:2022 is a Technical Corrigendum to the SQL Framework standard (Part 1 of the ISO/IEC 9075 series). Published June 2022, it provides corrective text and clarifications to the SQL/Framework document, improving how the core SQL language framework interoperates with other SQL parts (notably SQL/MD or Part 15). The corrigendum updates definitions, rule‑evaluation behavior, and exception handling to ensure consistent interpretation by implementers and tool vendors.

Key Topics

• SQL data types and constructed composite types
  • Inserts clarifying text for collection types as modified by Part 15 (SQL/MD).
  • Introduces/clarifies MD-array: an ordered collection of not-necessarily-distinct values referenced by coordinates, and specified using an MD-array type constructor.
• User-defined and distinct types
  • Replaces the distinct type definition: a distinct type is a user-defined datatype based on a predefined type or a collection type.
  • Important constraint: the collection type used as the base for a distinct type shall not be an MD-array type.
  • Values of a distinct type are represented by the values of the base type.
• Notation, conventions, and rule evaluation
  • Defines the interpretation of the phrase “the General Rules of X are evaluated” - specifying that such General Rules are deferred (not evaluated at the normal time) to allow nested evaluation of other syntactic elements.
  • Provides an example using procedure statements and nested SQL statements to illustrate deferred evaluation.
• Exceptions and termination rules
  • Updates exception-handling text to correct termination behavior for applications of the General Rules when exceptions occur.

Applications

• Database vendors and DBMS implementers: to correctly implement SQL language features, especially multi-dimensional array types (MD-arrays), distinct types based on collections, and consistent rule-evaluation semantics.
• SQL language implementers and compiler/parser authors: to handle deferred evaluation and exception termination correctly in tooling and interpreters.
• Standards committees and interoperability testers: to align Part 1 behavior with Part 15 (SQL/MD) and ensure compatibility across SQL implementations.
• Database architects and advanced SQL developers: for understanding how user-defined types and collection types behave under the SQL standard.

Related Standards

• ISO/IEC 9075 series (SQL) - Part 15 (SQL/MD) is specifically referenced and integrated by this corrigendum.
• Other SQL Parts that rely on Part 1 for framework, notation, and rule semantics.

Keywords: ISO/IEC 9075-1, SQL/Framework, Technical Corrigendum, MD-array, SQL data types, distinct types, rule evaluation, SQL standard, DBMS implementation.

Standards Content (Sample)

INTERNATIONAL STANDARD ISO/IEC 9075-1:2016
TECHNICAL CORRIGENDUM 1
Published 2022-06
INTERNATIONAL ORGANIZATION FOR STANDARDIZATION • МЕЖДУНАРОДНАЯ ОРГАНИЗАЦИЯ ПО СТАНДАРТИЗАЦИИ • ORGANISATION INTERNATIONALE DE NORMALISATION
INTERNATIONAL ELECTROTECHNICAL COMMISSION • МЕЖДУНАРОДНАЯ ЭЛЕКТРОТЕХНИЧЕСКАЯ КОМИССИЯ • COMMISSION ÉLECTROTECHNIQUE INTERNATIONALE
Information technology — Database languages — SQL — Part 1:
Framework (SQL/Framework)
TECHNICAL CORRIGENDUM 1
Technologies de l'information — Langages de base de données — SQL — Partie 1: Charpente
(SQL/Charpente)
RECTIFICATIF TECHNIQUE 1
Technical Corrigendum 1 to ISO/IEC 9075-1: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-1:2016/Cor.1:2022(E)
©  ISO/IEC 2022 – All rights reserved
Published in Switzerland
ISO/IEC 9075-1:2016/Cor.1: 2022(E)
4 Concepts
4.4 SQL data types
4.4.5 Constructed composite types
4.4.5.1 Collection types
This Subclause is modified by Subclause 4.1.1.1, “Collection types”, in ISO/IEC 9075-15.
1. Rationale:InsertmissingtexttoallowPart15SQL/MDAtomergecorrectly.
Insertthefollowingparagraphsafterthethirdparagraph.
AnMD-arrayisanorderedcollectionofnotnecessarilydistinctvalues,whoseelementsarereferenced
bytheircoordinateintheMD-array.
AnMD-arraytypeisspecifiedbyanMD-arraytypeconstructor.
4.6 SQL-schemaobjects
4.6.4 User-definedtypes
4.6.4.2Distincttypes
ThisSubclauseismodifiedbySubclause4.2.1.1,“Distincttypes”,inISO/IEC9075-15.
1. Rationale:InsertmissingtexttoallowPart
...