[CALCITE-2582] FilterProjectTransposeRule does not always simplify the new filter condition

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.17.0
• Fix Version/s: 1.19.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Julian Hyde
• Reporter: Stamatis Zampetakis
• Created: 20/Sep/18 16:00
• Updated: 25/Mar/19 00:11
• Resolved: 21/Feb/19 10:49

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

Issue Links

• links to: GitHub Pull Request #847