[CALCITE-3280] Cannot parse query REGEXP_REPLACE in Redshift

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.21.0
• Labels: pull-request-available
• Assignee: Julian Hyde
• Reporter: Ryan Fu
• Created: 21/Aug/19 23:44
• Updated: 30/Oct/23 06:44
• Resolved: 27/Aug/19 08:04

Description

REGEXP_REPLACE error:

No match found for function signature REGEXP_REPLACE(<CHARACTER>, <CHARACTER>, <CHARACTER>)

 

Example query:

SELECT * , MD5(TRIM(BOTH ' ' FROM REGEXP_REPLACE(LOWER(name), '([[:space:]]|,)+([iInNcC]|[lLcC]).*$', ''))) AS company_id FROM public.account 

Issue Links

• relates to: CALCITE-5914 Cache compiled regular expressions in SQL function runtime
• relates to: CALCITE-5858 Add REGEXP_CONTAINS, REGEXP_EXTRACT, REGEXP_EXTRACT_ALL, REGEXP_INSTR, REGEXP_REPLACE and REGEXP_SUBSTR functions (enabled in BigQuery library)
• relates to: CALCITE-5979 Add REGEXP_REPLACE function (enabled in BigQuery library)
• links to: GitHub Pull Request #1401