[
https://issues.apache.org/jira/browse/SPARK-60747?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Uroš Bojanić resolved SPARK-60747.
----------------------------------
Fix Version/s: 4.4.0
Resolution: Fixed
Issue resolved by pull request 59958
[https://github.com/apache/spark/pull/59958]
> 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, Tests
> Affects Versions: 4.4.0
> Reporter: Vladan Vasić
> Assignee: Vladan Vasić
> Priority: Major
> Labels: pull-request-available
> Fix For: 4.4.0
>
>
> 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]
