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)