[DRILL-4472] Pushing Filter past Union All fails: DRILL-3257 regressed DRILL-2746 but unit test update break test goal

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.7.0
• Component/s: Query Planning & Optimization
• Assignee: Sean Hsuan-Yi Chu
• Reporter: Jacques Nadeau
• Reviewer: Krystal
• Created: 04/Mar/16 11:39
• Updated: 02/May/16 20:59
• Resolved: 30/Mar/16 00:07

Description

While reviewing DRILL-4467, I discovered this test.

https://github.com/apache/drill/blame/master/exec/java-exec/src/test/java/org/apache/drill/TestUnionAll.java#L560

As you can see, the test is checking that test name confirms that filter is pushed below union all. However, as you can see, the expected result in DRILL-3257 was updated to a plan which doesn't push the in clause below the filter. I'm disabling the test since 4467 happens to remove what becomes a trivial project. However, we really should fix the core problem (a regression of DRILL-2746.

Issue Links

• is part of: DRILL-4476 Enhance Union-All operator for dealing with empty left input or empty both inputs