[GitHub] spark issue #10162: [SPARK-11250] [SQL] Generate different alias for columns...

[gatorsmile <gi...@git.apache.org>]

Github user gatorsmile commented on the issue:

    https://github.com/apache/spark/pull/10162
  
    Thanks for submitting this PR. We are following how the SQL interface handles the issue. For example,
    ```SQL
    create table t1(c1 int, c2 int);
    create table t2(c1 int, c2 int);
    
    insert into t1 values (1, 2);
    insert into t2 values (1, 2);
    
    select c1 from (select * from t1, t2) t;
    ```
    
    When Oracle executing the last line, it will trigger the error
    > ORA-00918: column ambiguously defined
    
    We can revisit automatic alias name generation in the future. How about closing this PR now?
    
    



---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org