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

ISO/IEC 19075-5:2021/Cor 1:2026 is an ISO technical corrigendum to the first edition of the SQL guidance part on row pattern recognition. It corrects examples and explanatory text so users of SQL row pattern features can apply the same syntax and interpretation consistently across the FROM and WINDOW clause cases.

What does ISO/IEC 19075-5:2021/Cor 1:2026 specify?

ISO/IEC 19075-5:2021/Cor 1:2026 specifies corrections to ISO/IEC 19075-5:2021. The document updates example syntax and explanatory wording in clause 4 and clause 6, with a corrected result table in 6.16.

Clause / subclause	What the corrigendum corrects
4.12.2	Example syntax for ALL ROWS PER MATCH SHOW EMPTY MATCHES
4.12.3	Example syntax for ALL ROWS PER MATCH WITH UNMATCHED ROWS
4.17.2	Explanation of the correlation name for the row pattern output table
6.2	Cross-reference and example syntax for row pattern matching in the WINDOW clause
6.16	Table 20 on empty matches and empty reduced window frames

In practice, this is a maintenance document: it helps readers copy and interpret the guidance correctly, rather than introducing a new feature.

What are the key requirements of ISO/IEC 19075-5:2021/Cor 1:2026?

4.12 corrections for empty matches and unmatched rows

ISO/IEC 19075-5:2021/Cor 1:2026 replaces the example syntax in 4.12.2 for ALL ROWS PER MATCH SHOW EMPTY MATCHES. The corrected example shows the full MATCH_RECOGNIZE form, including MATCH_NUMBER(), CLASSIFIER(), FINAL FIRST, FINAL LAST, AFTER MATCH SKIP PAST LAST ROW, PATTERN (A*), and DEFINE A AS A.Price > PREV(A.Price). In practice, this gives a valid example for matching a sequence that can produce empty matches.

ISO/IEC 19075-5:2021/Cor 1:2026 also replaces the example syntax in 4.12.3 for ALL ROWS PER MATCH WITH UNMATCHED ROWS. The corrected example includes STARTp, BOTTOMp, ENDp, AVGp, SUBSET U = (A, B, C), and PATTERN (A B+ C+). In practice, this is the example to follow when unmatched rows still need to appear in the output.

4.17 row pattern output table naming

ISO/IEC 19075-5:2021/Cor 1:2026 clarifies in 4.17.2 that M is the correlation name assigned to the row pattern output table, and that AS is optional. In practice, this removes ambiguity about the alias used in the query examples.

6 row pattern recognition in the WINDOW clause

ISO/IEC 19075-5:2021/Cor 1:2026 corrects the opening text of 6.2 so the example is linked to subclause 4.4. It also replaces the example syntax for row pattern matching in the WINDOW clause. The corrected example shows PARTITION BY Symbol, ORDER BY Tradeday, ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING, AFTER MATCH SKIP PAST LAST ROW, and the same pattern-building elements used in clause 4. In practice, this is the template for using row pattern recognition inside a window definition.

6.16 empty matches and reduced window frames

ISO/IEC 19075-5:2021/Cor 1:2026 replaces Table 20 in 6.16. The corrected table shows how matches are computed together with window function results when empty matches and empty reduced window frames occur. In practice, it supports validation and test cases for implementations that must handle these edge conditions.

What terms does ISO/IEC 19075-5:2021/Cor 1:2026 define?

• Row pattern recognition - The SQL feature that finds row sequences matching a pattern in ordered partitions.
• MATCH_RECOGNIZE - The SQL clause used to express row pattern recognition and produce a row pattern output table.
• Correlation name - The name given to the row pattern output table; the corrigendum uses M in the examples.
• MATCH_NUMBER() - A function that returns the sequential number of a match.
• CLASSIFIER() - A function that identifies which pattern variable matched a row.
• PREV() - A function used in the pattern definitions to compare a row with a previous row value.
• SUBSET - The construct used to group pattern variables into a named subset for later measures.

Who uses ISO/IEC 19075-5:2021/Cor 1:2026?

ISO/IEC 19075-5:2021/Cor 1:2026 is used by database engine developers, SQL query authors, data management architects, and test teams working with row pattern recognition. It is also useful for technical writers and trainers who need correct example syntax for MATCH_RECOGNIZE in the FROM clause and in WINDOW clause usage.

In practice, the corrigendum matters to anyone designing, implementing, reviewing, or validating SQL features that work with ordered row sequences, match numbering, classifiers, and output tables.

What changed in ISO/IEC 19075-5:2021/Cor 1:2026 from the previous edition?

ISO/IEC 19075-5:2021/Cor 1:2026 is Technical Corrigendum 1 to ISO/IEC 19075-5:2021. It corrects example syntax in 4.12.2, 4.12.3, and 6.2, clarifies the correlation-name wording in 4.17.2, and replaces Table 20 in 6.16.

What does the ISO/IEC 19075-5:2021/Cor 1:2026 document contain?

The document contains corrected SQL example statements for row pattern recognition in the FROM clause and the WINDOW clause. It also contains a short wording correction about the row pattern output table name, a corrected cross-reference, and a revised results table for empty matches and empty reduced window frames.

The corrigendum is focused on example-level accuracy. It does not add a new feature; it adjusts the published guidance so the examples and explanatory text align with the intended SQL usage.

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