[
https://issues.apache.org/jira/browse/TAJO-867?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14020666#comment-14020666
]
ASF GitHub Bot commented on TAJO-867:
-------------------------------------
GitHub user babokim opened a pull request:
https://github.com/apache/tajo/pull/35
TAJO-867: OUTER JOIN with empty result subquery produces a wrong result.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/babokim/tajo TAJO-867
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/tajo/pull/35.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #35
----
commit 53797b74f5a0b31425f3bb5a18d336a057f7d5ac
Author: Hyunsik Choi <[email protected]>
Date: 2014-06-05T18:27:25Z
TAJO-868: TestDateTimeFunctions unit test is occasionally failed.
commit 82b39e03a773f407d525116bb7c90a5ded708412
Author: 김형준 <[email protected]>
Date: 2014-06-06T12:44:48Z
TAJO-867: OUTER JOIN with empty result subquery produces a wrong result.
commit 18d6621150b2e2bd4a24de38485a8ca3ef3e2046
Author: 김형준 <[email protected]>
Date: 2014-06-06T12:45:56Z
Merge branch 'TAJO-868' of https://github.com/hyunsik/tajo
commit 144463b7772f1771564c9de66839fd979d3e38d4
Author: 김형준 <[email protected]>
Date: 2014-06-06T14:08:48Z
TAJO-867: OUTER JOIN with empty result subquery produces a wrong result.
add order by clause in some test query.
commit 990f495cbc11ed6e535e5edf879a1c72be46386e
Author: 김형준 <[email protected]>
Date: 2014-06-06T14:10:56Z
Merge branch 'master' of https://git-wip-us.apache.org/repos/asf/tajo
Conflicts:
CHANGES
commit e2b30a8d06d261f78dd4cefbfa3a80897c3c2f76
Author: 김형준 <[email protected]>
Date: 2014-06-07T02:31:41Z
Merge branch 'master' of https://git-wip-us.apache.org/repos/asf/tajo into
TAJO-867
----
> 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)
