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

["Khurram Faraaz (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-5556?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Khurram Faraaz updated DRILL-5556:
----------------------------------
    Component/s: Storage - Text & CSV

> Drill allows "SELECT *, *" query
> --------------------------------
>
>                 Key: DRILL-5556
>                 URL: https://issues.apache.org/jira/browse/DRILL-5556
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - Text & CSV
>    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.4.14#64029)