drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jinfeng Ni (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-5556) Drill allows "SELECT *, *" query
Date Tue, 30 May 2017 18:10:04 GMT

    [ https://issues.apache.org/jira/browse/DRILL-5556?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16029852#comment-16029852
] 

Jinfeng Ni commented on DRILL-5556:
-----------------------------------

When same columns appear twice in Select list, Drill choose to rename the second one, while
postgres keep the same column name twice in the final query result. The renaming behavior
comes from Calcite. 

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

Mime
View raw message