Peter Toth created SPARK-31535:
----------------------------------
Summary: Fix nested CTE substitution
Key: SPARK-31535
URL: https://issues.apache.org/jira/browse/SPARK-31535
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 3.0.0
Reporter: Peter Toth
The following nested CTE should result empty result instead of {{1}}
{noformat}
WITH t(c) AS (SELECT 1)
SELECT * FROM t
WHERE c IN (
WITH t(c) AS (SELECT 2)
SELECT * FROM t
)
{noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
