[ https://issues.apache.org/jira/browse/CALCITE-3280?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16916079#comment-16916079 ]
Julian Hyde commented on CALCITE-3280: -------------------------------------- Reviewing now. > 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 > Assignee: Julian Hyde > Priority: Minor > Labels: pull-request-available > Fix For: 1.21.0 > > Time Spent: 2h > Remaining Estimate: 0h > > 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)