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

Simplify predicate of JOIN, and optimize away LIMIT 0

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: None
        • Fix Version/s: 1.7.0
        • Component/s: None
        • Labels:
          None

          Description

          Following CALCITE-996, RelBuilder should simplify predicates in other situations, such as the and method and the join method.

          RelBuilder.filter(false) and RelBuilder.limit(0, 0) should simplify to RelBuilder.empty(), a new method that returns an empty relation. The default implementation returns a Values with no rows, but schema-on-query systems such as Drill might override the empty method.

            Activity

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            julianhyde Julian Hyde added a comment -

            Work in progress: https://github.com/julianhyde/calcite/tree/1056-simplify.

            CALCITE-1054 is similar, lower ambition level, and should make it into release 1.6. This case will have to wait until 1.7.

            Show
            julianhyde Julian Hyde added a comment - Work in progress: https://github.com/julianhyde/calcite/tree/1056-simplify . CALCITE-1054 is similar, lower ambition level, and should make it into release 1.6. This case will have to wait until 1.7.
            Hide
            Permalink
            julianhyde Julian Hyde added a comment -

            Fixed in http://git-wip-us.apache.org/repos/asf/calcite/commit/ee52f691.

            Show
            julianhyde Julian Hyde added a comment - Fixed in http://git-wip-us.apache.org/repos/asf/calcite/commit/ee52f691 .
            Hide
            Permalink
            julianhyde Julian Hyde added a comment -

            Resolved in release 1.7.0 (2016-03-22).

            Show
            julianhyde Julian Hyde added a comment - Resolved in release 1.7.0 (2016-03-22).

              People

              • Assignee:
                julianhyde Julian Hyde
                Reporter:
                julianhyde Julian Hyde
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Development