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

["Hyoungjun Kim (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TAJO-850?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Hyoungjun Kim updated TAJO-850:
-------------------------------

    Description: 
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}

  was:
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:sql}

{code:sql}
select
  c_custkey,
from
  customer left outer join orders on c_name = o_orderstatus
where o_orderdate is null
{code}


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