[CALCITE-6979] Invalid unparse for IS TRUE,IS FALSE,IS NOT TRUE and IS NOT FALSE in ClickHouseDialect - ASF JIRA

XML

Word

Printable

JSON

IS TRUE/ IS FALSE/IS NOT TRUE/IS NOT FALSE can not support in ClickHouse System(test with all versions about it).

such as:

SELECT CAST(1 AS DECIMAL(12, 2)) > 0.00 IS TRUE;

would error out:

Code: 62. DB::Exception: Syntax error: failed at position 824 (TRUE) (line 24, col 44): TRUE;

and convert to IS NOT NULL and BOOLEAN can work well:

select CAST(1 AS DECIMAL(12, 2)) > 0.00 IS NOT NULL AND CAST(1 AS DECIMAL(12, 2)) > 0.00; 
> 1

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

Blocked

CALCITE-7005 Invalid unparse for IS TRUE,IS FALSE,IS NOT TRUE and IS NOT FALSE in Hive/Presto Dialect

is related to

CALCITE-6835 Invalid unparse for IS TRUE,IS FALSE,IS NOT TRUE and IS NOT FALSE in StarRocksDialect

links to

GitHub Pull Request #4327