This is an automated email from the ASF dual-hosted git repository.

yiguolei 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 939766df919 [fix](plsql) Fix regression test execute the same name 
procedure in parallel #33234
939766df919 is described below

commit 939766df9197b49191c70a0e5a2c8340502e13f4
Author: Xinyi Zou <zouxiny...@gmail.com>
AuthorDate: Thu Apr 4 00:47:05 2024 +0800

    [fix](plsql) Fix regression test execute the same name procedure in 
parallel #33234
---
 .../suites/plsql_p0/test_plsql_variable.groovy            | 15 ++++++++++-----
 1 file changed, 10 insertions(+), 5 deletions(-)

diff --git a/regression-test/suites/plsql_p0/test_plsql_variable.groovy 
b/regression-test/suites/plsql_p0/test_plsql_variable.groovy
index 8738524f08c..eace315c40c 100644
--- a/regression-test/suites/plsql_p0/test_plsql_variable.groovy
+++ b/regression-test/suites/plsql_p0/test_plsql_variable.groovy
@@ -52,15 +52,15 @@ suite("test_plsql_variable") {
         """
 
     sql """
-        CREATE OR REPLACE PROCEDURE procedure_insert(IN id int, IN name STRING)
+        CREATE OR REPLACE PROCEDURE plsql_variable_insert(IN id int, IN name 
STRING)
         BEGIN
             INSERT INTO ${tableName} VALUES(id, name);
         END;
         """
-    sql """call procedure_insert(111, "plsql111")"""
-    sql """call procedure_insert(222, "plsql222")"""
-    sql """call procedure_insert(333, "plsql333")"""
-    sql """call procedure_insert(111, "plsql333")"""
+    sql """call plsql_variable_insert(111, "plsql111")"""
+    sql """call plsql_variable_insert(222, "plsql222")"""
+    sql """call plsql_variable_insert(333, "plsql333")"""
+    sql """call plsql_variable_insert(111, "plsql333")"""
     qt_select "select sum(id), count(1) from ${tableName}"
 
     sql """
@@ -107,4 +107,9 @@ suite("test_plsql_variable") {
         END;
         """
     qt_select """call plsql_variable3()"""
+
+    sql """DROP PROCEDURE plsql_variable1"""
+    sql """DROP PROCEDURE plsql_variable2"""
+    sql """DROP PROCEDURE plsql_variable3"""
+    sql """DROP PROC plsql_variable_insert"""
 }


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to