[CALCITE-444] Filters wrongly pushed into full outer join

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.9.2-incubating
• Assignee: Laljo John Pullokkaran
• Reporter: Laljo John Pullokkaran
• Created: 23/Oct/14 05:18
• Updated: 02/Sep/15 01:03
• Resolved: 23/Oct/14 20:49

Description

Filter R1.x=10 (R1 full outer join R2 on R1.y=R2.y)
Gets rewritten as
R1 left outer join R2 on R1.y=R2.y and R1.x=10.

This is obviously wrong and produces wrong result.

select count from(select ss.ss_sold_date_sk, ss.ss_item_sk, ss.ss_customer_sk from store_sales ss full outer join date_dim d on ss.ss_sold_date_sk = d.d_date_sk where ss.ss_item_sk = 4496)R;
produces wrong result due to above described problem.

Patch separates the join simplification from Join filter classification.
Predicate Push Down through Join would first simplify Outer Joins before applying predicate push down.