Details
-
Improvement
-
Status: Closed
-
Major
-
Resolution: Fixed
-
1.38.0
Description
Currently ClickHouseSQL Dialect not support join on boolean type in Calcite,but most system support with the syntax, so need to support it.
syntax like:
select A.id, B.name, B.address from A left join B on true;
query as on true:
default> select a.id
from
`default`.example_table2 as a
left join `default`.example_table2 as b on true;
[2025-02-19 23:36:04] Code: 403, e.displayText() = DB::Exception: Cannot get JOIN keys from JOIN ON section: true (version 21.8.7.22 (official build))
query as on 1=1:
default> select a.id
from
`default`.example_table1 as a
left join `default`.example_table2 as b on 1 =1
[2025-02-20 00:04:20] 18 rows retrieved starting from 1 in 63 ms (execution: 40 ms, fetching: 23 ms)
Attachments
Issue Links
- is related to
-
CALCITE-6819 MSSQL doesn't support TRUE/FALSE keywords in its Join predicate
-
- Closed
-
- links to