cloud-fan commented on code in PR #37588: URL: https://github.com/apache/spark/pull/37588#discussion_r1380278496
########## sql/core/src/test/scala/org/apache/spark/sql/execution/command/ShowTablesSuiteBase.scala: ########## @@ -126,4 +158,258 @@ trait ShowTablesSuiteBase extends QueryTest with DDLCommandTestUtils { } } } + + test("show table in a not existing namespace") { + checkError( + exception = intercept[AnalysisException] { + sql(s"SHOW TABLES IN $catalog.nonexist") + }, + errorClass = "SCHEMA_NOT_FOUND", + parameters = Map("schemaName" -> "`nonexist`")) + } + + test("show table extended in a not existing namespace") { + checkError( + exception = intercept[AnalysisException] { + sql(s"SHOW TABLE EXTENDED IN $catalog.nonexist LIKE '*tbl*'") + }, + errorClass = "SCHEMA_NOT_FOUND", + parameters = Map("schemaName" -> "`nonexist`")) + } + + test("show table extended in a not existing table") { Review Comment: ```suggestion test("show table extended with no matching table") { ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org