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

Calcite engine. Correlated queries with ORDER and LIMIT can't be planned

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      For example:

      CREATE TABLE test (a INTEGER)
SELECT (SELECT test.a FROM test t ORDER BY 1 LIMIT 1) FROM test

      Fail with:

      org.apache.calcite.plan.RelOptPlanner$CannotPlanException: There are not enough rules to produce a node with desired properties

      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
          links to

          Web Link GitHub Pull Request #9705

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 0.5h
                  0.5h