This is an automated email from the ASF dual-hosted git repository. wenchen pushed a commit to branch branch-3.3 in repository https://gitbox.apache.org/repos/asf/spark.git
The following commit(s) were added to refs/heads/branch-3.3 by this push: new 0887a2f09fc Revert "[MINOR][TEST][SQL] Add a CTE subquery scope test case" 0887a2f09fc is described below commit 0887a2f09fcd7dc0ddfb4b28f6fc9a4dcae2d93c Author: Wenchen Fan <wenc...@databricks.com> AuthorDate: Wed Dec 28 16:57:18 2022 +0800 Revert "[MINOR][TEST][SQL] Add a CTE subquery scope test case" This reverts commit aa39b06462a98f37be59e239d12edd9f09a25b88. --- .../test/resources/sql-tests/inputs/cte-nested.sql | 10 -------- .../resources/sql-tests/results/cte-legacy.sql.out | 28 ---------------------- .../resources/sql-tests/results/cte-nested.sql.out | 28 ---------------------- .../sql-tests/results/cte-nonlegacy.sql.out | 28 ---------------------- 4 files changed, 94 deletions(-) diff --git a/sql/core/src/test/resources/sql-tests/inputs/cte-nested.sql b/sql/core/src/test/resources/sql-tests/inputs/cte-nested.sql index e5ef2443417..5f12388b9cb 100644 --- a/sql/core/src/test/resources/sql-tests/inputs/cte-nested.sql +++ b/sql/core/src/test/resources/sql-tests/inputs/cte-nested.sql @@ -17,16 +17,6 @@ SELECT ( SELECT * FROM t ); --- Make sure CTE in subquery is scoped to that subquery rather than global --- the 2nd half of the union should fail because the cte is scoped to the first half -SELECT * FROM - ( - WITH cte AS (SELECT * FROM range(10)) - SELECT * FROM cte WHERE id = 8 - ) a -UNION -SELECT * FROM cte; - -- CTE in CTE definition shadows outer WITH t AS (SELECT 1), diff --git a/sql/core/src/test/resources/sql-tests/results/cte-legacy.sql.out b/sql/core/src/test/resources/sql-tests/results/cte-legacy.sql.out index ebdd64c3ac8..264b64ffe96 100644 --- a/sql/core/src/test/resources/sql-tests/results/cte-legacy.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/cte-legacy.sql.out @@ -36,34 +36,6 @@ struct<scalarsubquery():int> 1 --- !query -SELECT * FROM - ( - WITH cte AS (SELECT * FROM range(10)) - SELECT * FROM cte WHERE id = 8 - ) a -UNION -SELECT * FROM cte --- !query schema -struct<> --- !query output -org.apache.spark.sql.AnalysisException -{ - "errorClass" : "TABLE_OR_VIEW_NOT_FOUND", - "sqlState" : "42000", - "messageParameters" : { - "relationName" : "`cte`" - }, - "queryContext" : [ { - "objectType" : "", - "objectName" : "", - "startIndex" : 120, - "stopIndex" : 122, - "fragment" : "cte" - } ] -} - - -- !query WITH t AS (SELECT 1), diff --git a/sql/core/src/test/resources/sql-tests/results/cte-nested.sql.out b/sql/core/src/test/resources/sql-tests/results/cte-nested.sql.out index b6e1793f7d7..2c622de3f36 100644 --- a/sql/core/src/test/resources/sql-tests/results/cte-nested.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/cte-nested.sql.out @@ -36,34 +36,6 @@ struct<scalarsubquery():int> 1 --- !query -SELECT * FROM - ( - WITH cte AS (SELECT * FROM range(10)) - SELECT * FROM cte WHERE id = 8 - ) a -UNION -SELECT * FROM cte --- !query schema -struct<> --- !query output -org.apache.spark.sql.AnalysisException -{ - "errorClass" : "TABLE_OR_VIEW_NOT_FOUND", - "sqlState" : "42000", - "messageParameters" : { - "relationName" : "`cte`" - }, - "queryContext" : [ { - "objectType" : "", - "objectName" : "", - "startIndex" : 120, - "stopIndex" : 122, - "fragment" : "cte" - } ] -} - - -- !query WITH t AS (SELECT 1), diff --git a/sql/core/src/test/resources/sql-tests/results/cte-nonlegacy.sql.out b/sql/core/src/test/resources/sql-tests/results/cte-nonlegacy.sql.out index 546ab7ecb95..283f5a54a42 100644 --- a/sql/core/src/test/resources/sql-tests/results/cte-nonlegacy.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/cte-nonlegacy.sql.out @@ -36,34 +36,6 @@ struct<scalarsubquery():int> 1 --- !query -SELECT * FROM - ( - WITH cte AS (SELECT * FROM range(10)) - SELECT * FROM cte WHERE id = 8 - ) a -UNION -SELECT * FROM cte --- !query schema -struct<> --- !query output -org.apache.spark.sql.AnalysisException -{ - "errorClass" : "TABLE_OR_VIEW_NOT_FOUND", - "sqlState" : "42000", - "messageParameters" : { - "relationName" : "`cte`" - }, - "queryContext" : [ { - "objectType" : "", - "objectName" : "", - "startIndex" : 120, - "stopIndex" : 122, - "fragment" : "cte" - } ] -} - - -- !query WITH t AS (SELECT 1), --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@spark.apache.org For additional commands, e-mail: commits-h...@spark.apache.org