[
https://issues.apache.org/jira/browse/CALCITE-5684?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zine eddine Zidane updated CALCITE-5684:
----------------------------------------
Description:
In the example query below (redshift):
{code:java}
SELECT CASE WHEN table.columnA IS NOT NULL THEN '' ELSE table.columnA END
columnA FROM table where (columnA LIKE '%example%') {code}
When the parser reaches "THEN ''" it considers the second single quote as an
escape character so rather than returning the correct string literal which is
an empty string '' it returns:
'' ELSE table.columnA END columnA FROM table where (columnA LIKE '
The query is valid on redshift
was:
In the example query below (redshift):
{code:java}
SELECT CASE WHEN table.columnA IS NOT NULL THEN '' ELSE table.columnA END
columnA FROM table where (columnA LIKE '%example%') {code}
When the parser reaches "THEN ''" it considers the second single quote as an
escape character so rather than returning the correct string literal which is
an empty string '' it returns:
'' ELSE table.columnA END columnA FROM table where (columnA LIKE '
> Parser fails to differentiate between empty string '' and escaped string
> literal single quote
> ---------------------------------------------------------------------------------------------
>
> Key: CALCITE-5684
> URL: https://issues.apache.org/jira/browse/CALCITE-5684
> Project: Calcite
> Issue Type: New Feature
> Components: core
> Reporter: Zine eddine Zidane
> Priority: Blocker
>
> In the example query below (redshift):
>
> {code:java}
> SELECT CASE WHEN table.columnA IS NOT NULL THEN '' ELSE table.columnA END
> columnA FROM table where (columnA LIKE '%example%') {code}
> When the parser reaches "THEN ''" it considers the second single quote as an
> escape character so rather than returning the correct string literal which is
> an empty string '' it returns:
>
> '' ELSE table.columnA END columnA FROM table where (columnA LIKE '
> The query is valid on redshift
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
