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