[DRILL-5556] Drill allows "SELECT *, *" query

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 1.10.0
• Component/s: Storage - Text & CSV
• Assignee: Unassigned
• Reporter: Paul Rogers
• Created: 30/May/17 00:10
• Updated: 06/Jul/17 06:53

Description

Configure the CSV storage plugin to not read the header row. Create a simple CSV file:

10,foo,bar

Issue the following nonsensical query:

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

Get the following results:

columns,columns0
["10","foo","bar"],["10","foo","bar"]

Expected an error as using two unqualified *'s is not valid SQL.