ISO/IEC 19075-5:2021/Cor 1:2026

• Status: Published
• Publication Date: 30-Jun-2026
• 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/WG 3 - Database language
• Current Stage: 6060 - International Standard published
• Start Date: 01-Jul-2026
• Completion Date: 30-Jun-2026

• Corrects: ISO/IEC 19075-5:2021 - Information technology — Guidance for the use of database language SQL — Part 5: Row pattern recognition
• Effective Date: 07-Jan-2026

Overview

ISO/IEC 19075-5:2021/Cor 1:2026 is a Technical Corrigendum published by ISO and IEC under the Joint Technical Committee JTC 1, Subcommittee SC 32, Data Management and Interchange. This corrigendum amends Part 5: Row pattern recognition of the Information technology - Guidance for the use of database language SQL series. The document addresses clarifications and corrections related to the use of SQL row pattern recognition syntax, examples, and result table computations, strengthening the guidance for database professionals and organizations utilizing advanced SQL features.

Key Topics

• Row Pattern Recognition in SQL: Explains the use of SQL's MATCH_RECOGNIZE and WINDOW clauses for identifying and processing sequence patterns in table data.
• Syntax Corrections and Example Clarifications: Provides updates and corrections to example queries that demonstrate effective application of row pattern recognition features.
• Handling Empty Matches and Unmatched Rows: Clarifies SQL syntax for handling cases where no patterns are matched, including options like SHOW EMPTY MATCHES and WITH UNMATCHED ROWS.
• Row Pattern Output Table Naming: Defines how correlation names are assigned to the pattern output table and confirms the optionality of the AS keyword.
• Result Table Interpretation: Updates tabular examples to clarify computation results for pattern matches and window function outputs.
• Compliant Implementation Guidance: Ensures that SQL implementations conform more closely to intended behavior, avoiding ambiguity in complex pattern recognition scenarios.

Applications

ISO/IEC 19075-5:2021/Cor 1:2026 is valuable in several practical contexts:

• Financial Data Analysis: Supports accurate identification of price trends and anomalies in trading data by leveraging advanced pattern matching in SQL queries.
• Compliance and Auditing: Ensures that database procedures relying on row pattern recognition meet the international standards for correctness and reliability.
• Business Intelligence and Data Warehousing: Facilitates enhanced pattern discovery in large datasets, driving informed decision-making through reliable SQL practices.
• Training and Development: Provides authoritative SQL guidance for curriculum developers and trainers needing up-to-date information on standard-compliant SQL pattern features.
• Vendor Implementations: Assists database system vendors in maintaining compliance with ISO/IEC standards, reducing discrepancies in behavior across different SQL engines.

Related Standards

Professionals referencing ISO/IEC 19075-5:2021/Cor 1:2026 may also benefit from the following related standards:

• ISO/IEC 9075 (SQL): The primary standard for SQL, covering foundational syntax, semantics, and features for relational databases.
• ISO/IEC 19075-1: General guidance for the use of database language SQL.
• ISO/IEC 19075-x Series: Parts covering other aspects of SQL usage and implementation.
• ISO/IEC JTC 1/SC 32 Standards: Focused on data management and interchange, offering further guidance on data modeling, metadata, and standard data interfaces.

Practical Value

Adopting the guidance and corrections from this corrigendum ensures:

• Error-Free SQL Implementations: By following clarified syntax and example corrections, database developers reduce the risk of misinterpretation and implementation errors.
• Standardized SQL Usage: Organizations can align SQL practices across different database environments, ensuring interoperability and best practices.
• Future-Proof Systems: Staying informed with updates to international standards helps future-proof database applications and supports long-term data strategy alignment.

For comprehensive SQL standardization and improved pattern analysis, integrating ISO/IEC 19075-5:2021/Cor 1:2026 into your database management processes is crucial. For more details, consult the full document or visit ISO's official website.

International
Standard
ISO/IEC 19075-5
First edition
Information technology — Guidance
2021-08
for the use of database language
SQL —
TECHNICAL
CORRIGENDUM 1
Part 5:
2026-06
Row pattern recognition
TECHNICAL CORRIGENDUM 1
Technologies de l'information — Recommandations pour
l'utilisation du langage de base de données SQL —
Partie 5: Reconnaissance de formes de lignes
RECTIFICATIF TECHNIQUE 1
Reference number
ISO/IEC 19075-5:2021/Cor. 1:2026(en) © ISO/IEC 2026

ISO/IEC 19075-5:2021/Cor. 1:2026(en)
© ISO/IEC 2026
All rights reserved. Unless otherwise specified, or required in the context of its implementation, no part of this publication may
be reproduced or utilized otherwise in any form or by any means, electronic or mechanical, including photocopying, or posting on
the internet or an intranet, without prior written permission. Permission can be requested from either ISO at the address below
or ISO’s member body in the country of the requester.
ISO copyright office
CP 401 • Ch. de Blandonnet 8
CH-1214 Vernier, Geneva
Phone: [phone]
Email: [e-mail]
Website: www.iso.org
Published in Switzerland
© ISO/IEC 2026 – All rights reserved
ii
ISO/IEC 19075-5:2021/Cor.1:2026(en)
Technical Corrigendum 1 to ISO/IEC 19075-5:2021 was prepared by Joint Technical Committee ISO/IEC JTC 1,
Information technology, Subcommittee SC 32, Data management and interchange.

© ISO/IEC 2026 – All rights reserved
iii
ISO/IEC 19075-5:2021/Cor. 1:2026(en)
4 Rowpatternrecognition:FROMclause
4.12 ONEROWPERMATCHvs.ALLROWSPERMATCH
4.12.2Handlingemptymatches
1. Rationale:Correctthesyntaxofanexample.
Replacetheexamplesyntaxfollowingthetext“Thefollowingexamplealterstheprecedingexample
slightly,touseALLROWSPERMATCHSHOWEMPTYMATCHES:”with:
SELECT M.Symbol,  /* ticker symbol */
M.Matchno,  /* sequential match number */
M.Tradeday, /* day of trading */
M.Price, /* price on day of trading */
M.Classy,  /* classifier */
M.Firstp,  /* starting price */
M.Lastp /* ending price */
FROM Ticker
MATCH_RECOGNIZE (
PARTITION BY Symbol
ORDER BY Tradeday
MEASURES MATCH_NUMBER() AS Matchno,
CLASSIFIER() AS Classy,
FINAL FIRST (A.Price) AS Firstp,
FINAL LAST (A.Price) AS Lastp
ALL ROWS PER MATCH SHOW EMPTY MATCHES
AFTER MATCH SKIP PAST LAST ROW
PATTERN (A*)
DEFINE A AS A.Price > PREV (A.Price)
) AS M
4.12.3Handlingunmatchedrows
1. Rationale:Correctthesyntaxofanexample.
Replacetheexamplesyntaxwith:
SELECT M.Symbol,  /* ticker symbol */
M.Matchno, /* sequential match number */
M.Tradeday, /* day of trading */
M.Price,  /* price on day of trading */
M.Classy,  /* classif
...