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 <[email protected]>
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: [email protected]
For additional commands, e-mail: [email protected]
