[
https://issues.apache.org/jira/browse/DRILL-663?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Nadeau resolved DRILL-663.
----------------------------------
Resolution: Fixed
> Outer joins having no matches result in 0 instead of null
> ---------------------------------------------------------
>
> Key: DRILL-663
> URL: https://issues.apache.org/jira/browse/DRILL-663
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Ramana Inukonda Nagaraj
>
> select c.C_custkey,c.C_NAME,o.O_ORDERKEY from customer c left outer join
> orders o on c.c_custkey = o.o_custkey;
> When the join condition is not satisfied postgres returns null for O_ORDERKEY
> while we return 0.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
