[jira] [Assigned] (SPARK-28228) Better support for WITH clause
[ https://issues.apache.org/jira/browse/SPARK-28228?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Apache Spark reassigned SPARK-28228: Assignee: 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 >Assignee: Apache Spark >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
[jira] [Assigned] (SPARK-28228) Better support for WITH clause
[ 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