[jira] [Resolved] (TAJO-1361) Unexpected filter behaviours during outer join processing

["Jihoon Son (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TAJO-1361?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jihoon Son resolved TAJO-1361.
------------------------------
    Resolution: Cannot Reproduce

> Unexpected filter behaviours during outer join processing
> ---------------------------------------------------------
>
>                 Key: TAJO-1361
>                 URL: https://issues.apache.org/jira/browse/TAJO-1361
>             Project: Tajo
>          Issue Type: Bug
>          Components: Planner/Optimizer
>            Reporter: Jihoon Son
>            Assignee: Jihoon Son
>            Priority: Critical
>
> This bug is reported at Apache Tajo Korea User Group https://groups.google.com/forum/#!topic/tajo-user-kr/srFllmbThG0.
> The bug can be reproduced as follows.
> {noformat}
> default> \dfs -cat /test/test.tbl
> 1,1,regist
> 1,2,regist
> 1,1,start
> default> create external table test_a ( id int , id_detail int , status text) using text with ('csvfile.delimiter'=',') location '/test';
> OK
> default> select * from 
> > (select * from test_a  where status='regist')a 
> > left outer join ( select * from test_a where status='start')b 
> > on a.id=b.id and a.id_detail =b.id_detail 
> > where b.id is null and b.id_detail is null;
> Progress: 100%, response time: 1.57 sec
> id,  id_detail,  status,  id,  id_detail,  status
> -------------------------------
> 1,  1,  regist,  1,  1,  start
> 1,  2,  regist,  ,  ,  
> (2 rows, 1.57 sec, 37 B selected)
> {noformat}
> The expected query result is :
> {noformat}
> id,  id_detail,  status,  id,  id_detail,  status
> 1,  2,  regist,  ,  ,  
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)