[DRILL-3676] Group by ordinal number of an output column results in parse error

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.2.0
• Fix Version/s: 1.17.0
• Component/s: Query Planning & Optimization
• Assignee: Unassigned
• Reporter: Khurram Faraaz
• Created: 20/Aug/15 18:05
• Updated: 08/Jul/19 13:35
• Resolved: 08/Jul/19 13:35

Description

Group by number results in parse error.

0: jdbc:drill:schema=dfs.tmp> select sub_q.col1 from (select col1 from FEWRWSPQQ_101) sub_q group by 1;
Error: PARSE ERROR: At line 1, column 8: Expression 'q.col1' is not being grouped


[Error Id: 0eedafd9-372e-4610-b7a8-d97e26458d58 on centos-02.qa.lab:31010] (state=,code=0)

When we use the column name instead of the number, the query compiles and returns results.

0: jdbc:drill:schema=dfs.tmp> select col1 from (select col1 from FEWRWSPQQ_101) group by col1;
+----------------------+
|         col1         |
+----------------------+
| 65534                |
| 10000000             |
| -1                   |
| 0                    |
| 1                    |
| 13                   |
| 17                   |
| 23                   |
| 1000                 |
| 9999999              |
| 30                   |
| 25                   |
| 1001                 |
| -65535               |
| 5000                 |
| 3000                 |
| 200                  |
| 197                  |
| 4611686018427387903  |
| 9223372036854775806  |
| 9223372036854775807  |
| 92233720385475807    |
+----------------------+
22 rows selected (0.218 seconds)

0: jdbc:drill:schema=dfs.tmp> select sub_query.col1 from (select col1 from FEWRWSPQQ_101) sub_query group by sub_query.col1;
+----------------------+
|         col1         |
+----------------------+
| 65534                |
| 10000000             |
| -1                   |
| 0                    |
| 1                    |
| 13                   |
| 17                   |
| 23                   |
| 1000                 |
| 9999999              |
| 30                   |
| 25                   |
| 1001                 |
| -65535               |
| 5000                 |
| 3000                 |
| 200                  |
| 197                  |
| 4611686018427387903  |
| 9223372036854775806  |
| 9223372036854775807  |
| 92233720385475807    |
+----------------------+
22 rows selected (0.177 seconds)