You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@drill.apache.org by "Jacques Nadeau (JIRA)" <ji...@apache.org> on 2014/06/09 07:35:14 UTC

[jira] [Resolved] (DRILL-663) Outer joins having no matches result in 0 instead of null

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