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

dataroaring pushed a commit to branch branch-3.0
in repository https://gitbox.apache.org/repos/asf/doris.git


The following commit(s) were added to refs/heads/branch-3.0 by this push:
     new b76afc0ab8a branch-3.0: [Test](check) Add check for create view #46204 
(#46333)
b76afc0ab8a is described below

commit b76afc0ab8ab90930fa1c36bfd7b1936a97abbd6
Author: github-actions[bot] 
<41898282+github-actions[bot]@users.noreply.github.com>
AuthorDate: Tue Jan 7 14:48:53 2025 +0800

    branch-3.0: [Test](check) Add check for create view #46204 (#46333)
    
    Cherry-picked from #46204
    
    Co-authored-by: Uniqueyou <[email protected]>
---
 .../suites/check_before_quit/check_before_quit.groovy         | 11 +++++++----
 1 file changed, 7 insertions(+), 4 deletions(-)

diff --git a/regression-test/suites/check_before_quit/check_before_quit.groovy 
b/regression-test/suites/check_before_quit/check_before_quit.groovy
index c9a71fe09aa..5d5accf089f 100644
--- a/regression-test/suites/check_before_quit/check_before_quit.groovy
+++ b/regression-test/suites/check_before_quit/check_before_quit.groovy
@@ -233,7 +233,7 @@ suite("check_before_quit", "nonConcurrent,p0") {
 
     def num = allDataBases.size()
 
-    for (int i = 0; i < allDataBases.size(); i++) {
+    for (int i = 0; i < num; i++) {
         def db = allDataBases[i][0]
         if (db == "__internal_schema" || db == "information_schema" || db == 
"mysql") {
             continue
@@ -243,11 +243,14 @@ suite("check_before_quit", "nonConcurrent,p0") {
         for (int j = 0;j < allTables.size();j ++) {
             def tbl = allTables[j][0]
             def createTableSql = sql "show create table ${db}.${tbl}"
-            logger.info("create table sql info: ${createTableSql}")
-            sql "drop table if exists ${tbl}"
+            if (createTableSql[0][1].contains("CREATE VIEW")) {
+                sql "drop view if exists ${tbl}"
+            }else {
+                sql "drop table if exists ${tbl}"
+            }
             sql(createTableSql[0][1])
             def createTableSqlResult = sql "show create table ${tbl}"
-            logger.info("create table sql result info: 
${createTableSqlResult}")
+            logger.info("create table/view sql result info: 
${createTableSqlResult}")
             assertEquals(createTableSqlResult, createTableSql)
         }
     }


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to