[jira] [Updated] (CALCITE-3280) Cannot parse query REGEXP_REPLACE in Redshift
[ 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: No match found for function signature REGEXP_REPLACE(, , ) Example query: {code:java} SELECT * , MD5(TRIM(BOTH ' ' FROM REGEXP_REPLACE(LOWER(name), '([[:space:]]|,)+([iInNcC]|[lLcC]).*$', ''))) AS company_id FROM public.account {code} was: REGEXP_REPLACE error: No match found for function signature REGEXP_REPLACE(, , ) Example query: {{}} {code:java} {code} {{ SELECT * , MD5(TRIM(BOTH ' ' FROM REGEXP_REPLACE(LOWER(name), '([[:space:]]|\\,)+([iInNcC]|[lLcC]).*$', ''))) AS company_id FROM public.account}} > 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: > No match found for function signature REGEXP_REPLACE(, > , ) > > Example query: > > {code:java} > 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)
[jira] [Updated] (CALCITE-3280) Cannot parse query REGEXP_REPLACE in Redshift
[ 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:java} No match found for function signature REGEXP_REPLACE(, , ){code} Example query: {code:java} 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(, , ){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:java} > No match found for function signature REGEXP_REPLACE(, > , ){code} > > Example query: > {code:java} > 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)
[jira] [Updated] (CALCITE-3280) Cannot parse query REGEXP_REPLACE in Redshift
[ 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:java} No match found for function signature REGEXP_REPLACE(, , ){code} Example query: {code:java} SELECT * , MD5(TRIM(BOTH ' ' FROM REGEXP_REPLACE(LOWER(name), '([[:space:]]|,)+([iInNcC]|[lLcC]).*$', ''))) AS company_id FROM public.account {code} was: REGEXP_REPLACE error: No match found for function signature REGEXP_REPLACE(, , ) 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:java} > No match found for function signature REGEXP_REPLACE(, > , ){code} > > Example query: > > {code:java} > 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)
[jira] [Updated] (CALCITE-3280) Cannot parse query REGEXP_REPLACE in Redshift
[ 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(, , ){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(, , ){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(, > , ){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)
[jira] [Updated] (CALCITE-3280) Cannot parse query REGEXP_REPLACE in Redshift
[ https://issues.apache.org/jira/browse/CALCITE-3280?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3280: Labels: pull-request-available (was: ) > 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 > Labels: pull-request-available > > REGEXP_REPLACE error: > {code:} > No match found for function signature REGEXP_REPLACE(, > , ){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)
[jira] [Updated] (CALCITE-3280) Cannot parse query REGEXP_REPLACE in Redshift
[ https://issues.apache.org/jira/browse/CALCITE-3280?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3280: - Fix Version/s: 1.21.0 > 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 > 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(, > , ){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)