diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out /tmp/cirrus-ci-build/build/testrun/regress/regress/results/incremental_matview.out --- /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out 2024-03-04 03:05:18.960394000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/incremental_matview.out 2024-03-04 03:07:31.501363000 +0000 @@ -14,6 +14,7 @@ (4,104); CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_1 AS SELECT i,j,k FROM mv_base_a a INNER JOIN mv_base_b b USING(i) WITH NO DATA; SELECT * FROM mv_ivm_1 ORDER BY 1,2,3; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ERROR: materialized view "mv_ivm_1" has not been populated HINT: Use the REFRESH MATERIALIZED VIEW command. REFRESH MATERIALIZED VIEW mv_ivm_1; @@ -21,6 +22,7 @@ DETAIL: This target list does not have all the primary key columns, or this view does not contain GROUP BY or DISTINCT clause. HINT: Create an index on the materialized view for efficient incremental maintenance. SELECT * FROM mv_ivm_1 ORDER BY 1,2,3; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree i | j | k ---+----+----- 1 | 10 | 101 @@ -60,7 +62,9 @@ -- immediate maintenance BEGIN; INSERT INTO mv_base_b VALUES(5,105); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT * FROM mv_ivm_1 ORDER BY 1,2,3; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree i | j | k ---+----+----- 1 | 10 | 101 @@ -71,7 +75,10 @@ (5 rows) UPDATE mv_base_a SET j = 0 WHERE i = 1; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT * FROM mv_ivm_1 ORDER BY 1,2,3; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree i | j | k ---+----+----- 1 | 0 | 101 @@ -82,7 +89,9 @@ (5 rows) DELETE FROM mv_base_b WHERE (i,k) = (5,105); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT * FROM mv_ivm_1 ORDER BY 1,2,3; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree i | j | k ---+----+----- 1 | 0 | 101 @@ -93,6 +102,7 @@ ROLLBACK; SELECT * FROM mv_ivm_1 ORDER BY 1,2,3; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree i | j | k ---+----+----- 1 | 10 | 101 @@ -121,6 +131,7 @@ BEGIN; TRUNCATE mv_base_a; SELECT * FROM mv_ivm_1; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree i | j | k ---+---+--- (0 rows) @@ -129,6 +140,7 @@ BEGIN; TRUNCATE mv_base_b; SELECT * FROM mv_ivm_1; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree i | j | k ---+---+--- (0 rows) @@ -156,7 +168,10 @@ CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_distinct AS SELECT DISTINCT j FROM mv_base_a; NOTICE: created index "mv_ivm_distinct_index" on materialized view "mv_ivm_distinct" INSERT INTO mv_base_a VALUES(6,20); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT * FROM mv_ivm_duplicate ORDER BY 1; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree j ---- 10 @@ -168,6 +183,7 @@ (6 rows) SELECT * FROM mv_ivm_distinct ORDER BY 1; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree j ---- 10 @@ -178,7 +194,11 @@ (5 rows) DELETE FROM mv_base_a WHERE (i,j) = (2,20); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT * FROM mv_ivm_duplicate ORDER BY 1; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree j ---- 10 @@ -189,6 +209,7 @@ (5 rows) SELECT * FROM mv_ivm_distinct ORDER BY 1; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree j ---- 10 @@ -204,6 +225,7 @@ CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg AS SELECT i, SUM(j), COUNT(i), AVG(j) FROM mv_base_a GROUP BY i; NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg" SELECT * FROM mv_ivm_agg ORDER BY 1,2,3,4; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree i | sum | count | avg ---+-----+-------+--------------------- 1 | 10 | 1 | 10.0000000000000000 @@ -214,7 +236,10 @@ (5 rows) INSERT INTO mv_base_a VALUES(2,100); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT * FROM mv_ivm_agg ORDER BY 1,2,3,4; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree i | sum | count | avg ---+-----+-------+--------------------- 1 | 10 | 1 | 10.0000000000000000 @@ -225,7 +250,12 @@ (5 rows) UPDATE mv_base_a SET j = 200 WHERE (i,j) = (2,100); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT * FROM mv_ivm_agg ORDER BY 1,2,3,4; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree i | sum | count | avg ---+-----+-------+---------------------- 1 | 10 | 1 | 10.0000000000000000 @@ -236,7 +266,10 @@ (5 rows) DELETE FROM mv_base_a WHERE (i,j) = (2,200); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT * FROM mv_ivm_agg ORDER BY 1,2,3,4; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree i | sum | count | avg ---+-----+-------+--------------------- 1 | 10 | 1 | 10.0000000000000000 @@ -252,6 +285,7 @@ CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg AS SELECT i, SUM(j), COUNT(*) FROM mv_base_a GROUP BY i; NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg" SELECT * FROM mv_ivm_agg ORDER BY 1,2,3; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree i | sum | count ---+-----+------- 1 | 10 | 1 @@ -262,7 +296,10 @@ (5 rows) INSERT INTO mv_base_a VALUES(2,100); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT * FROM mv_ivm_agg ORDER BY 1,2,3; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree i | sum | count ---+-----+------- 1 | 10 | 1 @@ -279,6 +316,7 @@ NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg" TRUNCATE mv_base_a; SELECT sum, count FROM mv_ivm_agg; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree sum | count -----+------- (0 rows) @@ -296,20 +334,26 @@ DETAIL: This target list does not have all the primary key columns, or this view does not contain GROUP BY or DISTINCT clause. HINT: Create an index on the materialized view for efficient incremental maintenance. SELECT * FROM mv_ivm_group ORDER BY 1; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree sum | count | avg -----+-------+--------------------- 150 | 5 | 30.0000000000000000 (1 row) INSERT INTO mv_base_a VALUES(6,60); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT * FROM mv_ivm_group ORDER BY 1; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree sum | count | avg -----+-------+--------------------- 210 | 6 | 35.0000000000000000 (1 row) DELETE FROM mv_base_a; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT * FROM mv_ivm_group ORDER BY 1; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree sum | count | avg -----+-------+----- | 0 | @@ -324,6 +368,7 @@ HINT: Create an index on the materialized view for efficient incremental maintenance. TRUNCATE mv_base_a; SELECT sum, count, avg FROM mv_ivm_group; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree sum | count | avg -----+-------+----- | 0 | @@ -341,6 +386,7 @@ CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_avg_bug AS SELECT i, SUM(j), COUNT(j), AVG(j) FROM mv_base_A GROUP BY i; NOTICE: created index "mv_ivm_avg_bug_index" on materialized view "mv_ivm_avg_bug" SELECT * FROM mv_ivm_avg_bug ORDER BY 1,2,3; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree i | sum | count | avg ---+-----+-------+--------------------- 1 | 10 | 1 | 10.0000000000000000 @@ -355,7 +401,10 @@ (1,0), (2,30), (2,30); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT * FROM mv_ivm_avg_bug ORDER BY 1,2,3; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree i | sum | count | avg ---+-----+-------+--------------------- 1 | 10 | 3 | 3.3333333333333333 @@ -366,8 +415,13 @@ (5 rows) DELETE FROM mv_base_a WHERE (i,j) = (1,0); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree DELETE FROM mv_base_a WHERE (i,j) = (2,30); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT * FROM mv_ivm_avg_bug ORDER BY 1,2,3; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree i | sum | count | avg ---+-----+-------+--------------------- 1 | 10 | 1 | 10.0000000000000000 @@ -383,6 +437,7 @@ CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_min_max AS SELECT i, MIN(j), MAX(j) FROM mv_base_a GROUP BY i; NOTICE: created index "mv_ivm_min_max_index" on materialized view "mv_ivm_min_max" SELECT * FROM mv_ivm_min_max ORDER BY 1,2,3; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree i | min | max ---+-----+----- 1 | 10 | 10 @@ -398,7 +453,10 @@ (3,31), (3,32), (4,41), (4,42), (5,51), (5,52); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT * FROM mv_ivm_min_max ORDER BY 1,2,3; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree i | min | max ---+-----+----- 1 | 10 | 12 @@ -409,7 +467,11 @@ (5 rows) DELETE FROM mv_base_a WHERE (i,j) IN ((1,10), (2,21), (3,32)); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT * FROM mv_ivm_min_max ORDER BY 1,2,3; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree i | min | max ---+-----+----- 1 | 11 | 12 @@ -427,6 +489,7 @@ DETAIL: This target list does not have all the primary key columns, or this view does not contain GROUP BY or DISTINCT clause. HINT: Create an index on the materialized view for efficient incremental maintenance. SELECT * FROM mv_ivm_min_max; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree min | max -----+----- 10 | 50 @@ -434,21 +497,29 @@ INSERT INTO mv_base_a VALUES (0,0), (6,60), (7,70); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT * FROM mv_ivm_min_max; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree min | max -----+----- 0 | 70 (1 row) DELETE FROM mv_base_a WHERE (i,j) IN ((0,0), (7,70)); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT * FROM mv_ivm_min_max; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree min | max -----+----- 10 | 60 (1 row) DELETE FROM mv_base_a; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT * FROM mv_ivm_min_max; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree min | max -----+----- | @@ -462,6 +533,7 @@ DETAIL: This target list does not have all the primary key columns, or this view does not contain GROUP BY or DISTINCT clause. HINT: Create an index on the materialized view for efficient incremental maintenance. SELECT * FROM mv_ivm_min; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree min ----- 10 @@ -472,7 +544,11 @@ CREATE TABLE myschema.mv_base_a (j int); INSERT INTO myschema.mv_base_a VALUES (1); DELETE FROM mv_base_a WHERE (i,j) = (1,10); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT * FROM mv_ivm_min; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree min ----- 20 @@ -480,7 +556,11 @@ SET search_path TO myschema,public,pg_catalog; DELETE FROM public.mv_base_a WHERE (i,j) = (2,20); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT * FROM mv_ivm_min; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree min ----- 30 @@ -492,9 +572,18 @@ CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i; NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg" INSERT INTO mv_base_a VALUES (1,100), (2,200), (3,300); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree UPDATE mv_base_a SET j = 2000 WHERE (i,j) = (2,20); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree DELETE FROM mv_base_a WHERE (i,j) = (3,30); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT * FROM mv_ivm_agg ORDER BY 1,2; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree a | sum ---+------ 1 | 110 @@ -509,9 +598,18 @@ CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i; NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg" INSERT INTO mv_base_a VALUES (1,100), (2,200), (3,300); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree UPDATE mv_base_a SET j = 2000 WHERE (i,j) = (2,20); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree DELETE FROM mv_base_a WHERE (i,j) = (3,30); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT * FROM mv_ivm_agg ORDER BY 1,2; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree a | b ---+------ 1 | 110 @@ -536,6 +634,7 @@ DETAIL: This target list does not have all the primary key columns, or this view does not contain GROUP BY or DISTINCT clause. HINT: Create an index on the materialized view for efficient incremental maintenance. SELECT * FROM mv_self ORDER BY v1; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree v1 | v2 ----+---- 10 | 10 @@ -544,9 +643,16 @@ (3 rows) INSERT INTO base_t VALUES (4,40); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree DELETE FROM base_t WHERE i = 1; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree UPDATE base_t SET v = v*10 WHERE i=2; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT * FROM mv_self ORDER BY v1; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree v1 | v2 -----+----- 30 | 30 @@ -560,12 +666,17 @@ upd_t AS (UPDATE base_t SET v = v + 100 RETURNING 1), dlt_t AS (DELETE FROM base_t WHERE i IN (4,5) RETURNING 1) SELECT NULL; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ?column? ---------- (1 row) SELECT * FROM mv_self ORDER BY v1; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree v1 | v2 -----+----- 50 | 50 @@ -577,9 +688,13 @@ --- with sub-transactions SAVEPOINT p1; INSERT INTO base_t VALUES (7,70); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree RELEASE SAVEPOINT p1; INSERT INTO base_t VALUES (7,77); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT * FROM mv_self ORDER BY v1, v2; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree v1 | v2 -----+----- 50 | 50 @@ -605,6 +720,7 @@ DETAIL: This target list does not have all the primary key columns, or this view does not contain GROUP BY or DISTINCT clause. HINT: Create an index on the materialized view for efficient incremental maintenance. SELECT * FROM mv ORDER BY v1; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree v1 | v2 ----+----- 10 | 100 @@ -619,12 +735,17 @@ upd_r AS (UPDATE base_r SET v = v + 1000 WHERE i = 2 RETURNING 1), dlt_s AS (DELETE FROM base_s WHERE i = 3 RETURNING 1) SELECT NULL; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree ?column? ---------- (1 row) SELECT * FROM mv ORDER BY v1; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree v1 | v2 ------+----- 10 | 100 @@ -644,6 +765,7 @@ SELECT ri1.i, ri2.i FROM ri1 JOIN ri2 USING(i); NOTICE: created index "mv_ri_index" on materialized view "mv_ri" SELECT * FROM mv_ri ORDER BY i1; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree i1 | i2 ----+---- 1 | 1 @@ -652,8 +774,12 @@ (3 rows) UPDATE ri1 SET i=10 where i=1; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree DELETE FROM ri1 WHERE i=2; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT * FROM mv_ri ORDER BY i2; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree i1 | i2 ----+---- 3 | 3 @@ -670,6 +796,7 @@ DETAIL: This target list does not have all the primary key columns, or this view does not contain GROUP BY or DISTINCT clause. HINT: Create an index on the materialized view for efficient incremental maintenance. SELECT * FROM mv ORDER BY i; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree i | v ---+---- 1 | 10 @@ -677,7 +804,10 @@ (2 rows) UPDATE base_t SET v = 20 WHERE i = 2; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT * FROM mv ORDER BY i; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree i | v ---+---- 1 | 10 @@ -692,12 +822,15 @@ DETAIL: This target list does not have all the primary key columns, or this view does not contain GROUP BY or DISTINCT clause. HINT: Create an index on the materialized view for efficient incremental maintenance. SELECT * FROM mv ORDER BY i; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree i --- (0 rows) INSERT INTO base_t VALUES (1),(NULL); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT * FROM mv ORDER BY i; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree i --- 1 @@ -711,6 +844,7 @@ CREATE INCREMENTAL MATERIALIZED VIEW mv AS SELECT i, sum(v) FROM base_t GROUP BY i; NOTICE: created index "mv_index" on materialized view "mv" SELECT * FROM mv ORDER BY i; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree i | sum ---+----- 1 | 30 @@ -718,7 +852,10 @@ (2 rows) UPDATE base_t SET v = v * 10; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT * FROM mv ORDER BY i; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree i | sum ---+----- 1 | 300 @@ -732,27 +869,35 @@ CREATE INCREMENTAL MATERIALIZED VIEW mv AS SELECT i, min(v), max(v) FROM base_t GROUP BY i; NOTICE: created index "mv_index" on materialized view "mv" SELECT * FROM mv ORDER BY i; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree i | min | max ---+-----+----- | 1 | 5 (1 row) DELETE FROM base_t WHERE v = 1; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT * FROM mv ORDER BY i; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree i | min | max ---+-----+----- | 2 | 5 (1 row) DELETE FROM base_t WHERE v = 3; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT * FROM mv ORDER BY i; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree i | min | max ---+-----+----- | 2 | 5 (1 row) DELETE FROM base_t WHERE v = 5; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT * FROM mv ORDER BY i; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree i | min | max ---+-----+----- | 2 | 4 @@ -802,7 +947,9 @@ DETAIL: This target list does not have all the primary key columns, or this view does not contain GROUP BY or DISTINCT clause. HINT: Create an index on the materialized view for efficient incremental maintenance. INSERT INTO t_mytype VALUES ('1'::mytype); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT * FROM mv_mytype; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree x --- 1 @@ -910,7 +1057,9 @@ DROP USER IF EXISTS ivm_user; NOTICE: role "ivm_user" does not exist, skipping CREATE USER ivm_admin; +WARNING: roles created by regression test cases should have names starting with "regress_" CREATE USER ivm_user; +WARNING: roles created by regression test cases should have names starting with "regress_" --- create a table with RLS SET SESSION AUTHORIZATION ivm_admin; CREATE TABLE rls_tbl(id int, data text, owner name); @@ -937,6 +1086,7 @@ DETAIL: This target list does not have all the primary key columns, or this view does not contain GROUP BY or DISTINCT clause. HINT: Create an index on the materialized view for efficient incremental maintenance. SELECT id, data, owner FROM ivm_rls ORDER BY 1,2,3; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree id | data | owner ----+------+---------- 1 | foo | ivm_user @@ -947,7 +1097,9 @@ INSERT INTO rls_tbl VALUES (3,'baz','ivm_user'), (4,'qux','postgres'); +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree SELECT id, data, owner FROM ivm_rls ORDER BY 1,2,3; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree id | data | owner ----+------+---------- 1 | foo | ivm_user @@ -960,10 +1112,13 @@ u AS (UPDATE rls_tbl SET owner = 'postgres' WHERE id = 1), u2 AS (UPDATE rls_tbl SET owner = 'ivm_user' WHERE id = 2) SELECT; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree -- (1 row) SELECT id, data, owner FROM ivm_rls ORDER BY 1,2,3; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree id | data | owner ----+-------+---------- 2 | bar | ivm_user @@ -982,10 +1137,17 @@ x AS (UPDATE rls_tbl SET data = data || '_2' where id in (3,4)), y AS (UPDATE num_tbl SET num = num || '_2' where id in (3,4)) SELECT; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree -- (1 row) SELECT * FROM ivm_rls2 ORDER BY 1,2,3; +WARNING: outfuncs/readfuncs failed to produce an equal rewritten parse tree id | data | owner | num ----+-------+----------+--------- 2 | bar | ivm_user | two