You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Aman Sinha (JIRA)" <ji...@apache.org> on 2014/06/13 03:15:02 UTC
[jira] [Created] (DRILL-979) Wrong result for Union-All query
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)