[SPARK-33899] v1 SHOW TABLES fails with assert on spark_catalog

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.2.0
• Fix Version/s: 3.1.0
• Component/s: SQL
• Assignee: Max Gekk
• Reporter: Max Gekk
• Created: 24/Dec/20 09:01
• Updated: 28/Dec/20 18:22
• Resolved: 28/Dec/20 09:07

Description

The v1 SHOW TABLES, SHOW TABLE EXTENDED and SHOW VIEWS fail with internal assert when a database is not specified:

spark-sql> show tables in spark_catalog;
20/12/24 11:19:46 ERROR SparkSQLDriver: Failed in [show tables in spark_catalog]
java.lang.AssertionError: assertion failed
	at scala.Predef$.assert(Predef.scala:208)
	at org.apache.spark.sql.catalyst.analysis.ResolveSessionCatalog$$anonfun$apply$1.applyOrElse(ResolveSessionCatalog.scala:366)
	at org.apache.spark.sql.catalyst.analysis.ResolveSessionCatalog$$anonfun$apply$1.applyOrElse(ResolveSessionCatalog.scala:49)
	at org.apache.spark.sql.catalyst.plans.logical.AnalysisHelper.$anonfun$resolveOperatorsUp$3(AnalysisHelper.scala:90)
	at org.apache.spark.sql.catalyst.trees.CurrentOrigin$.withOrigin(TreeNode.scala:73)

Issue Links

• links to: [Github] Pull Request #30915 (MaxGekk)
• links to: [Github] Pull Request #30950 (MaxGekk)
• links to: [Github] Pull Request #30950 (MaxGekk)