This is an automated email from the ASF dual-hosted git repository. panxiaolei pushed a commit to branch case_1024 in repository https://gitbox.apache.org/repos/asf/doris.git
commit f5121e09a1120abe75db5744f7b0763e5628375d Author: BiteTheDDDDt <[email protected]> AuthorDate: Mon Oct 23 17:03:24 2023 +0800 add case for delete stmt on materialized-view --- 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]
