[DRILL-979] Wrong result for Union-All query

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Execution - Relational Operators
• Assignee: DrillCommitter
• Reporter: Aman Sinha
• Created: 13/Jun/14 01:13
• Updated: 31/Jul/14 06:32
• Resolved: 21/Jul/14 02:48

Description

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)