[jira] [Updated] (SPARK-20690) Subqueries in FROM should have alias names

["Liang-Chi Hsieh (JIRA)" <ji...@apache.org>]

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

Liang-Chi Hsieh updated SPARK-20690:
------------------------------------
    Summary: Subqueries in FROM should have alias names  (was: Analyzer shouldn't add missing attributes through subquery)

> Subqueries in FROM should have alias names
> ------------------------------------------
>
>                 Key: SPARK-20690
>                 URL: https://issues.apache.org/jira/browse/SPARK-20690
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 2.2.0
>            Reporter: Liang-Chi Hsieh
>            Assignee: Liang-Chi Hsieh
>              Labels: release-notes
>             Fix For: 2.3.0
>
>
> We add missing attributes into Filter in Analyzer. But we shouldn't do it through subqueries like this:
> {code}
> select 1 from  (select 1 from onerow t1 LIMIT 1) where  t1.c1=1
> {code}
> This query works in current codebase. However, the outside where clause shouldn't be able to refer t1.c1 attribute.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

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