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