Peter Toth created SPARK-28299:
----------------------------------
Summary: Evaluation of multiple CTE uses
Key: SPARK-28299
URL: https://issues.apache.org/jira/browse/SPARK-28299
Project: Spark
Issue Type: Sub-task
Components: SQL
Affects Versions: 3.0.0
Reporter: Peter Toth
This query returns 2 in Spark SQL (ie. the CTE is evaluated twice), but it
returns 1 in PostgreSQL.
{noformat}
WITH t(x) AS (SELECT random())
SELECT count(*) FROM (
SELECT * FROM t
UNION
SELECT * FROM t
) x
{noformat}
I tested MSSQL too and it returns 2 as Spark SQL does. Further tests are needed
on different DBs...
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
