You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudberry.apache.org by av...@apache.org on 2025/04/10 05:00:07 UTC
(cloudberry) 02/02: SINGLENODE and EntryDB materialized view status maintenance optimization.
This is an automated email from the ASF dual-hosted git repository.
avamingli pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/cloudberry.git
commit 49d49b87eee30fbd9bc777e2717be6bf658d89dc
Author: Zhang Mingli <av...@gmail.com>
AuthorDate: Thu Mar 13 18:25:36 2025 +0800
SINGLENODE and EntryDB materialized view status maintenance optimization.
In SINGLENODE mode or when operating as an entry db, we cannot use
the extend libpq to send messages because we are already functioning in
a QD role. Processing modified relations at `EndModifyTable()` is
too late, especially since materialized views are updated when
the executor ends.
This change moves the processing of modified relations to
`ExecModifyTable()` to ensure timely handling of modifications. This
avoids issues with materialized view updates and ensures correct
behavior in SINGLENODE or entry DB scenarios.
Authored-by: Zhang Mingli avamingli@gmail.com
---
src/backend/executor/execMain.c | 2 +-
src/backend/executor/nodeModifyTable.c | 51 ++-
src/test/regress/expected/aqumv.out | 2 +-
src/test/regress/expected/matview_data.out | 2 +-
.../singlenode_regress/expected/matview_data.out | 384 +++++++++++++++++++++
src/test/singlenode_regress/sql/matview_data.sql | 141 ++++++++
6 files changed, 578 insertions(+), 4 deletions(-)
diff --git a/src/backend/executor/execMain.c b/src/backend/executor/execMain.c
index bf79dbbfa3..5bb1463e42 100644
--- a/src/backend/executor/execMain.c
+++ b/src/backend/executor/execMain.c
@@ -553,7 +553,7 @@ standard_ExecutorStart(QueryDesc *queryDesc, int eflags)
else
shouldDispatch = false;
- if (GP_ROLE_DISPATCH == Gp_role && has_writable_operation)
+ if (IS_QD_OR_SINGLENODE() && has_writable_operation)
{
InitExtendProtocolData();
}
diff --git a/src/backend/executor/nodeModifyTable.c b/src/backend/executor/nodeModifyTable.c
index d092fed83d..0a35902481 100644
--- a/src/backend/executor/nodeModifyTable.c
+++ b/src/backend/executor/nodeModifyTable.c
@@ -105,6 +105,12 @@ send_subtag(StringInfoData *buf, ExtendProtocolSubTag subtag, Bitmapset* relids)
static void
notify_modified_relations_to_QD(ModifyTableState *node);
+static void
+notify_modified_relations_local(ModifyTableState *node);
+
+static void
+epd_add_subtag_data(ExtendProtocolSubTag subtag, Bitmapset *relids);
+
/*
* Verify that the tuples to be produced by INSERT match the
* target relation's rowtype
@@ -2997,6 +3003,17 @@ ExecModifyTable(PlanState *pstate)
node->mt_done = true;
+ /*
+ * For SINGLENODE mode or we are entry db, we could not use extend
+ * libpq to send message because we actually already on kind of QD
+ * role.
+ * Process modified relations here instead of EndModifiyTable().
+ * It's too late to do there because we update materialized views
+ * when executor end.
+ */
+ if (IS_QD_OR_SINGLENODE())
+ notify_modified_relations_local(node);
+
return NULL;
}
@@ -3693,11 +3710,43 @@ ExecEndModifyTable(ModifyTableState *node)
*/
ExecEndNode(outerPlanState(node));
- /* Send back lead_relids to QD */
+ /* Notify modified leaf relids to QD */
if (GP_ROLE_EXECUTE == Gp_role && node->has_leaf_changed)
notify_modified_relations_to_QD(node);
}
+/*
+ * notify_modified_relations_local
+ * For SINGLENODE or we are entry db, update the modified relids on local.
+ * To keep consistent, we set the extend protocol data which will be processed
+ * uniformly later at the end of exetuor run.
+ */
+static void
+notify_modified_relations_local(ModifyTableState *node)
+{
+ Assert(epd);
+
+ if (!bms_is_empty(node->mt_leaf_relids_inserted))
+ epd_add_subtag_data(EP_TAG_I, node->mt_leaf_relids_inserted);
+
+ if (!bms_is_empty(node->mt_leaf_relids_updated))
+ epd_add_subtag_data(EP_TAG_U, node->mt_leaf_relids_updated);
+
+ if (!bms_is_empty(node->mt_leaf_relids_deleted))
+ epd_add_subtag_data(EP_TAG_D, node->mt_leaf_relids_deleted);
+}
+
+static void
+epd_add_subtag_data(ExtendProtocolSubTag subtag, Bitmapset *relids)
+{
+ Bitmapset *data = (Bitmapset *) list_nth(epd->subtagdata, subtag);
+
+ data = bms_union(data, relids);
+ list_nth_replace(epd->subtagdata, subtag, data);
+ /* Mark subtag to be consumed. */
+ epd->consumed_bitmap |= 1 << subtag;
+}
+
static void
send_subtag(StringInfoData *buf, ExtendProtocolSubTag subtag, Bitmapset* relids)
{
diff --git a/src/test/regress/expected/aqumv.out b/src/test/regress/expected/aqumv.out
index 64edb134de..eabb56c025 100644
--- a/src/test/regress/expected/aqumv.out
+++ b/src/test/regress/expected/aqumv.out
@@ -3181,7 +3181,7 @@ create materialized view mv_par1 as select count(*) from par_1_prt_1;
create materialized view mv_par1_1 as select count(*) from par_1_prt_1_2_prt_1;
create materialized view mv_par1_2 as select count(*) from par_1_prt_1_2_prt_2;
create materialized view mv_par2 as select count(*) from par_1_prt_2;
-create materialized view mv_par2_2 as select count(*) from par_1_prt_2_2_prt_1;
+create materialized view mv_par2_1 as select count(*) from par_1_prt_2_2_prt_1;
create materialized view mv_par_prune as select count(*) from par where b = 1;
set enable_answer_query_using_materialized_views = on;
explain(costs off, verbose)
diff --git a/src/test/regress/expected/matview_data.out b/src/test/regress/expected/matview_data.out
index 9d37c33c2c..281f89f4c3 100644
--- a/src/test/regress/expected/matview_data.out
+++ b/src/test/regress/expected/matview_data.out
@@ -491,7 +491,7 @@ select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
mv_par1_1 | i
mv_par1 | i
mv_par | i
- mv_par2 | i
+ mv_par2 | u
(6 rows)
refresh materialized view mv_par;
diff --git a/src/test/singlenode_regress/expected/matview_data.out b/src/test/singlenode_regress/expected/matview_data.out
index 242bbc95e3..4139b96f5f 100644
--- a/src/test/singlenode_regress/expected/matview_data.out
+++ b/src/test/singlenode_regress/expected/matview_data.out
@@ -403,6 +403,390 @@ select mvname, datastatus from gp_matview_aux where mvname in ('tri_mv1', 'tri_m
drop trigger trigger_insert_tri_t2 on tri_t1;
drop function trigger_insert_tri_t2;
+-- test partitioned tables
+create table par(a int, b int, c int) partition by range(b)
+ subpartition by range(c) subpartition template (start (1) end (3) every (1))
+ (start(1) end(3) every(1));
+NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Apache Cloudberry data distribution key for this table.
+HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew.
+insert into par values(1, 1, 1), (1, 1, 2), (2, 2, 1), (2, 2, 2);
+create materialized view mv_par as select * from par;
+NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column(s) named 'a' as the Apache Cloudberry data distribution key for this table.
+HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew.
+create materialized view mv_par1 as select * from par_1_prt_1;
+NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column(s) named 'a' as the Apache Cloudberry data distribution key for this table.
+HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew.
+create materialized view mv_par1_1 as select * from par_1_prt_1_2_prt_1;
+NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column(s) named 'a' as the Apache Cloudberry data distribution key for this table.
+HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew.
+create materialized view mv_par1_2 as select * from par_1_prt_1_2_prt_2;
+NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column(s) named 'a' as the Apache Cloudberry data distribution key for this table.
+HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew.
+create materialized view mv_par2 as select * from par_1_prt_2;
+NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column(s) named 'a' as the Apache Cloudberry data distribution key for this table.
+HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew.
+create materialized view mv_par2_1 as select * from par_1_prt_2_2_prt_1;
+NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column(s) named 'a' as the Apache Cloudberry data distribution key for this table.
+HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew.
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+ mvname | datastatus
+-----------+------------
+ mv_par | u
+ mv_par1 | u
+ mv_par1_1 | u
+ mv_par1_2 | u
+ mv_par2 | u
+ mv_par2_1 | u
+(6 rows)
+
+insert into par_1_prt_1 values (1, 1, 1);
+-- mv_par1* shoud be updated
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+ mvname | datastatus
+-----------+------------
+ mv_par1_2 | u
+ mv_par2 | u
+ mv_par2_1 | u
+ mv_par1_1 | i
+ mv_par1 | i
+ mv_par | i
+(6 rows)
+
+insert into par values (1, 2, 2);
+-- mv_par* should be updated
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+ mvname | datastatus
+-----------+------------
+ mv_par1_2 | u
+ mv_par2_1 | u
+ mv_par1_1 | i
+ mv_par1 | i
+ mv_par | i
+ mv_par2 | u
+(6 rows)
+
+refresh materialized view mv_par;
+refresh materialized view mv_par1;
+refresh materialized view mv_par1_1;
+refresh materialized view mv_par1_2;
+refresh materialized view mv_par2;
+refresh materialized view mv_par2_1;
+begin;
+insert into par_1_prt_2_2_prt_1 values (1, 2, 1);
+-- mv_par1* should not be updated
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+ mvname | datastatus
+-----------+------------
+ mv_par1 | u
+ mv_par1_1 | u
+ mv_par1_2 | u
+ mv_par2_1 | i
+ mv_par2 | i
+ mv_par | i
+(6 rows)
+
+abort;
+begin;
+truncate par_1_prt_2;
+-- mv_par1* should not be updated
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+ mvname | datastatus
+-----------+------------
+ mv_par1 | u
+ mv_par1_1 | u
+ mv_par1_2 | u
+ mv_par2_1 | e
+ mv_par2 | e
+ mv_par | e
+(6 rows)
+
+abort;
+truncate par_1_prt_2;
+-- mv_par1* should not be updated
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+ mvname | datastatus
+-----------+------------
+ mv_par1 | u
+ mv_par1_1 | u
+ mv_par1_2 | u
+ mv_par2_1 | e
+ mv_par2 | e
+ mv_par | e
+(6 rows)
+
+refresh materialized view mv_par;
+refresh materialized view mv_par1;
+refresh materialized view mv_par1_1;
+refresh materialized view mv_par1_2;
+refresh materialized view mv_par2;
+refresh materialized view mv_par2_1;
+vacuum full par_1_prt_1_2_prt_1;
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+ mvname | datastatus
+-----------+------------
+ mv_par1_2 | u
+ mv_par2 | u
+ mv_par2_1 | u
+ mv_par1_1 | r
+ mv_par1 | r
+ mv_par | r
+(6 rows)
+
+refresh materialized view mv_par;
+refresh materialized view mv_par1;
+refresh materialized view mv_par1_1;
+refresh materialized view mv_par1_2;
+refresh materialized view mv_par2;
+refresh materialized view mv_par2_1;
+vacuum full par;
+-- all should be updated.
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+ mvname | datastatus
+-----------+------------
+ mv_par2 | r
+ mv_par | r
+ mv_par2_1 | r
+ mv_par1_2 | r
+ mv_par1 | r
+ mv_par1_1 | r
+(6 rows)
+
+refresh materialized view mv_par;
+refresh materialized view mv_par1;
+refresh materialized view mv_par1_1;
+refresh materialized view mv_par1_2;
+refresh materialized view mv_par2;
+refresh materialized view mv_par2_1;
+begin;
+create table par_1_prt_1_2_prt_3 partition of par_1_prt_1 for values from (3) to (4);
+NOTICE: table has parent, setting distribution columns to match parent table
+-- update status when partition of
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+ mvname | datastatus
+-----------+------------
+ mv_par1_1 | u
+ mv_par1_2 | u
+ mv_par2 | u
+ mv_par2_1 | u
+ mv_par1 | e
+ mv_par | e
+(6 rows)
+
+abort;
+begin;
+drop table par_1_prt_1 cascade;
+NOTICE: drop cascades to 3 other objects
+DETAIL: drop cascades to materialized view mv_par1_1
+drop cascades to materialized view mv_par1_2
+drop cascades to materialized view mv_par1
+-- update status when drop table
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+ mvname | datastatus
+-----------+------------
+ mv_par2 | u
+ mv_par2_1 | u
+ mv_par | e
+(3 rows)
+
+abort;
+begin;
+alter table par_1_prt_1 detach partition par_1_prt_1_2_prt_1;
+-- update status when detach
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+ mvname | datastatus
+-----------+------------
+ mv_par1_1 | u
+ mv_par1_2 | u
+ mv_par2 | u
+ mv_par2_1 | u
+ mv_par1 | e
+ mv_par | e
+(6 rows)
+
+abort;
+begin;
+create table new_par(a int, b int, c int);
+NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'a' as the Apache Cloudberry data distribution key for this table.
+HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew.
+-- update status when attach
+alter table par_1_prt_1 attach partition new_par for values from (4) to (5);
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+ mvname | datastatus
+-----------+------------
+ mv_par1_1 | u
+ mv_par1_2 | u
+ mv_par2 | u
+ mv_par2_1 | u
+ mv_par1 | e
+ mv_par | e
+(6 rows)
+
+abort;
+--
+-- Maintain materialized views on partitioned tables from bottom to up.
+--
+insert into par values(1, 1, 1), (1, 1, 2), (2, 2, 1), (2, 2, 2);
+refresh materialized view mv_par;
+refresh materialized view mv_par1;
+refresh materialized view mv_par1_1;
+refresh materialized view mv_par1_2;
+refresh materialized view mv_par2;
+refresh materialized view mv_par2_1;
+begin;
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+ mvname | datastatus
+-----------+------------
+ mv_par | u
+ mv_par1 | u
+ mv_par1_1 | u
+ mv_par1_2 | u
+ mv_par2 | u
+ mv_par2_1 | u
+(6 rows)
+
+insert into par values(1, 1, 1), (1, 1, 2);
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+ mvname | datastatus
+-----------+------------
+ mv_par2 | u
+ mv_par2_1 | u
+ mv_par1_1 | i
+ mv_par1 | i
+ mv_par | i
+ mv_par1_2 | i
+(6 rows)
+
+abort;
+begin;
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+ mvname | datastatus
+-----------+------------
+ mv_par | u
+ mv_par1 | u
+ mv_par1_1 | u
+ mv_par1_2 | u
+ mv_par2 | u
+ mv_par2_1 | u
+(6 rows)
+
+insert into par_1_prt_2_2_prt_1 values(2, 2, 1);
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+ mvname | datastatus
+-----------+------------
+ mv_par1 | u
+ mv_par1_1 | u
+ mv_par1_2 | u
+ mv_par2_1 | i
+ mv_par2 | i
+ mv_par | i
+(6 rows)
+
+abort;
+begin;
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+ mvname | datastatus
+-----------+------------
+ mv_par | u
+ mv_par1 | u
+ mv_par1_1 | u
+ mv_par1_2 | u
+ mv_par2 | u
+ mv_par2_1 | u
+(6 rows)
+
+delete from par where b = 2 and c = 1;
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+ mvname | datastatus
+-----------+------------
+ mv_par1 | u
+ mv_par1_1 | u
+ mv_par1_2 | u
+ mv_par2_1 | e
+ mv_par2 | e
+ mv_par | e
+(6 rows)
+
+abort;
+begin;
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+ mvname | datastatus
+-----------+------------
+ mv_par | u
+ mv_par1 | u
+ mv_par1_1 | u
+ mv_par1_2 | u
+ mv_par2 | u
+ mv_par2_1 | u
+(6 rows)
+
+delete from par_1_prt_1_2_prt_2;
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+ mvname | datastatus
+-----------+------------
+ mv_par1_1 | u
+ mv_par2 | u
+ mv_par2_1 | u
+ mv_par1_2 | e
+ mv_par1 | e
+ mv_par | e
+(6 rows)
+
+abort;
+-- Across partition update.
+begin;
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+ mvname | datastatus
+-----------+------------
+ mv_par | u
+ mv_par1 | u
+ mv_par1_1 | u
+ mv_par1_2 | u
+ mv_par2 | u
+ mv_par2_1 | u
+(6 rows)
+
+update par set c = 2 where b = 1 and c = 1;
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+ mvname | datastatus
+-----------+------------
+ mv_par2 | u
+ mv_par2_1 | u
+ mv_par1_2 | i
+ mv_par1_1 | e
+ mv_par1 | e
+ mv_par | e
+(6 rows)
+
+abort;
+-- Split Update with acrosss partition update.
+begin;
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+ mvname | datastatus
+-----------+------------
+ mv_par | u
+ mv_par1 | u
+ mv_par1_1 | u
+ mv_par1_2 | u
+ mv_par2 | u
+ mv_par2_1 | u
+(6 rows)
+
+update par set c = 2, a = 2 where b = 1 and c = 1;
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+ mvname | datastatus
+-----------+------------
+ mv_par2 | u
+ mv_par2_1 | u
+ mv_par1_2 | i
+ mv_par1_1 | e
+ mv_par1 | e
+ mv_par | e
+(6 rows)
+
+abort;
+--
+-- End of Maintain materialized views on partitioned tables from bottom to up.
+--
-- start_ignore
drop schema matview_data_schema cascade;
NOTICE: drop cascades to 9 other objects
diff --git a/src/test/singlenode_regress/sql/matview_data.sql b/src/test/singlenode_regress/sql/matview_data.sql
index b9c14fab6b..1fdb280a4d 100644
--- a/src/test/singlenode_regress/sql/matview_data.sql
+++ b/src/test/singlenode_regress/sql/matview_data.sql
@@ -156,6 +156,147 @@ select mvname, datastatus from gp_matview_aux where mvname in ('tri_mv1', 'tri_m
drop trigger trigger_insert_tri_t2 on tri_t1;
drop function trigger_insert_tri_t2;
+-- test partitioned tables
+create table par(a int, b int, c int) partition by range(b)
+ subpartition by range(c) subpartition template (start (1) end (3) every (1))
+ (start(1) end(3) every(1));
+insert into par values(1, 1, 1), (1, 1, 2), (2, 2, 1), (2, 2, 2);
+create materialized view mv_par as select * from par;
+create materialized view mv_par1 as select * from par_1_prt_1;
+create materialized view mv_par1_1 as select * from par_1_prt_1_2_prt_1;
+create materialized view mv_par1_2 as select * from par_1_prt_1_2_prt_2;
+create materialized view mv_par2 as select * from par_1_prt_2;
+create materialized view mv_par2_1 as select * from par_1_prt_2_2_prt_1;
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+insert into par_1_prt_1 values (1, 1, 1);
+-- mv_par1* shoud be updated
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+insert into par values (1, 2, 2);
+-- mv_par* should be updated
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+
+refresh materialized view mv_par;
+refresh materialized view mv_par1;
+refresh materialized view mv_par1_1;
+refresh materialized view mv_par1_2;
+refresh materialized view mv_par2;
+refresh materialized view mv_par2_1;
+begin;
+insert into par_1_prt_2_2_prt_1 values (1, 2, 1);
+-- mv_par1* should not be updated
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+abort;
+
+begin;
+truncate par_1_prt_2;
+-- mv_par1* should not be updated
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+abort;
+truncate par_1_prt_2;
+-- mv_par1* should not be updated
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+
+refresh materialized view mv_par;
+refresh materialized view mv_par1;
+refresh materialized view mv_par1_1;
+refresh materialized view mv_par1_2;
+refresh materialized view mv_par2;
+refresh materialized view mv_par2_1;
+vacuum full par_1_prt_1_2_prt_1;
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+
+refresh materialized view mv_par;
+refresh materialized view mv_par1;
+refresh materialized view mv_par1_1;
+refresh materialized view mv_par1_2;
+refresh materialized view mv_par2;
+refresh materialized view mv_par2_1;
+vacuum full par;
+-- all should be updated.
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+
+refresh materialized view mv_par;
+refresh materialized view mv_par1;
+refresh materialized view mv_par1_1;
+refresh materialized view mv_par1_2;
+refresh materialized view mv_par2;
+refresh materialized view mv_par2_1;
+begin;
+create table par_1_prt_1_2_prt_3 partition of par_1_prt_1 for values from (3) to (4);
+-- update status when partition of
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+abort;
+
+begin;
+drop table par_1_prt_1 cascade;
+-- update status when drop table
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+abort;
+
+begin;
+alter table par_1_prt_1 detach partition par_1_prt_1_2_prt_1;
+-- update status when detach
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+abort;
+
+begin;
+create table new_par(a int, b int, c int);
+-- update status when attach
+alter table par_1_prt_1 attach partition new_par for values from (4) to (5);
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+abort;
+
+--
+-- Maintain materialized views on partitioned tables from bottom to up.
+--
+insert into par values(1, 1, 1), (1, 1, 2), (2, 2, 1), (2, 2, 2);
+refresh materialized view mv_par;
+refresh materialized view mv_par1;
+refresh materialized view mv_par1_1;
+refresh materialized view mv_par1_2;
+refresh materialized view mv_par2;
+refresh materialized view mv_par2_1;
+begin;
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+insert into par values(1, 1, 1), (1, 1, 2);
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+abort;
+
+begin;
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+insert into par_1_prt_2_2_prt_1 values(2, 2, 1);
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+abort;
+
+begin;
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+delete from par where b = 2 and c = 1;
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+abort;
+
+begin;
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+delete from par_1_prt_1_2_prt_2;
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+abort;
+
+-- Across partition update.
+begin;
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+update par set c = 2 where b = 1 and c = 1;
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+abort;
+
+-- Split Update with acrosss partition update.
+begin;
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+update par set c = 2, a = 2 where b = 1 and c = 1;
+select mvname, datastatus from gp_matview_aux where mvname like 'mv_par%';
+abort;
+--
+-- End of Maintain materialized views on partitioned tables from bottom to up.
+--
+
-- start_ignore
drop schema matview_data_schema cascade;
-- end_ignore
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cloudberry.apache.org
For additional commands, e-mail: commits-help@cloudberry.apache.org