ISO/IEC 19075-5:2021/Cor 1:2026
(Corrigendum)Information technology — Guidance for the use of database language SQL — Part 5: Row pattern recognition — Technical Corrigendum 1
General Information
- Abstract
- Status
- Published
- Publication Date
- 30-Jun-2026
- 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
Relations
- Effective Date
- 07-Jan-2026
Get Certified
Connect with accredited certification bodies for this standard
BSI Group
BSI (British Standards Institution) is the business standards company that helps organizations make excellence a habit.
NYCE
Mexican standards and certification body.
Sponsored listings
Frequently Asked Questions
ISO/IEC 19075-5:2021/Cor 1:2026 is a standard published by the International Organization for Standardization (ISO). Its full title is "Information technology — Guidance for the use of database language SQL — Part 5: Row pattern recognition — Technical Corrigendum 1". This standard covers: Information technology — Guidance for the use of database language SQL — Part 5: Row pattern recognition — Technical Corrigendum 1
Information technology — Guidance for the use of database language SQL — Part 5: Row pattern recognition — Technical Corrigendum 1
ISO/IEC 19075-5:2021/Cor 1:2026 is classified under the following ICS (International Classification for Standards) categories: 35.060 - Languages used in information technology. The ICS classification helps identify the subject area and facilitates finding related standards.
ISO/IEC 19075-5:2021/Cor 1:2026 has the following relationships with other standards: It is inter standard links to ISO/IEC 19075-5:2021. Understanding these relationships helps ensure you are using the most current and applicable version of the standard.
ISO/IEC 19075-5:2021/Cor 1:2026 is available in PDF format for immediate download after purchase. The document can be added to your cart and obtained through the secure checkout process. Digital delivery ensures instant access to the complete standard document.
Standards Content (Sample)
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: +41 22 749 01 11
Email: copyright@iso.org
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
...