Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-16046

Calcite engine. Double JOIN hangs on optimization phase

    XMLWordPrintableJSON

Details

    Description

      Reproducer:

      CREATE TABLE T1(A INT, B INT);
CREATE TABLE T2(A INT, C INT);
CREATE TABLE T3(B INT, C INT);
SELECT * FROM T1 JOIN T2 ON (T1.A = T2.A) JOIN T3 ON (T1.B = T3.B AND T2.C = T3.C);

      Attachments

        Issue Links

          is part of

          New Feature - A new feature of the product, which has yet to be developed. IGNITE-12248 Apache Calcite based query execution engine

          • Major - Major loss of function.
          • Open
          is related to

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-16151 Introduce timeout for calcite planner

          • Major - Major loss of function.
          • Resolved

          Activity

            People

              ivandasch Ivan Daschinsky
              alex_pl Aleksey Plekhanov
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated: