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

Calcite engine. Order by subquery containing WITH clause failed

    XMLWordPrintableJSON

Details

    Description

      For example:

      SELECT * FROM (SELECT 1) ORDER BY (WITH t AS (SELECT 1) SELECT * FROM t)

      Fail with error:

      Failed to validate query. org.apache.calcite.runtime.CalciteContextException: At line 1, column 58: Column 'T' not found in any table

      Related tests: test_correlated_subquery_cte.test_ignore

      Attachments

        Issue Links

          Dependency

          Bug - A problem which impairs or prevents the functions of the product. CALCITE-4926 'ORDER BY' misses alias/table of own 'WITH'

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open
          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
          Testing discovered

          Improvement - An improvement or enhancement to an existing feature or task. IGNITE-21949 Cover SQL T122(WITH (excluding RECURSIVE) in subquery) feature by tests

          • Major - Major loss of function.
          • Resolved

          Activity

            People

              Unassigned Unassigned
              alex_pl Aleksey Plekhanov
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated: