[
https://issues.apache.org/jira/browse/CALCITE-5684?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zine eddine Zidane closed CALCITE-5684.
---------------------------------------
Fix Version/s: 1.34.0
Resolution: Invalid
> 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
> Fix For: 1.34.0
>
>
> 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)
