ISO IEC 19075-1-2021 PDF

Full title and description

ISO/IEC 19075-1:2021 — Information technology — Guidance for the use of database language SQL — Part 1: XQuery regular expressions. This part provides guidance on the use and interpretation of XQuery-style regular expression syntax and related SQL functions and predicates when used within SQL implementations and applications.

Abstract

This document offers guidance for using the regular expression syntax adopted from XQuery (and XPath) within SQL. It explains semantics and practical use of SQL features that rely on XQuery regular expressions — for example predicates and functions to test for matches, count occurrences, find positions, extract matching substrings and perform replacements — and it provides implementation and portability notes for database vendors and SQL users. The 2021 edition supersedes the earlier technical report from 2011.

General information

• Status: Published.
• Publication date: 2021-08-31 (Edition 1.0).
• Publisher: ISO/IEC (prepared by ISO/IEC JTC 1/SC 32 — Data management and interchange).
• ICS / categories: 35.060 (Languages used in information technology).
• Edition / version: Edition 1.0 (2021).
• Number of pages: 25.

Scope

The standard provides guidance on the syntax and semantics of XQuery-derived regular expressions when used in SQL contexts and explains the expected behaviour of associated SQL predicates and functions. It covers how regular-expression-based features should be interpreted in SQL statements, examples of usage, and considerations for consistent implementation across database systems. The part is intended to guide implementers and users toward interoperable behaviour for SQL features that rely on XQuery-style regular expressions.

Key topics and requirements

• Explanation of XQuery/XPath derived regular expression syntax and semantics as applied in SQL.
• Guidance on SQL predicates and functions that use regular expressions (examples include LIKE_REGEX, OCCURRENCES_REGEX, POSITION_REGEX, SUBSTRING_REGEX, TRANSLATE_REGEX and equivalent functionality).
• Portability and conformance considerations for database vendors implementing XQuery-style regular expressions in SQL.
• Examples and recommended interpretations to reduce ambiguity in cross-vendor SQL behaviour.
• Notes on character encoding, Unicode handling and collation interactions relevant to regular expression matching in SQL.

Typical use and users

Primary users are database implementers, SQL language designers, and tool vendors who need a consistent interpretation of XQuery-style regular expressions in SQL. Secondary users include application developers, QA/test teams, and standards bodies seeking guidance for interoperable SQL implementations and for writing portable SQL that uses regular-expression features.

Related standards

This part is one element of the ISO/IEC 19075 series (Guidance for the use of database language SQL). It complements and references the core SQL standard (ISO/IEC 9075) and other 19075 parts (for example parts addressing routines and Java, row pattern recognition, multidimensional arrays, etc.). The 2021 publication replaces the earlier ISO/IEC TR 19075-1:2011 technical report.

Keywords

SQL, regular expressions, XQuery, XPath, pattern matching, LIKE_REGEX, OCCURRENCES_REGEX, POSITION_REGEX, SUBSTRING_REGEX, TRANSLATE_REGEX, portability, ISO/IEC 19075.

FAQ

Q: What is this standard?

A: ISO/IEC 19075-1:2021 is an international guidance document that explains how XQuery-style regular expressions are to be used and interpreted within SQL environments to promote consistent behaviour across implementations.

Q: What does it cover?

A: It covers the XQuery-derived regular expression syntax and semantics as applied to SQL, guidance on related SQL functions/predicates (match testing, counting occurrences, locating positions, extracting substrings, performing replacements), and implementation/portability considerations.

Q: Who typically uses it?

A: Database engine implementers, SQL language/tool vendors, application developers who need portable regular-expression behaviour in SQL, and test/quality teams validating conformance and interoperability.

Q: Is it current or superseded?

A: ISO/IEC 19075-1:2021 is the current published edition (published 2021-08-31). It supersedes and replaces ISO/IEC TR 19075-1:2011 (the earlier technical report).

Q: Is it part of a series?

A: Yes — it is Part 1 of the ISO/IEC 19075 series (Guidance for the use of database language SQL). Other parts in the series provide guidance on routines and types using Java, row pattern recognition, multidimensional arrays, and additional SQL features.

Q: What are the key keywords?

A: SQL, XQuery regular expressions, pattern matching, LIKE_REGEX, OCCURRENCES_REGEX, POSITION_REGEX, SUBSTRING_REGEX, TRANSLATE_REGEX, portability, ISO/IEC 19075.