This is an automated email from the ASF dual-hosted git repository.
kxiao pushed a commit to branch branch-2.0
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-2.0 by this push:
new 73f3feac3f6 add case for delete stmt on materialized-view (#25778)
73f3feac3f6 is described below
commit 73f3feac3f6d6e217672ed8b90e34271792eabfd
Author: Pxl <[email protected]>
AuthorDate: Mon Oct 23 23:31:25 2023 +0800
add case for delete stmt on materialized-view (#25778)
---
regression-test/data/mv_p0/k1s2m3/k1s2m3.out | 11 +++++++++++
regression-test/suites/mv_p0/k1s2m3/k1s2m3.groovy | 10 ++++++++++
2 files changed, 21 insertions(+)
diff --git a/regression-test/data/mv_p0/k1s2m3/k1s2m3.out
b/regression-test/data/mv_p0/k1s2m3/k1s2m3.out
index 1da9198a32e..ca71d1d8067 100644
--- a/regression-test/data/mv_p0/k1s2m3/k1s2m3.out
+++ b/regression-test/data/mv_p0/k1s2m3/k1s2m3.out
@@ -62,3 +62,14 @@
2 4
3 \N
+-- !select_mv --
+\N \N
+-4 16
+2 4
+3 \N
+
+-- !select_star --
+\N 4 \N d
+-4 -4 -4 d
+2 2 2 b
+3 -3 \N c
diff --git a/regression-test/suites/mv_p0/k1s2m3/k1s2m3.groovy
b/regression-test/suites/mv_p0/k1s2m3/k1s2m3.groovy
index 9c732f5699b..70d63b905c3 100644
--- a/regression-test/suites/mv_p0/k1s2m3/k1s2m3.groovy
+++ b/regression-test/suites/mv_p0/k1s2m3/k1s2m3.groovy
@@ -98,4 +98,14 @@ suite ("k1s2m3") {
contains "(k1s2m3)"
}
qt_select_mv "select K1,sum(K2*K3) from d_table group by K1 order by K1;"
+
+ sql "delete from d_table where k1=1;"
+
+ explain {
+ sql("select k1,sum(k2*k3) from d_table group by k1 order by k1;")
+ contains "(k1s2m3)"
+ }
+ qt_select_mv "select k1,sum(k2*k3) from d_table group by k1 order by k1;"
+
+ qt_select_star "select * from d_table order by k1;"
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
