[SPARK-31535] Fix nested CTE substitution

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Component/s: SQL
• Labels: correctness
• Target Version/s: 3.0.0
• Assignee: Peter Toth
• Reporter: Peter Toth
• Created: 23/Apr/20 18:40
• Updated: 26/Apr/20 22:32
• Resolved: 26/Apr/20 22:32

Description

The following nested CTE should result empty result instead of 1

WITH t(c) AS (SELECT 1)
SELECT * FROM t
WHERE c IN (
  WITH t(c) AS (SELECT 2)
  SELECT * FROM t
)