[jira] [Updated] (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:all-tabpanel ]

Hyunsik Choi updated TAJO-850:
------------------------------

    Priority: Major  (was: Minor)

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