[FLINK-34477] support capture groups in REGEXP_REPLACE

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.18.1
• Component/s: Table SQL / API
• Labels: pull-request-available
• Assignee: Jeyhun Karimov
• Reporter: David Anderson
• Created: 20/Feb/24 17:42
• Updated: 03/Mar/24 23:36

Description

For example, I would expect this query

select REGEXP_REPLACE('ERR1,ERR2', '([^,]+)', 'AA$1AA'); 

to produce

AAERR1AA,AAERR2AA

but instead it produces

AA$1AA,AA$1AA

With FLINK-9990 support was added for REGEXP_EXTRACT, which does provide access to the capture groups, but for many use cases supporting this in the way that users expect, in REGEXP_REPLACE, would be more natural and convenient.

Issue Links

• links to: GitHub Pull Request #24363