drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-663) Outer joins having no matches result in 0 instead of null
Date Mon, 09 Jun 2014 05:35:14 GMT

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

Mime
View raw message