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] [Commented] (DRILL-831) NOT-IN query returns wrong results if right side is empty
Date Wed, 28 May 2014 19:29:03 GMT

    [ https://issues.apache.org/jira/browse/DRILL-831?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14011483#comment-14011483
] 

Jacques Nadeau commented on DRILL-831:
--------------------------------------

fixed in e6a6652

> NOT-IN query returns wrong results if right side is empty
> ---------------------------------------------------------
>
>                 Key: DRILL-831
>                 URL: https://issues.apache.org/jira/browse/DRILL-831
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Aman Sinha
>            Assignee: Aman Sinha
>         Attachments: 0001-Fix-DRILL-831-Execute-the-probe-phase-for-outer-join.patch,
0002-Fix-DRILL-831-Execute-the-probe-phase-for-outer-join.patch
>
>
> 0: jdbc:drill:zk=local> select count(*) from region r1 where r1.r_regionkey not in
(select r2.r_regionkey from region r2 where r2.r_regionkey = 10);
> +--+
> |  |
> +--+
> +--+
> No rows selected
> This correct result is 5 rows since right side of the NOT IN produces 0 rows. 



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message