[jira] [Created] (DRILL-5552) Drill, but not MySQL allows "SELECT *, a"

[Paul Rogers (JIRA)]

Paul Rogers created DRILL-5552:
----------------------------------

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


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

{code}
a,b,c
10,foo,bar
{code}

Then, I tried the following SELECT:

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

Results:

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

By contrast, the [MySQL flavor of 
SQL|https://dev.mysql.com/doc/refman/5.5/en/select.html] does not allow "*" and 
other column references:

bq. 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.)



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