You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "Stamatis Zampetakis (JIRA)" <ji...@apache.org> on 2018/09/20 16:00:05 UTC

[jira] [Created] (CALCITE-2582) FilterProjectTransposeRule does not always simplify the new filter condition

Stamatis Zampetakis created CALCITE-2582:
--------------------------------------------

             Summary: FilterProjectTransposeRule does not always simplify the new filter condition
                 Key: CALCITE-2582
                 URL: https://issues.apache.org/jira/browse/CALCITE-2582
             Project: Calcite
          Issue Type: Improvement
          Components: core
    Affects Versions: 1.17.0
            Reporter: Stamatis Zampetakis
            Assignee: Julian Hyde
             Fix For: 1.18.0


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). 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)