[jira] [Created] (SPARK-40297) CTE outer reference nested in CTE main body cannot be resolved

["Wei Xue (Jira)" <ji...@apache.org>]

Wei Xue created SPARK-40297:
-------------------------------

             Summary: CTE outer reference nested in CTE main body cannot be resolved
                 Key: SPARK-40297
                 URL: https://issues.apache.org/jira/browse/SPARK-40297
             Project: Spark
          Issue Type: Bug
          Components: SQL
    Affects Versions: 3.3.0
            Reporter: Wei Xue


AnalysisException "Table or view not found" is thrown when a CTE reference occurs in an inner CTE definition nested in the outer CTE's main body FROM clause. E.g.,

{code}
WITH cte_outer AS (
  SELECT 1
)
SELECT * FROM (
  WITH cte_inner AS (
    SELECT * FROM cte_outer
  )
  SELECT * FROM cte_inner
)
{code}




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

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