Details

      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)
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                arina Arina Ielchiieva
                Reporter:
                khfaraaz Khurram Faraaz
                Reviewer:
                Chun Chang
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: