[
https://issues.apache.org/jira/browse/CALCITE-5684?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17719202#comment-17719202
]
Dan Zou commented on CALCITE-5684:
----------------------------------
[~zineeddine998] Could you please add a complete exception stack for this?
> 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)
