[DRILL-5552] Drill, but not MySQL allows "SELECT *, a"

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 1.10.0
• Assignee: Unassigned
• Reporter: Paul Rogers
• Created: 29/May/17 22:43
• Updated: 29/May/17 22:43

Description

In working with CSV files, I tried the following file, with headers:

a,b,c
10,foo,bar

Then, I tried the following SELECT:

SELECT *, a FROM `dfs.data.example.csv`

Results:

1 row(s):
a,b,c,a0
10,foo,bar,10

By contrast, the MySQL flavor of SQL does not allow "*" and other column references:

Use of an unqualified * with other items in the select list may produce a parse error.

Proposed solution: Drill should not allow an unqualified star along with other column references. (SELECT a, b, table2.* should be allowed, however.)