Jihoon Son created TAJO-1361:
--------------------------------
Summary: Unexpected outer join behaviours
Key: TAJO-1361
URL: https://issues.apache.org/jira/browse/TAJO-1361
Project: Tajo
Issue Type: Bug
Components: planner/optimizer
Reporter: 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)
