Vladan Vasić created SPARK-60583:
------------------------------------
Summary: Add golden tests for SHOW commands
Key: SPARK-60583
URL: https://issues.apache.org/jira/browse/SPARK-60583
Project: Spark
Issue Type: Test
Components: SQL
Affects Versions: 5.0.0
Reporter: Vladan Vasić
Add a consolidated SQL golden test, show-commands.sql, for SHOW CATALOGS,
SHOW COLLATIONS and SHOW CURRENT NAMESPACE, including the CURRENT DATABASE and
CURRENT SCHEMA aliases. Generate both execution-result and analyzed-plan golden
files.
Cover 11 SHOW scenarios:
* Catalogs: catalog loading, case-insensitive wildcard filtering and no-match
patterns.
* Current namespace: the session catalog's default and changed databases, a
catalog with
an empty default namespace, a quoted multipart V2 namespace and the
DATABASE/SCHEMA aliases.
* Collations: a bounded UTF8/ICU wildcard and alternation selection, exact
matching without
LIKE and a no-match pattern.
These tests protect output schemas, returned values and analyzed command nodes
without
changing runtime behavior. Use a bounded collation selection rather than
snapshotting
the entire ICU inventory.
--
This message was sent by Atlassian Jira
(v10.3.26#10030026)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
