drill-issues 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-979) Wrong result for Union-All query
Date Fri, 13 Jun 2014 01:15:02 GMT
Aman Sinha created DRILL-979:
--------------------------------

             Summary: Wrong result for Union-All query
                 Key: DRILL-979
                 URL: https://issues.apache.org/jira/browse/DRILL-979
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Aman Sinha
            Assignee: Aman Sinha


The following query gives wrong results.   The last 5 rows should be non-null values from
region table but they are nulls in the result set. 

0: jdbc:drill:zk=local> select n_nationkey, n_nationkey from nation union all select r_regionkey,
r_regionkey from region;
+-------------+--------------+
| n_nationkey | n_nationkey0 |
+-------------+--------------+
| 0           | 0            |
| 1           | 1            |
| 2           | 2            |
| 3           | 3            |
| 4           | 4            |
| 5           | 5            |
| 6           | 6            |
| 7           | 7            |
| 8           | 8            |
| 9           | 9            |
| 10          | 10           |
| 11          | 11           |
| 12          | 12           |
| 13          | 13           |
| 14          | 14           |
| 15          | 15           |
| 16          | 16           |
| 17          | 17           |
| 18          | 18           |
| 19          | 19           |
| 20          | 20           |
| 21          | 21           |
| 22          | 22           |
| 23          | 23           |
| 24          | 24           |
| null        | null         |
| null        | null         |
| null        | null         |
| null        | null         |
| null        | null         |
+-------------+--------------+
30 rows selected (0.166 seconds)



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

Mime
View raw message