[
https://issues.apache.org/jira/browse/TAJO-1361?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jihoon Son updated TAJO-1361:
-----------------------------
Summary: Unexpected filter behaviours during outer join processing (was:
Unexpected outer join behaviours)
> 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)
