Zine eddine Zidane created CALCITE-5684:
-------------------------------------------
Summary: Parser fails to differentiate between empty string '' and
escaped string literal 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
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 '
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
