Mihailo Aleksic created SPARK-52217:
---------------------------------------

             Summary: Skip outer reference validation under Filter in 
single-pass resolver
                 Key: SPARK-52217
                 URL: https://issues.apache.org/jira/browse/SPARK-52217
             Project: Spark
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 4.1.0
            Reporter: Mihailo Aleksic


Validation for outer references in subquery expressions is done in the bottom 
up manner in single-pass resolver. In other words, we do the validation right 
after we resolve the subquery expression and at that moment missing attributes 
haven't been pushed down yet. Because of that, we fail with 
UNSUPPORTED_SUBQUERY_EXPRESSION_CATEGORY.MUST_AGGREGATE_CORRELATED_SCALAR_SUBQUERY.
 With the validation disabled, we fail with UNRESOLVED_COLUMN.WITH_SUGGESTION 
on the unhappy path and pass on the happy path which was intended.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

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

Reply via email to