[ https://issues.apache.org/jira/browse/SPARK-28228?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Apache Spark reassigned SPARK-28228: ------------------------------------ Assignee: (was: Apache Spark) > Better support for WITH clause > ------------------------------ > > Key: SPARK-28228 > URL: https://issues.apache.org/jira/browse/SPARK-28228 > Project: Spark > Issue Type: Sub-task > Components: SQL > Affects Versions: 3.0.0 > Reporter: Peter Toth > Priority: Major > > PostgreSQL handles nested WITHs in a different way then Spark does currently. > These queries retunes 1 in Spark while they return 2 in PostgreSQL: > {noformat} > WITH > t AS (SELECT 1), > t2 AS ( > WITH t AS (SELECT 2) > SELECT * FROM t > ) > SELECT * FROM t2 > {noformat} > {noformat} > WITH t AS (SELECT 1) > SELECT ( > WITH t AS (SELECT 2) > SELECT * FROM t > ) > {noformat} -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org