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.