Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-31535

Fix nested CTE substitution

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 3.0.0
    • Fix Version/s: 3.0.0
    • Component/s: SQL
    • Labels:
    • Target Version/s:

      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
      )
      

        Attachments

          Activity

            People

            • Assignee:
              petertoth Peter Toth
              Reporter:
              petertoth Peter Toth
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: