[ https://issues.apache.org/jira/browse/CALCITE-3280?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ryan Fu updated CALCITE-3280: ----------------------------- Description: REGEXP_REPLACE error: {code:} No match found for function signature REGEXP_REPLACE(<CHARACTER>, <CHARACTER>, <CHARACTER>){code} Example query: {code:sql} SELECT * , MD5(TRIM(BOTH ' ' FROM REGEXP_REPLACE(LOWER(name), '([[:space:]]|,)+([iInNcC]|[lLcC]).*$', ''))) AS company_id FROM public.account {code} was: REGEXP_REPLACE error: {code:java} No match found for function signature REGEXP_REPLACE(<CHARACTER>, <CHARACTER>, <CHARACTER>){code} Example query: {code:java} SELECT * , MD5(TRIM(BOTH ' ' FROM REGEXP_REPLACE(LOWER(name), '([[:space:]]|,)+([iInNcC]|[lLcC]).*$', ''))) AS company_id FROM public.account {code} > 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 > Priority: Minor > > REGEXP_REPLACE error: > {code:} > No match found for function signature REGEXP_REPLACE(<CHARACTER>, > <CHARACTER>, <CHARACTER>){code} > > Example query: > {code:sql} > SELECT * , MD5(TRIM(BOTH ' ' FROM REGEXP_REPLACE(LOWER(name), > '([[:space:]]|,)+([iInNcC]|[lLcC]).*$', ''))) AS company_id FROM > public.account {code} -- This message was sent by Atlassian Jira (v8.3.2#803003)