Vladan Vasić created SPARK-60747:
------------------------------------
Summary: Add SQL golden tests for persistent CREATE VIEW
Key: SPARK-60747
URL: https://issues.apache.org/jira/browse/SPARK-60747
Project: Spark
Issue Type: Test
Components: SQL
Affects Versions: 5.0.0
Reporter: Vladan Vasić
Add consolidated SQL golden-file coverage for persistent CREATE VIEW and CREATE
OR REPLACE VIEW.
The tests should exercise:
* View bodies containing joins (including USING and NATURAL), aggregates,
windows, set operations, scalar and correlated subqueries, EXISTS, CTEs, and
file metadata columns.
* Explicit column lists and comments, duplicate columns, existing tables and
views, IF NOT EXISTS, replacement, and recursive dependencies.
* Rejection of temporary view, SQL function, and session-variable references,
including variable references nested under IDENTIFIER clauses, subqueries,
lambdas, and CTEs.
* Constant and variable IDENTIFIER clauses in view targets and bodies,
including the legacy variable-identifier configuration.
* View comments, properties, schema binding, explicit default collations,
nested collations, and legacy auto-generated alias handling.
* EXECUTE IMMEDIATE, EXPLAIN, and invalid CREATE OR REPLACE VIEW IF NOT EXISTS
syntax.
Generate both execution-result and analyzer-plan golden files using
SQLQueryTestSuite on Apache Spark. The tests capture existing upstream
behavior; no production behavior change is proposed.
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
