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.