Yu Xu created CALCITE-6979:
------------------------------
Summary: Invalid unparse for IS TRUE,IS FALSE,IS NOT TRUE and IS
NOT FALSE in ClickHouseDialect
Key: CALCITE-6979
URL: https://issues.apache.org/jira/browse/CALCITE-6979
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.39.0
Reporter: Yu Xu
Assignee: Yu Xu
Fix For: 1.40.0
IS TRUE/ IS FALSE/IS NOT TRUE/IS NOT FALSE can not support in ClickHouse
System.
such as:
{code:java}
SELECT CAST(1 AS DECIMAL(12, 2)) > 0.00 IS TRUE; {code}
would error out:
{code:java}
Code: 62. DB::Exception: Syntax error: failed at position 824 (TRUE) (line 24,
col 44): TRUE; {code}
and convert to IS NOT NULL and BOOLEAN can work well:
{code:java}
select CAST(1 AS DECIMAL(12, 2)) > 0.00 IS NOT NULL AND CAST(1 AS DECIMAL(12,
2)) > 0.00;
> 1 {code}
*we should convert the syntax as:*
BOOLEAN IS TRUE: BOOLEAN IS NOT NULL AND BOOLEAN
BOOLEAN IS FALSE: BOOLEAN IS NOT NULL AND NOT BOOLEAN
BOOLEAN IS NOT TRUE: BOOLEAN IS NULL OR NOT BOOLEAN
BOOLEAN IS NOT FALSE: BOOLEAN IS NULL OR NOT BOOLEAN
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
