davidm-db commented on code in PR #47462: URL: https://github.com/apache/spark/pull/47462#discussion_r1689273146
########## sql/catalyst/src/test/scala/org/apache/spark/sql/catalyst/parser/SqlScriptingParserSuite.scala: ########## @@ -263,6 +264,37 @@ class SqlScriptingParserSuite extends SparkFunSuite with SQLHelper { assert(tree.label.nonEmpty) } + test("declare at the beginning") { + val sqlScriptText = + """ + |BEGIN + | DECLARE testVariable1 VARCHAR(50); + | DECLARE testVariable2 INTEGER; + |END""".stripMargin + val tree = parseScript(sqlScriptText) + assert(tree.collection.length == 2) + assert(tree.collection.forall(_.isInstanceOf[SingleStatement])) + assert(tree.collection.forall( + _.asInstanceOf[SingleStatement].parsedPlan.isInstanceOf[CreateVariable])) + } + + test("declare after beginning") { + val sqlScriptText = + """ + |BEGIN + | SELECT 1; + | DECLARE testVariable INTEGER; + |END""".stripMargin + checkError( + exception = intercept[SparkException] { + parseScript(sqlScriptText) + }, + errorClass = "INVALID_VARIABLE_DECLARATION.ONLY_AT_BEGINNING", + parameters = Map("varName" -> "testVariable", "lineNumber" -> "4")) + } + + // TODO Add test for INVALID_VARIABLE_DECLARATION.NOT_ALLOWED_IN_SCOPE exception Review Comment: let's not forget to add this test as well, now that the PR for variable checks has been merged. -- 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