[DRILL-5130] UNION ALL difference in results

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.9.0
• Fix Version/s: 1.11.0
• Component/s: Execution - Flow, Query Planning & Optimization
• Labels: ready-to-commit
• Assignee: Arina Ielchiieva
• Reporter: Khurram Faraaz
• Reviewer: Chun Chang
• Created: 14/Dec/16 06:24
• Updated: 31/Aug/17 22:14
• Resolved: 26/Jun/17 09:09

Description

Drill 1.9.0 git commit ID: 51246693

0: jdbc:drill:schema=dfs.tmp> values(1,2,3,4,5,6) union all values(7,8,9,10,11,12);
+---------+---------+---------+---------+---------+---------+
| EXPR$0  | EXPR$1  | EXPR$2  | EXPR$3  | EXPR$4  | EXPR$5  |
+---------+---------+---------+---------+---------+---------+
| 7       | 8       | 9       | 10      | 11      | 12      |
| 7       | 8       | 9       | 10      | 11      | 12      |
+---------+---------+---------+---------+---------+---------+
2 rows selected (0.209 seconds)

Postgres 9.3

postgres=# values(1,2,3,4,5,6) union all values(7,8,9,10,11,12);
 column1 | column2 | column3 | column4 | column5 | column6 
---------+---------+---------+---------+---------+---------
       1 |       2 |       3 |       4 |       5 |       6
       7 |       8 |       9 |      10 |      11 |      12
(2 rows)

Issue Links

• links to: GitHub Pull Request #853