[jira] [Commented] (TAJO-850) OUTER JOIN does not properly handle a NULL.

["Hyunsik Choi (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TAJO-850?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14028223#comment-14028223 ] 

Hyunsik Choi commented on TAJO-850:
-----------------------------------

Thank you for sharing the documents.

> 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)