[
https://issues.apache.org/jira/browse/TAJO-850?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14009196#comment-14009196
]
ASF GitHub Bot commented on TAJO-850:
-------------------------------------
GitHub user babokim opened a pull request:
https://github.com/apache/tajo/pull/22
TAJO-850: OUTER JOIN does not properly handle a NULL.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/babokim/tajo TAJO-850
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/tajo/pull/22.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 #22
----
commit 922e4b9d820d7f1330097f16392e3c0c65f2e23b
Author: 김형준 <[email protected]>
Date: 2014-05-20T17:30:38Z
TAJO-830
commit e8e8efe933269abd147dfb0504f7b57e65a08183
Author: 김형준 <[email protected]>
Date: 2014-05-20T17:37:21Z
Merge branch 'master' of https://git-wip-us.apache.org/repos/asf/tajo
commit d8b4fa9b046c8a04cbd6fcd7a5b6724068ff8b1b
Author: 김형준 <[email protected]>
Date: 2014-05-20T17:42:14Z
Tajo 830: Some filter conditions with a SUBQUERY are removed by optimizer.
=> Remove unused test code
commit 3f6b6d0918645de5b27ef748f30c3beb733d6894
Author: 김형준 <[email protected]>
Date: 2014-05-25T05:10:57Z
TAJO-830:Some filter conditions with a SUBQUERY are removed by
optimizer(remove the korean comment)
commit e87b72725b384496b7e7667e85a5032270ac21af
Author: 김형준 <[email protected]>
Date: 2014-05-26T13:18:40Z
TAJO-850: OUTER JOIN does not properly handle a NULL.
commit 9215829f52130ce7c8b31fd49c794865a4924e15
Author: 김형준 <[email protected]>
Date: 2014-05-27T01:09:41Z
Merge branch 'TAJO-830' of https://github.com/babokim/tajo
Conflicts:
tajo-common/src/main/java/org/apache/tajo/conf/TajoConf.java
commit eda038cc492dba0e8a8e914bfaf95158aea31807
Author: 김형준 <[email protected]>
Date: 2014-05-27T01:34:10Z
Merge branch 'master' of https://git-wip-us.apache.org/repos/asf/tajo
Conflicts:
tajo-core/src/main/java/org/apache/tajo/engine/planner/LogicalPlan.java
tajo-core/src/main/java/org/apache/tajo/engine/planner/logical/GroupbyNode.java
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
> Priority: Minor
>
> 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)
