[jira] [Created] (SPARK-27769) Handling of sublinks within outer-level aggregates.

["Xiao Li (JIRA)" <ji...@apache.org>]

Xiao Li created SPARK-27769:
-------------------------------

             Summary: Handling of sublinks within outer-level aggregates.
                 Key: SPARK-27769
                 URL: https://issues.apache.org/jira/browse/SPARK-27769
             Project: Spark
          Issue Type: Sub-task
          Components: SQL
    Affects Versions: 3.0.0
            Reporter: Xiao Li


{code:java}
-- !query 39
select
 (select max((select i.unique2 from tenk1 i where i.unique1 = o.unique1)))
from tenk1 o
-- !query 39 schema
struct<>
-- !query 39 output
org.apache.spark.sql.AnalysisException
cannot resolve '`o.unique1`' given input columns: [i.two, i.odd, i.string4, i.ten, i.twothousand, i.thousand, i.fivethous, i.stringu2, i.hundred, i.unique1, i.stringu1, i.twenty, i.even, i.four, i.tenthous, i.unique2]; line 2 pos 63{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

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