You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Paul Rogers (JIRA)" <ji...@apache.org> on 2017/05/30 00:11:04 UTC

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

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)