Update of regular expression library

Details

Detail name Value
Changelog Number 20854
Type Improvement
Status Resolved
Fix Versions Exasol 2025.1.0
Resolution Date 2025-07-08

Background

Exasol database relies on library with implementation of compiling of regular expressions and matching strings against these patterns (see also Regular expressions).

Improvement

Upgraded the regular expression library from PCRE to PCRE2 10.44.

Impact

This update affects the following functions within the Exasol database:

  • REGEXP_INSTR
  • REGEXP_REPLACE
  • REGEXP_SUBSTR
  • [NOT] REGEXP_LIKE

Changed Behavior

As Exasol relies on library with implementation of compiling of regular expressions and matching string against these patterns, there might be changed behavior. For details refer to documentation on the PCRE2 syntax and PCRE syntax pages.

Changed behavior

Regular expression library was upgraded from PCRE to PCRE2 10.44., so there might be changed behavior. For details refer to documentation on the PCRE2 syntax: http://pcre.org/current/doc/html/pcre2syntax.html and PCRE syntax: http://pcre.org/original/doc/html/pcresyntax.html.