[
https://issues.apache.org/jira/browse/TAJO-867?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14045541#comment-14045541
]
Hudson commented on TAJO-867:
-----------------------------
SUCCESS: Integrated in Tajo-master-build #268 (See
[https://builds.apache.org/job/Tajo-master-build/268/])
TAJO-867: OUTER JOIN with empty result subquery produces a wrong result.
(Hyoungjun Kim via hyunsik) (hyunsik: rev
cdd358879051a19a421a9441550afbeac21c5709)
* tajo-client/src/main/java/org/apache/tajo/cli/ExecExternalShellCommand.java
* tajo-core/src/test/java/org/apache/tajo/engine/query/TestJoinQuery.java
* tajo-core/src/test/resources/queries/TestJoinQuery/testWhereClauseJoin3.sql
* tajo-core/src/main/java/org/apache/tajo/worker/TajoWorker.java
* tajo-core/src/test/resources/queries/TestJoinQuery/testWhereClauseJoin4.sql
* tajo-core/src/main/java/org/apache/tajo/master/TajoMaster.java
* tajo-core/src/main/java/org/apache/tajo/master/querymaster/SubQuery.java
* tajo-core/src/test/resources/queries/TestJoinQuery/testWhereClauseJoin1.sql
* tajo-core/src/test/java/org/apache/tajo/TajoTestingCluster.java
* CHANGES
* tajo-storage/src/main/java/org/apache/tajo/storage/RawFile.java
* tajo-core/src/main/java/org/apache/tajo/master/querymaster/Repartitioner.java
* tajo-common/src/main/java/org/apache/tajo/conf/TajoConf.java
* tajo-core/src/test/resources/queries/TestJoinQuery/testWhereClauseJoin2.sql
*
tajo-core/src/main/java/org/apache/tajo/engine/planner/physical/JoinTupleComparator.java
> 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
> Fix For: 0.9.0
>
>
> 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)
