[
https://issues.apache.org/jira/browse/TAJO-850?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14041729#comment-14041729
]
Hudson commented on TAJO-850:
-----------------------------
SUCCESS: Integrated in Tajo-master-build #253 (See
[https://builds.apache.org/job/Tajo-master-build/253/])
TAJO-850: OUTER JOIN does not properly handle a NULL. (Hyoungjun Kim via
hyunsik) (hyunsik: rev be21bc706d9ebade71e976ecb966149cf1272385)
*
tajo-core/src/test/resources/queries/TestJoinQuery/testLeftOuterJoinWithNull1.sql
*
tajo-core/src/test/resources/queries/TestJoinQuery/testLeftOuterJoinWithNull2.sql
*
tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithNull1.result
* tajo-core/src/test/resources/queries/TestJoinQuery/oj_table2_ddl.sql
*
tajo-core/src/test/resources/queries/TestJoinQuery/testLeftOuterJoinWithNull3.sql
*
tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithNull3.result
* tajo-core/src/test/resources/queries/TestJoinQuery/oj_table1_ddl.sql
* CHANGES
* tajo-core/src/main/java/org/apache/tajo/engine/eval/EvalTreeUtil.java
* tajo-core/src/main/java/org/apache/tajo/engine/planner/LogicalPlanner.java
* tajo-core/src/test/java/org/apache/tajo/engine/query/TestJoinQuery.java
*
tajo-core/src/test/resources/results/TestJoinQuery/testLeftOuterJoinWithNull2.result
*
tajo-core/src/main/java/org/apache/tajo/engine/planner/rewrite/FilterPushDownRule.java
> OUTER JOIN does not properly handle a NULL.
> -------------------------------------------
>
> Key: TAJO-850
> URL: https://issues.apache.org/jira/browse/TAJO-850
> Project: Tajo
> Issue Type: Bug
> Reporter: Hyoungjun Kim
> Assignee: Hyoungjun Kim
> Fix For: 0.9.0
>
>
> See the title. In the case of the following query NULL value is evaluated at
> the SCAN time.
> {code:sql}
> select
> c_custkey,
> coalesce(orders.o_totalprice, 999.0)
> from
> customer left outer join orders on c_name = o_orderstatus
> {code}
> {code:sql}
> select
> c_custkey,
> from
> customer left outer join orders on c_name = o_orderstatus
> where o_orderdate is null
> {code}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
