[jira] [Created] (DRILL-5556) Drill allows "SELECT *, *" query

[Paul Rogers (JIRA)]

Paul Rogers created DRILL-5556:
----------------------------------

             Summary: Drill allows "SELECT *, *" query
                 Key: DRILL-5556
                 URL: https://issues.apache.org/jira/browse/DRILL-5556
             Project: Apache Drill
          Issue Type: Bug
    Affects Versions: 1.10.0
            Reporter: Paul Rogers
            Priority: Minor


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

{code}
10,foo,bar
{code}

Issue the following nonsensical query:

{code}
SELECT *, * FROM `dfs.data`.`example.csv`
{code}

Get the following results:

{code}
columns,columns0
["10","foo","bar"],["10","foo","bar"]
{code}

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



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)