[jira] [Closed] (OPTIQ-411) Relax ProjectRelbase restriction on duplicate names

["Harish Butani (JIRA)" <ji...@apache.org>]

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

Harish Butani closed OPTIQ-411.
-------------------------------
    Resolution: Not a Problem

Makes sense. 

I don't know if Hive JDBC can get names from the AST. There maybe a way using the SchemaReader in Hive, will follow up.

But this is not an Optiq issue. Thanks for checking.

> Relax ProjectRelbase restriction on duplicate names
> ---------------------------------------------------
>
>                 Key: OPTIQ-411
>                 URL: https://issues.apache.org/jira/browse/OPTIQ-411
>             Project: Optiq
>          Issue Type: Bug
>            Reporter: Harish Butani
>            Assignee: Julian Hyde
>
> ProjectRelBase:180
> {code}
> !Util.isDistinct(rowType.getFieldNames()
> {code}
> disallows duplicate fieldNames. 
> But this the following is allowed in mysql, postgres and hive
> {code}
> create table t1(x int, y int);
> select x,x from t1;
> {code}
> Can optiq relax this check?



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)