This robot generates gigabytes of CI logs every week. Here is an attempt to
search for "highlights", so it's easier to find actionable information
quickly. New ideas for what patterns to search for are very welcome.
"Current" shows only the most recent results from each submission. The
wider time ranges also show information about historical versions, which
may be useful for flapping tests, and also for hunting for bugs in master.
| 51/5097 |
Make tuple deformation faster |
 |
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pageinspect/expected/gist.out /tmp/cirrus-ci-build/build/testrun/pageinspect/regre...
--- /tmp/cirrus-ci-build/contrib/pageinspect/expected/gist.out 2024-12-27 13:48:55.814876000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pageinspect/regress/results/gist.out 2024-12-27 13:52:12.717305000 +0000
@@ -2,124 +2,7 @@
-- Use an unlogged index, so that the LSN is predictable.
CREATE UNLOGGED TABLE test_gist AS SELECT point(i,i) p, i::text t FROM
generate_series(1,1000) i;
-CREATE INDEX test_gist_idx ON test_gist USING gist (p);
--- Page 0 is the root, the rest are leaf pages
-SELECT * FROM gist_page_opaque_info(get_raw_page('test_gist_idx', 0));
- lsn | nsn | rightlink | flags
------+-----+------------+-------
- 0/1 | 0/0 | 4294967295 | {}
-(1 row)
-
-SELECT * FROM gist_page_opaque_info(get_raw_page('test_gist_idx', 1));
- lsn | nsn | rightlink | flags
------+-----+------------+--------
- 0/1 | 0/0 | 4294967295 | {leaf}
-(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/build/testrun/recovery/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-12-27 13:48:57.367958000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/partition_join.out 2024-12-27 13:52:38.1...
@@ -20,5212 +20,7 @@
CREATE TABLE prt2_p1 PARTITION OF prt2 FOR VALUES FROM (0) TO (250);
CREATE TABLE prt2_p2 PARTITION OF prt2 FOR VALUES FROM (250) TO (500);
CREATE TABLE prt2_p3 PARTITION OF prt2 FOR VALUES FROM (500) TO (600);
-INSERT INTO prt2 SELECT i % 25, i, to_char(i, 'FM0000') FROM generate_series(0, 599) i WHERE i % 3 = 0;
-CREATE INDEX iprt2_p1_b on prt2_p1(b);
-CREATE INDEX iprt2_p2_b on prt2_p2(b);
-CREATE INDEX iprt2_p3_b on prt2_p3(b);
-ANALYZE prt2;
--- inner join
-EXPLAIN (COSTS OFF)
-SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.b AND t1.b = 0 ORDER BY t1.a, t2.b;
- QUERY PLAN
---------------------------------------------------
- Sort
- Sort Key: t1.a
- -> Append
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out 2024-12-27 13:48:57.336878000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/foreign_key.out 2024-12-27 13:51:24.500892000 +0000
@@ -1615,1433 +1615,7 @@
ERROR: insert or update on table "fk_partitioned_fk_2" violates foreign key constraint "fk_partitioned_fk_a_b_fkey"
DETAIL: Key (a, b)=(1500, 1501) is not present in table "fk_notpartitioned_pk".
INSERT INTO fk_partitioned_fk_2 (a,b) VALUES (1500, 1501);
-ERROR: insert or update on table "fk_partitioned_fk_2" violates foreign key constraint "fk_partitioned_fk_a_b_fkey"
-DETAIL: Key (a, b)=(1500, 1501) is not present in table "fk_notpartitioned_pk".
-INSERT INTO fk_partitioned_fk (a,b) VALUES (2500, 2502);
-ERROR: insert or update on table "fk_partitioned_fk_3_1" violates foreign key constraint "fk_partitioned_fk_a_b_fkey"
-DETAIL: Key (a, b)=(2500, 2502) is not present in table "fk_notpartitioned_pk".
-INSERT INTO fk_partitioned_fk_3 (a,b) VALUES (2500, 2502);
-ERROR: insert or update on table "fk_partitioned_fk_3_1" violates foreign key constraint "fk_partitioned_fk_a_b_fkey"
-DETAIL: Key (a, b)=(2500, 2502) is not present in table "fk_notpartitioned_pk".
-INSERT INTO fk_partitioned_fk (a,b) VALUES (2501, 2503);
-ERROR: insert or update on table "fk_partitioned_fk_3_0" violates foreign key constraint "fk_partitioned_fk_a_b_fkey"
-DETAIL: Key (a, b)=(2501, 2503) is not present in table "fk_notpartitioned_pk".
-INSERT INTO fk_partitioned_fk_3 (a,b) VALUES (2501, 2503);
-ERROR: insert or update on table "fk_partitioned_fk_3_0" violates foreign key constraint "fk_partitioned_fk_a_b_fkey"
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/seg/expected/partition.out /tmp/cirrus-ci-build/build/testrun/seg/regress/results/...
--- /tmp/cirrus-ci-build/contrib/seg/expected/partition.out 2024-12-27 13:48:55.863388000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/seg/regress/results/partition.out 2024-12-27 13:52:19.237163000 +0000
@@ -13,42 +13,7 @@
partition by list (category);
-- pre-existing partition
create table pt12 partition of pt for values in (1,2);
-insert into pt values(1, '0 .. 1'::seg, 'zed');
--- expression references object in public schema
-create index pti1 on pt ((mydouble(category) + 1));
--- opclass in public schema
-create index pti2 on pt (sdata seg_ops);
--- collation in public schema
-create index pti3 on pt (tdata collate mycollation);
--- new partition
-create table pt34 partition of pt for values in (3,4);
-insert into pt values(4, '-1 .. 1'::seg, 'foo');
-\d+ pt
- Partitioned table "public.pt"
- Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
... |
| 51/5284 |
database-specific role memberships |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/privs_in_db.out /tmp/cirrus-ci-build/build/testrun/regress-runni...
--- /tmp/cirrus-ci-build/src/test/regress/expected/privs_in_db.out 2024-12-27 13:28:19.169210000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress-running/regress/results/privs_in_db.out 2024-12-27 13:34:21.368392000 +00...
@@ -756,9 +756,10 @@
DROP DATABASE regression_db_0;
DROP ROLE regress_role_admin;
SELECT datname FROM pg_database WHERE datname LIKE 'regression_db_%';
- datname
----------
-(0 rows)
+ datname
+-------------------
+ regression_dblink
+(1 row)
SELECT rolname FROM pg_roles WHERE rolname LIKE 'regress_role_%';
rolname |
| 51/5404 |
Self contradictory examining on rel's baserestrictinfo |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/btree_gin/expected/bool.out /tmp/cirrus-ci-build/build/testrun/btree_gin/regress/r...
--- /tmp/cirrus-ci-build/contrib/btree_gin/expected/bool.out 2024-12-27 12:50:32.100928000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/btree_gin/regress/results/bool.out 2024-12-27 12:53:16.813620000 +0000
@@ -109,15 +109,13 @@
(6 rows)
EXPLAIN (COSTS OFF) SELECT * FROM test_bool WHERE i>true ORDER BY i;
- QUERY PLAN
--------------------------------------------
+ QUERY PLAN
+--------------------------------
Sort
Sort Key: i
- -> Bitmap Heap Scan on test_bool
- Recheck Cond: (i > true)
- -> Bitmap Index Scan on idx_bool
- Index Cond: (i > true)
-(6 rows)
+ -> Result
+ One-Time Filter: false
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/horology.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/horology.out 2024-12-27 12:50:33.675090000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/horology.out 2024-12-27 12:51:59.428226000...
@@ -2541,18 +2541,17 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+----------------------------
Aggregate
-> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
+(2 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
count
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/horology.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/horology.out 2024-12-27 12:50:33.675090000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/horology.out 2024-12-27 12:52:37.4366640...
@@ -2541,18 +2541,17 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+----------------------------
Aggregate
-> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
+(2 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
count
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/horology.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/horology.out 2024-12-27 12:50:33.675090000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/horology.out 2024-12-27 12:51:57.252715000 +0000
@@ -2541,18 +2541,17 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+----------------------------
Aggregate
-> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
+(2 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
count
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/btree_gin/expected/bool.out /tmp/cirrus-ci-build/contrib/btree_gin/results/bool.ou...
--- /tmp/cirrus-ci-build/contrib/btree_gin/expected/bool.out 2024-12-27 12:50:31.714543636 +0000
+++ /tmp/cirrus-ci-build/contrib/btree_gin/results/bool.out 2024-12-27 12:54:31.607771223 +0000
@@ -109,15 +109,13 @@
(6 rows)
EXPLAIN (COSTS OFF) SELECT * FROM test_bool WHERE i>true ORDER BY i;
- QUERY PLAN
--------------------------------------------
+ QUERY PLAN
+--------------------------------
Sort
Sort Key: i
- -> Bitmap Heap Scan on test_bool
- Recheck Cond: (i > true)
- -> Bitmap Index Scan on idx_bool
- Index Cond: (i > true)
-(6 rows)
+ -> Result
+ One-Time Filter: false
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/horology.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/horology.out 2024-12-27 12:50:33.606298038 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/horology.out 2024-12-27 12:55:41.595656225 +0000
@@ -2541,18 +2541,18 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+--------------------------------------------
Aggregate
-> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
+ Filter: (f1 <= '01-01-1998'::date)
(3 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
count
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/horology.out /tmp/cirrus-ci-build/src/test/regress/results/horol...
--- /tmp/cirrus-ci-build/src/test/regress/expected/horology.out 2024-12-27 12:50:33.606298038 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/horology.out 2024-12-27 12:53:36.503836931 +0000
@@ -2541,18 +2541,18 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+--------------------------------------------
Aggregate
-> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
+ Filter: (f1 <= '01-01-1998'::date)
(3 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
count
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/btree_gin/expected/bool.out /tmp/cirrus-ci-build/build/testrun/btree_gin/regress/r...
--- /tmp/cirrus-ci-build/contrib/btree_gin/expected/bool.out 2024-12-27 12:50:30.318827280 +0000
+++ /tmp/cirrus-ci-build/build/testrun/btree_gin/regress/results/bool.out 2024-12-27 12:54:51.462066204 +0000
@@ -109,15 +109,13 @@
(6 rows)
EXPLAIN (COSTS OFF) SELECT * FROM test_bool WHERE i>true ORDER BY i;
- QUERY PLAN
--------------------------------------------
+ QUERY PLAN
+--------------------------------
Sort
Sort Key: i
- -> Bitmap Heap Scan on test_bool
- Recheck Cond: (i > true)
- -> Bitmap Index Scan on idx_bool
- Index Cond: (i > true)
-(6 rows)
+ -> Result
+ One-Time Filter: false
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/horology.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/horology.out 2024-12-27 12:50:32.178827319 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/horology.out 2024-12-27 12:54:09.562115606...
@@ -2541,1334 +2541,7 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
- Aggregate
- -> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
-
-select count(*) from date_tbl
- where f1 between symmetric '1997-01-01' and '1998-01-01';
- count
--------
- 3
-(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/horology.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/horology.out 2024-12-27 12:50:32.178827319 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/horology.out 2024-12-27 12:54:35.2980826...
@@ -2541,1334 +2541,7 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
- Aggregate
- -> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
-
-select count(*) from date_tbl
- where f1 between symmetric '1997-01-01' and '1998-01-01';
- count
--------
- 3
-(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/horology.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/horology.out 2024-12-27 12:50:32.178827319 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/horology.out 2024-12-27 12:54:05.786121327 +0000
@@ -2541,1334 +2541,7 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
- Aggregate
- -> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
-
-select count(*) from date_tbl
- where f1 between symmetric '1997-01-01' and '1998-01-01';
- count
--------
- 3
-(1 row)
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/contrib/btree_gin/expected/bool.out /Users/admin/pgsql/build/testrun/btree_gin/regress/resul...
--- /Users/admin/pgsql/contrib/btree_gin/expected/bool.out 2024-12-27 12:50:10
+++ /Users/admin/pgsql/build/testrun/btree_gin/regress/results/bool.out 2024-12-27 12:53:17
@@ -109,15 +109,13 @@
(6 rows)
EXPLAIN (COSTS OFF) SELECT * FROM test_bool WHERE i>true ORDER BY i;
- QUERY PLAN
--------------------------------------------
+ QUERY PLAN
+--------------------------------
Sort
Sort Key: i
- -> Bitmap Heap Scan on test_bool
- Recheck Cond: (i > true)
- -> Bitmap Index Scan on idx_bool
- Index Cond: (i > true)
-(6 rows)
+ -> Result
+ One-Time Filter: false
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/horology.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/horology.out 2024-12-27 12:50:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/horology.out 2024-12-27 12:51:58
@@ -2541,18 +2541,17 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+----------------------------
Aggregate
-> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
+(2 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
count
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/horology.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/horology.out 2024-12-27 12:50:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/horology.out 2024-12-27 12:52:40
@@ -2541,18 +2541,17 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+----------------------------
Aggregate
-> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
+(2 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
count
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/horology.out /Users/admin/pgsql/build/testrun/regress/regress/resu...
--- /Users/admin/pgsql/src/test/regress/expected/horology.out 2024-12-27 12:50:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/horology.out 2024-12-27 12:51:55
@@ -2541,18 +2541,17 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+----------------------------
Aggregate
-> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
+(2 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
count
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/btree_gin/expected/bool.out C:/cirrus/build/testrun/btree_gin/regress/res...
--- C:/cirrus/contrib/btree_gin/expected/bool.out 2024-12-27 12:50:32.359269500 +0000
+++ C:/cirrus/build/testrun/btree_gin/regress/results/bool.out 2024-12-27 12:56:28.409723800 +0000
@@ -109,15 +109,13 @@
(6 rows)
EXPLAIN (COSTS OFF) SELECT * FROM test_bool WHERE i>true ORDER BY i;
- QUERY PLAN
--------------------------------------------
+ QUERY PLAN
+--------------------------------
Sort
Sort Key: i
- -> Bitmap Heap Scan on test_bool
- Recheck Cond: (i > true)
- -> Bitmap Index Scan on idx_bool
- Index Cond: (i > true)
-(6 rows)
+ -> Result
+ One-Time Filter: false
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/horology.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/horology.out 2024-12-27 12:50:36.897288100 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/horology.out 2024-12-27 12:52:44.999556200 +0000
@@ -2541,18 +2541,17 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+----------------------------
Aggregate
-> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
+(2 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
count
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/horology.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/horology.out 2024-12-27 12:50:36.897288100 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/horology.out 2024-12-27 12:55:03.695820800 +0000
@@ -2541,18 +2541,17 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+----------------------------
Aggregate
-> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
+(2 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
count
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/horology.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/horology.out 2024-12-27 12:50:36.897288100 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/horology.out 2024-12-27 12:52:38.885335800 +0000
@@ -2541,18 +2541,17 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+----------------------------
Aggregate
-> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
+(2 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
count
... |
| 51/5410 |
Disable installcheck for tap and regress tests for injection_points module |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/crash.out /tmp/cirrus-ci-build/build/testrun/in...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/crash.out 2024-12-27 11:57:10.975785000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/crash.out 2024-12-27 11:59:44.594764000 +0000
@@ -23,4 +23,16 @@
step c2: COMMIT;
ERROR: could not serialize access due to read/write dependencies among transactions
-step c3: COMMIT;
+s2: WARNING: AbortTransaction while in ABORT state
+ERROR: ResourceOwnerEnlarge called after release started
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+
+s3: WARNING: terminating connection because of crash of another server process
+DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because anothe...
+HINT: In a moment you should be able to reconnect to the database and repeat your command.
+PQconsumeInput failed: server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/crash.out /tmp/cirrus-ci-build/src/test/modules...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/crash.out 2024-12-27 11:57:08.158204771 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/injection_points/output_iso/results/crash.out 2024-12-27 12:02:20.305345142 +0...
@@ -23,4 +23,10 @@
step c2: COMMIT;
ERROR: could not serialize access due to read/write dependencies among transactions
+s2: WARNING: AbortTransaction while in ABORT state
+ERROR: ResourceOwnerEnlarge called after release started
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+
step c3: COMMIT;
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/inplace.out /tmp/cirrus-ci-build/src/test/modul...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/inplace.out 2024-12-27 11:57:08.158204771 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/injection_points/output_iso/results/inplace.out 2024-12-27 12:02:20.929344717 ...
@@ -14,327 +14,6 @@
step vac1: VACUUM vactest.orig50; -- wait during inplace update <waiting ...>
step grant2: GRANT SELECT ON TABLE vactest.orig50 TO PUBLIC;
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/crash.out /tmp/cirrus-ci-build/build/testrun/in...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/crash.out 2024-12-27 11:57:10.148305636 +0000
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/crash.out 2024-12-27 12:00:06.151888715 +0000
@@ -23,4 +23,10 @@
step c2: COMMIT;
ERROR: could not serialize access due to read/write dependencies among transactions
+s2: WARNING: AbortTransaction while in ABORT state
+ERROR: ResourceOwnerEnlarge called after release started
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+
step c3: COMMIT;
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/inplace.out /tmp/cirrus-ci-build/build/testrun/...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/inplace.out 2024-12-27 11:57:10.148305636 +0000
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/inplace.out 2024-12-27 12:00:06.727888710 +000...
@@ -47,294 +47,6 @@
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/modules/injection_points/expected/crash.out /Users/admin/pgsql/build/testrun/inject...
--- /Users/admin/pgsql/src/test/modules/injection_points/expected/crash.out 2024-12-27 11:56:12
+++ /Users/admin/pgsql/build/testrun/injection_points/isolation/results/crash.out 2024-12-27 11:59:25
@@ -23,4 +23,16 @@
step c2: COMMIT;
ERROR: could not serialize access due to read/write dependencies among transactions
-step c3: COMMIT;
+s2: WARNING: AbortTransaction while in ABORT state
+ERROR: ResourceOwnerEnlarge called after release started
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+
+s3: WARNING: terminating connection because of crash of another server process
+DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because anothe...
+HINT: In a moment you should be able to reconnect to the database and repeat your command.
+PQconsumeInput failed: server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/injection_points/expected/crash.out C:/cirrus/build/testrun/inje...
--- C:/cirrus/src/test/modules/injection_points/expected/crash.out 2024-12-27 11:57:15.399417700 +0000
+++ C:/cirrus/build/testrun/injection_points/isolation/results/crash.out 2024-12-27 12:03:57.088376600 +0000
@@ -23,4 +23,10 @@
step c2: COMMIT;
ERROR: could not serialize access due to read/write dependencies among transactions
+ERROR: ResourceOwnerEnlarge called after release started
+s2: WARNING: AbortTransaction while in ABORT state
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+
step c3: COMMIT; |
| 51/5117 |
VACUUM FULL / CLUSTER CONCURRENTLY |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/cluster.out /tmp/cirrus-ci-build/build/testrun/...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/cluster.out 2024-12-27 09:02:04.271054000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/injection_points-running/isolation/results/cluster.out 2024-12-27 09:08:06.111122...
@@ -8,7 +8,8 @@
step wait_before_lock:
CLUSTER (CONCURRENTLY) clstr_test USING clstr_test_pkey;
- <waiting ...>
+
+ERROR: logical decoding requires "wal_level" >= "logical"
step change_existing:
UPDATE clstr_test SET i=10 where i=1;
UPDATE clstr_test SET j=20 where i=2;
@@ -63,12 +64,7 @@
step wakeup_before_lock:
SELECT injection_points_wakeup('cluster-concurrently-before-lock');
-injection_points_wakeup
------------------------
-
... |
| 51/4980 |
Expand applicability of aggregate's sortop optimization |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2024-12-27 08:15:57.635447000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2024-12-27 08:18:10.39600400...
@@ -1029,7 +1029,7 @@
-> Seq Scan on tenk1 t
Filter: ((ANY (unique2 = (hashed SubPlan 2).col1)) OR (ten < 0))
SubPlan 2
- -> Index Only Scan using tenk1_unique1 on tenk1 k
+ -> Index Only Scan using idx_int4 on tenk1 k
(5 rows)
select count(*) from tenk1 t
@@ -1445,7 +1445,7 @@
-> Seq Scan on public.tenk1 b
Output: b.unique1, b.unique2, b.two, b.four, b.ten, b.twenty, b.hundred, b.thousand, b.twothousand, b.fivethou...
SubPlan 1
- -> Index Only Scan using tenk1_unique1 on public.tenk1 a
+ -> Index Only Scan using idx_int4 on public.tenk1 a
Output: a.unique1
(10 rows)
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2024-12-27 08:15:56.923629905 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2024-12-27 08:21:02.69115169...
@@ -1112,10 +1112,10 @@
and exists ( select 1 from tenk1 c where b.hundred = c.hundred
and not exists ( select 1 from tenk1 d
where a.thousand = d.thousand ) );
- thousand
-----------
-(0 rows)
-
+ERROR: deadlock detected
+DETAIL: Process 30239 waits for AccessShareLock on relation 25289 of database 16387; blocked by process 30249.
+Process 30249 waits for AccessExclusiveLock on relation 16421 of database 16387; blocked by process 30239.
+HINT: See server log for query details.
--
-- Check that nested sub-selects are not pulled up if they contain volatiles
-- |
| 51/5446 |
Improving default column names/aliases of subscript text expressions |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/hstore/expected/hstore.out /tmp/cirrus-ci-build/build/testrun/hstore/regress/resul...
--- /tmp/cirrus-ci-build/contrib/hstore/expected/hstore.out 2024-12-27 07:56:18.543589000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/hstore/regress/results/hstore.out 2024-12-27 07:58:29.694690000 +0000
@@ -1597,7 +1597,7 @@
-- Test subscripting
insert into test_json_agg default values;
select f2['d'], f2['x'] is null as x_isnull from test_json_agg;
- f2 | x_isnull
+ d | x_isnull
--------+----------
12345 | t
-12345 | t |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2024-12-27 07:56:20.089969000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonb.out 2024-12-27 07:57:52.193829000 +0...
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2024-12-27 07:56:20.089969000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/jsonb.out 2024-12-27 07:58:45.533427000 ...
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/build/testrun/regress/regress/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2024-12-27 07:56:20.089969000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/jsonb.out 2024-12-27 07:57:46.792368000 +0000
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/hstore/expected/hstore.out /tmp/cirrus-ci-build/contrib/hstore/results/hstore.out
--- /tmp/cirrus-ci-build/contrib/hstore/expected/hstore.out 2024-12-27 07:56:15.805608030 +0000
+++ /tmp/cirrus-ci-build/contrib/hstore/results/hstore.out 2024-12-27 07:58:38.856263354 +0000
@@ -1597,7 +1597,7 @@
-- Test subscripting
insert into test_json_agg default values;
select f2['d'], f2['x'] is null as x_isnull from test_json_agg;
- f2 | x_isnull
+ d | x_isnull
--------+----------
12345 | t
-12345 | t |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/resu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2024-12-27 07:56:17.667286208 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/jsonb.out 2024-12-27 08:01:28.431905658 +0000
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2024-12-27 07:56:17.667286208 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/jsonb.out 2024-12-27 08:03:18.911524672 +0000
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/src/test/regress/results/jsonb.ou...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2024-12-27 07:56:17.667286208 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/jsonb.out 2024-12-27 07:59:21.904068505 +0000
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/hstore/expected/hstore.out /tmp/cirrus-ci-build/build/testrun/hstore/regress/resul...
--- /tmp/cirrus-ci-build/contrib/hstore/expected/hstore.out 2024-12-27 07:56:18.055074500 +0000
+++ /tmp/cirrus-ci-build/build/testrun/hstore/regress/results/hstore.out 2024-12-27 07:59:14.789047364 +0000
@@ -1597,7 +1597,7 @@
-- Test subscripting
insert into test_json_agg default values;
select f2['d'], f2['x'] is null as x_isnull from test_json_agg;
- f2 | x_isnull
+ d | x_isnull
--------+----------
12345 | t
-12345 | t |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2024-12-27 07:56:19.897640669 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonb.out 2024-12-27 07:58:50.437182133 +0...
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2024-12-27 07:56:19.897640669 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/jsonb.out 2024-12-27 07:59:26.477057244 ...
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/build/testrun/regress/regress/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2024-12-27 07:56:19.897640669 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/jsonb.out 2024-12-27 07:58:44.013221578 +0000
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/contrib/hstore/expected/hstore.out /Users/admin/pgsql/build/testrun/hstore/regress/results/h...
--- /Users/admin/pgsql/contrib/hstore/expected/hstore.out 2024-12-27 07:56:07
+++ /Users/admin/pgsql/build/testrun/hstore/regress/results/hstore.out 2024-12-27 07:58:59
@@ -1597,7 +1597,7 @@
-- Test subscripting
insert into test_json_agg default values;
select f2['d'], f2['x'] is null as x_isnull from test_json_agg;
- f2 | x_isnull
+ d | x_isnull
--------+----------
12345 | t
-12345 | t |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/jsonb.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgra...
--- /Users/admin/pgsql/src/test/regress/expected/jsonb.out 2024-12-27 07:56:09
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonb.out 2024-12-27 07:57:55
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/jsonb.out /Users/admin/pgsql/build/testrun/recovery/027_stream_reg...
--- /Users/admin/pgsql/src/test/regress/expected/jsonb.out 2024-12-27 07:56:09
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/jsonb.out 2024-12-27 07:59:05
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/jsonb.out /Users/admin/pgsql/build/testrun/regress/regress/results...
--- /Users/admin/pgsql/src/test/regress/expected/jsonb.out 2024-12-27 07:56:09
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/jsonb.out 2024-12-27 07:57:56
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/hstore/expected/hstore.out C:/cirrus/build/testrun/hstore/regress/results...
--- C:/cirrus/contrib/hstore/expected/hstore.out 2024-12-27 07:56:18.562178600 +0000
+++ C:/cirrus/build/testrun/hstore/regress/results/hstore.out 2024-12-27 08:02:17.323557900 +0000
@@ -1597,7 +1597,7 @@
-- Test subscripting
insert into test_json_agg default values;
select f2['d'], f2['x'] is null as x_isnull from test_json_agg;
- f2 | x_isnull
+ d | x_isnull
--------+----------
12345 | t
-12345 | t |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/jsonb.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upg...
--- C:/cirrus/src/test/regress/expected/jsonb.out 2024-12-27 07:56:23.183585300 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonb.out 2024-12-27 07:59:53.891436100 +0000
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/jsonb.out C:/cirrus/build/testrun/recovery/027_stream_r...
--- C:/cirrus/src/test/regress/expected/jsonb.out 2024-12-27 07:56:23.183585300 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/jsonb.out 2024-12-27 08:02:05.885571800 +0000
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/jsonb.out C:/cirrus/build/testrun/regress/regress/resul...
--- C:/cirrus/src/test/regress/expected/jsonb.out 2024-12-27 07:56:23.183585300 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/jsonb.out 2024-12-27 07:59:44.218587100 +0000
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| 51/4620 |
CRC32C Parallel Computation Optimization on ARM |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/test_crc32c/expected/test_crc32c.out /tmp/cirrus-ci-build/build-32/testrun/test_cr...
--- /tmp/cirrus-ci-build/contrib/test_crc32c/expected/test_crc32c.out 2024-12-27 06:49:49.246104615 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/test_crc32c/regress/results/test_crc32c.out 2024-12-27 06:59:02.929269622 +000...
@@ -1,57 +1,6 @@
CREATE EXTENSION test_crc32c;
select drive_crc32c(1, i) from generate_series(100, 300, 4) i;
- drive_crc32c
---------------
- 532139994
- 2103623867
- 785984197
- 2686825890
- 3213049059
- 3819630168
- 1389234603
- 534072900
- 2930108140
- 2496889855
- 1475239611
- 136366931
... |
| 51/5371 |
TimestampTz->Text->TimestampTz casting fails with DateStyle 'Postgres' |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out 2024-12-27 04:51:13.660030000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/timestamptz.out 2024-12-27 04:52:03.177398...
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out 2024-12-27 04:51:13.660030000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/timestamptz.out 2024-12-27 04:52:39.1983...
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out 2024-12-27 04:51:13.660030000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/timestamptz.out 2024-12-27 04:52:02.454542000 +0000
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_chec...
--- /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out 2024-12-27 04:51:12.318794383 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/timestamptz.out 2024-12-27 04:54:04.639890431 +0000
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out /tmp/cirrus-ci-build/src/test/regress/results/ti...
--- /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out 2024-12-27 04:51:12.318794383 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/timestamptz.out 2024-12-27 04:52:39.539869836 +0000
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out 2024-12-27 04:51:12.072416557 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/timestamptz.out 2024-12-27 04:52:36.700234...
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out 2024-12-27 04:51:12.072416557 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/timestamptz.out 2024-12-27 04:53:11.5881...
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out 2024-12-27 04:51:12.072416557 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/timestamptz.out 2024-12-27 04:52:32.656242370 +0000
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/timestamptz.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg...
--- /Users/admin/pgsql/src/test/regress/expected/timestamptz.out 2024-12-27 04:51:10
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/timestamptz.out 2024-12-27 04:52:25
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/timestamptz.out /Users/admin/pgsql/build/testrun/recovery/027_stre...
--- /Users/admin/pgsql/src/test/regress/expected/timestamptz.out 2024-12-27 04:51:10
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/timestamptz.out 2024-12-27 04:53:09
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/timestamptz.out /Users/admin/pgsql/build/testrun/regress/regress/r...
--- /Users/admin/pgsql/src/test/regress/expected/timestamptz.out 2024-12-27 04:51:10
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/timestamptz.out 2024-12-27 04:52:22
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/timestamptz.out C:/cirrus/build/testrun/pg_upgrade/002_...
--- C:/cirrus/src/test/regress/expected/timestamptz.out 2024-12-27 04:51:17.249584900 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/timestamptz.out 2024-12-27 04:53:19.411770400 +0000
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/timestamptz.out C:/cirrus/build/testrun/recovery/027_st...
--- C:/cirrus/src/test/regress/expected/timestamptz.out 2024-12-27 04:51:17.249584900 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/timestamptz.out 2024-12-27 04:55:27.456186100 +0000
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/timestamptz.out C:/cirrus/build/testrun/regress/regress...
--- C:/cirrus/src/test/regress/expected/timestamptz.out 2024-12-27 04:51:17.249584900 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/timestamptz.out 2024-12-27 04:53:13.390785800 +0000
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
| 51/5417 |
pure parsers and reentrant scanners |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_record.out /tmp/cirrus-ci-build/build/testrun/plpgsql/...
--- /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_record.out 2024-12-26 18:43:15.632219000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plpgsql/regress/results/plpgsql_record.out 2024-12-26 18:45:16.257550000 +0000
@@ -620,255 +620,7 @@
$$ declare r mutable2; begin r.f1 := $1; return r.f1 + 2; end $$;
reset check_function_bodies;
select sillyaddtwo(42); -- fail
-ERROR: type "mutable2" does not exist
-LINE 1: declare r mutable2; begin r.f1 := $1; return r.f1 + 2; end
- ^
-QUERY: declare r mutable2; begin r.f1 := $1; return r.f1 + 2; end
-CONTEXT: compilation of PL/pgSQL function "sillyaddtwo" near line 1
-create table mutable2(f1 int, f2 text);
-select sillyaddtwo(42);
- sillyaddtwo
--------------
- 44
-(1 row)
-
-drop table mutable2;
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_record.out /tmp/cirrus-ci-build/src/pl/plpgsql/src/res...
--- /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_record.out 2024-12-26 18:43:10.440800468 +0000
+++ /tmp/cirrus-ci-build/src/pl/plpgsql/src/results/plpgsql_record.out 2024-12-26 18:44:35.728059028 +0000
@@ -620,255 +620,7 @@
$$ declare r mutable2; begin r.f1 := $1; return r.f1 + 2; end $$;
reset check_function_bodies;
select sillyaddtwo(42); -- fail
-ERROR: type "mutable2" does not exist
-LINE 1: declare r mutable2; begin r.f1 := $1; return r.f1 + 2; end
- ^
-QUERY: declare r mutable2; begin r.f1 := $1; return r.f1 + 2; end
-CONTEXT: compilation of PL/pgSQL function "sillyaddtwo" near line 1
-create table mutable2(f1 int, f2 text);
-select sillyaddtwo(42);
- sillyaddtwo
--------------
- 44
-(1 row)
-
-drop table mutable2;
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_record.out /tmp/cirrus-ci-build/build/testrun/plpgsql/...
--- /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_record.out 2024-12-26 18:43:09.721107522 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plpgsql/regress/results/plpgsql_record.out 2024-12-26 18:45:48.999413916 +0000
@@ -620,255 +620,7 @@
$$ declare r mutable2; begin r.f1 := $1; return r.f1 + 2; end $$;
reset check_function_bodies;
select sillyaddtwo(42); -- fail
-ERROR: type "mutable2" does not exist
-LINE 1: declare r mutable2; begin r.f1 := $1; return r.f1 + 2; end
- ^
-QUERY: declare r mutable2; begin r.f1 := $1; return r.f1 + 2; end
-CONTEXT: compilation of PL/pgSQL function "sillyaddtwo" near line 1
-create table mutable2(f1 int, f2 text);
-select sillyaddtwo(42);
- sillyaddtwo
--------------
- 44
-(1 row)
-
-drop table mutable2;
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/pl/plpgsql/src/expected/plpgsql_record.out /Users/admin/pgsql/build/testrun/plpgsql/regr...
--- /Users/admin/pgsql/src/pl/plpgsql/src/expected/plpgsql_record.out 2024-12-26 18:43:08
+++ /Users/admin/pgsql/build/testrun/plpgsql/regress/results/plpgsql_record.out 2024-12-26 18:46:03
@@ -619,256 +619,8 @@
create function sillyaddtwo(int) returns int language plpgsql as
$$ declare r mutable2; begin r.f1 := $1; return r.f1 + 2; end $$;
reset check_function_bodies;
-select sillyaddtwo(42); -- fail
-ERROR: type "mutable2" does not exist
-LINE 1: declare r mutable2; begin r.f1 := $1; return r.f1 + 2; end
- ^
-QUERY: declare r mutable2; begin r.f1 := $1; return r.f1 + 2; end
-CONTEXT: compilation of PL/pgSQL function "sillyaddtwo" near line 1
-create table mutable2(f1 int, f2 text);
-select sillyaddtwo(42);
- sillyaddtwo
--------------
- 44
-(1 row)
-
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/pl/plpgsql/src/expected/plpgsql_record.out C:/cirrus/build/testrun/plpgsql/re...
--- C:/cirrus/src/pl/plpgsql/src/expected/plpgsql_record.out 2024-12-26 18:43:15.766382500 +0000
+++ C:/cirrus/build/testrun/plpgsql/regress/results/plpgsql_record.out 2024-12-26 18:48:37.683737200 +0000
@@ -620,255 +620,7 @@
$$ declare r mutable2; begin r.f1 := $1; return r.f1 + 2; end $$;
reset check_function_bodies;
select sillyaddtwo(42); -- fail
-ERROR: type "mutable2" does not exist
-LINE 1: declare r mutable2; begin r.f1 := $1; return r.f1 + 2; end
- ^
-QUERY: declare r mutable2; begin r.f1 := $1; return r.f1 + 2; end
-CONTEXT: compilation of PL/pgSQL function "sillyaddtwo" near line 1
-create table mutable2(f1 int, f2 text);
-select sillyaddtwo(42);
- sillyaddtwo
--------------
- 44
-(1 row)
-
-drop table mutable2;
... |
| 51/5153 |
Prohibit to use EphemeralNamedRelation in materialized views |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-12-26 15:30:25.278217000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2024-12-26 15:31:28.347680000...
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-12-26 15:30:25.278217000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2024-12-26 15:32:10.5716090...
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-12-26 15:30:25.278217000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/triggers.out 2024-12-26 15:31:28.200559000 +0000
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-12-26 15:30:25.933152676 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/triggers.out 2024-12-26 15:34:20.208565009 +0000
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-12-26 15:30:25.933152676 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/triggers.out 2024-12-26 15:36:57.708380318 +0000
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/test/regress/results/trigg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-12-26 15:30:25.933152676 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/triggers.out 2024-12-26 15:32:09.488706367 +0000
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-12-26 15:30:25.529903301 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2024-12-26 15:32:03.540013429...
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-12-26 15:30:25.529903301 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2024-12-26 15:32:41.9440730...
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-12-26 15:30:25.529903301 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/triggers.out 2024-12-26 15:32:00.720097483 +0000
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/triggers.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/triggers.out 2024-12-26 15:30:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2024-12-26 15:31:38
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/triggers.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/triggers.out 2024-12-26 15:30:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2024-12-26 15:32:24
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/triggers.out /Users/admin/pgsql/build/testrun/regress/regress/resu...
--- /Users/admin/pgsql/src/test/regress/expected/triggers.out 2024-12-26 15:30:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/triggers.out 2024-12-26 15:31:37
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/triggers.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/triggers.out 2024-12-26 15:30:30.911958200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2024-12-26 15:32:55.004165600 +0000
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/triggers.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/triggers.out 2024-12-26 15:30:30.911958200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2024-12-26 15:35:08.404084100 +0000
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/triggers.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/triggers.out 2024-12-26 15:30:30.911958200 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/triggers.out 2024-12-26 15:32:44.056895900 +0000
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
| 51/4929 |
apply_scanjoin_target_to_paths and partitionwise join |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-12-26 01:41:19.338947000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_join.out 2024-12-26 01:43:10.376...
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/build/testrun/recovery/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-12-26 01:41:19.338947000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/partition_join.out 2024-12-26 01:44:05.5...
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/build/testrun/regress/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-12-26 01:41:19.338947000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/partition_join.out 2024-12-26 01:43:06.969772000 +0000
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_c...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-12-26 01:41:18.101028754 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/partition_join.out 2024-12-26 01:47:01.964386223 +0000
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/src/test/recovery/tmp_ch...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-12-26 01:41:18.101028754 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/partition_join.out 2024-12-26 01:48:31.355719094 +0000
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/src/test/regress/results...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-12-26 01:41:18.101028754 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/partition_join.out 2024-12-26 01:44:38.960777492 +0000
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-12-26 01:41:15.203566128 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_join.out 2024-12-26 01:44:06.247...
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/build/testrun/recovery/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-12-26 01:41:15.203566128 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/partition_join.out 2024-12-26 01:44:41.1...
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/build/testrun/regress/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-12-26 01:41:15.203566128 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/partition_join.out 2024-12-26 01:44:03.683899082 +0000
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/partition_join.out /Users/admin/pgsql/build/testrun/pg_upgrade/002...
--- /Users/admin/pgsql/src/test/regress/expected/partition_join.out 2024-12-26 01:40:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_join.out 2024-12-26 01:42:11
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/partition_join.out /Users/admin/pgsql/build/testrun/recovery/027_s...
--- /Users/admin/pgsql/src/test/regress/expected/partition_join.out 2024-12-26 01:40:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/partition_join.out 2024-12-26 01:43:10
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/partition_join.out /Users/admin/pgsql/build/testrun/regress/regres...
--- /Users/admin/pgsql/src/test/regress/expected/partition_join.out 2024-12-26 01:40:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/partition_join.out 2024-12-26 01:42:11
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/partition_join.out C:/cirrus/build/testrun/pg_upgrade/0...
--- C:/cirrus/src/test/regress/expected/partition_join.out 2024-12-26 01:41:21.070874400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_join.out 2024-12-26 01:45:05.790164500 +000...
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/partition_join.out C:/cirrus/build/testrun/recovery/027...
--- C:/cirrus/src/test/regress/expected/partition_join.out 2024-12-26 01:41:21.070874400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/partition_join.out 2024-12-26 01:47:29.615757300 +0...
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/partition_join.out C:/cirrus/build/testrun/regress/regr...
--- C:/cirrus/src/test/regress/expected/partition_join.out 2024-12-26 01:41:21.070874400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/partition_join.out 2024-12-26 01:44:59.917093900 +0000
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
| 51/4720 |
"unexpected duplicate for tablespace" problem in logical replication |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-12-25 20:29:08.233571000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/alter_table.out 2024-12-25 20:30:51.176942...
@@ -3488,9 +3488,20 @@
WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid;
SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid
WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL;
- oid | mapped_oid | reltablespace | relfilenode | relname
------+------------+---------------+-------------+---------
-(0 rows)
+ oid | mapped_oid | reltablespace | relfilenode | relname
+-------+------------+---------------+-------------+----------------------
+ 39428 | | 0 | 39428 | pktable
+ 39435 | | 0 | 39435 | fktable
+ 39432 | | 0 | 39432 | pktable_pkey
+ 40235 | | 0 | 40240 | foo
+ 40244 | | 0 | 40244 | pg_toast_40235_index
+ 40243 | | 0 | 40243 | pg_toast_40235
+ 40473 | | 0 | 40473 | old_oids
+ 40490 | | 0 | 40490 | pg_toast_40487
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-12-25 20:29:08.233571000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/alter_table.out 2024-12-25 20:31:34.2980...
@@ -3488,9 +3488,20 @@
WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid;
SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid
WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL;
- oid | mapped_oid | reltablespace | relfilenode | relname
------+------------+---------------+-------------+---------
-(0 rows)
+ oid | mapped_oid | reltablespace | relfilenode | relname
+-------+------------+---------------+-------------+----------------------
+ 39598 | | 0 | 39598 | pktable_pkey
+ 39594 | | 0 | 39594 | pktable
+ 39600 | | 0 | 39600 | fktable
+ 40105 | | 0 | 40113 | foo
+ 40117 | | 0 | 40117 | pg_toast_40105_index
+ 40116 | | 0 | 40116 | pg_toast_40105
+ 40407 | | 0 | 40407 | recur1
+ 40398 | | 0 | 40398 | old_oids
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-12-25 20:29:08.233571000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/alter_table.out 2024-12-25 20:30:47.490434000 +0000
@@ -3488,9 +3488,20 @@
WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid;
SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid
WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL;
- oid | mapped_oid | reltablespace | relfilenode | relname
------+------------+---------------+-------------+---------
-(0 rows)
+ oid | mapped_oid | reltablespace | relfilenode | relname
+-------+------------+---------------+-------------+----------------------
+ 39605 | | 0 | 39605 | pktable_pkey
+ 39599 | | 0 | 39599 | pktable
+ 39608 | | 0 | 39608 | fktable
+ 40233 | | 0 | 40238 | foo
+ 40242 | | 0 | 40242 | pg_toast_40233_index
+ 40241 | | 0 | 40241 | pg_toast_40233
+ 40471 | | 0 | 40471 | old_oids
+ 40488 | | 0 | 40488 | pg_toast_40485
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_chec...
--- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-12-25 20:29:06.898824595 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/alter_table.out 2024-12-25 20:34:49.954189907 +0000
@@ -3488,9 +3488,20 @@
WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid;
SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid
WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL;
- oid | mapped_oid | reltablespace | relfilenode | relname
------+------------+---------------+-------------+---------
-(0 rows)
+ oid | mapped_oid | reltablespace | relfilenode | relname
+-------+------------+---------------+-------------+----------------------
+ 39829 | | 0 | 39829 | pktable_pkey
+ 39825 | | 0 | 39825 | pktable
+ 39831 | | 0 | 39831 | fktable
+ 40322 | | 0 | 40336 | foo
+ 40340 | | 0 | 40340 | pg_toast_40322_index
+ 40339 | | 0 | 40339 | pg_toast_40322
+ 40558 | | 0 | 40558 | old_oids
+ 40579 | | 0 | 40579 | pg_toast_40576
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check...
--- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-12-25 20:29:06.898824595 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/alter_table.out 2024-12-25 20:36:00.062181455 +0000
@@ -3488,9 +3488,20 @@
WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid;
SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid
WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL;
- oid | mapped_oid | reltablespace | relfilenode | relname
------+------------+---------------+-------------+---------
-(0 rows)
+ oid | mapped_oid | reltablespace | relfilenode | relname
+-------+------------+---------------+-------------+----------------------
+ 39730 | | 0 | 39730 | pktable_pkey
+ 39726 | | 0 | 39726 | pktable
+ 39735 | | 0 | 39735 | fktable
+ 40216 | | 0 | 40224 | foo
+ 40228 | | 0 | 40228 | pg_toast_40216_index
+ 40227 | | 0 | 40227 | pg_toast_40216
+ 40475 | | 0 | 40475 | old_oids
+ 40492 | | 0 | 40492 | pg_toast_40489
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/src/test/regress/results/al...
--- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-12-25 20:29:06.898824595 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/alter_table.out 2024-12-25 20:32:12.362230958 +0000
@@ -3488,9 +3488,20 @@
WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid;
SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid
WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL;
- oid | mapped_oid | reltablespace | relfilenode | relname
------+------------+---------------+-------------+---------
-(0 rows)
+ oid | mapped_oid | reltablespace | relfilenode | relname
+-------+------------+---------------+-------------+----------------------
+ 39807 | | 0 | 39807 | pktable_pkey
+ 39803 | | 0 | 39803 | pktable
+ 39809 | | 0 | 39809 | fktable
+ 40287 | | 0 | 40292 | foo
+ 40296 | | 0 | 40296 | pg_toast_40287_index
+ 40295 | | 0 | 40295 | pg_toast_40287
+ 40546 | | 0 | 40546 | old_oids
+ 40565 | | 0 | 40565 | pg_toast_40562
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-12-25 20:29:06.295837565 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/alter_table.out 2024-12-25 20:31:38.494453...
@@ -3488,9 +3488,29 @@
WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid;
SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid
WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL;
- oid | mapped_oid | reltablespace | relfilenode | relname
------+------------+---------------+-------------+---------
-(0 rows)
+ oid | mapped_oid | reltablespace | relfilenode | relname
+-------+------------+---------------+-------------+----------------------
+ 39845 | | 0 | 39845 | pg_toast_39839_index
+ 39839 | | 0 | 39839 | users
+ 39838 | | 0 | 39838 | users_id_seq
+ 39844 | | 0 | 39844 | pg_toast_39839
+ 40051 | | 0 | 40051 | foo
+ 40216 | | 0 | 40216 | forc_test
+ 40682 | | 0 | 40682 | pg_toast_40679
+ 40683 | | 0 | 40683 | pg_toast_40679_index
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-12-25 20:29:06.295837565 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/alter_table.out 2024-12-25 20:32:13.6553...
@@ -3488,9 +3488,20 @@
WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid;
SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid
WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL;
- oid | mapped_oid | reltablespace | relfilenode | relname
------+------------+---------------+-------------+---------
-(0 rows)
+ oid | mapped_oid | reltablespace | relfilenode | relname
+-------+------------+---------------+-------------+----------------------
+ 39562 | | 0 | 39562 | pktable_pkey
+ 39558 | | 0 | 39558 | pktable
+ 39564 | | 0 | 39564 | fktable
+ 40035 | | 0 | 40040 | foo
+ 40044 | | 0 | 40044 | pg_toast_40035_index
+ 40043 | | 0 | 40043 | pg_toast_40035
+ 40275 | | 0 | 40275 | old_oids
+ 40294 | | 0 | 40294 | pg_toast_40291
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-12-25 20:29:06.295837565 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/alter_table.out 2024-12-25 20:31:31.718308815 +0000
@@ -3488,9 +3488,20 @@
WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid;
SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid
WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL;
- oid | mapped_oid | reltablespace | relfilenode | relname
------+------------+---------------+-------------+---------
-(0 rows)
+ oid | mapped_oid | reltablespace | relfilenode | relname
+-------+------------+---------------+-------------+----------------------
+ 39622 | | 0 | 39622 | pktable_pkey
+ 39618 | | 0 | 39618 | pktable
+ 39624 | | 0 | 39624 | fktable
+ 40119 | | 0 | 40126 | foo
+ 40130 | | 0 | 40130 | pg_toast_40119_index
+ 40129 | | 0 | 40129 | pg_toast_40119
+ 40367 | | 0 | 40367 | old_oids
+ 40385 | | 0 | 40385 | pg_toast_40382
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/alter_table.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg...
--- /Users/admin/pgsql/src/test/regress/expected/alter_table.out 2024-12-25 20:28:11
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/alter_table.out 2024-12-25 20:30:21
@@ -3488,9 +3488,20 @@
WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid;
SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid
WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL;
- oid | mapped_oid | reltablespace | relfilenode | relname
------+------------+---------------+-------------+---------
-(0 rows)
+ oid | mapped_oid | reltablespace | relfilenode | relname
+-------+------------+---------------+-------------+----------------------
+ 38532 | | 0 | 38532 | pktable_pkey
+ 38528 | | 0 | 38528 | pktable
+ 38553 | | 0 | 38553 | fktable
+ 40132 | | 0 | 40137 | foo
+ 40141 | | 0 | 40141 | pg_toast_40132_index
+ 40140 | | 0 | 40140 | pg_toast_40132
+ 40433 | | 0 | 40433 | old_oids
+ 40450 | | 0 | 40450 | pg_toast_40447
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/alter_table.out /Users/admin/pgsql/build/testrun/recovery/027_stre...
--- /Users/admin/pgsql/src/test/regress/expected/alter_table.out 2024-12-25 20:28:11
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/alter_table.out 2024-12-25 20:31:15
@@ -3488,9 +3488,20 @@
WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid;
SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid
WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL;
- oid | mapped_oid | reltablespace | relfilenode | relname
------+------------+---------------+-------------+---------
-(0 rows)
+ oid | mapped_oid | reltablespace | relfilenode | relname
+-------+------------+---------------+-------------+----------------------
+ 39344 | | 0 | 39344 | pktable_pkey
+ 39338 | | 0 | 39338 | pktable
+ 39350 | | 0 | 39350 | fktable
+ 40052 | | 0 | 40057 | foo
+ 40061 | | 0 | 40061 | pg_toast_40052_index
+ 40060 | | 0 | 40060 | pg_toast_40052
+ 40262 | | 0 | 40262 | old_oids
+ 40288 | | 0 | 40288 | pg_toast_40283
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/alter_table.out /Users/admin/pgsql/build/testrun/regress/regress/r...
--- /Users/admin/pgsql/src/test/regress/expected/alter_table.out 2024-12-25 20:28:11
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/alter_table.out 2024-12-25 20:30:25
@@ -3488,9 +3488,20 @@
WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid;
SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid
WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL;
- oid | mapped_oid | reltablespace | relfilenode | relname
------+------------+---------------+-------------+---------
-(0 rows)
+ oid | mapped_oid | reltablespace | relfilenode | relname
+-------+------------+---------------+-------------+----------------------
+ 39531 | | 0 | 39531 | pktable_pkey
+ 39527 | | 0 | 39527 | pktable
+ 39533 | | 0 | 39533 | fktable
+ 40141 | | 0 | 40146 | foo
+ 40150 | | 0 | 40150 | pg_toast_40141_index
+ 40149 | | 0 | 40149 | pg_toast_40141
+ 40357 | | 0 | 40357 | old_oids
+ 40377 | | 0 | 40377 | pg_toast_40374
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/alter_table.out C:/cirrus/build/testrun/pg_upgrade/002_...
--- C:/cirrus/src/test/regress/expected/alter_table.out 2024-12-25 20:29:13.346342700 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/alter_table.out 2024-12-25 20:32:52.682167300 +0000
@@ -3488,9 +3488,20 @@
WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid;
SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid
WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL;
- oid | mapped_oid | reltablespace | relfilenode | relname
------+------------+---------------+-------------+---------
-(0 rows)
+ oid | mapped_oid | reltablespace | relfilenode | relname
+-------+------------+---------------+-------------+----------------------
+ 39032 | | 0 | 39032 | pktable_pkey
+ 39028 | | 0 | 39028 | pktable
+ 39035 | | 0 | 39035 | fktable
+ 39763 | | 0 | 39763 | pg_toast_39745_index
+ 39745 | | 0 | 39758 | foo
+ 39761 | | 0 | 39761 | pg_toast_39745
+ 39998 | | 0 | 39998 | old_oids
+ 40016 | | 0 | 40016 | pg_toast_40013
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/alter_table.out C:/cirrus/build/testrun/recovery/027_st...
--- C:/cirrus/src/test/regress/expected/alter_table.out 2024-12-25 20:29:13.346342700 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/alter_table.out 2024-12-25 20:35:05.324360200 +0000
@@ -3488,9 +3488,20 @@
WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid;
SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid
WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL;
- oid | mapped_oid | reltablespace | relfilenode | relname
------+------------+---------------+-------------+---------
-(0 rows)
+ oid | mapped_oid | reltablespace | relfilenode | relname
+-------+------------+---------------+-------------+----------------------
+ 38818 | | 0 | 38818 | pktable_pkey
+ 38813 | | 0 | 38813 | pktable
+ 38821 | | 0 | 38821 | fktable
+ 39712 | | 0 | 39717 | foo
+ 39721 | | 0 | 39721 | pg_toast_39712_index
+ 39720 | | 0 | 39720 | pg_toast_39712
+ 39991 | | 0 | 39991 | old_oids
+ 40008 | | 0 | 40008 | pg_toast_40005
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/alter_table.out C:/cirrus/build/testrun/regress/regress...
--- C:/cirrus/src/test/regress/expected/alter_table.out 2024-12-25 20:29:13.346342700 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/alter_table.out 2024-12-25 20:32:47.986854200 +0000
@@ -3488,9 +3488,20 @@
WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid;
SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid
WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL;
- oid | mapped_oid | reltablespace | relfilenode | relname
------+------------+---------------+-------------+---------
-(0 rows)
+ oid | mapped_oid | reltablespace | relfilenode | relname
+-------+------------+---------------+-------------+----------------------
+ 39387 | | 0 | 39387 | pktable_pkey
+ 39383 | | 0 | 39383 | pktable
+ 39391 | | 0 | 39391 | fktable
+ 39900 | | 0 | 39905 | foo
+ 39909 | | 0 | 39909 | pg_toast_39900_index
+ 39908 | | 0 | 39908 | pg_toast_39900
+ 40101 | | 0 | 40101 | old_oids
+ 40118 | | 0 | 40118 | pg_toast_40115
... |
| 51/5357 |
New predefined role pg_manage_extensions |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/pl/plperl/expected/plperl_setup.out /tmp/cirrus-ci-build/build/testrun/plperl/regress/...
--- /tmp/cirrus-ci-build/src/pl/plperl/expected/plperl_setup.out 2024-12-25 12:27:26.343310000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plperl/regress/results/plperl_setup.out 2024-12-25 12:29:22.799470000 +0000
@@ -12,7 +12,7 @@
HINT: Must have CREATE privilege on current database to create this extension.
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Only roles with privileges of the "pg_manage_extensions" role are allowed to create this extension.
RESET ROLE;
DO $$
begin
@@ -24,7 +24,7 @@
CREATE EXTENSION plperl;
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Only roles with privileges of the "pg_manage_extensions" role are allowed to create this extension.
CREATE SCHEMA plperl_setup_scratch;
SET search_path = plperl_setup_scratch;
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/pl/plperl/expected/plperl_setup.out /tmp/cirrus-ci-build/src/pl/plperl/results/plperl_...
--- /tmp/cirrus-ci-build/src/pl/plperl/expected/plperl_setup.out 2024-12-25 12:27:23.543282500 +0000
+++ /tmp/cirrus-ci-build/src/pl/plperl/results/plperl_setup.out 2024-12-25 12:28:44.822942247 +0000
@@ -12,7 +12,7 @@
HINT: Must have CREATE privilege on current database to create this extension.
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Only roles with privileges of the "pg_manage_extensions" role are allowed to create this extension.
RESET ROLE;
DO $$
begin
@@ -24,7 +24,7 @@
CREATE EXTENSION plperl;
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Only roles with privileges of the "pg_manage_extensions" role are allowed to create this extension.
CREATE SCHEMA plperl_setup_scratch;
SET search_path = plperl_setup_scratch;
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/pl/plperl/expected/plperl_setup.out /tmp/cirrus-ci-build/build/testrun/plperl/regress/...
--- /tmp/cirrus-ci-build/src/pl/plperl/expected/plperl_setup.out 2024-12-25 12:27:25.598226619 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plperl/regress/results/plperl_setup.out 2024-12-25 12:30:04.168385696 +0000
@@ -12,7 +12,7 @@
HINT: Must have CREATE privilege on current database to create this extension.
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Only roles with privileges of the "pg_manage_extensions" role are allowed to create this extension.
RESET ROLE;
DO $$
begin
@@ -24,7 +24,7 @@
CREATE EXTENSION plperl;
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Only roles with privileges of the "pg_manage_extensions" role are allowed to create this extension.
CREATE SCHEMA plperl_setup_scratch;
SET search_path = plperl_setup_scratch;
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/pl/plperl/expected/plperl_setup.out /Users/admin/pgsql/build/testrun/plperl/regress/resu...
--- /Users/admin/pgsql/src/pl/plperl/expected/plperl_setup.out 2024-12-25 12:27:11
+++ /Users/admin/pgsql/build/testrun/plperl/regress/results/plperl_setup.out 2024-12-25 12:29:49
@@ -12,7 +12,7 @@
HINT: Must have CREATE privilege on current database to create this extension.
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Only roles with privileges of the "pg_manage_extensions" role are allowed to create this extension.
RESET ROLE;
DO $$
begin
@@ -24,7 +24,7 @@
CREATE EXTENSION plperl;
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Only roles with privileges of the "pg_manage_extensions" role are allowed to create this extension.
CREATE SCHEMA plperl_setup_scratch;
SET search_path = plperl_setup_scratch;
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/pl/plperl/expected/plperl_setup.out C:/cirrus/build/testrun/plperl/regress/re...
--- C:/cirrus/src/pl/plperl/expected/plperl_setup.out 2024-12-25 12:27:27.981901400 +0000
+++ C:/cirrus/build/testrun/plperl/regress/results/plperl_setup.out 2024-12-25 12:32:41.967228500 +0000
@@ -12,7 +12,7 @@
HINT: Must have CREATE privilege on current database to create this extension.
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Only roles with privileges of the "pg_manage_extensions" role are allowed to create this extension.
RESET ROLE;
DO $$
begin
@@ -24,7 +24,7 @@
CREATE EXTENSION plperl;
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Only roles with privileges of the "pg_manage_extensions" role are allowed to create this extension.
CREATE SCHEMA plperl_setup_scratch;
SET search_path = plperl_setup_scratch;
... |
| 51/5231 |
Consider the number of columns in the sort cost model |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/level_tracking.out /tmp/cirrus-ci-build/build/testrun/...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/level_tracking.out 2024-12-25 04:42:44.853542000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_stat_statements/regress/results/level_tracking.out 2024-12-25 04:45:43.2746140...
@@ -383,26 +383,24 @@
(1 row)
EXPLAIN (COSTS OFF) SELECT 1, 2 UNION SELECT 3, 4\; EXPLAIN (COSTS OFF) (SELECT 1, 2, 3) UNION SELECT 3, 4, 5;
+ QUERY PLAN
+-----------------------
+ HashAggregate
+ Group Key: (1), (2)
+ -> Append
+ -> Result
+ -> Result
+(5 rows)
+
QUERY PLAN
----------------------------
- Unique
- -> Sort
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/level_tracking.out /tmp/cirrus-ci-build/contrib/pg_sta...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/level_tracking.out 2024-12-25 04:42:41.267289208 +0000
+++ /tmp/cirrus-ci-build/contrib/pg_stat_statements/results/level_tracking.out 2024-12-25 04:48:22.386557776 +0000
@@ -383,25 +383,23 @@
(1 row)
EXPLAIN (COSTS OFF) SELECT 1, 2 UNION SELECT 3, 4\; EXPLAIN (COSTS OFF) (SELECT 1, 2, 3) UNION SELECT 3, 4, 5;
+ QUERY PLAN
+-----------------------
+ HashAggregate
+ Group Key: (1), (2)
+ -> Append
+ -> Result
+ -> Result
+(5 rows)
+
QUERY PLAN
----------------------------
- Unique
- -> Sort
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/level_tracking.out /tmp/cirrus-ci-build/build/testrun/...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/level_tracking.out 2024-12-25 04:42:40.779184813 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_stat_statements/regress/results/level_tracking.out 2024-12-25 04:48:34.6344829...
@@ -383,25 +383,23 @@
(1 row)
EXPLAIN (COSTS OFF) SELECT 1, 2 UNION SELECT 3, 4\; EXPLAIN (COSTS OFF) (SELECT 1, 2, 3) UNION SELECT 3, 4, 5;
+ QUERY PLAN
+-----------------------
+ HashAggregate
+ Group Key: (1), (2)
+ -> Append
+ -> Result
+ -> Result
+(5 rows)
+
QUERY PLAN
----------------------------
- Unique
- -> Sort
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/contrib/pg_stat_statements/expected/level_tracking.out /Users/admin/pgsql/build/testrun/pg_s...
--- /Users/admin/pgsql/contrib/pg_stat_statements/expected/level_tracking.out 2024-12-25 04:42:10
+++ /Users/admin/pgsql/build/testrun/pg_stat_statements/regress/results/level_tracking.out 2024-12-25 04:45:37
@@ -383,25 +383,23 @@
(1 row)
EXPLAIN (COSTS OFF) SELECT 1, 2 UNION SELECT 3, 4\; EXPLAIN (COSTS OFF) (SELECT 1, 2, 3) UNION SELECT 3, 4, 5;
+ QUERY PLAN
+-----------------------
+ HashAggregate
+ Group Key: (1), (2)
+ -> Append
+ -> Result
+ -> Result
+(5 rows)
+
QUERY PLAN
----------------------------
- Unique
- -> Sort
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_stat_statements/expected/level_tracking.out C:/cirrus/build/testrun/pg...
--- C:/cirrus/contrib/pg_stat_statements/expected/level_tracking.out 2024-12-25 04:42:45.634097900 +0000
+++ C:/cirrus/build/testrun/pg_stat_statements/regress/results/level_tracking.out 2024-12-25 04:49:04.401937200 +0000
@@ -383,25 +383,23 @@
(1 row)
EXPLAIN (COSTS OFF) SELECT 1, 2 UNION SELECT 3, 4\; EXPLAIN (COSTS OFF) (SELECT 1, 2, 3) UNION SELECT 3, 4, 5;
+ QUERY PLAN
+-----------------------
+ HashAggregate
+ Group Key: (1), (2)
+ -> Append
+ -> Result
+ -> Result
+(5 rows)
+
QUERY PLAN
----------------------------
- Unique
- -> Sort
... |
| 51/5283 |
Replace IN VALUES with ANY in WHERE clauses during optimization |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/regress-running...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2024-12-25 02:18:12.369503000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress-running/regress/results/subselect.out 2024-12-25 02:23:02.551671000 +0000
@@ -2831,15 +2831,16 @@
EXPLAIN (COSTS OFF)
SELECT c.oid,c.relname FROM pg_class c JOIN pg_am a USING (oid)
WHERE c.oid IN (VALUES (1), (2));
- QUERY PLAN
----------------------------------------------------------------
- Hash Join
- Hash Cond: (a.oid = c.oid)
- -> Seq Scan on pg_am a
- -> Hash
- -> Index Scan using pg_class_oid_index on pg_class c
- Index Cond: (oid = ANY ('{1,2}'::integer[]))
-(6 rows)
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (c.oid = a.oid)
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/subselect.out /Users/admin/pgsql/build/testrun/regress/regress/res...
--- /Users/admin/pgsql/src/test/regress/expected/subselect.out 2024-12-25 02:17:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/subselect.out 2024-12-25 02:18:40
@@ -2831,15 +2831,16 @@
EXPLAIN (COSTS OFF)
SELECT c.oid,c.relname FROM pg_class c JOIN pg_am a USING (oid)
WHERE c.oid IN (VALUES (1), (2));
- QUERY PLAN
----------------------------------------------------------------
- Hash Join
- Hash Cond: (a.oid = c.oid)
- -> Seq Scan on pg_am a
- -> Hash
- -> Index Scan using pg_class_oid_index on pg_class c
- Index Cond: (oid = ANY ('{1,2}'::integer[]))
-(6 rows)
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (c.oid = a.oid)
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subselect.out C:/cirrus/build/testrun/pg_upgrade/002_pg...
--- C:/cirrus/src/test/regress/expected/subselect.out 2024-12-25 02:18:12.988955400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2024-12-25 02:20:43.914777300 +0000
@@ -2831,15 +2831,16 @@
EXPLAIN (COSTS OFF)
SELECT c.oid,c.relname FROM pg_class c JOIN pg_am a USING (oid)
WHERE c.oid IN (VALUES (1), (2));
- QUERY PLAN
----------------------------------------------------------------
- Hash Join
- Hash Cond: (a.oid = c.oid)
- -> Seq Scan on pg_am a
- -> Hash
- -> Index Scan using pg_class_oid_index on pg_class c
- Index Cond: (oid = ANY ('{1,2}'::integer[]))
-(6 rows)
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (c.oid = a.oid)
... |
| 51/5426 |
Add a warning message when using unencrypted passwords |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/connect-test5.stderr /tmp/cirrus-ci-build/build/testrun/...
--- /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/connect-test5.stderr 2024-12-24 23:34:09.516418000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/ecpg/ecpg/results/connect-test5.stderr 2024-12-24 23:36:56.957338000 +0000
@@ -4,16 +4,24 @@
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ecpg_execute on line 24: query: alter user regress_ecpg_user2 encrypted password 'insecure'; with 0 parameter...
[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_execute on line 24: using PQexec
+[NO_PID]: ECPGnoticeReceiver: using a plaintext password in a query
[NO_PID]: sqlca: code: 0, state: 00000
+[NO_PID]: raising sqlcode 0
+[NO_PID]: sqlca: code: 0, state: 01000
+[NO_PID]: ecpg_execute on line 24: using PQexec
+[NO_PID]: sqlca: code: 0, state: 01000
[NO_PID]: ecpg_process_output on line 24: OK: ALTER ROLE
-[NO_PID]: sqlca: code: 0, state: 00000
+[NO_PID]: sqlca: code: 0, state: 01000
[NO_PID]: ecpg_execute on line 25: query: alter user regress_ecpg_user1 encrypted password 'connectpw'; with 0 paramete...
[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_execute on line 25: using PQexec
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/connect-test5.stderr /tmp/cirrus-ci-build/src/interfaces...
--- /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/connect-test5.stderr 2024-12-24 23:34:05.781787584 +0000
+++ /tmp/cirrus-ci-build/src/interfaces/ecpg/test/results/connect-test5.stderr 2024-12-24 23:36:07.767947448 +0000
@@ -4,16 +4,24 @@
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ecpg_execute on line 24: query: alter user regress_ecpg_user2 encrypted password 'insecure'; with 0 parameter...
[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_execute on line 24: using PQexec
+[NO_PID]: ECPGnoticeReceiver: using a plaintext password in a query
[NO_PID]: sqlca: code: 0, state: 00000
+[NO_PID]: raising sqlcode 0
+[NO_PID]: sqlca: code: 0, state: 01000
+[NO_PID]: ecpg_execute on line 24: using PQexec
+[NO_PID]: sqlca: code: 0, state: 01000
[NO_PID]: ecpg_process_output on line 24: OK: ALTER ROLE
-[NO_PID]: sqlca: code: 0, state: 00000
+[NO_PID]: sqlca: code: 0, state: 01000
[NO_PID]: ecpg_execute on line 25: query: alter user regress_ecpg_user1 encrypted password 'connectpw'; with 0 paramete...
[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_execute on line 25: using PQexec
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/connect-test5.stderr /tmp/cirrus-ci-build/build/testrun/...
--- /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/connect-test5.stderr 2024-12-24 23:34:04.398228592 +0000
+++ /tmp/cirrus-ci-build/build/testrun/ecpg/ecpg/results/connect-test5.stderr 2024-12-24 23:37:26.827199872 +0000
@@ -4,16 +4,24 @@
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ecpg_execute on line 24: query: alter user regress_ecpg_user2 encrypted password 'insecure'; with 0 parameter...
[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_execute on line 24: using PQexec
+[NO_PID]: ECPGnoticeReceiver: using a plaintext password in a query
[NO_PID]: sqlca: code: 0, state: 00000
+[NO_PID]: raising sqlcode 0
+[NO_PID]: sqlca: code: 0, state: 01000
+[NO_PID]: ecpg_execute on line 24: using PQexec
+[NO_PID]: sqlca: code: 0, state: 01000
[NO_PID]: ecpg_process_output on line 24: OK: ALTER ROLE
-[NO_PID]: sqlca: code: 0, state: 00000
+[NO_PID]: sqlca: code: 0, state: 01000
[NO_PID]: ecpg_execute on line 25: query: alter user regress_ecpg_user1 encrypted password 'connectpw'; with 0 paramete...
[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_execute on line 25: using PQexec
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/interfaces/ecpg/test/expected/connect-test5.stderr /Users/admin/pgsql/build/testrun/ecpg...
--- /Users/admin/pgsql/src/interfaces/ecpg/test/expected/connect-test5.stderr 2024-12-24 23:33:11
+++ /Users/admin/pgsql/build/testrun/ecpg/ecpg/results/connect-test5.stderr 2024-12-24 23:36:16
@@ -4,16 +4,24 @@
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ecpg_execute on line 24: query: alter user regress_ecpg_user2 encrypted password 'insecure'; with 0 parameter...
[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_execute on line 24: using PQexec
+[NO_PID]: ECPGnoticeReceiver: using a plaintext password in a query
[NO_PID]: sqlca: code: 0, state: 00000
+[NO_PID]: raising sqlcode 0
+[NO_PID]: sqlca: code: 0, state: 01000
+[NO_PID]: ecpg_execute on line 24: using PQexec
+[NO_PID]: sqlca: code: 0, state: 01000
[NO_PID]: ecpg_process_output on line 24: OK: ALTER ROLE
-[NO_PID]: sqlca: code: 0, state: 00000
+[NO_PID]: sqlca: code: 0, state: 01000
[NO_PID]: ecpg_execute on line 25: query: alter user regress_ecpg_user1 encrypted password 'connectpw'; with 0 paramete...
[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_execute on line 25: using PQexec
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/interfaces/ecpg/test/expected/connect-test5.stderr C:/cirrus/build/testrun/ec...
--- C:/cirrus/src/interfaces/ecpg/test/expected/connect-test5.stderr 2024-12-24 23:34:10.389485400 +0000
+++ C:/cirrus/build/testrun/ecpg/ecpg/results/connect-test5.stderr 2024-12-24 23:41:21.430007700 +0000
@@ -4,16 +4,24 @@
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ecpg_execute on line 24: query: alter user regress_ecpg_user2 encrypted password 'insecure'; with 0 parameter...
[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_execute on line 24: using PQexec
+[NO_PID]: ECPGnoticeReceiver: using a plaintext password in a query
[NO_PID]: sqlca: code: 0, state: 00000
+[NO_PID]: raising sqlcode 0
+[NO_PID]: sqlca: code: 0, state: 01000
+[NO_PID]: ecpg_execute on line 24: using PQexec
+[NO_PID]: sqlca: code: 0, state: 01000
[NO_PID]: ecpg_process_output on line 24: OK: ALTER ROLE
-[NO_PID]: sqlca: code: 0, state: 00000
+[NO_PID]: sqlca: code: 0, state: 01000
[NO_PID]: ecpg_execute on line 25: query: alter user regress_ecpg_user1 encrypted password 'connectpw'; with 0 paramete...
[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_execute on line 25: using PQexec
... |
| 51/5004 |
CREATE INDEX CONCURRENTLY for partitioned tables |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2024-12-24 21:41:53.795053000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2024-12-24 21:44:34.421142000...
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2024-12-24 21:41:53.795053000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2024-12-24 21:45:16.4076170...
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2024-12-24 21:41:53.795053000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/indexing.out 2024-12-24 21:44:27.234053000 +0000
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2024-12-24 21:41:52.095517833 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/indexing.out 2024-12-24 21:50:00.885064045 +0000
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/partitioned-cic.out /tmp/cirrus-ci-build/src/test/isolation/ou...
--- /tmp/cirrus-ci-build/src/test/isolation/expected/partitioned-cic.out 2024-12-24 21:41:51.935899903 +0000
+++ /tmp/cirrus-ci-build/src/test/isolation/output_iso/results/partitioned-cic.out 2024-12-24 22:11:20.726967585 +0000
@@ -3,10 +3,14 @@
starting permutation: lock_p1 cic insert drop2 commit chk_content
step lock_p1: lock cictab_part_1 in row exclusive mode;
step cic: CREATE INDEX CONCURRENTLY ON cictab(i); <waiting ...>
-step insert: insert into cictab values (1, 1), (11, 1);
-step drop2: DROP TABLE cictab_part_2;
+step insert: insert into cictab values (1, 1), (11, 1); <waiting ...>
+isolationtester: canceling step insert after 360 seconds
+step insert: <... completed>
+ERROR: canceling statement due to user request
+step drop2: DROP TABLE cictab_part_2; <waiting ...>
step commit: COMMIT;
step cic: <... completed>
+step drop2: <... completed>
step chk_content:
set enable_seqscan to off;
explain (costs off) select * from cictab where i > 0;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2024-12-24 21:41:52.095517833 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/indexing.out 2024-12-24 21:51:11.109182786 +0000
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/test/regress/results/index...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2024-12-24 21:41:52.095517833 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/indexing.out 2024-12-24 21:47:28.793561102 +0000
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2024-12-24 21:41:49.897450807 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2024-12-24 21:47:28.752822999...
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2024-12-24 21:41:49.897450807 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2024-12-24 21:47:56.5447977...
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2024-12-24 21:41:49.897450807 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/indexing.out 2024-12-24 21:47:22.008829612 +0000
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2024-12-24 21:41:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2024-12-24 21:46:31
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2024-12-24 21:41:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2024-12-24 21:47:13
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/regress/regress/resu...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2024-12-24 21:41:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/indexing.out 2024-12-24 21:46:34
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/indexing.out 2024-12-24 21:41:57.321626000 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2024-12-24 21:45:43.545955900 +0000
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/indexing.out 2024-12-24 21:41:57.321626000 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2024-12-24 21:47:43.918950300 +0000
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/indexing.out 2024-12-24 21:41:57.321626000 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/indexing.out 2024-12-24 21:45:38.816478000 +0000
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
| 51/5421 |
Use streaming read API in pgstattuple. |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pgstattuple/expected/pgstattuple.out /tmp/cirrus-ci-build/build-32/testrun/pgstatt...
--- /tmp/cirrus-ci-build/contrib/pgstattuple/expected/pgstattuple.out 2024-12-24 15:54:19.852404282 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/pgstattuple/regress/results/pgstattuple.out 2024-12-24 16:03:33.235581706 +000...
@@ -134,7 +134,7 @@
select * from pgstathashindex('test_hashidx');
version | bucket_pages | overflow_pages | bitmap_pages | unused_pages | live_items | dead_items | free_percent
---------+--------------+----------------+--------------+--------------+------------+------------+--------------
- 4 | 4 | 0 | 1 | 0 | 0 | 0 | 100
+ 4 | 2 | 0 | 1 | 0 | 0 | 0 | 100
(1 row)
create index test_gistidx ON test USING gist(c);
@@ -166,7 +166,7 @@
select pgstattuple('test_hashidx');
pgstattuple
---------------------------------
- (49152,0,0,0,0,0,0,32608,66.34)
+ (32768,0,0,0,0,0,0,16304,49.76)
(1 row)
... |
| 51/5284 |
database-specific role memberships |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/privs_in_db.out /tmp/cirrus-ci-build/build/testrun/regress-runni...
--- /tmp/cirrus-ci-build/src/test/regress/expected/privs_in_db.out 2024-12-24 13:46:12.561476000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress-running/regress/results/privs_in_db.out 2024-12-24 13:52:20.405797000 +00...
@@ -756,9 +756,10 @@
DROP DATABASE regression_db_0;
DROP ROLE regress_role_admin;
SELECT datname FROM pg_database WHERE datname LIKE 'regression_db_%';
- datname
----------
-(0 rows)
+ datname
+-------------------
+ regression_dblink
+(1 row)
SELECT rolname FROM pg_roles WHERE rolname LIKE 'regress_role_%';
rolname |
| 51/5404 |
Self contradictory examining on rel's baserestrictinfo |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/btree_gin/expected/bool.out /tmp/cirrus-ci-build/build/testrun/btree_gin/regress/r...
--- /tmp/cirrus-ci-build/contrib/btree_gin/expected/bool.out 2024-12-24 13:09:40.429167000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/btree_gin/regress/results/bool.out 2024-12-24 13:12:22.617855000 +0000
@@ -109,15 +109,13 @@
(6 rows)
EXPLAIN (COSTS OFF) SELECT * FROM test_bool WHERE i>true ORDER BY i;
- QUERY PLAN
--------------------------------------------
+ QUERY PLAN
+--------------------------------
Sort
Sort Key: i
- -> Bitmap Heap Scan on test_bool
- Recheck Cond: (i > true)
- -> Bitmap Index Scan on idx_bool
- Index Cond: (i > true)
-(6 rows)
+ -> Result
+ One-Time Filter: false
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/horology.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/horology.out 2024-12-24 13:09:42.001962000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/horology.out 2024-12-24 13:11:06.337289000...
@@ -2541,18 +2541,17 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+----------------------------
Aggregate
-> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
+(2 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
count
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/horology.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/horology.out 2024-12-24 13:09:42.001962000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/horology.out 2024-12-24 13:11:45.0405330...
@@ -2541,18 +2541,17 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+----------------------------
Aggregate
-> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
+(2 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
count
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/horology.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/horology.out 2024-12-24 13:09:42.001962000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/horology.out 2024-12-24 13:11:05.482641000 +0000
@@ -2541,18 +2541,17 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+----------------------------
Aggregate
-> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
+(2 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
count
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/btree_gin/expected/bool.out /tmp/cirrus-ci-build/contrib/btree_gin/results/bool.ou...
--- /tmp/cirrus-ci-build/contrib/btree_gin/expected/bool.out 2024-12-24 13:09:38.150463286 +0000
+++ /tmp/cirrus-ci-build/contrib/btree_gin/results/bool.out 2024-12-24 13:14:39.638541081 +0000
@@ -109,15 +109,13 @@
(6 rows)
EXPLAIN (COSTS OFF) SELECT * FROM test_bool WHERE i>true ORDER BY i;
- QUERY PLAN
--------------------------------------------
+ QUERY PLAN
+--------------------------------
Sort
Sort Key: i
- -> Bitmap Heap Scan on test_bool
- Recheck Cond: (i > true)
- -> Bitmap Index Scan on idx_bool
- Index Cond: (i > true)
-(6 rows)
+ -> Result
+ One-Time Filter: false
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/horology.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/horology.out 2024-12-24 13:09:40.096883002 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/horology.out 2024-12-24 13:14:57.958497556 +0000
@@ -2541,18 +2541,18 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+--------------------------------------------
Aggregate
-> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
+ Filter: (f1 <= '01-01-1998'::date)
(3 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
count
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/horology.out /tmp/cirrus-ci-build/src/test/regress/results/horol...
--- /tmp/cirrus-ci-build/src/test/regress/expected/horology.out 2024-12-24 13:09:40.096883002 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/horology.out 2024-12-24 13:12:58.206642600 +0000
@@ -2541,18 +2541,18 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+--------------------------------------------
Aggregate
-> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
+ Filter: (f1 <= '01-01-1998'::date)
(3 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
count
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/btree_gin/expected/bool.out /tmp/cirrus-ci-build/build/testrun/btree_gin/regress/r...
--- /tmp/cirrus-ci-build/contrib/btree_gin/expected/bool.out 2024-12-24 13:09:36.694570253 +0000
+++ /tmp/cirrus-ci-build/build/testrun/btree_gin/regress/results/bool.out 2024-12-24 13:13:46.162002211 +0000
@@ -109,15 +109,13 @@
(6 rows)
EXPLAIN (COSTS OFF) SELECT * FROM test_bool WHERE i>true ORDER BY i;
- QUERY PLAN
--------------------------------------------
+ QUERY PLAN
+--------------------------------
Sort
Sort Key: i
- -> Bitmap Heap Scan on test_bool
- Recheck Cond: (i > true)
- -> Bitmap Index Scan on idx_bool
- Index Cond: (i > true)
-(6 rows)
+ -> Result
+ One-Time Filter: false
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/horology.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/horology.out 2024-12-24 13:09:38.582570322 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/horology.out 2024-12-24 13:13:03.814097954...
@@ -2541,1334 +2541,7 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
- Aggregate
- -> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
-
-select count(*) from date_tbl
- where f1 between symmetric '1997-01-01' and '1998-01-01';
- count
--------
- 3
-(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/horology.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/horology.out 2024-12-24 13:09:38.582570322 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/horology.out 2024-12-24 13:13:30.6340355...
@@ -2541,1334 +2541,7 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
- Aggregate
- -> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
-
-select count(*) from date_tbl
- where f1 between symmetric '1997-01-01' and '1998-01-01';
- count
--------
- 3
-(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/horology.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/horology.out 2024-12-24 13:09:38.582570322 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/horology.out 2024-12-24 13:13:00.442099198 +0000
@@ -2541,1334 +2541,7 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
- Aggregate
- -> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
-
-select count(*) from date_tbl
- where f1 between symmetric '1997-01-01' and '1998-01-01';
- count
--------
- 3
-(1 row)
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/contrib/btree_gin/expected/bool.out /Users/admin/pgsql/build/testrun/btree_gin/regress/resul...
--- /Users/admin/pgsql/contrib/btree_gin/expected/bool.out 2024-12-24 13:09:10
+++ /Users/admin/pgsql/build/testrun/btree_gin/regress/results/bool.out 2024-12-24 13:12:15
@@ -109,15 +109,13 @@
(6 rows)
EXPLAIN (COSTS OFF) SELECT * FROM test_bool WHERE i>true ORDER BY i;
- QUERY PLAN
--------------------------------------------
+ QUERY PLAN
+--------------------------------
Sort
Sort Key: i
- -> Bitmap Heap Scan on test_bool
- Recheck Cond: (i > true)
- -> Bitmap Index Scan on idx_bool
- Index Cond: (i > true)
-(6 rows)
+ -> Result
+ One-Time Filter: false
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/horology.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/horology.out 2024-12-24 13:09:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/horology.out 2024-12-24 13:10:57
@@ -2541,18 +2541,17 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+----------------------------
Aggregate
-> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
+(2 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
count
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/horology.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/horology.out 2024-12-24 13:09:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/horology.out 2024-12-24 13:11:42
@@ -2541,18 +2541,17 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+----------------------------
Aggregate
-> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
+(2 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
count
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/horology.out /Users/admin/pgsql/build/testrun/regress/regress/resu...
--- /Users/admin/pgsql/src/test/regress/expected/horology.out 2024-12-24 13:09:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/horology.out 2024-12-24 13:10:55
@@ -2541,18 +2541,17 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+----------------------------
Aggregate
-> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
+(2 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
count
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/btree_gin/expected/bool.out C:/cirrus/build/testrun/btree_gin/regress/res...
--- C:/cirrus/contrib/btree_gin/expected/bool.out 2024-12-24 13:09:40.220296400 +0000
+++ C:/cirrus/build/testrun/btree_gin/regress/results/bool.out 2024-12-24 13:15:26.926398700 +0000
@@ -109,15 +109,13 @@
(6 rows)
EXPLAIN (COSTS OFF) SELECT * FROM test_bool WHERE i>true ORDER BY i;
- QUERY PLAN
--------------------------------------------
+ QUERY PLAN
+--------------------------------
Sort
Sort Key: i
- -> Bitmap Heap Scan on test_bool
- Recheck Cond: (i > true)
- -> Bitmap Index Scan on idx_bool
- Index Cond: (i > true)
-(6 rows)
+ -> Result
+ One-Time Filter: false
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/horology.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/horology.out 2024-12-24 13:09:44.946359300 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/horology.out 2024-12-24 13:11:50.208965100 +0000
@@ -2541,18 +2541,17 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+----------------------------
Aggregate
-> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
+(2 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
count
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/horology.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/horology.out 2024-12-24 13:09:44.946359300 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/horology.out 2024-12-24 13:13:59.773093700 +0000
@@ -2541,18 +2541,17 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+----------------------------
Aggregate
-> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
+(2 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
count
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/horology.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/horology.out 2024-12-24 13:09:44.946359300 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/horology.out 2024-12-24 13:11:44.560454000 +0000
@@ -2541,18 +2541,17 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+----------------------------
Aggregate
-> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
+(2 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
count
... |
| 51/5410 |
Disable installcheck for tap and regress tests for injection_points module |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/crash.out /tmp/cirrus-ci-build/build/testrun/in...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/crash.out 2024-12-24 11:41:12.572348000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/crash.out 2024-12-24 11:43:45.933680000 +0000
@@ -23,4 +23,10 @@
step c2: COMMIT;
ERROR: could not serialize access due to read/write dependencies among transactions
+s2: WARNING: AbortTransaction while in ABORT state
+ERROR: ResourceOwnerEnlarge called after release started
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+
step c3: COMMIT;
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/inplace.out /tmp/cirrus-ci-build/build/testrun/...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/inplace.out 2024-12-24 11:41:12.572541000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/inplace.out 2024-12-24 11:43:45.993155000 +000...
@@ -1,340 +1,2 @@
Parsed test spec with 3 sessions
-
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/crash.out /tmp/cirrus-ci-build/src/test/modules...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/crash.out 2024-12-24 11:41:08.612625080 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/injection_points/output_iso/results/crash.out 2024-12-24 11:46:06.431478570 +0...
@@ -23,4 +23,10 @@
step c2: COMMIT;
ERROR: could not serialize access due to read/write dependencies among transactions
+s2: WARNING: AbortTransaction while in ABORT state
+ERROR: ResourceOwnerEnlarge called after release started
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+
step c3: COMMIT;
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/inplace.out /tmp/cirrus-ci-build/src/test/modul...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/inplace.out 2024-12-24 11:41:08.612625080 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/injection_points/output_iso/results/inplace.out 2024-12-24 11:46:07.023485363 ...
@@ -14,327 +14,6 @@
step vac1: VACUUM vactest.orig50; -- wait during inplace update <waiting ...>
step grant2: GRANT SELECT ON TABLE vactest.orig50 TO PUBLIC;
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/crash.out /tmp/cirrus-ci-build/build/testrun/in...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/crash.out 2024-12-24 11:41:07.706979560 +0000
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/crash.out 2024-12-24 11:43:59.238721127 +0000
@@ -23,4 +23,10 @@
step c2: COMMIT;
ERROR: could not serialize access due to read/write dependencies among transactions
+s2: WARNING: AbortTransaction while in ABORT state
+ERROR: ResourceOwnerEnlarge called after release started
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+
step c3: COMMIT;
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/inplace.out /tmp/cirrus-ci-build/build/testrun/...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/inplace.out 2024-12-24 11:41:07.706979560 +0000
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/inplace.out 2024-12-24 11:43:59.742720942 +000...
@@ -47,294 +47,6 @@
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/modules/injection_points/expected/crash.out /Users/admin/pgsql/build/testrun/inject...
--- /Users/admin/pgsql/src/test/modules/injection_points/expected/crash.out 2024-12-24 11:40:11
+++ /Users/admin/pgsql/build/testrun/injection_points/isolation/results/crash.out 2024-12-24 11:43:32
@@ -23,4 +23,20 @@
step c2: COMMIT;
ERROR: could not serialize access due to read/write dependencies among transactions
+s2: WARNING: AbortTransaction while in ABORT state
+ERROR: ResourceOwnerEnlarge called after release started
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+
+s3: WARNING: terminating connection because of crash of another server process
+DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because anothe...
+HINT: In a moment you should be able to reconnect to the database and repeat your command.
step c3: COMMIT;
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/injection_points/expected/crash.out C:/cirrus/build/testrun/inje...
--- C:/cirrus/src/test/modules/injection_points/expected/crash.out 2024-12-24 11:41:12.775965400 +0000
+++ C:/cirrus/build/testrun/injection_points/isolation/results/crash.out 2024-12-24 11:48:28.716653100 +0000
@@ -23,4 +23,10 @@
step c2: COMMIT;
ERROR: could not serialize access due to read/write dependencies among transactions
+ERROR: ResourceOwnerEnlarge called after release started
+s2: WARNING: AbortTransaction while in ABORT state
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+
step c3: COMMIT; |
| 51/5117 |
VACUUM FULL / CLUSTER CONCURRENTLY |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/cluster.out /tmp/cirrus-ci-build/build/testrun/...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/cluster.out 2024-12-24 08:28:02.575619000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/injection_points-running/isolation/results/cluster.out 2024-12-24 08:34:11.781113...
@@ -8,7 +8,8 @@
step wait_before_lock:
CLUSTER (CONCURRENTLY) clstr_test USING clstr_test_pkey;
- <waiting ...>
+
+ERROR: logical decoding requires "wal_level" >= "logical"
step change_existing:
UPDATE clstr_test SET i=10 where i=1;
UPDATE clstr_test SET j=20 where i=2;
@@ -63,12 +64,7 @@
step wakeup_before_lock:
SELECT injection_points_wakeup('cluster-concurrently-before-lock');
-injection_points_wakeup
------------------------
-
... |
| 51/4980 |
Expand applicability of aggregate's sortop optimization |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/regress/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2024-12-24 07:43:04.231869000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/subselect.out 2024-12-24 07:45:13.759204000 +0000
@@ -1029,7 +1029,7 @@
-> Seq Scan on tenk1 t
Filter: ((ANY (unique2 = (hashed SubPlan 2).col1)) OR (ten < 0))
SubPlan 2
- -> Index Only Scan using tenk1_unique1 on tenk1 k
+ -> Index Only Scan using idx_int4 on tenk1 k
(5 rows)
select count(*) from tenk1 t |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2024-12-24 07:43:04.253707613 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/subselect.out 2024-12-24 07:50:28.703533314 +0000
@@ -1029,7 +1029,7 @@
-> Seq Scan on tenk1 t
Filter: ((ANY (unique2 = (hashed SubPlan 2).col1)) OR (ten < 0))
SubPlan 2
- -> Index Only Scan using tenk1_unique1 on tenk1 k
+ -> Index Only Scan using idx_int4 on tenk1 k
(5 rows)
select count(*) from tenk1 t |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out /tmp/cirrus-ci-build/src/test/regress/results/bt...
--- /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out 2024-12-24 07:43:04.169778473 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/btree_index.out 2024-12-24 07:47:35.479861429 +0000
@@ -158,13 +158,10 @@
set enable_bitmapscan to false;
explain (costs off)
select hundred, twenty from tenk1 where hundred < 48 order by hundred desc limit 1;
- QUERY PLAN
---------------------------------------------------------
- Limit
- -> Index Scan Backward using tenk1_hundred on tenk1
- Index Cond: (hundred < 48)
-(3 rows)
-
+ERROR: deadlock detected
+DETAIL: Process 24182 waits for AccessShareLock on relation 25247 of database 16384; blocked by process 24171.
+Process 24171 waits for AccessExclusiveLock on relation 16418 of database 16384; blocked by process 24182.
+HINT: See server log for query details.
select hundred, twenty from tenk1 where hundred < 48 order by hundred desc limit 1;
hundred | twenty
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_distinct.out /tmp/cirrus-ci-build/build/testrun/pg_upgrad...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_distinct.out 2024-12-24 07:43:06.334965020 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_distinct.out 2024-12-24 07:48:11.51...
@@ -334,13 +334,10 @@
-- Ensure we get a plan with a Limit 1 when the SELECT list contains constants
EXPLAIN (COSTS OFF)
SELECT DISTINCT four,1,2,3 FROM tenk1 WHERE four = 0;
- QUERY PLAN
-----------------------------
- Limit
- -> Seq Scan on tenk1
- Filter: (four = 0)
-(3 rows)
-
+ERROR: deadlock detected
+DETAIL: Process 30127 waits for AccessShareLock on relation 25296 of database 16387; blocked by process 30131.
+Process 30131 waits for AccessExclusiveLock on relation 16421 of database 16387; blocked by process 30127.
+HINT: See server log for query details.
-- Ensure we only get 1 row
SELECT DISTINCT four,1,2,3 FROM tenk1 WHERE four = 0;
... |
| 51/5446 |
Improving default column names/aliases of subscript text expressions |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/hstore/expected/hstore.out /tmp/cirrus-ci-build/build/testrun/hstore/regress/resul...
--- /tmp/cirrus-ci-build/contrib/hstore/expected/hstore.out 2024-12-24 07:24:31.945023000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/hstore/regress/results/hstore.out 2024-12-24 07:27:08.272283000 +0000
@@ -1597,7 +1597,7 @@
-- Test subscripting
insert into test_json_agg default values;
select f2['d'], f2['x'] is null as x_isnull from test_json_agg;
- f2 | x_isnull
+ d | x_isnull
--------+----------
12345 | t
-12345 | t |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2024-12-24 07:24:33.457245000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonb.out 2024-12-24 07:26:31.962999000 +0...
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2024-12-24 07:24:33.457245000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/jsonb.out 2024-12-24 07:27:18.769405000 ...
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/build/testrun/regress/regress/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2024-12-24 07:24:33.457245000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/jsonb.out 2024-12-24 07:26:29.351402000 +0000
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/hstore/expected/hstore.out /tmp/cirrus-ci-build/contrib/hstore/results/hstore.out
--- /tmp/cirrus-ci-build/contrib/hstore/expected/hstore.out 2024-12-24 07:24:32.014939519 +0000
+++ /tmp/cirrus-ci-build/contrib/hstore/results/hstore.out 2024-12-24 07:29:38.911119229 +0000
@@ -1597,7 +1597,7 @@
-- Test subscripting
insert into test_json_agg default values;
select f2['d'], f2['x'] is null as x_isnull from test_json_agg;
- f2 | x_isnull
+ d | x_isnull
--------+----------
12345 | t
-12345 | t |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/resu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2024-12-24 07:24:33.905849886 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/jsonb.out 2024-12-24 07:31:09.814775232 +0000
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2024-12-24 07:24:33.905849886 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/jsonb.out 2024-12-24 07:33:11.135683375 +0000
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/src/test/regress/results/jsonb.ou...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2024-12-24 07:24:33.905849886 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/jsonb.out 2024-12-24 07:29:15.226774157 +0000
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/hstore/expected/hstore.out /tmp/cirrus-ci-build/build/testrun/hstore/regress/resul...
--- /tmp/cirrus-ci-build/contrib/hstore/expected/hstore.out 2024-12-24 07:24:32.053727994 +0000
+++ /tmp/cirrus-ci-build/build/testrun/hstore/regress/results/hstore.out 2024-12-24 07:29:32.739505344 +0000
@@ -1597,7 +1597,7 @@
-- Test subscripting
insert into test_json_agg default values;
select f2['d'], f2['x'] is null as x_isnull from test_json_agg;
- f2 | x_isnull
+ d | x_isnull
--------+----------
12345 | t
-12345 | t |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2024-12-24 07:24:33.937838051 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonb.out 2024-12-24 07:29:08.731541223 +0...
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2024-12-24 07:24:33.937838051 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/jsonb.out 2024-12-24 07:29:49.099463646 ...
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/build/testrun/regress/regress/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2024-12-24 07:24:33.937838051 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/jsonb.out 2024-12-24 07:29:01.035544555 +0000
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/contrib/hstore/expected/hstore.out /Users/admin/pgsql/build/testrun/hstore/regress/results/h...
--- /Users/admin/pgsql/contrib/hstore/expected/hstore.out 2024-12-24 07:24:10
+++ /Users/admin/pgsql/build/testrun/hstore/regress/results/hstore.out 2024-12-24 07:27:06
@@ -1597,7 +1597,7 @@
-- Test subscripting
insert into test_json_agg default values;
select f2['d'], f2['x'] is null as x_isnull from test_json_agg;
- f2 | x_isnull
+ d | x_isnull
--------+----------
12345 | t
-12345 | t |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/jsonb.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgra...
--- /Users/admin/pgsql/src/test/regress/expected/jsonb.out 2024-12-24 07:24:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonb.out 2024-12-24 07:25:58
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/jsonb.out /Users/admin/pgsql/build/testrun/recovery/027_stream_reg...
--- /Users/admin/pgsql/src/test/regress/expected/jsonb.out 2024-12-24 07:24:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/jsonb.out 2024-12-24 07:27:02
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/jsonb.out /Users/admin/pgsql/build/testrun/regress/regress/results...
--- /Users/admin/pgsql/src/test/regress/expected/jsonb.out 2024-12-24 07:24:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/jsonb.out 2024-12-24 07:26:01
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/hstore/expected/hstore.out C:/cirrus/build/testrun/hstore/regress/results...
--- C:/cirrus/contrib/hstore/expected/hstore.out 2024-12-24 07:24:32.456402100 +0000
+++ C:/cirrus/build/testrun/hstore/regress/results/hstore.out 2024-12-24 07:30:31.197262300 +0000
@@ -1597,7 +1597,7 @@
-- Test subscripting
insert into test_json_agg default values;
select f2['d'], f2['x'] is null as x_isnull from test_json_agg;
- f2 | x_isnull
+ d | x_isnull
--------+----------
12345 | t
-12345 | t |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/jsonb.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upg...
--- C:/cirrus/src/test/regress/expected/jsonb.out 2024-12-24 07:24:36.640422900 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonb.out 2024-12-24 07:28:04.375925500 +0000
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/jsonb.out C:/cirrus/build/testrun/recovery/027_stream_r...
--- C:/cirrus/src/test/regress/expected/jsonb.out 2024-12-24 07:24:36.640422900 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/jsonb.out 2024-12-24 07:30:24.009757000 +0000
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/jsonb.out C:/cirrus/build/testrun/regress/regress/resul...
--- C:/cirrus/src/test/regress/expected/jsonb.out 2024-12-24 07:24:36.640422900 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/jsonb.out 2024-12-24 07:27:55.078067100 +0000
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| 51/4620 |
CRC32C Parallel Computation Optimization on ARM |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/test_crc32c/expected/test_crc32c.out /tmp/cirrus-ci-build/build-32/testrun/test_cr...
--- /tmp/cirrus-ci-build/contrib/test_crc32c/expected/test_crc32c.out 2024-12-24 07:07:46.541145890 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/test_crc32c/regress/results/test_crc32c.out 2024-12-24 07:17:10.868461790 +000...
@@ -1,57 +1,6 @@
CREATE EXTENSION test_crc32c;
select drive_crc32c(1, i) from generate_series(100, 300, 4) i;
- drive_crc32c
---------------
- 532139994
- 2103623867
- 785984197
- 2686825890
- 3213049059
- 3819630168
- 1389234603
- 534072900
- 2930108140
- 2496889855
- 1475239611
- 136366931
... |
| 51/5323 |
Support enabling checksums online |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/brin.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgr...
--- C:/cirrus/src/test/regress/expected/brin.out 2024-12-24 06:02:59.907817800 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/brin.out 2024-12-24 06:05:47.671263100 +0000
@@ -574,18 +574,10 @@
SET LOCAL min_parallel_table_scan_size = 0;
SET LOCAL max_parallel_maintenance_workers = 4;
CREATE INDEX brintest_expr_idx ON brintest_expr USING brin (brintest_func());
-COMMIT;
-DROP TABLE brintest_expr;
-DROP FUNCTION brintest_func();
--- test an unlogged table, mostly to get coverage of brinbuildempty
-CREATE UNLOGGED TABLE brintest_unlogged (n numrange);
-CREATE INDEX brinidx_unlogged ON brintest_unlogged USING brin (n);
-INSERT INTO brintest_unlogged VALUES (numrange(0, 2^1000::numeric));
-DROP TABLE brintest_unlogged;
--- test that the insert optimization works if no rows end up inserted
-CREATE TABLE brin_insert_optimization (a int);
-INSERT INTO brin_insert_optimization VALUES (1);
-CREATE INDEX brin_insert_optimization_idx ON brin_insert_optimization USING brin (a);
-UPDATE brin_insert_optimization SET a = a;
... |
| 51/5371 |
TimestampTz->Text->TimestampTz casting fails with DateStyle 'Postgres' |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out 2024-12-24 05:44:12.446168000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/timestamptz.out 2024-12-24 05:45:00.831733...
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out 2024-12-24 05:44:12.446168000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/timestamptz.out 2024-12-24 05:45:40.2874...
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out 2024-12-24 05:44:12.446168000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/timestamptz.out 2024-12-24 05:44:58.841736000 +0000
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_chec...
--- /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out 2024-12-24 05:44:09.801446819 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/timestamptz.out 2024-12-24 05:47:49.905456024 +0000
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check...
--- /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out 2024-12-24 05:44:09.801446819 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/timestamptz.out 2024-12-24 05:50:15.809286738 +0000
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out /tmp/cirrus-ci-build/src/test/regress/results/ti...
--- /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out 2024-12-24 05:44:09.801446819 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/timestamptz.out 2024-12-24 05:45:34.701571060 +0000
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out 2024-12-24 05:44:09.399777318 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/timestamptz.out 2024-12-24 05:45:34.743440...
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out 2024-12-24 05:44:09.399777318 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/timestamptz.out 2024-12-24 05:46:09.5553...
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out 2024-12-24 05:44:09.399777318 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/timestamptz.out 2024-12-24 05:45:30.915454246 +0000
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/timestamptz.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg...
--- /Users/admin/pgsql/src/test/regress/expected/timestamptz.out 2024-12-24 05:43:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/timestamptz.out 2024-12-24 05:44:27
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/timestamptz.out /Users/admin/pgsql/build/testrun/recovery/027_stre...
--- /Users/admin/pgsql/src/test/regress/expected/timestamptz.out 2024-12-24 05:43:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/timestamptz.out 2024-12-24 05:45:13
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/timestamptz.out /Users/admin/pgsql/build/testrun/regress/regress/r...
--- /Users/admin/pgsql/src/test/regress/expected/timestamptz.out 2024-12-24 05:43:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/timestamptz.out 2024-12-24 05:44:26
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/timestamptz.out C:/cirrus/build/testrun/pg_upgrade/002_...
--- C:/cirrus/src/test/regress/expected/timestamptz.out 2024-12-24 05:44:14.762700200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/timestamptz.out 2024-12-24 05:46:18.149717300 +0000
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/timestamptz.out C:/cirrus/build/testrun/recovery/027_st...
--- C:/cirrus/src/test/regress/expected/timestamptz.out 2024-12-24 05:44:14.762700200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/timestamptz.out 2024-12-24 05:48:38.076536900 +0000
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/timestamptz.out C:/cirrus/build/testrun/regress/regress...
--- C:/cirrus/src/test/regress/expected/timestamptz.out 2024-12-24 05:44:14.762700200 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/timestamptz.out 2024-12-24 05:46:11.925099400 +0000
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
| 51/5153 |
Prohibit to use EphemeralNamedRelation in materialized views |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-12-23 16:01:17.863971000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2024-12-23 16:02:20.622551000...
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-12-23 16:01:17.863971000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2024-12-23 16:03:05.5484650...
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-12-23 16:01:17.863971000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/triggers.out 2024-12-23 16:02:20.941703000 +0000
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-12-23 16:01:18.211816713 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/triggers.out 2024-12-23 16:06:10.195110588 +0000
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-12-23 16:01:18.211816713 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/triggers.out 2024-12-23 16:07:46.227349896 +0000
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/test/regress/results/trigg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-12-23 16:01:18.211816713 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/triggers.out 2024-12-23 16:03:10.826744985 +0000
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-12-23 16:01:21.352510597 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2024-12-23 16:03:03.094414623...
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-12-23 16:01:21.352510597 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2024-12-23 16:03:42.6346182...
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-12-23 16:01:21.352510597 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/triggers.out 2024-12-23 16:02:59.818463749 +0000
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/triggers.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/triggers.out 2024-12-23 16:01:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2024-12-23 16:02:35
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/triggers.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/triggers.out 2024-12-23 16:01:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2024-12-23 16:03:23
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/triggers.out /Users/admin/pgsql/build/testrun/regress/regress/resu...
--- /Users/admin/pgsql/src/test/regress/expected/triggers.out 2024-12-23 16:01:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/triggers.out 2024-12-23 16:02:35
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/triggers.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/triggers.out 2024-12-23 16:01:24.022784600 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2024-12-23 16:03:55.300303300 +0000
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/triggers.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/triggers.out 2024-12-23 16:01:24.022784600 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2024-12-23 16:06:28.196356800 +0000
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/triggers.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/triggers.out 2024-12-23 16:01:24.022784600 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/triggers.out 2024-12-23 16:03:44.273877800 +0000
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
| 51/5160 |
Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/reindex_concurrently_upsert.out /tmp/cirrus-ci-...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/reindex_concurrently_upsert.out 2024-12-23 01:16:08....
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/reindex_concurrently_upsert.out 2024-12-23 01:...
@@ -141,7 +141,6 @@
(1 row)
-step s2_start_upsert: <... completed>
step s4_wakeup_to_set_dead:
SELECT injection_points_detach('reindex_relation_concurrently_before_set_dead');
SELECT injection_points_wakeup('reindex_relation_concurrently_before_set_dead');
@@ -157,6 +156,7 @@
(1 row)
step s3_start_reindex: <... completed>
+step s2_start_upsert: <... completed>
starting permutation: s3_start_reindex s4_wakeup_to_swap s1_start_upsert s2_start_upsert s4_wakeup_s1 s4_wakeup_to_set_...
injection_points_attach |
| 51/4929 |
apply_scanjoin_target_to_paths and partitionwise join |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-12-20 21:15:02.048046000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_join.out 2024-12-20 21:17:50.540...
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/build/testrun/recovery/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-12-20 21:15:02.048046000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/partition_join.out 2024-12-20 21:18:33.3...
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/build/testrun/regress/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-12-20 21:15:02.048046000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/partition_join.out 2024-12-20 21:17:44.184359000 +0000
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_c...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-12-20 21:15:02.000656960 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/partition_join.out 2024-12-20 21:22:33.135367041 +0000
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/src/test/regress/results...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-12-20 21:15:02.000656960 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/partition_join.out 2024-12-20 21:21:06.765486578 +0000
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-12-20 21:15:02.387603164 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_join.out 2024-12-20 21:20:51.053...
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/build/testrun/recovery/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-12-20 21:15:02.387603164 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/partition_join.out 2024-12-20 21:21:28.9...
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/build/testrun/regress/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-12-20 21:15:02.387603164 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/partition_join.out 2024-12-20 21:20:47.009004724 +0000
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/partition_join.out /Users/admin/pgsql/build/testrun/pg_upgrade/002...
--- /Users/admin/pgsql/src/test/regress/expected/partition_join.out 2024-12-20 21:14:11
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_join.out 2024-12-20 21:17:08
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/partition_join.out /Users/admin/pgsql/build/testrun/recovery/027_s...
--- /Users/admin/pgsql/src/test/regress/expected/partition_join.out 2024-12-20 21:14:11
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/partition_join.out 2024-12-20 21:17:55
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/partition_join.out /Users/admin/pgsql/build/testrun/regress/regres...
--- /Users/admin/pgsql/src/test/regress/expected/partition_join.out 2024-12-20 21:14:11
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/partition_join.out 2024-12-20 21:17:10
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |