[MDEV-29095] REGEXP_REPLACE treats empty strings different than REPLACE in ORACLE mode - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.3.35, 10.4.25, 10.5.16, 10.6.8, 10.7.4, 10.8.3
Fix Version/s: 10.4.33, 10.5.24, 10.6.17, 10.11.7, 11.0.5, 11.1.4, 11.2.3, 11.3.2
Component/s: OTHER
Labels:
None

Description

The REPLACE function has special treatment for cases where the 3rd parameter is NULL in ORACLE sql_mode, REGEXP_REPLACE on the other hand always returns NULL when the 3rd parameter is NULL, or an empty string converted to NULL due to empty_string_is_null sql_mode.

When calling both functions with parameters ('x-x', '-', empty string or NULL) the results are as follows

3rd param  REPLACE  REGEXP_REPLACE  sql_mode

---------------------------------------------------------------

''           xx           xx        ORACLE

NULL         xx          NULL       ORACLE

''           xx          NULL       ORACLE,empty_string_is_null

NULL         xx          NULL       ORACLE,empty_string_is_null

Attachments

Issue Links

is blocked by

MDEV-27744 LPAD in vcol created in ORACLE mode makes table corrupted in non-ORACLE

Closed

relates to

MDEV-13003 Oracle compatibility : Replace function (PR: #401)

Closed

Activity

People

Assignee:: Alexander Barkov

Reporter:: Hartmut Holzgraefe

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2022-07-13 16:50

Updated:: 2024-03-29 23:10

Resolved:: 2024-01-24 08:27

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.