This is an automated email from the ASF dual-hosted git repository.
zykkk pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 8cae0848d09 [regression](show stmt) Add test checkpoint for the Show
Procedure status and Show create procedure command (#35395)
8cae0848d09 is described below
commit 8cae0848d0967196cdef932bc01104a5f1b38a57
Author: Vallish Pai <vallish...@gmail.com>
AuthorDate: Sun Jun 2 19:26:00 2024 +0530
[regression](show stmt) Add test checkpoint for the Show Procedure status
and Show create procedure command (#35395)
improve regression check point for bug #35350
Added EmptySet checkpoint for SHOW PROCEDURE STATUS and SHOW CREATE
PROCEDURE commands.
If empty set return the result in groovy check point will be empty.
if return OK query, the result will contains [0]
added empty check for result for cases where both command return 0 rows.
---
.../suites/plsql_p0/test_plsql_show_procedure.groovy | 16 ++++++++++++++++
1 file changed, 16 insertions(+)
diff --git a/regression-test/suites/plsql_p0/test_plsql_show_procedure.groovy
b/regression-test/suites/plsql_p0/test_plsql_show_procedure.groovy
index 2202be9ee5c..830c06d5c9e 100644
--- a/regression-test/suites/plsql_p0/test_plsql_show_procedure.groovy
+++ b/regression-test/suites/plsql_p0/test_plsql_show_procedure.groovy
@@ -109,6 +109,22 @@ suite("test_plsql_show_procedure") {
sql """SHOW PROCEDURE STATUS where Db="${dbName}" and name =
"test_plsql_show_proc1";"""
sql """SHOW PROCEDURE STATUS where Db="${dbName}" and Name LIKE
"test_plsql_show_proc1";"""
sql """SHOW PROCEDURE STATUS where
procedureName="test_plsql_show_proc1";"""
+
+ test {
+ sql """SHOW PROCEDURE STATUS where
procedureName="not_exist_procedure";"""
+ check { result, ex, startTime, endTime ->
+ assertTrue(result.isEmpty());
+ }
+ }
+
+ test {
+ sql """SHOW CREATE PROCEDURE not_exist_procedure;"""
+ check { result, ex, startTime, endTime ->
+ assertTrue(result.isEmpty());
+ }
+ }
+
+
sql """DROP PROC test_plsql_show_proc1"""
sql """DROP PROC test_plsql_show_proc2"""
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
