[DRILL-724] select two columns with order by produce wrong results

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Assignee: Chun Chang
• Reporter: Chun Chang
• Created: 13/May/14 23:15
• Updated: 31/Jul/14 06:31
• Resolved: 29/May/14 01:03

Description

postgres:

foodmart=# select c_row, c_int from data order by c_row;
c_row | c_int
------+------------
1 | 0
2 | 1
3 | -1
4 | 12
5 | 123
6 | 92032039
7 | -23395000
8 | -99392039
9 | -2147483648
10 | 2147483647
11 | 32767
12 | -32767
13 | 49032
14 | -4989385
15 | 69834830
16 | 243
17 | -426432
18 | -3904
19 | 489392758
20 | 589032574
21 | 340000504
22 | 0
23 | 1
(23 rows)

drill:

0: jdbc:drill:schema=dfs> select c_row, c_int from data order by c_row;
----------------------+

c_int

c_row

----------------------+

1	0
1	2
-1	3
12	4
123	5
92032039	6
-23395000	7
-99392039	8
-2147483648	9
10	2147483647
32767	11
-32767	12
13	49032
-4989385	14
69834830	15
243	16
-426432	17
-3904	18
489392758	19
589032574	20
340000504	21
22	0
1	23

----------------------+
23 rows selected (10.932 seconds)

notice for drill, on some of the rows, the columns are exchanged.

Issue Links

• relates to: DRILL-765 Order by query will always send an empty record batch as the first record batch