[
https://issues.apache.org/jira/browse/TAJO-850?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14009235#comment-14009235
]
Keuntae Park commented on TAJO-850:
-----------------------------------
It works well !!
However, how about change the name of method
'checkIfCaseWhenWithOuterJoinBeEvaluated' ?
Because, it no longer checks 'case when' only. It additionally checks 'is null'
and 'coalesce'.
One suggestion is 'checkIfShouldBeEvaluatedAtTopMostJoin' or making separate
method for each 'is null' and 'coalesce'.
> 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)
