[
https://issues.apache.org/jira/browse/CALCITE-6979?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
xiong duan resolved CALCITE-6979.
---------------------------------
Resolution: Fixed
> 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
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.40.0
>
>
> IS TRUE/ IS FALSE/IS NOT TRUE/IS NOT FALSE can not support in ClickHouse
> System(test with all versions about it).
> 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)
