yjhjstz commented on code in PR #725:
URL: https://github.com/apache/cloudberry/pull/725#discussion_r1875085340
##########
src/test/regress/expected/dynamic_table.out:
##########
@@ -0,0 +1,326 @@
+-- start_matchsubs
+-- m/ERROR: can not drop a internal task "gp_dynamic_table_refresh_.*/
+-- s/ERROR: can not drop a internal task "gp_dynamic_table_refresh_.*/ERROR:
can not drop a internal task "gp_dynamic_table_refresh_xxx"/g
+-- m/WARNING: relation of oid "\d+" is not dynamic table/
+-- s/WARNING: relation of oid "\d+" is not dynamic table/WARNING: relation
of oid "XXX" is not dynamic table/g
+-- end_matchsubs
+CREATE SCHEMA dynamic_table_schema;
+SET search_path TO dynamic_table_schema;
+SET optimizer = OFF;
+CREATE TABLE t1(a int, b int, c int) DISTRIBUTED BY (b);
+INSERT INTO t1 SELECT i, i + 1, i + 2 FROM GENERATE_SERIES(1, 10) i;
+INSERT INTO t1 SELECT i, i + 1, i + 2 FROM GENERATE_SERIES(1, 5) i;
+ANALYZE t1;
+CREATE DYNAMIC TABLE dt0 SCHEDULE '5 * * * *' AS
+ SELECT a, b, sum(c) FROM t1 GROUP BY a, b DISTRIBUTED BY(b);
Review Comment:
but I found that "Empty relids means the view is not supported now."
```
InsertMatviewAuxEntry(Oid mvoid, const Query *viewQuery, bool skipdata)
{
Relation mvauxRel;
HeapTuple tup;
bool nulls[Natts_gp_matview_aux];
Datum values[Natts_gp_matview_aux];
List *relids;
NameData mvname;
bool has_foreign = false;
Assert(OidIsValid(mvoid));
/* Empty relids means the view is not supported now. */
relids = GetViewBaseRelids(viewQuery, &has_foreign);
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
