Hyoungjun Kim created TAJO-850:
----------------------------------
Summary: 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:sql}
{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)
