[TAJO-850] OUTER JOIN does not properly handle a NULL.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.9.0
• Assignee: Hyoungjun Kim
• Reporter: Hyoungjun Kim
• Created: 26/May/14 12:41
• Updated: 24/Jun/14 05:49
• Resolved: 24/Jun/14 03:10

Description

See the title. In the case of the following query NULL value is evaluated at the SCAN time.

select
  c_custkey,
  coalesce(orders.o_totalprice, 999.0)
from
  customer left outer join orders on c_name = o_orderstatus

select
  c_custkey,
from
  customer left outer join orders on c_name = o_orderstatus
where o_orderdate is null