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 ffa1d4d96a [regression-test](mtmv) drop table and mv before running
the case (#17802)
ffa1d4d96a is described below
commit ffa1d4d96a6bd9d38bafdf16fcb88a10df9363c3
Author: Mingyu Chen <[email protected]>
AuthorDate: Thu Mar 16 11:16:06 2023 +0800
[regression-test](mtmv) drop table and mv before running the case (#17802)
To avoid table or mv already exist problem
---
regression-test/suites/mtmv_p0/test_create_mtmv.groovy | 6 ++++++
1 file changed, 6 insertions(+)
diff --git a/regression-test/suites/mtmv_p0/test_create_mtmv.groovy
b/regression-test/suites/mtmv_p0/test_create_mtmv.groovy
index 47d151c96f..a3b209b76c 100644
--- a/regression-test/suites/mtmv_p0/test_create_mtmv.groovy
+++ b/regression-test/suites/mtmv_p0/test_create_mtmv.groovy
@@ -23,6 +23,9 @@ suite("test_create_mtmv") {
ADMIN SET FRONTEND CONFIG("enable_mtmv_scheduler_framework"="true");
"""
+ sql """"drop table if exists `${tableName}`""
+ sql """"drop table if exists `${tableNamePv}`""
+
sql """
CREATE TABLE IF NOT EXISTS `${tableName}` (
event_day DATE,
@@ -52,6 +55,9 @@ suite("test_create_mtmv") {
sql """
INSERT INTO ${tableNamePv}
VALUES("2022-10-26",1,200),("2022-10-28",2,200),("2022-10-28",3,300);
"""
+
+ sql """drop materialized view if exists ${mvName}"""
+
sql """
CREATE MATERIALIZED VIEW ${mvName}
BUILD IMMEDIATE REFRESH COMPLETE
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
