Ryan Fu created CALCITE-3280: -------------------------------- Summary: Cannot parse query REGEXP_REPLACE in Redshift Key: CALCITE-3280 URL: https://issues.apache.org/jira/browse/CALCITE-3280 Project: Calcite Issue Type: Improvement Reporter: Ryan Fu
REGEXP_REPLACE error: No match found for function signature REGEXP_REPLACE(<CHARACTER>, <CHARACTER>, <CHARACTER>) Example query: {{}} {code:java} {code} {{ SELECT * , MD5(TRIM(BOTH ' ' FROM REGEXP_REPLACE(LOWER(name), '([[:space:]]|\\,)+([iInNcC]|[lLcC]).*$', ''))) AS company_id FROM public.account}} -- This message was sent by Atlassian Jira (v8.3.2#803003)