Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-6847

ClickHouse doesn't support TRUE/FALSE keywords in its Join predicate

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.38.0
    • 1.39.0
    • core

    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

          Activity

            People

              xuzifu666 Yu Xu
              xuzifu666 Yu Xu
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: