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

FilterProjectTransposeRule does not always simplify the new filter condition

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.17.0
    • Fix Version/s: 1.19.0
    • Component/s: core

      Description

      After pushing the filter below the project a new condition is going to be generated along with a new Filter operator. The new condition is not going to be simplified if the filter operator is copied and not created using the RelBuilder. 

      Thus the resulting plan may contain redundant conditions which can have a slight impact on performance. Apart, from that tests verifying the resulting (logical/physical) plan may produce indeterministic results if the rule is applied with (a different order and in combination with other rules). 

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                julianhyde Julian Hyde
                Reporter:
                zabetak Stamatis Zampetakis
              • Votes:
                0 Vote for this issue
                Watchers:
                6 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 - 10m
                  10m