[ https://issues.apache.org/jira/browse/DRILL-5130?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16062821#comment-16062821 ]
ASF GitHub Bot commented on DRILL-5130: --------------------------------------- Github user arina-ielchiieva closed the pull request at: https://github.com/apache/drill/pull/853 > UNION ALL difference in results > ------------------------------- > > Key: DRILL-5130 > URL: https://issues.apache.org/jira/browse/DRILL-5130 > Project: Apache Drill > Issue Type: Bug > Components: Execution - Flow, Query Planning & Optimization > Affects Versions: 1.9.0 > Reporter: Khurram Faraaz > Assignee: Arina Ielchiieva > Labels: ready-to-commit > Fix For: 1.11.0 > > > Drill 1.9.0 git commit ID: 51246693 > {noformat} > 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) > {noformat} > Postgres 9.3 > {noformat} > 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) > {noformat} -- This message was sent by Atlassian JIRA (v6.4.14#64029)