drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aman Sinha (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-831) NOT-IN query returns wrong results if right side is empty
Date Fri, 23 May 2014 20:27:03 GMT
Aman Sinha created DRILL-831:
--------------------------------

             Summary: 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


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