[TAJO-2135] Invalid join result when join key columns contain nulls

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 0.11.0
• Fix Version/s: 0.12.0, 0.11.3
• Assignee: Jihoon Son
• Reporter: Jihoon Son
• Created: 22/Apr/16 13:40
• Updated: 04/May/16 10:38
• Resolved: 04/May/16 10:38

Description

You can simply reproduce this bug as follows. The correct answer of the below query is 20965674.

tpcds100> select count(*) from store_sales, store_returns 
where 
ss_customer_sk = sr_customer_sk 
and ss_item_sk = sr_item_sk 
;
[=========================================>] 100%  33.315 sec
?count
-------------------------------
101145653
(1 rows, 33.315 sec, 16 B selected)

Issue Links

• is related to: TAJO-2141 Fix invalid null handling with NOT IN clause