[doris] branch master updated: [fix](nereids) delete view in regression-test (#14607)

[yiguolei]

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 dd21056a4c [fix](nereids) delete view in regression-test (#14607)
dd21056a4c is described below

commit dd21056a4c08cfa170baaee1b75bc1be59f81325
Author: xiaojunjie <971308...@qq.com>
AuthorDate: Sat Nov 26 18:03:21 2022 +0800

    [fix](nereids) delete view in regression-test (#14607)
---
 regression-test/suites/account_p0/test_nereids_row_policy.groovy | 7 ++++---
 1 file changed, 4 insertions(+), 3 deletions(-)

diff --git a/regression-test/suites/account_p0/test_nereids_row_policy.groovy 
b/regression-test/suites/account_p0/test_nereids_row_policy.groovy
index c5649db226..5860527306 100644
--- a/regression-test/suites/account_p0/test_nereids_row_policy.groovy
+++ b/regression-test/suites/account_p0/test_nereids_row_policy.groovy
@@ -44,14 +44,14 @@ suite("test_nereids_row_policy") {
 
     def createPolicy = { name, predicate, type ->
         sql """
-            CREATE ROW POLICY ${name} ON ${dbName}.${tableName}
+            CREATE ROW POLICY IF NOT EXISTS ${name} ON ${dbName}.${tableName}
             AS ${type} TO ${user} USING (${predicate})
         """
     }
 
     def dropPolciy = { name ->
         sql """
-            DROP ROW POLICY ${name} ON ${dbName}.${tableName} FOR ${user}
+            DROP ROW POLICY IF EXISTS ${name} ON ${dbName}.${tableName} FOR 
${user}
         """
     }
 
@@ -69,8 +69,9 @@ suite("test_nereids_row_policy") {
     """
 
     // create view
+    sql "DROP VIEW IF EXISTS ${viewName}"
     sql """
-        create view ${viewName} as select * from ${tableName};
+        CREATE VIEW ${viewName} AS SELECT * FROM ${tableName};
     """
     
     // create user


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