You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@tajo.apache.org by "Hyoungjun Kim (JIRA)" <ji...@apache.org> on 2014/06/05 14:42:02 UTC
[jira] [Created] (TAJO-867) OUTER JOIN with empty result subquery
produces a wrong result.
Hyoungjun Kim created TAJO-867:
----------------------------------
Summary: OUTER JOIN with empty result subquery produces a wrong result.
Key: TAJO-867
URL: https://issues.apache.org/jira/browse/TAJO-867
Project: Tajo
Issue Type: Bug
Reporter: Hyoungjun Kim
Assignee: Hyoungjun Kim
Priority: Minor
In the following query if a subquery has no data, a Execution block for final outer join has only one task and final result is wrong.
{code:sql}
select *
from table1 a
outer join (select * from table2 where code = '1') b
on a.id = b.id
{code}
--
This message was sent by Atlassian JIRA
(v6.2#6252)