[DRILL-7016] Wrong query result with RuntimeFilter enabled when order of join and filter condition is swapped

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.16.0
• Fix Version/s: 1.16.0
• Component/s: Execution - Flow
• Labels: ready-to-commit
• Assignee: Sorabh Hamirwasia
• Reporter: Sorabh Hamirwasia
• Reviewer: Weijie Tong
• Created: 30/Jan/19 05:09
• Updated: 27/Feb/19 18:48
• Resolved: 02/Feb/19 06:29

Description

Below 2 queries generate different results:

Query1: Result: 19826

select count(*)
from 
  customer c, 
  orders o
where 
  c.c_mktsegment = 'HOUSEHOLD' 
  and c.c_custkey = o.o_custkey 

Query2: Result: 2990828

select count(*)
from 
  customer c, 
  orders o
where 
  c.c_custkey = o.o_custkey and
  c.c_mktsegment = 'HOUSEHOLD' 

Issue Links

• is duplicated by: DRILL-6849 Runtime filter queries with nested broadcast returns wrong results
• is required by: DRILL-6871 Enabling runtime filter eliminates more incoming rows than it should.
• links to: GitHub Pull Request #1628