You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@tajo.apache.org by "Jihoon Son (JIRA)" <ji...@apache.org> on 2016/05/04 10:39:12 UTC
[jira] [Resolved] (TAJO-2135) Invalid join result when join key
columns contain nulls
[ https://issues.apache.org/jira/browse/TAJO-2135?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jihoon Son resolved TAJO-2135.
------------------------------
Resolution: Fixed
> Invalid join result when join key columns contain nulls
> -------------------------------------------------------
>
> Key: TAJO-2135
> URL: https://issues.apache.org/jira/browse/TAJO-2135
> Project: Tajo
> Issue Type: Bug
> Affects Versions: 0.11.0
> Reporter: Jihoon Son
> Assignee: Jihoon Son
> Priority: Critical
> Fix For: 0.12.0, 0.11.3
>
>
> You can simply reproduce this bug as follows. The correct answer of the below query is 20965674.
> {noformat}
> 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)
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)