Neeraja created DRILL-455:
-----------------------------
Summary: Inconsistent order of the fields between the SQL query
and results
Key: DRILL-455
URL: https://issues.apache.org/jira/browse/DRILL-455
Project: Apache Drill
Issue Type: Bug
Reporter: Neeraja
Performed the following query and expect the results to have the same order of
fields specified in query i.e l_returnflag first followed by l_linestatus
followed by count(*). Currently the order is not obeyed.
0: jdbc:drill:> select l_returnflag,l_linestatus, count(*) from lineitem
group by l_returnflag, l_linestatus order by l_returnflag,l_linestatus;
+------------+--------------+--------------+
| EXPR$2 | l_returnflag | l_linestatus |
+------------+--------------+--------------+
| 147790 | A | F |
| 3765 | N | F |
| 0 | N | O |
| 300716 | N | O |
| 148301 | R | F |
+------------+--------------+--------------+
--
This message was sent by Atlassian JIRA
(v6.2#6252)
