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.
| 53/5319 |
Changing shared_buffers without restart |
 |
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/numa.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/numa.out 2025-07-04 01:07:02.888514337 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/numa.out 2025-07-04 01:14:05.852640488 +0000
@@ -6,8 +6,4 @@
-- switch to superuser
\c -
SELECT COUNT(*) >= 0 AS ok FROM pg_shmem_allocations_numa;
- ok
-----
- t
-(1 row)
-
+ERROR: invalid memory alloc request size 864765899839712 |
| 55/5892 |
parallel safety of correlated subquery (was: parallel_safe) |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/btree_gist/expected/without_overlaps.out /tmp/cirrus-ci-build/build/testrun/btree_...
--- /tmp/cirrus-ci-build/contrib/btree_gist/expected/without_overlaps.out 2025-07-04 00:30:37.295402035 +0000
+++ /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/without_overlaps.out 2025-07-04 00:36:46.378786753 +00...
@@ -9,84 +9,7 @@
CONSTRAINT temporal_rng_pk PRIMARY KEY (id, valid_at WITHOUT OVERLAPS)
);
\d temporal_rng
- Table "public.temporal_rng"
- Column | Type | Collation | Nullable | Default
-----------+-----------+-----------+----------+---------
- id | integer | | not null |
- valid_at | daterange | | not null |
-Indexes:
- "temporal_rng_pk" PRIMARY KEY (id, valid_at WITHOUT OVERLAPS)
-
-SELECT pg_get_constraintdef(oid) FROM pg_constraint WHERE conname = 'temporal_rng_pk';
- pg_get_constraintdef
----------------------------------------------
- PRIMARY KEY (id, valid_at WITHOUT OVERLAPS)
-(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/earthdistance/expected/earthdistance.out /tmp/cirrus-ci-build/build/testrun/earthd...
--- /tmp/cirrus-ci-build/contrib/earthdistance/expected/earthdistance.out 2025-07-04 00:30:37.315402035 +0000
+++ /tmp/cirrus-ci-build/build/testrun/earthdistance/regress/results/earthdistance.out 2025-07-04 00:36:47.218786347 +00...
@@ -1053,46 +1053,7 @@
drop extension cube cascade;
NOTICE: drop cascades to column f1 of table foo
\d foo
- Table "public.foo"
- Column | Type | Collation | Nullable | Default
---------+---------+-----------+----------+---------
- f2 | integer | | |
-
--- list what's installed
-\dT public.*
- List of data types
- Schema | Name | Description
---------+------+-------------
-(0 rows)
-
-\df public.*
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/bit.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/bit.out 2025-07-04 00:30:39.235402076 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/bit.out 2025-07-04 00:35:33.362827794 +000...
@@ -772,79 +772,7 @@
b4 bit varying(5) DEFAULT B'0101'
);
\d bit_defaults
- Table "public.bit_defaults"
- Column | Type | Collation | Nullable | Default
---------+----------------+-----------+----------+---------------------
- b1 | bit(4) | | | '1001'::"bit"
- b2 | bit(4) | | | '0101'::"bit"
- b3 | bit varying(5) | | | '1001'::bit varying
- b4 | bit varying(5) | | | '0101'::"bit"
-
-INSERT INTO bit_defaults DEFAULT VALUES;
-TABLE bit_defaults;
- b1 | b2 | b3 | b4
-------+------+------+------
- 1001 | 0101 | 1001 | 0101
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-07-04 00:30:37.403402037 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2025-07-04 00:36:59.730780412 +0000
@@ -409,12184 +409,7 @@
-- subquery
SELECT * FROM ft1 t1 WHERE t1.c3 IN (SELECT c3 FROM ft2 t2 WHERE c1 <= 10) ORDER BY c1;
- c1 | c2 | c3 | c4 | c5 | c6 | c7 | c8
-----+----+-------+------------------------------+--------------------------+----+------------+-----
- 1 | 1 | 00001 | Fri Jan 02 00:00:00 1970 PST | Fri Jan 02 00:00:00 1970 | 1 | 1 | foo
- 2 | 2 | 00002 | Sat Jan 03 00:00:00 1970 PST | Sat Jan 03 00:00:00 1970 | 2 | 2 | foo
- 3 | 3 | 00003 | Sun Jan 04 00:00:00 1970 PST | Sun Jan 04 00:00:00 1970 | 3 | 3 | foo
- 4 | 4 | 00004 | Mon Jan 05 00:00:00 1970 PST | Mon Jan 05 00:00:00 1970 | 4 | 4 | foo
- 5 | 5 | 00005 | Tue Jan 06 00:00:00 1970 PST | Tue Jan 06 00:00:00 1970 | 5 | 5 | foo
- 6 | 6 | 00006 | Wed Jan 07 00:00:00 1970 PST | Wed Jan 07 00:00:00 1970 | 6 | 6 | foo
- 7 | 7 | 00007 | Thu Jan 08 00:00:00 1970 PST | Thu Jan 08 00:00:00 1970 | 7 | 7 | foo
- 8 | 8 | 00008 | Fri Jan 09 00:00:00 1970 PST | Fri Jan 09 00:00:00 1970 | 8 | 8 | foo
- 9 | 9 | 00009 | Sat Jan 10 00:00:00 1970 PST | Sat Jan 10 00:00:00 1970 | 9 | 9 | foo
- 10 | 0 | 00010 | Sun Jan 11 00:00:00 1970 PST | Sun Jan 11 00:00:00 1970 | 0 | 0 | foo
-(10 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/bit.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/bit.out 2025-07-04 00:30:39.235402076 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/bit.out 2025-07-04 00:36:13.450803595 +0...
@@ -772,79 +772,7 @@
b4 bit varying(5) DEFAULT B'0101'
);
\d bit_defaults
- Table "public.bit_defaults"
- Column | Type | Collation | Nullable | Default
---------+----------------+-----------+----------+---------------------
- b1 | bit(4) | | | '1001'::"bit"
- b2 | bit(4) | | | '0101'::"bit"
- b3 | bit varying(5) | | | '1001'::bit varying
- b4 | bit varying(5) | | | '0101'::"bit"
-
-INSERT INTO bit_defaults DEFAULT VALUES;
-TABLE bit_defaults;
- b1 | b2 | b3 | b4
-------+------+------+------
- 1001 | 0101 | 1001 | 0101
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/bit.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/bit.out 2025-07-04 00:30:39.235402076 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/bit.out 2025-07-04 00:35:31.026829387 +0000
@@ -772,79 +772,7 @@
b4 bit varying(5) DEFAULT B'0101'
);
\d bit_defaults
- Table "public.bit_defaults"
- Column | Type | Collation | Nullable | Default
---------+----------------+-----------+----------+---------------------
- b1 | bit(4) | | | '1001'::"bit"
- b2 | bit(4) | | | '0101'::"bit"
- b3 | bit varying(5) | | | '1001'::bit varying
- b4 | bit varying(5) | | | '0101'::"bit"
-
-INSERT INTO bit_defaults DEFAULT VALUES;
-TABLE bit_defaults;
- b1 | b2 | b3 | b4
-------+------+------+------
- 1001 | 0101 | 1001 | 0101
... |
| 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 2025-07-04 00:30:37.411402037 +0000
+++ /tmp/cirrus-ci-build/build/testrun/seg/regress/results/partition.out 2025-07-04 00:37:00.066780255 +0000
@@ -24,31 +24,7 @@
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
-----------+---------+-----------+----------+---------+----------+--------------+-------------
- category | integer | | | | plain | |
- sdata | seg | | | | plain | |
- tdata | text | | | | extended | |
-Partition key: LIST (category)
-Indexes:
- "pti1" btree ((mydouble(category) + 1))
- "pti2" btree (sdata)
- "pti3" btree (tdata COLLATE mycollation)
-Partitions: pt12 FOR VALUES IN (1, 2),
- pt34 FOR VALUES IN (3, 4)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/test_decoding/expected/ddl.out /tmp/cirrus-ci-build/build/testrun/test_decoding/re...
--- /tmp/cirrus-ci-build/contrib/test_decoding/expected/ddl.out 2025-07-04 00:30:37.431402038 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_decoding/regress/results/ddl.out 2025-07-04 00:37:04.378778255 +0000
@@ -484,374 +484,7 @@
WITH (user_catalog_table = true)
;
\d+ replication_metadata
- Table "public.replication_metadata"
- Column | Type | Collation | Nullable | Default | Storage | Stats target...
-----------+---------+-----------+----------+--------------------------------------------------+----------+-------------...
- id | integer | | not null | nextval('replication_metadata_id_seq'::regclass) | plain | ...
- relation | name | | not null | | plain | ...
- options | text[] | | | | extended | ...
-Indexes:
- "replication_metadata_pkey" PRIMARY KEY, btree (id)
-Not-null constraints:
- "replication_metadata_id_not_null" NOT NULL "id"
- "replication_metadata_relation_not_null" NOT NULL "relation"
-Options: user_catalog_table=true
-
... |
| 53/5270 |
jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/jsonpath.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/jsonpath.out 2025-07-03 22:03:19.110388600 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonpath.out 2025-07-03 22:07:19.554838200 +0000
@@ -436,998 +436,7 @@
(1 row)
select '$.replace("hello","bye")'::jsonpath;
- jsonpath
---------------------------
- $.replace("hello","bye")
-(1 row)
-
-select '$.lower()'::jsonpath;
- jsonpath
------------
- $.lower()
-(1 row)
-
-select '$.upper()'::jsonpath;
- jsonpath
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/jsonpath.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/jsonpath.out 2025-07-03 22:03:19.110388600 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/jsonpath.out 2025-07-03 22:09:46.863474500 +0000
@@ -436,998 +436,7 @@
(1 row)
select '$.replace("hello","bye")'::jsonpath;
- jsonpath
---------------------------
- $.replace("hello","bye")
-(1 row)
-
-select '$.lower()'::jsonpath;
- jsonpath
------------
- $.lower()
-(1 row)
-
-select '$.upper()'::jsonpath;
- jsonpath
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/jsonpath.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/jsonpath.out 2025-07-03 22:03:19.110388600 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/jsonpath.out 2025-07-03 22:07:19.427886300 +0000
@@ -436,998 +436,7 @@
(1 row)
select '$.replace("hello","bye")'::jsonpath;
- jsonpath
---------------------------
- $.replace("hello","bye")
-(1 row)
-
-select '$.lower()'::jsonpath;
- jsonpath
------------
- $.lower()
-(1 row)
-
-select '$.upper()'::jsonpath;
- jsonpath
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/jsonpath.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/jsonpath.out 2025-07-03 22:02:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonpath.out 2025-07-03 22:05:44
@@ -436,998 +436,7 @@
(1 row)
select '$.replace("hello","bye")'::jsonpath;
- jsonpath
---------------------------
- $.replace("hello","bye")
-(1 row)
-
-select '$.lower()'::jsonpath;
- jsonpath
------------
- $.lower()
-(1 row)
-
-select '$.upper()'::jsonpath;
- jsonpath
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/jsonpath.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/jsonpath.out 2025-07-03 22:02:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/jsonpath.out 2025-07-03 22:08:14
@@ -436,998 +436,7 @@
(1 row)
select '$.replace("hello","bye")'::jsonpath;
- jsonpath
---------------------------
- $.replace("hello","bye")
-(1 row)
-
-select '$.lower()'::jsonpath;
- jsonpath
------------
- $.lower()
-(1 row)
-
-select '$.upper()'::jsonpath;
- jsonpath
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/jsonpath.out /Users/admin/pgsql/build/testrun/regress/regress/resu...
--- /Users/admin/pgsql/src/test/regress/expected/jsonpath.out 2025-07-03 22:02:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/jsonpath.out 2025-07-03 22:05:44
@@ -436,998 +436,7 @@
(1 row)
select '$.replace("hello","bye")'::jsonpath;
- jsonpath
---------------------------
- $.replace("hello","bye")
-(1 row)
-
-select '$.lower()'::jsonpath;
- jsonpath
------------
- $.lower()
-(1 row)
-
-select '$.upper()'::jsonpath;
- jsonpath
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonpath.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonpath.out 2025-07-03 22:03:16.265134655 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonpath.out 2025-07-03 22:05:46.125954600...
@@ -436,998 +436,7 @@
(1 row)
select '$.replace("hello","bye")'::jsonpath;
- jsonpath
---------------------------
- $.replace("hello","bye")
-(1 row)
-
-select '$.lower()'::jsonpath;
- jsonpath
------------
- $.lower()
-(1 row)
-
-select '$.upper()'::jsonpath;
- jsonpath
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/json.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/json.out 2025-07-03 22:03:16.261148456 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/json.out 2025-07-03 22:06:55.862059252 +...
@@ -1750,1019 +1750,7 @@
(1 row)
SELECT jsb FROM json_populate_record(NULL::jsrec, '{"jsb": null}') q;
- jsb
------
-
-(1 row)
-
-SELECT jsb FROM json_populate_record(NULL::jsrec, '{"jsb": true}') q;
- jsb
-------
- true
-(1 row)
-
-SELECT jsb FROM json_populate_record(NULL::jsrec, '{"jsb": 123.45}') q;
- jsb
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonpath.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonpath.out 2025-07-03 22:03:16.265134655 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/jsonpath.out 2025-07-03 22:05:42.773944238 +0000
@@ -436,998 +436,7 @@
(1 row)
select '$.replace("hello","bye")'::jsonpath;
- jsonpath
---------------------------
- $.replace("hello","bye")
-(1 row)
-
-select '$.lower()'::jsonpath;
- jsonpath
------------
- $.lower()
-(1 row)
-
-select '$.upper()'::jsonpath;
- jsonpath
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/json.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_up...
--- /tmp/cirrus-ci-build/src/test/regress/expected/json.out 2025-07-03 22:03:16.118694000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/json.out 2025-07-03 22:06:25.200278000 +00...
@@ -1099,1670 +1099,10 @@
(1 row)
select '{"f2":{"f3":1},"f4":{"f5":99,"f6":"stringy"}}'::json#>array['f2'];
- ?column?
-----------
- {"f3":1}
-(1 row)
-
-select '{"f2":["f3",1],"f4":{"f5":99,"f6":"stringy"}}'::json#>array['f2','0'];
- ?column?
-----------
- "f3"
-(1 row)
-
-select '{"f2":["f3",1],"f4":{"f5":99,"f6":"stringy"}}'::json#>array['f2','1'];
- ?column?
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/json.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/json.out 2025-07-03 22:03:16.118694000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/json.out 2025-07-03 22:07:27.668542000 +...
@@ -1037,1732 +1037,10 @@
(1 row)
select json_extract_path('{"f2":["f3",1],"f4":{"f5":99,"f6":"stringy"}}','f2',1::text);
- json_extract_path
--------------------
- 1
-(1 row)
-
-select json_extract_path_text('{"f2":{"f3":1},"f4":{"f5":99,"f6":"stringy"}}','f4','f6');
- json_extract_path_text
-------------------------
- stringy
-(1 row)
-
-select json_extract_path_text('{"f2":{"f3":1},"f4":{"f5":99,"f6":"stringy"}}','f2');
- json_extract_path_text
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/json.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/json.out 2025-07-03 22:03:16.118694000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/json.out 2025-07-03 22:06:23.336062000 +0000
@@ -897,1872 +897,10 @@
(1 row)
select '{"a": [{"b": "c"}, {"b": "cc"}]}'::json ->> null::text;
- ?column?
-----------
-
-(1 row)
-
-select '{"a": [{"b": "c"}, {"b": "cc"}]}'::json ->> null::int;
- ?column?
-----------
-
-(1 row)
-
-select '{"a": [{"b": "c"}, {"b": "cc"}]}'::json ->> 1;
- ?column?
... |
|
Linux - Debian Bookworm - Autoconf |
| 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 2025-07-03 22:03:16.119483585 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/jsonb.out 2025-07-03 22:09:54.586974291 +0000
@@ -5420,414 +5420,10 @@
id text,
test_json jsonb
);
-insert into test_jsonb_subscript values('foo', '{"foo": "bar"}');
-insert into test_jsonb_subscript
- select s, ('{"' || s || '": "bar"}')::jsonb from repeat('xyzzy', 500) s;
-select length(id), test_json[id] from test_jsonb_subscript;
- length | test_json
---------+-----------
- 3 | "bar"
- 2500 | "bar"
-(2 rows)
-
-update test_jsonb_subscript set test_json[id] = '"baz"';
-select length(id), test_json[id] from test_jsonb_subscript;
- length | test_json
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/json.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/result...
--- /tmp/cirrus-ci-build/src/test/regress/expected/json.out 2025-07-03 22:03:16.115483585 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/json.out 2025-07-03 22:11:07.522941413 +0000
@@ -1863,906 +1863,10 @@
-- anonymous record type
SELECT json_populate_record(null::record, '{"x": 0, "y": 1}');
-ERROR: could not determine row type for result of json_populate_record
-HINT: Provide a non-null record argument, or call the function in the FROM clause using a column definition list.
-SELECT json_populate_record(row(1,2), '{"f1": 0, "f2": 1}');
- json_populate_record
-----------------------
- (0,1)
-(1 row)
-
-SELECT * FROM
- json_populate_record(null::record, '{"x": 776}') AS (x int, y int);
- x | y
------+---
- 776 |
... |
| 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 2025-07-03 22:03:16.119483585 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/jsonb.out 2025-07-03 22:06:47.675103554 +0000
@@ -5420,414 +5420,10 @@
id text,
test_json jsonb
);
-insert into test_jsonb_subscript values('foo', '{"foo": "bar"}');
-insert into test_jsonb_subscript
- select s, ('{"' || s || '": "bar"}')::jsonb from repeat('xyzzy', 500) s;
-select length(id), test_json[id] from test_jsonb_subscript;
- length | test_json
---------+-----------
- 3 | "bar"
- 2500 | "bar"
-(2 rows)
-
-update test_jsonb_subscript set test_json[id] = '"baz"';
-select length(id), test_json[id] from test_jsonb_subscript;
- length | test_json
... |
| 53/5382 |
Adding compression of temporary files |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join_hash_pglz.out /tmp/cirrus-ci-build/build/testrun/recovery/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/join_hash_pglz.out 2025-07-03 21:51:16.012036759 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/join_hash_pglz.out 2025-07-03 21:55:27.6...
@@ -262,11 +262,9 @@
$$
select count(*) from simple r join simple s using (id);
$$);
- initially_multibatch | increased_batches
-----------------------+-------------------
- t | f
-(1 row)
-
+ERROR: could not read from temporary file: read only 8176 of 15109 bytes
+CONTEXT: parallel worker
+PL/pgSQL function hash_join_batches(text) line 6 at FOR over EXECUTE statement
rollback to settings;
-- parallel with parallel-aware hash join
savepoint settings; |
| 53/4681 |
Make COPY format extendable: Extract COPY TO format implementations |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_copy_format/expected/test_copy_format.out /tmp/cirrus-ci-build/build...
--- /tmp/cirrus-ci-build/src/test/modules/test_copy_format/expected/test_copy_format.out 2025-07-03 20:06:45.342787000 +...
+++ /tmp/cirrus-ci-build/build/testrun/test_copy_format-running/regress/results/test_copy_format.out 2025-07-03 20:14:25...
@@ -1,19 +1,13 @@
CREATE TABLE copy_data (a smallint, b integer, c bigint);
INSERT INTO copy_data VALUES (1, 2, 3), (12, 34, 56), (123, 456, 789);
COPY copy_data FROM stdin WITH (FORMAT 'test_copy_format');
-NOTICE: CopyFromInFunc: attribute: smallint
-NOTICE: CopyFromInFunc: attribute: integer
-NOTICE: CopyFromInFunc: attribute: bigint
-NOTICE: CopyFromStart: the number of attributes: 3
-NOTICE: CopyFromOneRow
-NOTICE: CopyFromEnd
+ERROR: COPY format "test_copy_format" not recognized
+LINE 1: COPY copy_data FROM stdin WITH (FORMAT 'test_copy_format');
+ ^
+\.
+invalid command \.
COPY copy_data TO stdout WITH (FORMAT 'test_copy_format');
-NOTICE: CopyToOutFunc: attribute: smallint
... |
| 53/5681 |
Prevent internal error at concurrent CREATE OR REPLACE / ALTER FUNCTION |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/injection_points/expected/syscache-update-pruned.out C:/cirrus/b...
--- C:/cirrus/src/test/modules/injection_points/expected/syscache-update-pruned.out 2025-07-03 14:37:41.314435300 +0000
+++ C:/cirrus/build/testrun/injection_points/isolation/results/syscache-update-pruned.out 2025-07-03 14:45:56.857127200 ...
@@ -46,7 +46,7 @@
SELECT FROM injection_points_wakeup('heap_update-before-pin');
<waiting ...>
step grant1: <... completed>
-ERROR: duplicate key value violates unique constraint "pg_class_oid_index"
+ERROR: could not create object because a conflicting object already exists
step wakegrant4: <... completed>
starting permutation: snap3 cachefill1 at2 mkrels4 r3 waitprunable4 vac4 grant1 wakeinval4 at4 wakegrant4 inspect4 |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/test_decoding/expected/replorigin.out C:/cirrus/build/testrun/test_decodi...
--- C:/cirrus/contrib/test_decoding/expected/replorigin.out 2025-07-03 14:37:37.825883300 +0000
+++ C:/cirrus/build/testrun/test_decoding/regress/results/replorigin.out 2025-07-03 14:45:53.857458600 +0000
@@ -39,8 +39,9 @@
-- ensure duplicate creations fail
SELECT pg_replication_origin_create('regress_test_decoding: regression_slot');
-ERROR: duplicate key value violates unique constraint "pg_replication_origin_roname_index"
-DETAIL: Key (roname)=(regress_test_decoding: regression_slot) already exists.
+ERROR: could not create object because a conflicting object already exists
+DETAIL: Key (roname)=(regress_test_decoding: regression_slot) conflicts with existing entry in unique index pg_replica...
+HINT: Another session might have created an object with the same key concurrently.
--ensure deletions work (once)
SELECT pg_replication_origin_create('regress_test_decoding: temp');
pg_replication_origin_create |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/modules/injection_points/expected/syscache-update-pruned.out /Users/admin/pgsql/bui...
--- /Users/admin/pgsql/src/test/modules/injection_points/expected/syscache-update-pruned.out 2025-07-03 14:35:13
+++ /Users/admin/pgsql/build/testrun/injection_points/isolation/results/syscache-update-pruned.out 2025-07-03 14:38:53
@@ -46,7 +46,7 @@
SELECT FROM injection_points_wakeup('heap_update-before-pin');
<waiting ...>
step grant1: <... completed>
-ERROR: duplicate key value violates unique constraint "pg_class_oid_index"
+ERROR: could not create object because a conflicting object already exists
step wakegrant4: <... completed>
starting permutation: snap3 cachefill1 at2 mkrels4 r3 waitprunable4 vac4 grant1 wakeinval4 at4 wakegrant4 inspect4 |
| regress |
diff -U3 /Users/admin/pgsql/contrib/test_decoding/expected/replorigin.out /Users/admin/pgsql/build/testrun/test_decoding...
--- /Users/admin/pgsql/contrib/test_decoding/expected/replorigin.out 2025-07-03 14:35:11
+++ /Users/admin/pgsql/build/testrun/test_decoding/regress/results/replorigin.out 2025-07-03 14:38:51
@@ -39,8 +39,9 @@
-- ensure duplicate creations fail
SELECT pg_replication_origin_create('regress_test_decoding: regression_slot');
-ERROR: duplicate key value violates unique constraint "pg_replication_origin_roname_index"
-DETAIL: Key (roname)=(regress_test_decoding: regression_slot) already exists.
+ERROR: could not create object because a conflicting object already exists
+DETAIL: Key (roname)=(regress_test_decoding: regression_slot) conflicts with existing entry in unique index pg_replica...
+HINT: Another session might have created an object with the same key concurrently.
--ensure deletions work (once)
SELECT pg_replication_origin_create('regress_test_decoding: temp');
pg_replication_origin_create |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/syscache-update-pruned.out /tmp/cirrus-ci-build...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/syscache-update-pruned.out 2025-07-03 14:37:38.32189...
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/syscache-update-pruned.out 2025-07-03 14:43:51...
@@ -46,7 +46,7 @@
SELECT FROM injection_points_wakeup('heap_update-before-pin');
<waiting ...>
step grant1: <... completed>
-ERROR: duplicate key value violates unique constraint "pg_class_oid_index"
+ERROR: could not create object because a conflicting object already exists
step wakegrant4: <... completed>
starting permutation: snap3 cachefill1 at2 mkrels4 r3 waitprunable4 vac4 grant1 wakeinval4 at4 wakegrant4 inspect4 |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/test_decoding/expected/replorigin.out /tmp/cirrus-ci-build/build/testrun/test_deco...
--- /tmp/cirrus-ci-build/contrib/test_decoding/expected/replorigin.out 2025-07-03 14:37:36.567757611 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_decoding/regress/results/replorigin.out 2025-07-03 14:43:44.750191398 +0000
@@ -39,8 +39,9 @@
-- ensure duplicate creations fail
SELECT pg_replication_origin_create('regress_test_decoding: regression_slot');
-ERROR: duplicate key value violates unique constraint "pg_replication_origin_roname_index"
-DETAIL: Key (roname)=(regress_test_decoding: regression_slot) already exists.
+ERROR: could not create object because a conflicting object already exists
+DETAIL: Key (roname)=(regress_test_decoding: regression_slot) conflicts with existing entry in unique index pg_replica...
+HINT: Another session might have created an object with the same key concurrently.
--ensure deletions work (once)
SELECT pg_replication_origin_create('regress_test_decoding: temp');
pg_replication_origin_create |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/test_decoding/expected/replorigin.out /tmp/cirrus-ci-build/contrib/test_decoding/r...
--- /tmp/cirrus-ci-build/contrib/test_decoding/expected/replorigin.out 2025-07-03 14:37:30.877360902 +0000
+++ /tmp/cirrus-ci-build/contrib/test_decoding/results/replorigin.out 2025-07-03 14:43:38.100879374 +0000
@@ -39,8 +39,9 @@
-- ensure duplicate creations fail
SELECT pg_replication_origin_create('regress_test_decoding: regression_slot');
-ERROR: duplicate key value violates unique constraint "pg_replication_origin_roname_index"
-DETAIL: Key (roname)=(regress_test_decoding: regression_slot) already exists.
+ERROR: could not create object because a conflicting object already exists
+DETAIL: Key (roname)=(regress_test_decoding: regression_slot) conflicts with existing entry in unique index pg_replica...
+HINT: Another session might have created an object with the same key concurrently.
--ensure deletions work (once)
SELECT pg_replication_origin_create('regress_test_decoding: temp');
pg_replication_origin_create |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out 2025-07-03 14:37:32.757360829 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/plpgsql.out 2025-07-03 14:45:03.680873779 +0000
@@ -3549,2308 +3549,7 @@
end loop;
end;
$$ language plpgsql;
-select forc01();
-NOTICE: 1, 1
-NOTICE: 2, 2
-NOTICE: 3, 3
-NOTICE: 4, 4
-NOTICE: 5, 5
-NOTICE: 6, 6
-NOTICE: 7, 7
-NOTICE: 8, 8
-NOTICE: 9, 9
-NOTICE: 10, 10
- forc01
---------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/syscache-update-pruned.out /tmp/cirrus-ci-build...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/syscache-update-pruned.out 2025-07-03 14:37:32.59336...
+++ /tmp/cirrus-ci-build/src/test/modules/injection_points/output_iso/results/syscache-update-pruned.out 2025-07-03 14:4...
@@ -46,7 +46,7 @@
SELECT FROM injection_points_wakeup('heap_update-before-pin');
<waiting ...>
step grant1: <... completed>
-ERROR: duplicate key value violates unique constraint "pg_class_oid_index"
+ERROR: could not create object because a conflicting object already exists
step wakegrant4: <... completed>
starting permutation: snap3 cachefill1 at2 mkrels4 r3 waitprunable4 vac4 grant1 wakeinval4 at4 wakegrant4 inspect4 |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out 2025-07-03 14:37:32.757360829 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/plpgsql.out 2025-07-03 14:47:00.224861354 +0000
@@ -3549,2308 +3549,7 @@
end loop;
end;
$$ language plpgsql;
-select forc01();
-NOTICE: 1, 1
-NOTICE: 2, 2
-NOTICE: 3, 3
-NOTICE: 4, 4
-NOTICE: 5, 5
-NOTICE: 6, 6
-NOTICE: 7, 7
-NOTICE: 8, 8
-NOTICE: 9, 9
-NOTICE: 10, 10
- forc01
---------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out /tmp/cirrus-ci-build/src/test/regress/results/plpgsq...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out 2025-07-03 14:37:32.757360829 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/plpgsql.out 2025-07-03 14:42:33.032885219 +0000
@@ -3549,2308 +3549,7 @@
end loop;
end;
$$ language plpgsql;
-select forc01();
-NOTICE: 1, 1
-NOTICE: 2, 2
-NOTICE: 3, 3
-NOTICE: 4, 4
-NOTICE: 5, 5
-NOTICE: 6, 6
-NOTICE: 7, 7
-NOTICE: 8, 8
-NOTICE: 9, 9
-NOTICE: 10, 10
- forc01
---------
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/syscache-update-pruned.out /tmp/cirrus-ci-build...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/syscache-update-pruned.out 2025-07-03 14:37:41.22888...
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/syscache-update-pruned.out 2025-07-03 14:41:23...
@@ -46,7 +46,7 @@
SELECT FROM injection_points_wakeup('heap_update-before-pin');
<waiting ...>
step grant1: <... completed>
-ERROR: duplicate key value violates unique constraint "pg_class_oid_index"
+ERROR: could not create object because a conflicting object already exists
step wakegrant4: <... completed>
starting permutation: snap3 cachefill1 at2 mkrels4 r3 waitprunable4 vac4 grant1 wakeinval4 at4 wakegrant4 inspect4 |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/test_decoding/expected/replorigin.out /tmp/cirrus-ci-build/build/testrun/test_deco...
--- /tmp/cirrus-ci-build/contrib/test_decoding/expected/replorigin.out 2025-07-03 14:37:39.861802000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_decoding/regress/results/replorigin.out 2025-07-03 14:41:16.062231000 +0000
@@ -39,8 +39,9 @@
-- ensure duplicate creations fail
SELECT pg_replication_origin_create('regress_test_decoding: regression_slot');
-ERROR: duplicate key value violates unique constraint "pg_replication_origin_roname_index"
-DETAIL: Key (roname)=(regress_test_decoding: regression_slot) already exists.
+ERROR: could not create object because a conflicting object already exists
+DETAIL: Key (roname)=(regress_test_decoding: regression_slot) conflicts with existing entry in unique index pg_replica...
+HINT: Another session might have created an object with the same key concurrently.
--ensure deletions work (once)
SELECT pg_replication_origin_create('regress_test_decoding: temp');
pg_replication_origin_create |
| 53/5708 |
don't generate fake alias names, only fake eref names |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/memoize.out C:/cirrus/build/testrun/pg_upgrade/002_pg_u...
--- C:/cirrus/src/test/regress/expected/memoize.out 2025-07-03 08:31:20.157700500 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/memoize.out 2025-07-03 08:35:23.436787500 +0000
@@ -545,15 +545,15 @@
SELECT * FROM tab_anti t1 WHERE t1.a IN
(SELECT a FROM tab_anti t2 WHERE t2.b IN
(SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0));
- QUERY PLAN
--------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------
Nested Loop Semi Join
-> Seq Scan on tab_anti t1
-> Nested Loop Semi Join
Join Filter: (t1.a = t2.a)
-> Seq Scan on tab_anti t2
- -> Subquery Scan on "ANY_subquery"
- Filter: (t2.b = "ANY_subquery".b)
+ -> Subquery Scan on unnamed_subquery
+ Filter: (t2.b = unnamed_subquery.b)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/memoize.out C:/cirrus/build/testrun/recovery/027_stream...
--- C:/cirrus/src/test/regress/expected/memoize.out 2025-07-03 08:31:20.157700500 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/memoize.out 2025-07-03 08:38:09.532181900 +0000
@@ -545,15 +545,15 @@
SELECT * FROM tab_anti t1 WHERE t1.a IN
(SELECT a FROM tab_anti t2 WHERE t2.b IN
(SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0));
- QUERY PLAN
--------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------
Nested Loop Semi Join
-> Seq Scan on tab_anti t1
-> Nested Loop Semi Join
Join Filter: (t1.a = t2.a)
-> Seq Scan on tab_anti t2
- -> Subquery Scan on "ANY_subquery"
- Filter: (t2.b = "ANY_subquery".b)
+ -> Subquery Scan on unnamed_subquery
+ Filter: (t2.b = unnamed_subquery.b)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/memoize.out C:/cirrus/build/testrun/regress/regress/res...
--- C:/cirrus/src/test/regress/expected/memoize.out 2025-07-03 08:31:20.157700500 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/memoize.out 2025-07-03 08:35:18.385992500 +0000
@@ -545,15 +545,15 @@
SELECT * FROM tab_anti t1 WHERE t1.a IN
(SELECT a FROM tab_anti t2 WHERE t2.b IN
(SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0));
- QUERY PLAN
--------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------
Nested Loop Semi Join
-> Seq Scan on tab_anti t1
-> Nested Loop Semi Join
Join Filter: (t1.a = t2.a)
-> Seq Scan on tab_anti t2
- -> Subquery Scan on "ANY_subquery"
- Filter: (t2.b = "ANY_subquery".b)
+ -> Subquery Scan on unnamed_subquery
+ Filter: (t2.b = unnamed_subquery.b)
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/memoize.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upg...
--- /Users/admin/pgsql/src/test/regress/expected/memoize.out 2025-07-03 08:31:15
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/memoize.out 2025-07-03 08:34:30
@@ -545,15 +545,15 @@
SELECT * FROM tab_anti t1 WHERE t1.a IN
(SELECT a FROM tab_anti t2 WHERE t2.b IN
(SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0));
- QUERY PLAN
--------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------
Nested Loop Semi Join
-> Seq Scan on tab_anti t1
-> Nested Loop Semi Join
Join Filter: (t1.a = t2.a)
-> Seq Scan on tab_anti t2
- -> Subquery Scan on "ANY_subquery"
- Filter: (t2.b = "ANY_subquery".b)
+ -> Subquery Scan on unnamed_subquery
+ Filter: (t2.b = unnamed_subquery.b)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/memoize.out /Users/admin/pgsql/build/testrun/recovery/027_stream_r...
--- /Users/admin/pgsql/src/test/regress/expected/memoize.out 2025-07-03 08:31:15
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/memoize.out 2025-07-03 08:36:44
@@ -545,15 +545,15 @@
SELECT * FROM tab_anti t1 WHERE t1.a IN
(SELECT a FROM tab_anti t2 WHERE t2.b IN
(SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0));
- QUERY PLAN
--------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------
Nested Loop Semi Join
-> Seq Scan on tab_anti t1
-> Nested Loop Semi Join
Join Filter: (t1.a = t2.a)
-> Seq Scan on tab_anti t2
- -> Subquery Scan on "ANY_subquery"
- Filter: (t2.b = "ANY_subquery".b)
+ -> Subquery Scan on unnamed_subquery
+ Filter: (t2.b = unnamed_subquery.b)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/memoize.out /Users/admin/pgsql/build/testrun/regress/regress/resul...
--- /Users/admin/pgsql/src/test/regress/expected/memoize.out 2025-07-03 08:31:15
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/memoize.out 2025-07-03 08:34:37
@@ -545,15 +545,15 @@
SELECT * FROM tab_anti t1 WHERE t1.a IN
(SELECT a FROM tab_anti t2 WHERE t2.b IN
(SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0));
- QUERY PLAN
--------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------
Nested Loop Semi Join
-> Seq Scan on tab_anti t1
-> Nested Loop Semi Join
Join Filter: (t1.a = t2.a)
-> Seq Scan on tab_anti t2
- -> Subquery Scan on "ANY_subquery"
- Filter: (t2.b = "ANY_subquery".b)
+ -> Subquery Scan on unnamed_subquery
+ Filter: (t2.b = unnamed_subquery.b)
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out 2025-07-03 08:31:17.344458212 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/memoize.out 2025-07-03 08:36:46.287581053 ...
@@ -545,15 +545,15 @@
SELECT * FROM tab_anti t1 WHERE t1.a IN
(SELECT a FROM tab_anti t2 WHERE t2.b IN
(SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0));
- QUERY PLAN
--------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------
Nested Loop Semi Join
-> Seq Scan on tab_anti t1
-> Nested Loop Semi Join
Join Filter: (t1.a = t2.a)
-> Seq Scan on tab_anti t2
- -> Subquery Scan on "ANY_subquery"
- Filter: (t2.b = "ANY_subquery".b)
+ -> Subquery Scan on unnamed_subquery
+ Filter: (t2.b = unnamed_subquery.b)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out 2025-07-03 08:31:17.344458212 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/memoize.out 2025-07-03 08:38:10.36353563...
@@ -545,15 +545,15 @@
SELECT * FROM tab_anti t1 WHERE t1.a IN
(SELECT a FROM tab_anti t2 WHERE t2.b IN
(SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0));
- QUERY PLAN
--------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------
Nested Loop Semi Join
-> Seq Scan on tab_anti t1
-> Nested Loop Semi Join
Join Filter: (t1.a = t2.a)
-> Seq Scan on tab_anti t2
- -> Subquery Scan on "ANY_subquery"
- Filter: (t2.b = "ANY_subquery".b)
+ -> Subquery Scan on unnamed_subquery
+ Filter: (t2.b = unnamed_subquery.b)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out /tmp/cirrus-ci-build/build/testrun/regress/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out 2025-07-03 08:31:17.344458212 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/memoize.out 2025-07-03 08:36:42.243583612 +0000
@@ -545,15 +545,15 @@
SELECT * FROM tab_anti t1 WHERE t1.a IN
(SELECT a FROM tab_anti t2 WHERE t2.b IN
(SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0));
- QUERY PLAN
--------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------
Nested Loop Semi Join
-> Seq Scan on tab_anti t1
-> Nested Loop Semi Join
Join Filter: (t1.a = t2.a)
-> Seq Scan on tab_anti t2
- -> Subquery Scan on "ANY_subquery"
- Filter: (t2.b = "ANY_subquery".b)
+ -> Subquery Scan on unnamed_subquery
+ Filter: (t2.b = unnamed_subquery.b)
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out 2025-07-03 08:31:17.362579977 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/memoize.out 2025-07-03 08:38:13.173723147 +0000
@@ -545,15 +545,15 @@
SELECT * FROM tab_anti t1 WHERE t1.a IN
(SELECT a FROM tab_anti t2 WHERE t2.b IN
(SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0));
- QUERY PLAN
--------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------
Nested Loop Semi Join
-> Seq Scan on tab_anti t1
-> Nested Loop Semi Join
Join Filter: (t1.a = t2.a)
-> Seq Scan on tab_anti t2
- -> Subquery Scan on "ANY_subquery"
- Filter: (t2.b = "ANY_subquery".b)
+ -> Subquery Scan on unnamed_subquery
+ Filter: (t2.b = unnamed_subquery.b)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out 2025-07-03 08:31:17.362579977 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/memoize.out 2025-07-03 08:39:51.041635093 +0000
@@ -545,15 +545,15 @@
SELECT * FROM tab_anti t1 WHERE t1.a IN
(SELECT a FROM tab_anti t2 WHERE t2.b IN
(SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0));
- QUERY PLAN
--------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------
Nested Loop Semi Join
-> Seq Scan on tab_anti t1
-> Nested Loop Semi Join
Join Filter: (t1.a = t2.a)
-> Seq Scan on tab_anti t2
- -> Subquery Scan on "ANY_subquery"
- Filter: (t2.b = "ANY_subquery".b)
+ -> Subquery Scan on unnamed_subquery
+ Filter: (t2.b = unnamed_subquery.b)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out /tmp/cirrus-ci-build/src/test/regress/results/memoiz...
--- /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out 2025-07-03 08:31:17.362579977 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/memoize.out 2025-07-03 08:35:05.953843545 +0000
@@ -545,15 +545,15 @@
SELECT * FROM tab_anti t1 WHERE t1.a IN
(SELECT a FROM tab_anti t2 WHERE t2.b IN
(SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0));
- QUERY PLAN
--------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------
Nested Loop Semi Join
-> Seq Scan on tab_anti t1
-> Nested Loop Semi Join
Join Filter: (t1.a = t2.a)
-> Seq Scan on tab_anti t2
- -> Subquery Scan on "ANY_subquery"
- Filter: (t2.b = "ANY_subquery".b)
+ -> Subquery Scan on unnamed_subquery
+ Filter: (t2.b = unnamed_subquery.b)
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out 2025-07-03 08:31:17.973989000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/memoize.out 2025-07-03 08:35:14.537010000 ...
@@ -545,15 +545,15 @@
SELECT * FROM tab_anti t1 WHERE t1.a IN
(SELECT a FROM tab_anti t2 WHERE t2.b IN
(SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0));
- QUERY PLAN
--------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------
Nested Loop Semi Join
-> Seq Scan on tab_anti t1
-> Nested Loop Semi Join
Join Filter: (t1.a = t2.a)
-> Seq Scan on tab_anti t2
- -> Subquery Scan on "ANY_subquery"
- Filter: (t2.b = "ANY_subquery".b)
+ -> Subquery Scan on unnamed_subquery
+ Filter: (t2.b = unnamed_subquery.b)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out 2025-07-03 08:31:17.973989000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/memoize.out 2025-07-03 08:36:43.19926100...
@@ -545,15 +545,15 @@
SELECT * FROM tab_anti t1 WHERE t1.a IN
(SELECT a FROM tab_anti t2 WHERE t2.b IN
(SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0));
- QUERY PLAN
--------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------
Nested Loop Semi Join
-> Seq Scan on tab_anti t1
-> Nested Loop Semi Join
Join Filter: (t1.a = t2.a)
-> Seq Scan on tab_anti t2
- -> Subquery Scan on "ANY_subquery"
- Filter: (t2.b = "ANY_subquery".b)
+ -> Subquery Scan on unnamed_subquery
+ Filter: (t2.b = unnamed_subquery.b)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out /tmp/cirrus-ci-build/build/testrun/regress/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out 2025-07-03 08:31:17.973989000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/memoize.out 2025-07-03 08:35:15.623555000 +0000
@@ -545,15 +545,15 @@
SELECT * FROM tab_anti t1 WHERE t1.a IN
(SELECT a FROM tab_anti t2 WHERE t2.b IN
(SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0));
- QUERY PLAN
--------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------
Nested Loop Semi Join
-> Seq Scan on tab_anti t1
-> Nested Loop Semi Join
Join Filter: (t1.a = t2.a)
-> Seq Scan on tab_anti t2
- -> Subquery Scan on "ANY_subquery"
- Filter: (t2.b = "ANY_subquery".b)
+ -> Subquery Scan on unnamed_subquery
+ Filter: (t2.b = unnamed_subquery.b)
... |
| 53/5627 |
Fix oldest LSN calculation for WAL segments removal when slots are advancing during checkpoint |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_walinspect/expected/pg_walinspect.out /tmp/cirrus-ci-build/build/testrun/pg_wal...
--- /tmp/cirrus-ci-build/contrib/pg_walinspect/expected/pg_walinspect.out 2025-07-02 17:33:45.636686000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_walinspect/regress/results/pg_walinspect.out 2025-07-02 17:47:36.317379000 +00...
@@ -124,7 +124,7 @@
WHERE relfilenode = :'sample_tbl_oid' AND block_data IS NOT NULL;
ok
----
- t
+ f
(1 row)
-- Force a checkpoint so that the next update will log a full-page image. |
| 53/5814 |
Add enable_groupagg GUC parameter to control GroupAggregate usage |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_up...
--- /tmp/cirrus-ci-build/src/test/regress/expected/join.out 2025-07-01 03:54:17.657308000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/join.out 2025-07-01 03:56:13.001730000 +00...
@@ -8186,15 +8186,15 @@
lateral (values(x.q1,y.q1,y.q2)) v(xq1,yq1,yq2);
q1 | q2 | q1 | q2 | xq1 | yq1 | ...
------------------+-------------------+------------------+-------------------+------------------+------------------+---...
- 123 | 456 | | | 123 | | ...
- 123 | 4567890123456789 | 4567890123456789 | -4567890123456789 | 123 | 4567890123456789 | -4...
- 123 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 123 | 4567890123456789 | 4...
- 123 | 4567890123456789 | 4567890123456789 | 123 | 123 | 4567890123456789 | ...
- 4567890123456789 | 123 | 123 | 4567890123456789 | 4567890123456789 | 123 | 4...
4567890123456789 | 123 | 123 | 456 | 4567890123456789 | 123 | ...
- 4567890123456789 | 4567890123456789 | 4567890123456789 | -4567890123456789 | 4567890123456789 | 4567890123456789 | -4...
- 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4...
+ 4567890123456789 | 123 | 123 | 4567890123456789 | 4567890123456789 | 123 | 4...
4567890123456789 | 4567890123456789 | 4567890123456789 | 123 | 4567890123456789 | 4567890123456789 | ...
+ 123 | 4567890123456789 | 4567890123456789 | 123 | 123 | 4567890123456789 | ...
+ 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4...
+ 123 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 123 | 4567890123456789 | 4...
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/join.out 2025-07-01 03:54:17.657308000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/join.out 2025-07-01 03:57:18.575479000 +...
@@ -8820,36 +8820,40 @@
where q2 = (select greatest(t1.q1,t2.q2))
and (select v.id=0)) offset 0) ss2) ss
where t1.q1 = ss.q2) ss0;
- QUERY PLAN ...
------------------------------------------------------------------------------------------------------------------------...
+ QUERY PLAN ...
+-----------------------------------------------------------------------------------------------------------------------...
Nested Loop
Output: "*VALUES*".column1, t1.q1, t1.q2, ss2.q1, ss2.q2
- -> Seq Scan on public.int8_tbl t1
- Output: t1.q1, t1.q2
+ -> Values Scan on "*VALUES*"
+ Output: "*VALUES*".column1
-> Nested Loop
- Output: "*VALUES*".column1, ss2.q1, ss2.q2
- -> Values Scan on "*VALUES*"
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/aggregates.out /tmp/cirrus-ci-build/build/testrun/regress/regres...
--- /tmp/cirrus-ci-build/src/test/regress/expected/aggregates.out 2025-07-01 03:54:17.617090000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/aggregates.out 2025-07-01 03:56:08.000829000 +0000
@@ -3612,8 +3612,8 @@
) AS sub
GROUP BY c1
ORDER BY c1;
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------------------------------------------
GroupAggregate
Group Key: sub.c1
-> Sort
@@ -3622,7 +3622,7 @@
-> HashAggregate
Group Key: test_groupagg.c1, test_groupagg.c2
-> Seq Scan on test_groupagg
- Settings: max_parallel_workers = '0', max_parallel_workers_per_gather = '0'
+ Settings: debug_parallel_query = 'regress', max_parallel_workers = '0', max_parallel_workers_per_gather = '0'
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/join.out 2025-07-01 03:54:17.676640510 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/join.out 2025-07-01 04:00:44.574879638 +0000
@@ -3683,12 +3683,12 @@
-----------------------------------------------------------
Sort
Sort Key: t1.q1, t1.q2
- -> Hash Left Join
- Hash Cond: (t1.q2 = t2.q1)
+ -> Hash Right Join
+ Hash Cond: (t2.q1 = t1.q2)
Filter: (1 = (SubPlan 1))
- -> Seq Scan on int8_tbl t1
+ -> Seq Scan on int8_tbl t2
-> Hash
- -> Seq Scan on int8_tbl t2
+ -> Seq Scan on int8_tbl t1
SubPlan 1
-> Limit
-> Result
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/result...
--- /tmp/cirrus-ci-build/src/test/regress/expected/join.out 2025-07-01 03:54:17.676640510 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/join.out 2025-07-01 04:02:25.378647286 +0000
@@ -8186,15 +8186,15 @@
lateral (values(x.q1,y.q1,y.q2)) v(xq1,yq1,yq2);
q1 | q2 | q1 | q2 | xq1 | yq1 | ...
------------------+-------------------+------------------+-------------------+------------------+------------------+---...
- 123 | 456 | | | 123 | | ...
- 123 | 4567890123456789 | 4567890123456789 | -4567890123456789 | 123 | 4567890123456789 | -4...
- 123 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 123 | 4567890123456789 | 4...
- 123 | 4567890123456789 | 4567890123456789 | 123 | 123 | 4567890123456789 | ...
- 4567890123456789 | 123 | 123 | 4567890123456789 | 4567890123456789 | 123 | 4...
4567890123456789 | 123 | 123 | 456 | 4567890123456789 | 123 | ...
- 4567890123456789 | 4567890123456789 | 4567890123456789 | -4567890123456789 | 4567890123456789 | 4567890123456789 | -4...
- 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4...
+ 4567890123456789 | 123 | 123 | 4567890123456789 | 4567890123456789 | 123 | 4...
4567890123456789 | 4567890123456789 | 4567890123456789 | 123 | 4567890123456789 | 4567890123456789 | ...
+ 123 | 4567890123456789 | 4567890123456789 | 123 | 123 | 4567890123456789 | ...
+ 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4...
+ 123 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 123 | 4567890123456789 | 4...
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join.out /tmp/cirrus-ci-build/src/test/regress/results/join.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/join.out 2025-07-01 03:54:17.676640510 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/join.out 2025-07-01 03:57:01.543800993 +0000
@@ -6012,22 +6012,26 @@
on t1.q2 = t2.q2
left join onek t4
on t2.q2 < t3.unique2;
- QUERY PLAN
--------------------------------------------------
+ QUERY PLAN
+-----------------------------------------------------------
Nested Loop Left Join
Join Filter: (t2.q2 < t3.unique2)
-> Nested Loop Left Join
- Join Filter: (t2.q1 > t3.unique1)
-> Hash Left Join
Hash Cond: (t1.q2 = t2.q2)
-> Seq Scan on int8_tbl t1
-> Hash
-> Seq Scan on int8_tbl t2
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join_hash.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/join_hash.out 2025-07-01 03:54:17.001910805 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/join_hash.out 2025-07-01 03:56:51.24124762...
@@ -1137,18 +1137,21 @@
int8_tbl i8,
lateral (select t1.fivethous, i4.f1 from tenk1 t1 join int4_tbl i4
on t1.fivethous = i4.f1+i8.q2 order by 1,2) ss;
- QUERY PLAN
------------------------------------------------------------
+ QUERY PLAN
+-----------------------------------------------------------------
Nested Loop
-> Seq Scan on int8_tbl i8
- -> Sort
- Sort Key: t1.fivethous, i4.f1
- -> Hash Join
- Hash Cond: (t1.fivethous = (i4.f1 + i8.q2))
- -> Seq Scan on tenk1 t1
- -> Hash
- -> Seq Scan on int4_tbl i4
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join_hash.out /tmp/cirrus-ci-build/build/testrun/recovery/027_st...
--- /tmp/cirrus-ci-build/src/test/regress/expected/join_hash.out 2025-07-01 03:54:17.001910805 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/join_hash.out 2025-07-01 03:58:12.961135...
@@ -1137,18 +1137,21 @@
int8_tbl i8,
lateral (select t1.fivethous, i4.f1 from tenk1 t1 join int4_tbl i4
on t1.fivethous = i4.f1+i8.q2 order by 1,2) ss;
- QUERY PLAN
------------------------------------------------------------
+ QUERY PLAN
+-----------------------------------------------------------------
Nested Loop
-> Seq Scan on int8_tbl i8
- -> Sort
- Sort Key: t1.fivethous, i4.f1
- -> Hash Join
- Hash Cond: (t1.fivethous = (i4.f1 + i8.q2))
- -> Seq Scan on tenk1 t1
- -> Hash
- -> Seq Scan on int4_tbl i4
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/join.out 2025-07-01 03:54:17.001910805 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/join.out 2025-07-01 03:56:37.709255485 +0000
@@ -8186,15 +8186,15 @@
lateral (values(x.q1,y.q1,y.q2)) v(xq1,yq1,yq2);
q1 | q2 | q1 | q2 | xq1 | yq1 | ...
------------------+-------------------+------------------+-------------------+------------------+------------------+---...
- 123 | 456 | | | 123 | | ...
- 123 | 4567890123456789 | 4567890123456789 | -4567890123456789 | 123 | 4567890123456789 | -4...
- 123 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 123 | 4567890123456789 | 4...
- 123 | 4567890123456789 | 4567890123456789 | 123 | 123 | 4567890123456789 | ...
- 4567890123456789 | 123 | 123 | 4567890123456789 | 4567890123456789 | 123 | 4...
4567890123456789 | 123 | 123 | 456 | 4567890123456789 | 123 | ...
- 4567890123456789 | 4567890123456789 | 4567890123456789 | -4567890123456789 | 4567890123456789 | 4567890123456789 | -4...
- 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4...
+ 4567890123456789 | 123 | 123 | 4567890123456789 | 4567890123456789 | 123 | 4...
4567890123456789 | 4567890123456789 | 4567890123456789 | 123 | 4567890123456789 | 4567890123456789 | ...
+ 123 | 4567890123456789 | 4567890123456789 | 123 | 123 | 4567890123456789 | ...
+ 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4...
+ 123 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 123 | 4567890123456789 | 4...
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/join.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrad...
--- /Users/admin/pgsql/src/test/regress/expected/join.out 2025-07-01 03:54:14
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/join.out 2025-07-01 03:56:54
@@ -8186,15 +8186,15 @@
lateral (values(x.q1,y.q1,y.q2)) v(xq1,yq1,yq2);
q1 | q2 | q1 | q2 | xq1 | yq1 | ...
------------------+-------------------+------------------+-------------------+------------------+------------------+---...
- 123 | 456 | | | 123 | | ...
- 123 | 4567890123456789 | 4567890123456789 | -4567890123456789 | 123 | 4567890123456789 | -4...
- 123 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 123 | 4567890123456789 | 4...
- 123 | 4567890123456789 | 4567890123456789 | 123 | 123 | 4567890123456789 | ...
- 4567890123456789 | 123 | 123 | 4567890123456789 | 4567890123456789 | 123 | 4...
4567890123456789 | 123 | 123 | 456 | 4567890123456789 | 123 | ...
- 4567890123456789 | 4567890123456789 | 4567890123456789 | -4567890123456789 | 4567890123456789 | 4567890123456789 | -4...
- 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4...
+ 4567890123456789 | 123 | 123 | 4567890123456789 | 4567890123456789 | 123 | 4...
4567890123456789 | 4567890123456789 | 4567890123456789 | 123 | 4567890123456789 | 4567890123456789 | ...
+ 123 | 4567890123456789 | 4567890123456789 | 123 | 123 | 4567890123456789 | ...
+ 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4...
+ 123 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 123 | 4567890123456789 | 4...
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/join.out /Users/admin/pgsql/build/testrun/recovery/027_stream_regr...
--- /Users/admin/pgsql/src/test/regress/expected/join.out 2025-07-01 03:54:14
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/join.out 2025-07-01 03:58:36
@@ -8505,12 +8505,14 @@
Output: a.q1, a.q2
-> Nested Loop
Output: b.q1, c.q1, LEAST(a.q1, b.q1, c.q1)
- -> Seq Scan on public.int8_tbl b
- Output: b.q1, b.q2
- Filter: (a.q2 = b.q1)
-> Seq Scan on public.int8_tbl c
Output: c.q1, c.q2
-(11 rows)
+ -> Materialize
+ Output: b.q1
+ -> Seq Scan on public.int8_tbl b
+ Output: b.q1
+ Filter: (a.q2 = b.q1)
+(13 rows)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/join_hash.out /Users/admin/pgsql/build/testrun/regress/regress/res...
--- /Users/admin/pgsql/src/test/regress/expected/join_hash.out 2025-07-01 03:54:14
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/join_hash.out 2025-07-01 03:56:57
@@ -1137,18 +1137,21 @@
int8_tbl i8,
lateral (select t1.fivethous, i4.f1 from tenk1 t1 join int4_tbl i4
on t1.fivethous = i4.f1+i8.q2 order by 1,2) ss;
- QUERY PLAN
------------------------------------------------------------
+ QUERY PLAN
+-----------------------------------------------------------------
Nested Loop
-> Seq Scan on int8_tbl i8
- -> Sort
- Sort Key: t1.fivethous, i4.f1
- -> Hash Join
- Hash Cond: (t1.fivethous = (i4.f1 + i8.q2))
- -> Seq Scan on tenk1 t1
- -> Hash
- -> Seq Scan on int4_tbl i4
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/join_hash.out C:/cirrus/build/testrun/pg_upgrade/002_pg...
--- C:/cirrus/src/test/regress/expected/join_hash.out 2025-07-01 03:54:21.569734700 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/join_hash.out 2025-07-01 03:57:08.737908300 +0000
@@ -1137,18 +1137,21 @@
int8_tbl i8,
lateral (select t1.fivethous, i4.f1 from tenk1 t1 join int4_tbl i4
on t1.fivethous = i4.f1+i8.q2 order by 1,2) ss;
- QUERY PLAN
------------------------------------------------------------
+ QUERY PLAN
+-----------------------------------------------------------------
Nested Loop
-> Seq Scan on int8_tbl i8
- -> Sort
- Sort Key: t1.fivethous, i4.f1
- -> Hash Join
- Hash Cond: (t1.fivethous = (i4.f1 + i8.q2))
- -> Seq Scan on tenk1 t1
- -> Hash
- -> Seq Scan on int4_tbl i4
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/join_hash.out C:/cirrus/build/testrun/recovery/027_stre...
--- C:/cirrus/src/test/regress/expected/join_hash.out 2025-07-01 03:54:21.569734700 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/join_hash.out 2025-07-01 03:59:58.538346200 +0000
@@ -1137,18 +1137,21 @@
int8_tbl i8,
lateral (select t1.fivethous, i4.f1 from tenk1 t1 join int4_tbl i4
on t1.fivethous = i4.f1+i8.q2 order by 1,2) ss;
- QUERY PLAN
------------------------------------------------------------
+ QUERY PLAN
+-----------------------------------------------------------------
Nested Loop
-> Seq Scan on int8_tbl i8
- -> Sort
- Sort Key: t1.fivethous, i4.f1
- -> Hash Join
- Hash Cond: (t1.fivethous = (i4.f1 + i8.q2))
- -> Seq Scan on tenk1 t1
- -> Hash
- -> Seq Scan on int4_tbl i4
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/join_hash.out C:/cirrus/build/testrun/regress/regress/r...
--- C:/cirrus/src/test/regress/expected/join_hash.out 2025-07-01 03:54:21.569734700 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/join_hash.out 2025-07-01 03:57:00.819403900 +0000
@@ -1137,18 +1137,21 @@
int8_tbl i8,
lateral (select t1.fivethous, i4.f1 from tenk1 t1 join int4_tbl i4
on t1.fivethous = i4.f1+i8.q2 order by 1,2) ss;
- QUERY PLAN
------------------------------------------------------------
+ QUERY PLAN
+-----------------------------------------------------------------
Nested Loop
-> Seq Scan on int8_tbl i8
- -> Sort
- Sort Key: t1.fivethous, i4.f1
- -> Hash Join
- Hash Cond: (t1.fivethous = (i4.f1 + i8.q2))
- -> Seq Scan on tenk1 t1
- -> Hash
- -> Seq Scan on int4_tbl i4
... |
| 53/5751 |
Disable parallel query by default |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/deadlock-parallel.out /tmp/cirrus-ci-build/build/testrun/isola...
--- /tmp/cirrus-ci-build/src/test/isolation/expected/deadlock-parallel.out 2025-07-01 02:49:13.338021000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/deadlock-parallel.out 2025-07-01 02:50:19.190870000 +...
@@ -46,6 +46,7 @@
1
(1 row)
+step e1c: COMMIT;
step d2a1: <... completed>
sum
-----
@@ -57,7 +58,6 @@
1
(1 row)
-step e1c: COMMIT;
step d2c: COMMIT;
step e2l: <... completed>
lock_excl |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_overexplain/expected/pg_overexplain.out /tmp/cirrus-ci-build/build/testrun/pg_o...
--- /tmp/cirrus-ci-build/contrib/pg_overexplain/expected/pg_overexplain.out 2025-07-01 02:49:11.949804000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_overexplain/regress/results/pg_overexplain.out 2025-07-01 02:51:40.698718000 +...
@@ -91,26 +91,26 @@
GroupAggregate
Group Key: vegetables.genus
Disabled Nodes: 0
- Parallel Safe: true
+ Parallel Safe: false
Plan Node ID: 0
-> Sort
Sort Key: vegetables.genus, vegetables.name
Disabled Nodes: 0
- Parallel Safe: true
+ Parallel Safe: false
Plan Node ID: 1
-> Append
Disabled Nodes: 0
- Parallel Safe: true
+ Parallel Safe: false
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/build/testrun/pg_upgrad...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2025-07-01 02:49:13.518373000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2025-07-01 02:50:39.75...
@@ -1390,7 +1390,6 @@
select set_role_and_error(0);
ERROR: division by zero
CONTEXT: SQL function "set_role_and_error" statement 1
-parallel worker
reset debug_parallel_query;
drop function set_and_report_role();
drop function set_role_and_error(int);
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out 2025-07-01 02:49:13.504128000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plpgsql.out 2025-07-01 02:50:55.445608000 ...
@@ -4111,15 +4111,11 @@
$$ language plpgsql parallel safe;
set debug_parallel_query to on;
explain (verbose, costs off) select error_trap_test();
- QUERY PLAN
------------------------------------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/build/testrun/recovery/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2025-07-01 02:49:13.518373000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2025-07-01 02:51:49....
@@ -1390,7 +1390,6 @@
select set_role_and_error(0);
ERROR: division by zero
CONTEXT: SQL function "set_role_and_error" statement 1
-parallel worker
reset debug_parallel_query;
drop function set_and_report_role();
drop function set_role_and_error(int);
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out 2025-07-01 02:49:13.504128000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/plpgsql.out 2025-07-01 02:52:07.73305300...
@@ -4111,15 +4111,11 @@
$$ language plpgsql parallel safe;
set debug_parallel_query to on;
explain (verbose, costs off) select error_trap_test();
- QUERY PLAN
------------------------------------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/build/testrun/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2025-07-01 02:49:13.518373000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/select_parallel.out 2025-07-01 02:50:39.497600000 +0000
@@ -1390,7 +1390,6 @@
select set_role_and_error(0);
ERROR: division by zero
CONTEXT: SQL function "set_role_and_error" statement 1
-parallel worker
reset debug_parallel_query;
drop function set_and_report_role();
drop function set_role_and_error(int);
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out /tmp/cirrus-ci-build/build/testrun/regress/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out 2025-07-01 02:49:13.504128000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/plpgsql.out 2025-07-01 02:50:54.174821000 +0000
@@ -4111,15 +4111,11 @@
$$ language plpgsql parallel safe;
set debug_parallel_query to on;
explain (verbose, costs off) select error_trap_test();
- QUERY PLAN
------------------------------------
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_overexplain/expected/pg_overexplain.out /tmp/cirrus-ci-build/contrib/pg_overexp...
--- /tmp/cirrus-ci-build/contrib/pg_overexplain/expected/pg_overexplain.out 2025-07-01 02:49:16.848740810 +0000
+++ /tmp/cirrus-ci-build/contrib/pg_overexplain/results/pg_overexplain.out 2025-07-01 02:53:34.440100846 +0000
@@ -91,26 +91,26 @@
GroupAggregate
Group Key: vegetables.genus
Disabled Nodes: 0
- Parallel Safe: true
+ Parallel Safe: false
Plan Node ID: 0
-> Sort
Sort Key: vegetables.genus, vegetables.name
Disabled Nodes: 0
- Parallel Safe: true
+ Parallel Safe: false
Plan Node ID: 1
-> Append
Disabled Nodes: 0
- Parallel Safe: true
+ Parallel Safe: false
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2025-07-01 02:49:18.768740881 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/select_parallel.out 2025-07-01 02:55:26.447969577 +0000
@@ -1390,7 +1390,6 @@
select set_role_and_error(0);
ERROR: division by zero
CONTEXT: SQL function "set_role_and_error" statement 1
-parallel worker
reset debug_parallel_query;
drop function set_and_report_role();
drop function set_role_and_error(int);
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out 2025-07-01 02:49:18.752740881 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/plpgsql.out 2025-07-01 02:55:45.107954851 +0000
@@ -4111,15 +4111,11 @@
$$ language plpgsql parallel safe;
set debug_parallel_query to on;
explain (verbose, costs off) select error_trap_test();
- QUERY PLAN
------------------------------------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/deadlock-parallel.out /tmp/cirrus-ci-build/src/test/isolation/...
--- /tmp/cirrus-ci-build/src/test/isolation/expected/deadlock-parallel.out 2025-07-01 02:49:18.540740873 +0000
+++ /tmp/cirrus-ci-build/src/test/isolation/output_iso/results/deadlock-parallel.out 2025-07-01 02:51:29.144243212 +0000
@@ -46,6 +46,7 @@
1
(1 row)
+step e1c: COMMIT;
step d2a1: <... completed>
sum
-----
@@ -57,7 +58,6 @@
1
(1 row)
-step e1c: COMMIT;
step d2c: COMMIT;
step e2l: <... completed>
lock_excl |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/src/test/recovery/tmp_c...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2025-07-01 02:49:18.768740881 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/select_parallel.out 2025-07-01 02:56:34.059919691 +0000
@@ -1390,7 +1390,6 @@
select set_role_and_error(0);
ERROR: division by zero
CONTEXT: SQL function "set_role_and_error" statement 1
-parallel worker
reset debug_parallel_query;
drop function set_and_report_role();
drop function set_role_and_error(int);
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out 2025-07-01 02:49:18.752740881 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/plpgsql.out 2025-07-01 02:56:48.635909852 +0000
@@ -4111,15 +4111,11 @@
$$ language plpgsql parallel safe;
set debug_parallel_query to on;
explain (verbose, costs off) select error_trap_test();
- QUERY PLAN
------------------------------------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/src/test/regress/result...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2025-07-01 02:49:18.768740881 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/select_parallel.out 2025-07-01 02:52:18.120208530 +0000
@@ -1390,7 +1390,6 @@
select set_role_and_error(0);
ERROR: division by zero
CONTEXT: SQL function "set_role_and_error" statement 1
-parallel worker
reset debug_parallel_query;
drop function set_and_report_role();
drop function set_role_and_error(int);
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out /tmp/cirrus-ci-build/src/test/regress/results/plpgsq...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out 2025-07-01 02:49:18.752740881 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/plpgsql.out 2025-07-01 02:52:43.528197349 +0000
@@ -4111,15 +4111,11 @@
$$ language plpgsql parallel safe;
set debug_parallel_query to on;
explain (verbose, costs off) select error_trap_test();
- QUERY PLAN
------------------------------------
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/deadlock-parallel.out /tmp/cirrus-ci-build/build/testrun/isola...
--- /tmp/cirrus-ci-build/src/test/isolation/expected/deadlock-parallel.out 2025-07-01 02:49:23.780893159 +0000
+++ /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/deadlock-parallel.out 2025-07-01 02:51:18.290623677 +...
@@ -46,6 +46,7 @@
1
(1 row)
+step e1c: COMMIT;
step d2a1: <... completed>
sum
-----
@@ -57,7 +58,6 @@
1
(1 row)
-step e1c: COMMIT;
step d2c: COMMIT;
step e2l: <... completed>
lock_excl |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_overexplain/expected/pg_overexplain.out /tmp/cirrus-ci-build/build/testrun/pg_o...
--- /tmp/cirrus-ci-build/contrib/pg_overexplain/expected/pg_overexplain.out 2025-07-01 02:49:22.045982498 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_overexplain/regress/results/pg_overexplain.out 2025-07-01 02:53:22.874277131 +...
@@ -91,26 +91,26 @@
GroupAggregate
Group Key: vegetables.genus
Disabled Nodes: 0
- Parallel Safe: true
+ Parallel Safe: false
Plan Node ID: 0
-> Sort
Sort Key: vegetables.genus, vegetables.name
Disabled Nodes: 0
- Parallel Safe: true
+ Parallel Safe: false
Plan Node ID: 1
-> Append
Disabled Nodes: 0
- Parallel Safe: true
+ Parallel Safe: false
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/build/testrun/pg_upgrad...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2025-07-01 02:49:24.014246240 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2025-07-01 02:51:49.49...
@@ -1390,7 +1390,6 @@
select set_role_and_error(0);
ERROR: division by zero
CONTEXT: SQL function "set_role_and_error" statement 1
-parallel worker
reset debug_parallel_query;
drop function set_and_report_role();
drop function set_role_and_error(int);
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out 2025-07-01 02:49:23.998160297 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plpgsql.out 2025-07-01 02:52:03.380791970 ...
@@ -4111,15 +4111,11 @@
$$ language plpgsql parallel safe;
set debug_parallel_query to on;
explain (verbose, costs off) select error_trap_test();
- QUERY PLAN
------------------------------------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/build/testrun/recovery/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2025-07-01 02:49:24.014246240 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2025-07-01 02:53:05....
@@ -1390,7 +1390,6 @@
select set_role_and_error(0);
ERROR: division by zero
CONTEXT: SQL function "set_role_and_error" statement 1
-parallel worker
reset debug_parallel_query;
drop function set_and_report_role();
drop function set_role_and_error(int);
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out 2025-07-01 02:49:23.998160297 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/plpgsql.out 2025-07-01 02:53:20.98636728...
@@ -4111,15 +4111,11 @@
$$ language plpgsql parallel safe;
set debug_parallel_query to on;
explain (verbose, costs off) select error_trap_test();
- QUERY PLAN
------------------------------------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/build/testrun/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2025-07-01 02:49:24.014246240 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/select_parallel.out 2025-07-01 02:51:48.719820272 +0000
@@ -1390,7 +1390,6 @@
select set_role_and_error(0);
ERROR: division by zero
CONTEXT: SQL function "set_role_and_error" statement 1
-parallel worker
reset debug_parallel_query;
drop function set_and_report_role();
drop function set_role_and_error(int);
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out /tmp/cirrus-ci-build/build/testrun/regress/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out 2025-07-01 02:49:23.998160297 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/plpgsql.out 2025-07-01 02:52:03.592807146 +0000
@@ -4111,15 +4111,11 @@
$$ language plpgsql parallel safe;
set debug_parallel_query to on;
explain (verbose, costs off) select error_trap_test();
- QUERY PLAN
------------------------------------
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/isolation/expected/deadlock-parallel.out /Users/admin/pgsql/build/testrun/isolation...
--- /Users/admin/pgsql/src/test/isolation/expected/deadlock-parallel.out 2025-07-01 02:48:12
+++ /Users/admin/pgsql/build/testrun/isolation/isolation/results/deadlock-parallel.out 2025-07-01 02:49:42
@@ -46,6 +46,7 @@
1
(1 row)
+step e1c: COMMIT;
step d2a1: <... completed>
sum
-----
@@ -57,7 +58,6 @@
1
(1 row)
-step e1c: COMMIT;
step d2c: COMMIT;
step e2l: <... completed>
lock_excl |
| regress |
diff -U3 /Users/admin/pgsql/contrib/pg_overexplain/expected/pg_overexplain.out /Users/admin/pgsql/build/testrun/pg_overe...
--- /Users/admin/pgsql/contrib/pg_overexplain/expected/pg_overexplain.out 2025-07-01 02:48:10
+++ /Users/admin/pgsql/build/testrun/pg_overexplain/regress/results/pg_overexplain.out 2025-07-01 02:52:12
@@ -91,26 +91,26 @@
GroupAggregate
Group Key: vegetables.genus
Disabled Nodes: 0
- Parallel Safe: true
+ Parallel Safe: false
Plan Node ID: 0
-> Sort
Sort Key: vegetables.genus, vegetables.name
Disabled Nodes: 0
- Parallel Safe: true
+ Parallel Safe: false
Plan Node ID: 1
-> Append
Disabled Nodes: 0
- Parallel Safe: true
+ Parallel Safe: false
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/select_parallel.out /Users/admin/pgsql/build/testrun/pg_upgrade/00...
--- /Users/admin/pgsql/src/test/regress/expected/select_parallel.out 2025-07-01 02:48:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2025-07-01 02:50:10
@@ -1390,7 +1390,6 @@
select set_role_and_error(0);
ERROR: division by zero
CONTEXT: SQL function "set_role_and_error" statement 1
-parallel worker
reset debug_parallel_query;
drop function set_and_report_role();
drop function set_role_and_error(int);
diff -U3 /Users/admin/pgsql/src/test/regress/expected/plpgsql.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upg...
--- /Users/admin/pgsql/src/test/regress/expected/plpgsql.out 2025-07-01 02:48:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plpgsql.out 2025-07-01 02:50:27
@@ -4111,15 +4111,11 @@
$$ language plpgsql parallel safe;
set debug_parallel_query to on;
explain (verbose, costs off) select error_trap_test();
- QUERY PLAN
------------------------------------
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/select_parallel.out /Users/admin/pgsql/build/testrun/recovery/027_...
--- /Users/admin/pgsql/src/test/regress/expected/select_parallel.out 2025-07-01 02:48:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2025-07-01 02:52:00
@@ -1390,7 +1390,6 @@
select set_role_and_error(0);
ERROR: division by zero
CONTEXT: SQL function "set_role_and_error" statement 1
-parallel worker
reset debug_parallel_query;
drop function set_and_report_role();
drop function set_role_and_error(int);
diff -U3 /Users/admin/pgsql/src/test/regress/expected/plpgsql.out /Users/admin/pgsql/build/testrun/recovery/027_stream_r...
--- /Users/admin/pgsql/src/test/regress/expected/plpgsql.out 2025-07-01 02:48:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/plpgsql.out 2025-07-01 02:52:18
@@ -4111,15 +4111,11 @@
$$ language plpgsql parallel safe;
set debug_parallel_query to on;
explain (verbose, costs off) select error_trap_test();
- QUERY PLAN
------------------------------------
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/select_parallel.out /Users/admin/pgsql/build/testrun/regress/regre...
--- /Users/admin/pgsql/src/test/regress/expected/select_parallel.out 2025-07-01 02:48:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/select_parallel.out 2025-07-01 02:50:13
@@ -1390,7 +1390,6 @@
select set_role_and_error(0);
ERROR: division by zero
CONTEXT: SQL function "set_role_and_error" statement 1
-parallel worker
reset debug_parallel_query;
drop function set_and_report_role();
drop function set_role_and_error(int);
diff -U3 /Users/admin/pgsql/src/test/regress/expected/plpgsql.out /Users/admin/pgsql/build/testrun/regress/regress/resul...
--- /Users/admin/pgsql/src/test/regress/expected/plpgsql.out 2025-07-01 02:48:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/plpgsql.out 2025-07-01 02:50:30
@@ -4111,15 +4111,11 @@
$$ language plpgsql parallel safe;
set debug_parallel_query to on;
explain (verbose, costs off) select error_trap_test();
- QUERY PLAN
------------------------------------
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/isolation/expected/deadlock-parallel.out C:/cirrus/build/testrun/isolati...
--- C:/cirrus/src/test/isolation/expected/deadlock-parallel.out 2025-07-01 02:49:18.523182900 +0000
+++ C:/cirrus/build/testrun/isolation/isolation/results/deadlock-parallel.out 2025-07-01 02:51:50.673884800 +0000
@@ -46,6 +46,7 @@
1
(1 row)
+step e1c: COMMIT;
step d2a1: <... completed>
sum
-----
@@ -57,7 +58,6 @@
1
(1 row)
-step e1c: COMMIT;
step d2c: COMMIT;
step e2l: <... completed>
lock_excl |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_overexplain/expected/pg_overexplain.out C:/cirrus/build/testrun/pg_ove...
--- C:/cirrus/contrib/pg_overexplain/expected/pg_overexplain.out 2025-07-01 02:49:14.531338400 +0000
+++ C:/cirrus/build/testrun/pg_overexplain/regress/results/pg_overexplain.out 2025-07-01 02:56:19.956126000 +0000
@@ -91,26 +91,26 @@
GroupAggregate
Group Key: vegetables.genus
Disabled Nodes: 0
- Parallel Safe: true
+ Parallel Safe: false
Plan Node ID: 0
-> Sort
Sort Key: vegetables.genus, vegetables.name
Disabled Nodes: 0
- Parallel Safe: true
+ Parallel Safe: false
Plan Node ID: 1
-> Append
Disabled Nodes: 0
- Parallel Safe: true
+ Parallel Safe: false
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/select_parallel.out C:/cirrus/build/testrun/pg_upgrade/...
--- C:/cirrus/src/test/regress/expected/select_parallel.out 2025-07-01 02:49:19.269233500 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2025-07-01 02:52:35.888549600 +00...
@@ -1390,7 +1390,6 @@
select set_role_and_error(0);
ERROR: division by zero
CONTEXT: SQL function "set_role_and_error" statement 1
-parallel worker
reset debug_parallel_query;
drop function set_and_report_role();
drop function set_role_and_error(int);
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/plpgsql.out C:/cirrus/build/testrun/pg_upgrade/002_pg_u...
--- C:/cirrus/src/test/regress/expected/plpgsql.out 2025-07-01 02:49:19.231663100 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plpgsql.out 2025-07-01 02:52:55.813567500 +0000
@@ -4111,15 +4111,11 @@
$$ language plpgsql parallel safe;
set debug_parallel_query to on;
explain (verbose, costs off) select error_trap_test();
- QUERY PLAN
------------------------------------
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/select_parallel.out C:/cirrus/build/testrun/recovery/02...
--- C:/cirrus/src/test/regress/expected/select_parallel.out 2025-07-01 02:49:19.269233500 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2025-07-01 02:55:26.334739600 +...
@@ -1390,7 +1390,6 @@
select set_role_and_error(0);
ERROR: division by zero
CONTEXT: SQL function "set_role_and_error" statement 1
-parallel worker
reset debug_parallel_query;
drop function set_and_report_role();
drop function set_role_and_error(int);
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/plpgsql.out C:/cirrus/build/testrun/recovery/027_stream...
--- C:/cirrus/src/test/regress/expected/plpgsql.out 2025-07-01 02:49:19.231663100 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/plpgsql.out 2025-07-01 02:55:46.270581100 +0000
@@ -4111,15 +4111,11 @@
$$ language plpgsql parallel safe;
set debug_parallel_query to on;
explain (verbose, costs off) select error_trap_test();
- QUERY PLAN
------------------------------------
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/select_parallel.out C:/cirrus/build/testrun/regress/reg...
--- C:/cirrus/src/test/regress/expected/select_parallel.out 2025-07-01 02:49:19.269233500 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/select_parallel.out 2025-07-01 02:52:33.106903700 +0000
@@ -1390,7 +1390,6 @@
select set_role_and_error(0);
ERROR: division by zero
CONTEXT: SQL function "set_role_and_error" statement 1
-parallel worker
reset debug_parallel_query;
drop function set_and_report_role();
drop function set_role_and_error(int);
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/plpgsql.out C:/cirrus/build/testrun/regress/regress/res...
--- C:/cirrus/src/test/regress/expected/plpgsql.out 2025-07-01 02:49:19.231663100 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/plpgsql.out 2025-07-01 02:52:49.760805800 +0000
@@ -4111,15 +4111,11 @@
$$ language plpgsql parallel safe;
set debug_parallel_query to on;
explain (verbose, costs off) select error_trap_test();
- QUERY PLAN
------------------------------------
... |
| 53/5669 |
Use CLOCK_MONOTONIC_COARSE for instr_time for explain analyze |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/entry_timestamp.out /tmp/cirrus-ci-build/contrib/pg_st...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/entry_timestamp.out 2025-06-30 22:50:47.304067851 +0000
+++ /tmp/cirrus-ci-build/contrib/pg_stat_statements/results/entry_timestamp.out 2025-06-30 22:57:00.651628438 +0000
@@ -45,7 +45,7 @@
WHERE query LIKE '%STMTTS%';
total | minmax_plan_zero | minmax_exec_zero | minmax_stats_since_after_ref | stats_since_after_ref
-------+------------------+------------------+------------------------------+-----------------------
- 2 | 0 | 0 | 0 | 0
+ 2 | 0 | 2 | 0 | 0
(1 row)
-- Perform single min/max reset
@@ -71,7 +71,7 @@
WHERE query LIKE '%STMTTS%';
total | minmax_plan_zero | minmax_exec_zero | minmax_stats_since_after_ref | stats_since_after_ref
-------+------------------+------------------+------------------------------+-----------------------
- 2 | 1 | 1 | 1 | 0
+ 2 | 1 | 2 | 1 | 0
(1 row)
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/entry_timestamp.out /tmp/cirrus-ci-build/build/testrun...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/entry_timestamp.out 2025-06-30 22:50:46.928857672 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_stat_statements/regress/results/entry_timestamp.out 2025-06-30 22:57:42.503084...
@@ -45,7 +45,7 @@
WHERE query LIKE '%STMTTS%';
total | minmax_plan_zero | minmax_exec_zero | minmax_stats_since_after_ref | stats_since_after_ref
-------+------------------+------------------+------------------------------+-----------------------
- 2 | 0 | 0 | 0 | 0
+ 2 | 0 | 2 | 0 | 0
(1 row)
-- Perform single min/max reset
@@ -71,7 +71,7 @@
WHERE query LIKE '%STMTTS%';
total | minmax_plan_zero | minmax_exec_zero | minmax_stats_since_after_ref | stats_since_after_ref
-------+------------------+------------------+------------------------------+-----------------------
- 2 | 1 | 1 | 1 | 0
+ 2 | 1 | 2 | 1 | 0
(1 row)
... |
| 53/5447 |
log_min_messages per backend type |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out 2025-06-30 22:40:52.570830000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/foreign_key.out 2025-06-30 22:44:28.675163...
@@ -1346,2063 +1346,10 @@
BEGIN;
-- doesn't match FK, but no error.
UPDATE pktable SET id = 10 WHERE id = 5;
--- doesn't match PK, but no error.
-INSERT INTO fktable VALUES (0, 20);
-ROLLBACK;
--- try additional syntax
-ALTER TABLE fktable ALTER CONSTRAINT fktable_fk_fkey NOT DEFERRABLE;
--- illegal options
-ALTER TABLE fktable ALTER CONSTRAINT fktable_fk_fkey NOT DEFERRABLE INITIALLY DEFERRED;
-ERROR: constraint declared INITIALLY DEFERRED must be DEFERRABLE
-LINE 1: ...e ALTER CONSTRAINT fktable_fk_fkey NOT DEFERRABLE INITIALLY ...
- ^
-ALTER TABLE fktable ALTER CONSTRAINT fktable_fk_fkey NO INHERIT;
-ERROR: constraint "fktable_fk_fkey" of relation "fktable" is not a not-null constraint
-ALTER TABLE fktable ALTER CONSTRAINT fktable_fk_fkey NOT VALID;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out 2025-06-30 22:40:52.570830000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/foreign_key.out 2025-06-30 22:45:29.3081...
@@ -565,2844 +565,10 @@
DELETE FROM PKTABLE where ptest1=1 and ptest2=5 and ptest3=3;
-- Show PKTABLE and FKTABLE
SELECT * from PKTABLE;
- ptest1 | ptest2 | ptest3 | ptest4
---------+--------+--------+--------
- 2 | 4 | 5 | test4
- 1 | 3 | 3 | test2
- 1 | 3 | 4 | test3
-(3 rows)
-
-SELECT * from FKTABLE;
- ftest1 | ftest2 | ftest3 | ftest4
---------+--------+--------+--------
- | 2 | 3 | 2
- 2 | | 3 | 3
- | 2 | 7 | 4
... |
| 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 2025-06-30 22:40:52.570830000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/foreign_key.out 2025-06-30 22:44:23.178237000 +0000
@@ -853,2556 +853,10 @@
(1, 2, NULL, 2);
DELETE FROM PKTABLE WHERE id = 1 OR id = 2;
SELECT * FROM FKTABLE ORDER BY id;
- tid | id | fk_id_del_set_null | fk_id_del_set_default
------+----+--------------------+-----------------------
- 1 | 1 | |
- 1 | 2 | | 0
-(2 rows)
-
-DROP TABLE FKTABLE;
-DROP TABLE PKTABLE;
--- Test some invalid FK definitions
-CREATE TABLE PKTABLE (ptest1 int PRIMARY KEY, someoid oid);
-CREATE TABLE FKTABLE_FAIL1 ( ftest1 int, CONSTRAINT fkfail1 FOREIGN KEY (ftest2) REFERENCES PKTABLE);
-ERROR: column "ftest2" referenced in foreign key constraint does not exist
-CREATE TABLE FKTABLE_FAIL2 ( ftest1 int, CONSTRAINT fkfail1 FOREIGN KEY (ftest1) REFERENCES PKTABLE(ptest2));
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_chec...
--- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out 2025-06-30 22:40:58.000975851 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/foreign_key.out 2025-06-30 22:48:10.988274372 +0000
@@ -1740,1669 +1740,10 @@
DETAIL: Key (a, b)=(2500, 2502) is still referenced from table "fk_partitioned_fk".
-- check psql behavior
\d fk_notpartitioned_pk
- Table "public.fk_notpartitioned_pk"
- Column | Type | Collation | Nullable | Default
---------+---------+-----------+----------+---------
- a | integer | | not null |
- b | integer | | not null |
-Indexes:
- "fk_notpartitioned_pk_pkey" PRIMARY KEY, btree (a, b)
-Referenced by:
- TABLE "fk_partitioned_fk" CONSTRAINT "fk_partitioned_fk_a_b_fkey" FOREIGN KEY (a, b) REFERENCES fk_notpartitioned_p...
-
--- Check the exsting FK trigger
-SELECT conname, tgrelid::regclass as tgrel, regexp_replace(tgname, '[0-9]+', 'N') as tgname, tgtype
-FROM pg_trigger t JOIN pg_constraint c ON (t.tgconstraint = c.oid)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/src/test/regress/results/fo...
--- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out 2025-06-30 22:40:58.000975851 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/foreign_key.out 2025-06-30 22:46:33.526831427 +0000
@@ -1099,2310 +1099,10 @@
DETAIL: Key columns "ptest2" of the referencing table and "ptest1" of the referenced table are of incompatible types: ...
create table pktable(ptest1 inet, ptest2 inet, primary key(base1, ptest1), foreign key(base2, ptest2) references
pktable(ptest1, base1)) inherits (pktable_base);
-ERROR: foreign key constraint "pktable_base2_ptest2_fkey" cannot be implemented
-DETAIL: Key columns "base2" of the referencing table and "ptest1" of the referenced table are of incompatible types: i...
-create table pktable(ptest1 inet, ptest2 inet, primary key(base1, ptest1), foreign key(ptest2, base2) references
- pktable(base1, ptest1)) inherits (pktable_base);
-ERROR: foreign key constraint "pktable_ptest2_base2_fkey" cannot be implemented
-DETAIL: Key columns "ptest2" of the referencing table and "base1" of the referenced table are of incompatible types: i...
-create table pktable(ptest1 inet, ptest2 inet, primary key(base1, ptest1), foreign key(ptest2, base2) references
- pktable(base1, ptest1)) inherits (pktable_base);
-ERROR: foreign key constraint "pktable_ptest2_base2_fkey" cannot be implemented
-DETAIL: Key columns "ptest2" of the referencing table and "base1" of the referenced table are of incompatible types: i...
-drop table pktable;
-ERROR: table "pktable" does not exist
-drop table pktable_base;
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out 2025-06-30 22:41:00.667558548 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/foreign_key.out 2025-06-30 22:46:16.112097...
@@ -2182,1227 +2182,10 @@
ALTER TABLE fk_partitioned_fk ALTER CONSTRAINT fk_partitioned_fk_a_b_fkey NOT ENFORCED;
ALTER TABLE fk_partitioned_fk ATTACH PARTITION fk_partitioned_fk_2 FOR VALUES IN (1500,1502);
\d fk_partitioned_fk_2
- Table "public.fk_partitioned_fk_2"
- Column | Type | Collation | Nullable | Default
---------+---------+-----------+----------+---------
- b | integer | | |
- a | integer | | |
-Partition of: fk_partitioned_fk FOR VALUES IN (1500, 1502)
-Foreign-key constraints:
- TABLE "fk_partitioned_fk" CONSTRAINT "fk_partitioned_fk_a_b_fkey" FOREIGN KEY (a, b) REFERENCES fk_notpartitioned_p...
-
-ROLLBACK;
-DROP TABLE fk_partitioned_fk_2;
-CREATE TABLE fk_partitioned_fk_4 (a int, b int, FOREIGN KEY (a, b) REFERENCES fk_notpartitioned_pk(a, b) ON UPDATE CASC...
-CREATE TABLE fk_partitioned_fk_4_1 PARTITION OF fk_partitioned_fk_4 FOR VALUES FROM (1,1) TO (100,100);
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out 2025-06-30 22:41:00.667558548 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/foreign_key.out 2025-06-30 22:47:22.2683...
@@ -967,2442 +967,10 @@
-- And this,
CREATE TABLE PKTABLE (ptest1 int, ptest2 inet, ptest3 int, ptest4 inet, PRIMARY KEY(ptest1, ptest2), FOREIGN KEY(ptest3...
ptest4) REFERENCES pktable);
-DROP TABLE PKTABLE;
--- This shouldn't (mixed up columns)
-CREATE TABLE PKTABLE (ptest1 int, ptest2 inet, ptest3 int, ptest4 inet, PRIMARY KEY(ptest1, ptest2), FOREIGN KEY(ptest3...
-ptest4) REFERENCES pktable(ptest2, ptest1));
-ERROR: foreign key constraint "pktable_ptest3_ptest4_fkey" cannot be implemented
-DETAIL: Key columns "ptest3" of the referencing table and "ptest2" of the referenced table are of incompatible types: ...
--- Nor should this... (same reason, we have 4,3 referencing 1,2 which mismatches types
-CREATE TABLE PKTABLE (ptest1 int, ptest2 inet, ptest3 int, ptest4 inet, PRIMARY KEY(ptest1, ptest2), FOREIGN KEY(ptest4...
-ptest3) REFERENCES pktable(ptest1, ptest2));
-ERROR: foreign key constraint "pktable_ptest4_ptest3_fkey" cannot be implemented
-DETAIL: Key columns "ptest4" of the referencing table and "ptest1" of the referenced table are of incompatible types: ...
--- Not this one either... Same as the last one except we didn't defined the columns being referenced.
-CREATE TABLE PKTABLE (ptest1 int, ptest2 inet, ptest3 int, ptest4 inet, PRIMARY KEY(ptest1, ptest2), FOREIGN KEY(ptest4...
... |
| 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 2025-06-30 22:41:00.667558548 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/foreign_key.out 2025-06-30 22:46:13.632089850 +0000
@@ -1972,1437 +1972,10 @@
CREATE TABLE fk_notpartitioned_pk (a int, b int, primary key (a, b));
CREATE TABLE fk_partitioned_fk (a int default 2501, b int default 142857) PARTITION BY LIST (a);
CREATE TABLE fk_partitioned_fk_1 PARTITION OF fk_partitioned_fk FOR VALUES IN (NULL,500,501,502);
-ALTER TABLE fk_partitioned_fk ADD FOREIGN KEY (a, b)
- REFERENCES fk_notpartitioned_pk MATCH SIMPLE
- ON DELETE SET NULL ON UPDATE SET NULL;
-CREATE TABLE fk_partitioned_fk_2 PARTITION OF fk_partitioned_fk FOR VALUES IN (1500,1502);
-CREATE TABLE fk_partitioned_fk_3 (a int, b int);
-ALTER TABLE fk_partitioned_fk ATTACH PARTITION fk_partitioned_fk_3 FOR VALUES IN (2500,2501,2502,2503);
--- this insert fails
-INSERT INTO fk_partitioned_fk (a, b) VALUES (2502, 2503);
-ERROR: insert or update on table "fk_partitioned_fk_3" violates foreign key constraint "fk_partitioned_fk_a_b_fkey"
-DETAIL: Key (a, b)=(2502, 2503) is not present in table "fk_notpartitioned_pk".
-INSERT INTO fk_partitioned_fk_3 (a, b) VALUES (2502, 2503);
-ERROR: insert or update on table "fk_partitioned_fk_3" violates foreign key constraint "fk_partitioned_fk_a_b_fkey"
-DETAIL: Key (a, b)=(2502, 2503) is not present in table "fk_notpartitioned_pk".
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/foreign_key.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg...
--- /Users/admin/pgsql/src/test/regress/expected/foreign_key.out 2025-06-30 22:40:13
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/foreign_key.out 2025-06-30 22:43:36
@@ -958,2451 +958,10 @@
-- As does this
CREATE TABLE FKTABLE (ftest1 int, ftest2 inet, FOREIGN KEY(ftest1, ftest2) REFERENCES pktable(ptest1, ptest2));
DROP TABLE FKTABLE;
-DROP TABLE PKTABLE;
--- Two columns, same table
--- Make sure this still works...
-CREATE TABLE PKTABLE (ptest1 int, ptest2 inet, ptest3 int, ptest4 inet, PRIMARY KEY(ptest1, ptest2), FOREIGN KEY(ptest3...
-ptest4) REFERENCES pktable(ptest1, ptest2));
-DROP TABLE PKTABLE;
--- And this,
-CREATE TABLE PKTABLE (ptest1 int, ptest2 inet, ptest3 int, ptest4 inet, PRIMARY KEY(ptest1, ptest2), FOREIGN KEY(ptest3...
-ptest4) REFERENCES pktable);
-DROP TABLE PKTABLE;
--- This shouldn't (mixed up columns)
-CREATE TABLE PKTABLE (ptest1 int, ptest2 inet, ptest3 int, ptest4 inet, PRIMARY KEY(ptest1, ptest2), FOREIGN KEY(ptest3...
-ptest4) REFERENCES pktable(ptest2, ptest1));
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/foreign_key.out /Users/admin/pgsql/build/testrun/recovery/027_stre...
--- /Users/admin/pgsql/src/test/regress/expected/foreign_key.out 2025-06-30 22:40:13
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/foreign_key.out 2025-06-30 22:44:53
@@ -179,3230 +179,10 @@
UPDATE FKTABLE SET ftest1 = 1 WHERE ftest1 = 1;
-- Try altering the column type where foreign keys are involved
ALTER TABLE PKTABLE ALTER COLUMN ptest1 TYPE bigint;
-ALTER TABLE FKTABLE ALTER COLUMN ftest1 TYPE bigint;
-SELECT * FROM PKTABLE;
- ptest1 | ptest2 | ptest3
---------+--------+---------
- 1 | 3 | Test1-2
- 3 | 6 | Test3
- 4 | 8 | Test4
- 1 | 4 | Test2
-(4 rows)
-
-SELECT * FROM FKTABLE;
- ftest1 | ftest2 | ftest3
---------+--------+--------
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/dependency.out /Users/admin/pgsql/build/testrun/regress/regress/re...
--- /Users/admin/pgsql/src/test/regress/expected/dependency.out 2025-06-30 22:40:13
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/dependency.out 2025-06-30 22:43:36
@@ -115,39 +115,11 @@
RESET SESSION AUTHORIZATION;
REASSIGN OWNED BY regress_dep_user1 TO regress_dep_user2;
+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.
\dt deptest
- List of tables
- Schema | Name | Type | Owner
---------+---------+-------+-------------------
- public | deptest | table | regress_dep_user2
-(1 row)
-
-SELECT typowner = relowner
-FROM pg_type JOIN pg_class c ON typrelid = c.oid WHERE typname = 'deptest_t';
- ?column?
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/foreign_key.out C:/cirrus/build/testrun/pg_upgrade/002_...
--- C:/cirrus/src/test/regress/expected/foreign_key.out 2025-06-30 22:41:05.772119000 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/foreign_key.out 2025-06-30 22:44:46.476306600 +0000
@@ -3350,59 +3350,10 @@
Number of partitions: 1 (Use \d+ to list them.)
INSERT INTO fk_r VALUES (1, 1, 1);
-INSERT INTO fk_r VALUES (2, 2, 1);
-ERROR: insert or update on table "fk_r_2_1" violates foreign key constraint "fk_r_p_id_p_jd_fkey"
-DETAIL: Key (p_id, p_jd)=(2, 1) is not present in table "fk_p".
-ALTER TABLE fk_r DETACH PARTITION fk_r_1;
-ALTER TABLE fk_r DETACH PARTITION fk_r_2;
-\d fk_r_2
- Partitioned table "fkpart12.fk_r_2"
- Column | Type | Collation | Nullable | Default
---------+---------+-----------+----------+---------
- id | integer | | not null |
- p_id | integer | | not null |
- p_jd | integer | | not null |
-Partition key: LIST (id)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/foreign_key.out C:/cirrus/build/testrun/recovery/027_st...
--- C:/cirrus/src/test/regress/expected/foreign_key.out 2025-06-30 22:41:05.772119000 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/foreign_key.out 2025-06-30 22:47:24.811220700 +0000
@@ -2567,842 +2567,7 @@
create table fk_part (a int, constraint fkey foreign key (a) references fkpart2.pkey) partition by list (a)
create table fk_part_1 partition of fkpart2.fk_part for values in (1) partition by list (a)
create table fk_part_1_1 (a int, constraint my_fkey foreign key (a) references fkpart2.pkey);
-alter table fkpart2.fk_part_1 attach partition fkpart2.fk_part_1_1 for values in (1);
-alter table fkpart2.fk_part_1 drop constraint fkey; -- should fail
-ERROR: cannot drop inherited constraint "fkey" of relation "fk_part_1"
-alter table fkpart2.fk_part_1_1 drop constraint my_fkey; -- should fail
-ERROR: cannot drop inherited constraint "my_fkey" of relation "fk_part_1_1"
-alter table fkpart2.fk_part detach partition fkpart2.fk_part_1;
-alter table fkpart2.fk_part_1 drop constraint fkey; -- ok
-alter table fkpart2.fk_part_1_1 drop constraint my_fkey; -- doesn't exist
-ERROR: constraint "my_fkey" of relation "fk_part_1_1" does not exist
--- verify constraint deferrability
-create schema fkpart3
- create table pkey (a int primary key)
- create table fk_part (a int, constraint fkey foreign key (a) references fkpart3.pkey deferrable initially immediate) ...
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/guc.out C:/cirrus/build/testrun/regress/regress/results...
--- C:/cirrus/src/test/regress/expected/guc.out 2025-06-30 22:41:05.779057200 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/guc.out 2025-06-30 22:44:46.064149200 +0000
@@ -929,35 +929,7 @@
(1 row)
SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1'; --fail
-ERROR: invalid value for parameter "log_min_messages": "checkpointer:debug2, autovacuum:debug1"
-DETAIL: Generic log level was not defined.
-SET log_min_messages TO 'debug1, backend:error, fatal'; -- fail
-ERROR: invalid value for parameter "log_min_messages": "debug1, backend:error, fatal"
-DETAIL: Generic log level was already assigned.
-SET log_min_messages TO 'backend:error, foo:fatal, archiver:debug1'; -- fail
-ERROR: invalid value for parameter "log_min_messages": "backend:error, foo:fatal, archiver:debug1"
-DETAIL: Unrecognized backend type: "foo".
-SET log_min_messages TO 'backend:error, checkpointer:bar, archiver:debug1'; -- fail
-ERROR: invalid value for parameter "log_min_messages": "backend:error, checkpointer:bar, archiver:debug1"
-DETAIL: Unrecognized log level: "bar".
-SET log_min_messages TO 'backend:error, checkpointer:debug3, fatal, archiver:debug2, autovacuum:debug1, walsender:debug...
-SHOW log_min_messages;
... |
| 53/5829 |
VCI (columnar store extension) |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/vci/expected/vci.out /tmp/cirrus-ci-build/build/testrun/vci/regress/results/vci.ou...
--- /tmp/cirrus-ci-build/contrib/vci/expected/vci.out 2025-06-26 18:33:14.463971640 +0000
+++ /tmp/cirrus-ci-build/build/testrun/vci/regress/results/vci.out 2025-06-26 18:40:42.724031030 +0000
@@ -88,39 +88,7 @@
INSERT INTO testtable (key, cond, c01a, c01b, c02, c03, c05, c06, c07, c08, c09, c10, c13, c15, c16, c17, c18, c19, c20...
-- Create an index which uses VCI index access method
CREATE INDEX testindex ON testtable USING vci (key, cond, c01a, c01b, c02, c03, c05, c06, c07, c08, c09, c10, c13, c15,...
--- We expect VCI plans are chosen here
-EXPLAIN (ANALYZE, TIMING OFF, COSTS OFF, SUMMARY OFF, BUFFERS OFF)
-SELECT key, count(*) AS count_star, count(c05) AS count_c05 FROM testtable WHERE NOT cond = 0 GROUP BY key ORDER BY key...
- QUERY PLAN
-------------------------------------------------------------------------------------------------
- Sort (actual rows=14.00 loops=1)
- Sort Key: key
- Sort Method: quicksort Memory: 25kB
- -> Custom Scan (VCI HashAggregate) (actual rows=14.00 loops=1)
- Group Key: key
- -> Custom Scan (VCI Scan) using testindex on testtable (actual rows=10221.00 loops=1)
- Filter: (cond <> 0)
- Rows Removed by Filter: 476
... |
| 52/5357 |
New predefined role pg_manage_extensions |
|
FreeBSD - 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 2025-04-08 05:52:49.895051000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plperl/regress/results/plperl_setup.out 2025-04-08 05:55:30.722340000 +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: Must be superuser or member of pg_manage_extensions 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: Must be superuser or member of pg_manage_extensions 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 2025-04-08 05:52:46.976426862 +0000
+++ /tmp/cirrus-ci-build/src/pl/plperl/results/plperl_setup.out 2025-04-08 05:56:27.370216753 +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: Must be superuser or member of pg_manage_extensions 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: Must be superuser or member of pg_manage_extensions 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 2025-04-08 05:52:49.092847353 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plperl/regress/results/plperl_setup.out 2025-04-08 05:58:59.307821334 +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: Must be superuser or member of pg_manage_extensions 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: Must be superuser or member of pg_manage_extensions 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 2025-04-08 05:52:09
+++ /Users/admin/pgsql/build/testrun/plperl/regress/results/plperl_setup.out 2025-04-08 05:55:24
@@ -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: Must be superuser or member of pg_manage_extensions 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: Must be superuser or member of pg_manage_extensions 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 2025-04-08 05:52:52.129960500 +0000
+++ C:/cirrus/build/testrun/plperl/regress/results/plperl_setup.out 2025-04-08 05:59:01.945179700 +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: Must be superuser or member of pg_manage_extensions 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: Must be superuser or member of pg_manage_extensions to create this extension.
CREATE SCHEMA plperl_setup_scratch;
SET search_path = plperl_setup_scratch;
... |
| 53/5597 |
Warn, and disallow, clear text passwords via SQL |
|
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/recovery/027_stre...
--- C:/cirrus/src/test/regress/expected/subselect.out 2025-04-04 13:43:52.629221600 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2025-04-04 13:49:17.277677700 +0000
@@ -2769,15 +2769,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}'::oid[]))
-(6 rows)
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (c.oid = a.oid)
... |
| 52/5607 |
SIMD optimization for list_sort |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/list_sort_simd.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade...
--- /tmp/cirrus-ci-build/src/test/regress/expected/list_sort_simd.out 2025-04-01 16:35:00.638454000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/list_sort_simd.out 2025-04-01 16:38:43.495...
@@ -26,62 +26,62 @@
(1 row)
SELECT test_list_sort_simd_float_random(100, 20, 2, true);
- test_list_sort_simd_float_random
-------------------------------------------------------------------------------------------------------------------
- {0.024923936,0.03346995,0.08167228,0.08531265,0.10674526,0.114986524,0.11994517,0.1355998,0.13572839,0.16894749}
+ test_list_sort_simd_float_random ...
+-----------------------------------------------------------------------------------------------------------------------...
+ {0.003372915,0.0034219418,0.013631644,0.019021165,0.030820394,0.031393025,0.057282537,0.0827536,0.090136975,0.09039178...
(1 row)
SELECT test_list_sort_simd_float_random(2, 20, 2, true);
test_list_sort_simd_float_random
----------------------------------
- {0.03346995,0.32996422}
+ {0.34728608,2}
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/list_sort_simd.out /tmp/cirrus-ci-build/build/testrun/recovery/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/list_sort_simd.out 2025-04-01 16:35:00.638454000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/list_sort_simd.out 2025-04-01 16:39:55.8...
@@ -26,62 +26,62 @@
(1 row)
SELECT test_list_sort_simd_float_random(100, 20, 2, true);
- test_list_sort_simd_float_random
-------------------------------------------------------------------------------------------------------------------
- {0.024923936,0.03346995,0.08167228,0.08531265,0.10674526,0.114986524,0.11994517,0.1355998,0.13572839,0.16894749}
+ test_list_sort_simd_float_random ...
+-----------------------------------------------------------------------------------------------------------------------...
+ {0.003372915,0.0034219418,0.013631644,0.019021165,0.030820394,0.031393025,0.057282537,0.0827536,0.090136975,0.09039178...
(1 row)
SELECT test_list_sort_simd_float_random(2, 20, 2, true);
test_list_sort_simd_float_random
----------------------------------
- {0.03346995,0.32996422}
+ {0.34728608,2}
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/list_sort_simd.out /tmp/cirrus-ci-build/build/testrun/regress/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/list_sort_simd.out 2025-04-01 16:35:00.638454000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/list_sort_simd.out 2025-04-01 16:38:52.282775000 +0000
@@ -26,62 +26,62 @@
(1 row)
SELECT test_list_sort_simd_float_random(100, 20, 2, true);
- test_list_sort_simd_float_random
-------------------------------------------------------------------------------------------------------------------
- {0.024923936,0.03346995,0.08167228,0.08531265,0.10674526,0.114986524,0.11994517,0.1355998,0.13572839,0.16894749}
+ test_list_sort_simd_float_random ...
+-----------------------------------------------------------------------------------------------------------------------...
+ {0.003372915,0.0034219418,0.013631644,0.019021165,0.030820394,0.031393025,0.057282537,0.0827536,0.090136975,0.09039178...
(1 row)
SELECT test_list_sort_simd_float_random(2, 20, 2, true);
test_list_sort_simd_float_random
----------------------------------
- {0.03346995,0.32996422}
+ {0.34728608,2}
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/list_sort_simd.out /Users/admin/pgsql/build/testrun/pg_upgrade/002...
--- /Users/admin/pgsql/src/test/regress/expected/list_sort_simd.out 2025-04-01 16:34:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/list_sort_simd.out 2025-04-01 16:37:11
@@ -26,62 +26,62 @@
(1 row)
SELECT test_list_sort_simd_float_random(100, 20, 2, true);
- test_list_sort_simd_float_random
-------------------------------------------------------------------------------------------------------------------
- {0.024923936,0.03346995,0.08167228,0.08531265,0.10674526,0.114986524,0.11994517,0.1355998,0.13572839,0.16894749}
+ test_list_sort_simd_float_random
+-----------------------------------------------------------------------------------------------------------------------
+ {0.0003287075,0.012317667,0.023025734,0.02969798,0.052807085,0.06473413,0.08912913,0.09746116,0.10345733,0.103527315}
(1 row)
SELECT test_list_sort_simd_float_random(2, 20, 2, true);
test_list_sort_simd_float_random
----------------------------------
- {0.03346995,0.32996422}
+ {0.0003287075,0.5245871}
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/list_sort_simd.out /Users/admin/pgsql/build/testrun/recovery/027_s...
--- /Users/admin/pgsql/src/test/regress/expected/list_sort_simd.out 2025-04-01 16:34:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/list_sort_simd.out 2025-04-01 16:38:10
@@ -26,62 +26,62 @@
(1 row)
SELECT test_list_sort_simd_float_random(100, 20, 2, true);
- test_list_sort_simd_float_random
-------------------------------------------------------------------------------------------------------------------
- {0.024923936,0.03346995,0.08167228,0.08531265,0.10674526,0.114986524,0.11994517,0.1355998,0.13572839,0.16894749}
+ test_list_sort_simd_float_random
+-----------------------------------------------------------------------------------------------------------------------
+ {0.0003287075,0.012317667,0.023025734,0.02969798,0.052807085,0.06473413,0.08912913,0.09746116,0.10345733,0.103527315}
(1 row)
SELECT test_list_sort_simd_float_random(2, 20, 2, true);
test_list_sort_simd_float_random
----------------------------------
- {0.03346995,0.32996422}
+ {0.0003287075,0.5245871}
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/list_sort_simd.out /Users/admin/pgsql/build/testrun/regress/regres...
--- /Users/admin/pgsql/src/test/regress/expected/list_sort_simd.out 2025-04-01 16:34:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/list_sort_simd.out 2025-04-01 16:37:13
@@ -26,62 +26,62 @@
(1 row)
SELECT test_list_sort_simd_float_random(100, 20, 2, true);
- test_list_sort_simd_float_random
-------------------------------------------------------------------------------------------------------------------
- {0.024923936,0.03346995,0.08167228,0.08531265,0.10674526,0.114986524,0.11994517,0.1355998,0.13572839,0.16894749}
+ test_list_sort_simd_float_random
+-----------------------------------------------------------------------------------------------------------------------
+ {0.0003287075,0.012317667,0.023025734,0.02969798,0.052807085,0.06473413,0.08912913,0.09746116,0.10345733,0.103527315}
(1 row)
SELECT test_list_sort_simd_float_random(2, 20, 2, true);
test_list_sort_simd_float_random
----------------------------------
- {0.03346995,0.32996422}
+ {0.0003287075,0.5245871}
... |
| 53/5318 |
System views for versions reporting |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-03-29 19:52:26.329748026 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2025-03-29 20:03:08.956984...
@@ -235,15 +235,7 @@
-- At least 4 core versions should be present, architecture, ICU, core and
-- compiler
select count(*) >= 4 as ok FROM pg_system_versions;
- ok
-----
- t
-(1 row)
-
--- There is always some number of shared objects
-select count(*) > 0 as ok FROM pg_system_libraries;
- ok
-----
- t
-(1 row)
-
+server closed the connection unexpectedly
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_table_like.out /tmp/cirrus-ci-build/build-32/testrun/reco...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_table_like.out 2025-03-29 19:52:26.249748024 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/recovery/027_stream_regress/data/results/create_table_like.out 2025-03-29 20:0...
@@ -320,352 +320,10 @@
-- including storage and comments
CREATE TABLE ctlt1 (a text CHECK (length(a) > 2) ENFORCED PRIMARY KEY,
b text CHECK (length(b) > 100) NOT ENFORCED);
-CREATE INDEX ctlt1_b_key ON ctlt1 (b);
-CREATE INDEX ctlt1_fnidx ON ctlt1 ((a || b));
-CREATE STATISTICS ctlt1_a_b_stat ON a,b FROM ctlt1;
-CREATE STATISTICS ctlt1_expr_stat ON (a || b) FROM ctlt1;
-COMMENT ON STATISTICS ctlt1_a_b_stat IS 'ab stats';
-COMMENT ON STATISTICS ctlt1_expr_stat IS 'ab expr stats';
-COMMENT ON COLUMN ctlt1.a IS 'A';
-COMMENT ON COLUMN ctlt1.b IS 'B';
-COMMENT ON CONSTRAINT ctlt1_a_check ON ctlt1 IS 't1_a_check';
-COMMENT ON INDEX ctlt1_pkey IS 'index pkey';
-COMMENT ON INDEX ctlt1_b_key IS 'index b_key';
-ALTER TABLE ctlt1 ALTER COLUMN a SET STORAGE MAIN;
-CREATE TABLE ctlt2 (c text);
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build-32/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-03-29 19:52:26.329748026 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/sysviews.out 2025-03-29 20:03:07.568985214 +0000
@@ -235,15 +235,7 @@
-- At least 4 core versions should be present, architecture, ICU, core and
-- compiler
select count(*) >= 4 as ok FROM pg_system_versions;
- ok
-----
- t
-(1 row)
-
--- There is always some number of shared objects
-select count(*) > 0 as ok FROM pg_system_libraries;
- ok
-----
- t
-(1 row)
-
+server closed the connection unexpectedly
... |
| 52/5595 |
Track and display estimated "work_mem" as well as limit, via EXPLAIN (work_mem on); add hook to override work_mem limits; add extension to override using "workmem.query_work_mem" GUC |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out 2025-03-16 11:18:10.400187000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/foreign_key.out 2025-03-16 11:22:05.426737...
@@ -2882,279 +2882,10 @@
DETAIL: Key (f1)=(-2) is still referenced from table "tbl4".
BEGIN;
UPDATE fkpart10.tbl3 SET f1 = f1 * -1;
-UPDATE fkpart10.tbl1 SET f1 = 3 WHERE f1 = 0;
-INSERT INTO fkpart10.tbl1 VALUES (0);
-INSERT INTO fkpart10.tbl3 VALUES (-2), (-1);
-COMMIT;
--- test where the updated table now has both an IMMEDIATE and a DEFERRED
--- constraint pointing into it
-CREATE TABLE fkpart10.tbl5(f1 int REFERENCES fkpart10.tbl3);
-INSERT INTO fkpart10.tbl5 VALUES (-2), (-1);
-BEGIN;
-UPDATE fkpart10.tbl3 SET f1 = f1 * -3;
-ERROR: update or delete on table "tbl3" violates foreign key constraint "tbl5_f1_fkey" on table "tbl5"
-DETAIL: Key (f1)=(-2) is still referenced from table "tbl5".
-COMMIT;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out 2025-03-16 11:18:10.400187000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/foreign_key.out 2025-03-16 11:22:58.4645...
@@ -1997,1164 +1997,10 @@
-- this one has an FK with mismatched properties
\d fk_partitioned_fk_4_2
- Table "public.fk_partitioned_fk_4_2"
- Column | Type | Collation | Nullable | Default
---------+---------+-----------+----------+---------
- a | integer | | |
- b | integer | | |
-Partition of: fk_partitioned_fk_4 FOR VALUES FROM (100, 100) TO (1000, 1000)
-Foreign-key constraints:
- "fk_partitioned_fk_4_2_a_b_fkey" FOREIGN KEY (a, b) REFERENCES fk_notpartitioned_pk(a, b) ON UPDATE SET NULL
- TABLE "fk_partitioned_fk" CONSTRAINT "fk_partitioned_fk_a_b_fkey" FOREIGN KEY (a, b) REFERENCES fk_notpartitioned_p...
-
-CREATE TABLE fk_partitioned_fk_5 (a int, b int,
- FOREIGN KEY (a, b) REFERENCES fk_notpartitioned_pk(a, b) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE,
- FOREIGN KEY (a, b) REFERENCES fk_notpartitioned_pk(a, b) MATCH FULL ON UPDATE CASCADE ON DELETE CASCADE)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tsearch.out /tmp/cirrus-ci-build/build/testrun/regress/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tsearch.out 2025-03-16 11:18:10.468490000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/tsearch.out 2025-03-16 11:22:20.226998000 +0000
@@ -1292,1723 +1292,10 @@
-- ts_debug
SELECT * from ts_debug('english', '<myns:foo-bar_baz.blurfl>abc&nm1;def©ghiõjkl</myns:foo-bar_baz.blurfl>');
- alias | description | token | dictionaries | dictionary | lexemes
------------+-----------------+----------------------------+----------------+--------------+---------
- tag | XML tag | <myns:foo-bar_baz.blurfl> | {} | |
- asciiword | Word, all ASCII | abc | {english_stem} | english_stem | {abc}
- entity | XML entity | &nm1; | {} | |
- asciiword | Word, all ASCII | def | {english_stem} | english_stem | {def}
- entity | XML entity | © | {} | |
- asciiword | Word, all ASCII | ghi | {english_stem} | english_stem | {ghi}
- entity | XML entity | õ | {} | |
- asciiword | Word, all ASCII | jkl | {english_stem} | english_stem | {jkl}
- tag | XML tag | </myns:foo-bar_baz.blurfl> | {} | |
-(9 rows)
-
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/workmem/expected/workmem.out /tmp/cirrus-ci-build/contrib/workmem/results/workmem....
--- /tmp/cirrus-ci-build/contrib/workmem/expected/workmem.out 2025-03-16 11:18:06.941606890 +0000
+++ /tmp/cirrus-ci-build/contrib/workmem/results/workmem.out 2025-03-16 11:24:27.285959208 +0000
@@ -30,9 +30,10 @@
from (values (1, 1), (2, 2)) as t (a, b) where a = b
group by grouping sets((a, b), (a));
');
- workmem_filter
-----------------------------------------------------------------------
+ workmem_filter
+--------------------------------------------------------------------------------------------
WindowAgg (work_mem=N kB limit=25600 kB)
+ Window: w1 AS (ORDER BY "*VALUES*".column1, "*VALUES*".column2 ROWS UNBOUNDED PRECEDING)
-> Sort (work_mem=N kB limit=25600 kB)
Sort Key: "*VALUES*".column1, "*VALUES*".column2 NULLS FIRST
-> HashAggregate (work_mem=N kB limit=51200 kB)
@@ -42,7 +43,7 @@
Filter: (column1 = column2)
Total Working Memory: N kB
Total Working Memory Limit: 102400 kB
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/workmem.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/workmem.out 2025-03-16 11:18:08.750696852 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/workmem.out 2025-03-16 11:25:39.979299380 +0000
@@ -207,9 +207,10 @@
from (values (1, 1), (2, 2)) as t (a, b) where a = b
group by grouping sets((a, b), (a));
');
- workmem_filter
-----------------------------------------------------------------------
+ workmem_filter
+--------------------------------------------------------------------------------------------
WindowAgg (work_mem=N kB limit=4096 kB)
+ Window: w1 AS (ORDER BY "*VALUES*".column1, "*VALUES*".column2 ROWS UNBOUNDED PRECEDING)
-> Sort (work_mem=N kB limit=4096 kB)
Sort Key: "*VALUES*".column1, "*VALUES*".column2 NULLS FIRST
-> HashAggregate (work_mem=N kB limit=8192 kB)
@@ -219,7 +220,7 @@
Filter: (column1 = column2)
Total Working Memory: N kB
Total Working Memory Limit: 16384 kB
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/workmem.out /tmp/cirrus-ci-build/src/test/regress/results/workme...
--- /tmp/cirrus-ci-build/src/test/regress/expected/workmem.out 2025-03-16 11:18:08.750696852 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/workmem.out 2025-03-16 11:23:54.557455409 +0000
@@ -207,9 +207,10 @@
from (values (1, 1), (2, 2)) as t (a, b) where a = b
group by grouping sets((a, b), (a));
');
- workmem_filter
-----------------------------------------------------------------------
+ workmem_filter
+--------------------------------------------------------------------------------------------
WindowAgg (work_mem=N kB limit=4096 kB)
+ Window: w1 AS (ORDER BY "*VALUES*".column1, "*VALUES*".column2 ROWS UNBOUNDED PRECEDING)
-> Sort (work_mem=N kB limit=4096 kB)
Sort Key: "*VALUES*".column1, "*VALUES*".column2 NULLS FIRST
-> HashAggregate (work_mem=N kB limit=8192 kB)
@@ -219,7 +220,7 @@
Filter: (column1 = column2)
Total Working Memory: N kB
Total Working Memory Limit: 16384 kB
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/workmem.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/workmem.out 2025-03-16 11:18:08.353234581 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/workmem.out 2025-03-16 11:24:02.384806845 ...
@@ -207,9 +207,10 @@
from (values (1, 1), (2, 2)) as t (a, b) where a = b
group by grouping sets((a, b), (a));
');
- workmem_filter
-----------------------------------------------------------------------
+ workmem_filter
+--------------------------------------------------------------------------------------------
WindowAgg (work_mem=N kB limit=4096 kB)
+ Window: w1 AS (ORDER BY "*VALUES*".column1, "*VALUES*".column2 ROWS UNBOUNDED PRECEDING)
-> Sort (work_mem=N kB limit=4096 kB)
Sort Key: "*VALUES*".column1, "*VALUES*".column2 NULLS FIRST
-> HashAggregate (work_mem=N kB limit=8192 kB)
@@ -219,7 +220,7 @@
Filter: (column1 = column2)
Total Working Memory: N kB
Total Working Memory Limit: 16384 kB
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/workmem.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/workmem.out 2025-03-16 11:18:08.353234581 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/workmem.out 2025-03-16 11:24:38.84077715...
@@ -207,9 +207,10 @@
from (values (1, 1), (2, 2)) as t (a, b) where a = b
group by grouping sets((a, b), (a));
');
- workmem_filter
-----------------------------------------------------------------------
+ workmem_filter
+--------------------------------------------------------------------------------------------
WindowAgg (work_mem=N kB limit=4096 kB)
+ Window: w1 AS (ORDER BY "*VALUES*".column1, "*VALUES*".column2 ROWS UNBOUNDED PRECEDING)
-> Sort (work_mem=N kB limit=4096 kB)
Sort Key: "*VALUES*".column1, "*VALUES*".column2 NULLS FIRST
-> HashAggregate (work_mem=N kB limit=8192 kB)
@@ -219,7 +220,7 @@
Filter: (column1 = column2)
Total Working Memory: N kB
Total Working Memory Limit: 16384 kB
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/workmem.out /tmp/cirrus-ci-build/build/testrun/regress/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/workmem.out 2025-03-16 11:18:08.353234581 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/workmem.out 2025-03-16 11:23:55.444814941 +0000
@@ -207,9 +207,10 @@
from (values (1, 1), (2, 2)) as t (a, b) where a = b
group by grouping sets((a, b), (a));
');
- workmem_filter
-----------------------------------------------------------------------
+ workmem_filter
+--------------------------------------------------------------------------------------------
WindowAgg (work_mem=N kB limit=4096 kB)
+ Window: w1 AS (ORDER BY "*VALUES*".column1, "*VALUES*".column2 ROWS UNBOUNDED PRECEDING)
-> Sort (work_mem=N kB limit=4096 kB)
Sort Key: "*VALUES*".column1, "*VALUES*".column2 NULLS FIRST
-> HashAggregate (work_mem=N kB limit=8192 kB)
@@ -219,7 +220,7 @@
Filter: (column1 = column2)
Total Working Memory: N kB
Total Working Memory Limit: 16384 kB
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/workmem.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upg...
--- /Users/admin/pgsql/src/test/regress/expected/workmem.out 2025-03-16 11:18:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/workmem.out 2025-03-16 11:21:05
@@ -207,9 +207,10 @@
from (values (1, 1), (2, 2)) as t (a, b) where a = b
group by grouping sets((a, b), (a));
');
- workmem_filter
-----------------------------------------------------------------------
+ workmem_filter
+--------------------------------------------------------------------------------------------
WindowAgg (work_mem=N kB limit=4096 kB)
+ Window: w1 AS (ORDER BY "*VALUES*".column1, "*VALUES*".column2 ROWS UNBOUNDED PRECEDING)
-> Sort (work_mem=N kB limit=4096 kB)
Sort Key: "*VALUES*".column1, "*VALUES*".column2 NULLS FIRST
-> HashAggregate (work_mem=N kB limit=8192 kB)
@@ -219,7 +220,7 @@
Filter: (column1 = column2)
Total Working Memory: N kB
Total Working Memory Limit: 16384 kB
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/workmem.out /Users/admin/pgsql/build/testrun/recovery/027_stream_r...
--- /Users/admin/pgsql/src/test/regress/expected/workmem.out 2025-03-16 11:18:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/workmem.out 2025-03-16 11:21:48
@@ -207,9 +207,10 @@
from (values (1, 1), (2, 2)) as t (a, b) where a = b
group by grouping sets((a, b), (a));
');
- workmem_filter
-----------------------------------------------------------------------
+ workmem_filter
+--------------------------------------------------------------------------------------------
WindowAgg (work_mem=N kB limit=4096 kB)
+ Window: w1 AS (ORDER BY "*VALUES*".column1, "*VALUES*".column2 ROWS UNBOUNDED PRECEDING)
-> Sort (work_mem=N kB limit=4096 kB)
Sort Key: "*VALUES*".column1, "*VALUES*".column2 NULLS FIRST
-> HashAggregate (work_mem=N kB limit=8192 kB)
@@ -219,7 +220,7 @@
Filter: (column1 = column2)
Total Working Memory: N kB
Total Working Memory Limit: 16384 kB
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/workmem.out /Users/admin/pgsql/build/testrun/regress/regress/resul...
--- /Users/admin/pgsql/src/test/regress/expected/workmem.out 2025-03-16 11:18:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/workmem.out 2025-03-16 11:21:05
@@ -207,9 +207,10 @@
from (values (1, 1), (2, 2)) as t (a, b) where a = b
group by grouping sets((a, b), (a));
');
- workmem_filter
-----------------------------------------------------------------------
+ workmem_filter
+--------------------------------------------------------------------------------------------
WindowAgg (work_mem=N kB limit=4096 kB)
+ Window: w1 AS (ORDER BY "*VALUES*".column1, "*VALUES*".column2 ROWS UNBOUNDED PRECEDING)
-> Sort (work_mem=N kB limit=4096 kB)
Sort Key: "*VALUES*".column1, "*VALUES*".column2 NULLS FIRST
-> HashAggregate (work_mem=N kB limit=8192 kB)
@@ -219,7 +220,7 @@
Filter: (column1 = column2)
Total Working Memory: N kB
Total Working Memory Limit: 16384 kB
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/workmem.out C:/cirrus/build/testrun/pg_upgrade/002_pg_u...
--- C:/cirrus/src/test/regress/expected/workmem.out 2025-03-16 11:18:13.944986300 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/workmem.out 2025-03-16 11:21:44.325758300 +0000
@@ -207,9 +207,10 @@
from (values (1, 1), (2, 2)) as t (a, b) where a = b
group by grouping sets((a, b), (a));
');
- workmem_filter
-----------------------------------------------------------------------
+ workmem_filter
+--------------------------------------------------------------------------------------------
WindowAgg (work_mem=N kB limit=4096 kB)
+ Window: w1 AS (ORDER BY "*VALUES*".column1, "*VALUES*".column2 ROWS UNBOUNDED PRECEDING)
-> Sort (work_mem=N kB limit=4096 kB)
Sort Key: "*VALUES*".column1, "*VALUES*".column2 NULLS FIRST
-> HashAggregate (work_mem=N kB limit=8192 kB)
@@ -219,7 +220,7 @@
Filter: (column1 = column2)
Total Working Memory: N kB
Total Working Memory Limit: 16384 kB
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/workmem.out C:/cirrus/build/testrun/recovery/027_stream...
--- C:/cirrus/src/test/regress/expected/workmem.out 2025-03-16 11:18:13.944986300 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/workmem.out 2025-03-16 11:23:55.806713400 +0000
@@ -207,9 +207,10 @@
from (values (1, 1), (2, 2)) as t (a, b) where a = b
group by grouping sets((a, b), (a));
');
- workmem_filter
-----------------------------------------------------------------------
+ workmem_filter
+--------------------------------------------------------------------------------------------
WindowAgg (work_mem=N kB limit=4096 kB)
+ Window: w1 AS (ORDER BY "*VALUES*".column1, "*VALUES*".column2 ROWS UNBOUNDED PRECEDING)
-> Sort (work_mem=N kB limit=4096 kB)
Sort Key: "*VALUES*".column1, "*VALUES*".column2 NULLS FIRST
-> HashAggregate (work_mem=N kB limit=8192 kB)
@@ -219,7 +220,7 @@
Filter: (column1 = column2)
Total Working Memory: N kB
Total Working Memory Limit: 16384 kB
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/workmem.out C:/cirrus/build/testrun/regress/regress/res...
--- C:/cirrus/src/test/regress/expected/workmem.out 2025-03-16 11:18:13.944986300 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/workmem.out 2025-03-16 11:21:39.294519000 +0000
@@ -207,9 +207,10 @@
from (values (1, 1), (2, 2)) as t (a, b) where a = b
group by grouping sets((a, b), (a));
');
- workmem_filter
-----------------------------------------------------------------------
+ workmem_filter
+--------------------------------------------------------------------------------------------
WindowAgg (work_mem=N kB limit=4096 kB)
+ Window: w1 AS (ORDER BY "*VALUES*".column1, "*VALUES*".column2 ROWS UNBOUNDED PRECEDING)
-> Sort (work_mem=N kB limit=4096 kB)
Sort Key: "*VALUES*".column1, "*VALUES*".column2 NULLS FIRST
-> HashAggregate (work_mem=N kB limit=8192 kB)
@@ -219,7 +220,7 @@
Filter: (column1 = column2)
Total Working Memory: N kB
Total Working Memory Limit: 16384 kB
... |
| 53/5614 |
Metadata and record block access stats for indexes |
|
Linux - Debian Bookworm - Meson |
| regress |
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 2025-03-15 11:59:57.447415198 +0000
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/inplace.out 2025-03-15 12:05:38.943494138 +000...
@@ -47,294 +47,6 @@
starting permutation: begin2 grant2 vac1 c2 vac3 mkrels3 read1
-mkrels
-------
-
-(1 row)
-
-injection_points_attach
------------------------
-
-(1 row)
-
-step begin2: BEGIN;
-step grant2: GRANT SELECT ON TABLE vactest.orig50 TO PUBLIC;
-step vac1: VACUUM vactest.orig50; -- wait during inplace update <waiting ...>
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_up...
--- /tmp/cirrus-ci-build/src/test/regress/expected/join.out 2025-03-15 11:59:57.576041004 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/join.out 2025-03-15 12:04:57.350621971 +00...
@@ -8729,635 +8729,7 @@
join fkest f2 on (f1.x = f2.x and f1.x10 = f2.x10b and f1.x100 = f2.x100)
join fkest f3 on f1.x = f3.x
where f1.x100 = 2;
- QUERY PLAN
------------------------------------------------------------
- Nested Loop
- -> Hash Join
- Hash Cond: ((f2.x = f1.x) AND (f2.x10b = f1.x10))
- -> Seq Scan on fkest f2
- Filter: (x100 = 2)
- -> Hash
- -> Seq Scan on fkest f1
- Filter: (x100 = 2)
- -> Index Scan using fkest_x_x10_x100_idx on fkest f3
- Index Cond: (x = f1.x)
-(10 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/test_setup.out /tmp/cirrus-ci-build/build/testrun/recovery/027_s...
--- /tmp/cirrus-ci-build/src/test/regress/expected/test_setup.out 2025-03-15 11:59:57.632314794 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/test_setup.out 2025-03-15 12:05:08.70680...
@@ -176,66 +176,7 @@
COPY road FROM :'filename';
VACUUM ANALYZE road;
CREATE TABLE ihighway () INHERITS (road);
-INSERT INTO ihighway
- SELECT *
- FROM ONLY road
- WHERE name ~ 'I- .*';
-VACUUM ANALYZE ihighway;
-CREATE TABLE shighway (
- surface text
-) INHERITS (road);
-INSERT INTO shighway
- SELECT *, 'asphalt'
- FROM ONLY road
- WHERE name ~ 'State Hwy.*';
-VACUUM ANALYZE shighway;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/interval.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/interval.out 2025-03-15 11:59:57.572021447 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/interval.out 2025-03-15 12:04:38.134440516 +0000
@@ -381,1948 +381,7 @@
(1 row)
SELECT f1 FROM INTERVAL_TBL_OF r1 ORDER BY f1;
- f1
--------------------------------------------
- -178956970 years -8 mons -2147483648 days
- -178956970 years -8 mons +2147483647 days
- 1 year
- 178956970 years 7 mons -2147483648 days
- 178956970 years 7 mons 2147483647 days
-(5 rows)
-
-RESET enable_seqscan;
--- subtracting about-to-overflow values should result in 0
-SELECT f1 - f1 FROM INTERVAL_TBL_OF;
- ?column?
... |
| 52/5525 |
explain plans for foreign servers |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/explain.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/explain.out 2025-02-26 20:18:51.484936000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/explain.out 2025-02-26 20:21:31.102750000 ...
@@ -400,29 +400,9 @@
"Actual Total Time": N.N, +
"Actual Rows": N, +
"Actual Loops": N, +
- "Disabled": false, +
- "Shared Hit Blocks": N, +
- "Shared Read Blocks": N, +
- "Shared Dirtied Blocks": N, +
- "Shared Written Blocks": N, +
- "Local Hit Blocks": N, +
- "Local Read Blocks": N, +
- "Local Dirtied Blocks": N, +
- "Local Written Blocks": N, +
- "Temp Read Blocks": N, +
- "Temp Written Blocks": N +
+ "Disabled": false +
}, +
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-02-26 20:18:49.994196000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2025-02-26 20:22:11.365595000 +0000
@@ -2,7 +2,14 @@
-- create FDW objects
-- ===================================================================
CREATE EXTENSION postgres_fdw;
+ERROR: could not load library "/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/lib/postgres_fdw.so": /tmp/cirru...
+CONTEXT: SQL statement "CREATE FUNCTION postgres_fdw_handler()
+RETURNS fdw_handler
+AS '$libdir/postgres_fdw'
+LANGUAGE C STRICT"
+extension script file "postgres_fdw--1.0.sql", near line 6
CREATE SERVER testserver1 FOREIGN DATA WRAPPER postgres_fdw;
+ERROR: foreign-data wrapper "postgres_fdw" does not exist
DO $d$
BEGIN
EXECUTE $$CREATE SERVER loopback FOREIGN DATA WRAPPER postgres_fdw
@@ -19,11 +26,21 @@
)$$;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/explain.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/explain.out 2025-02-26 20:18:51.484936000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/explain.out 2025-02-26 20:22:18.44812200...
@@ -400,29 +400,9 @@
"Actual Total Time": N.N, +
"Actual Rows": N, +
"Actual Loops": N, +
- "Disabled": false, +
- "Shared Hit Blocks": N, +
- "Shared Read Blocks": N, +
- "Shared Dirtied Blocks": N, +
- "Shared Written Blocks": N, +
- "Local Hit Blocks": N, +
- "Local Read Blocks": N, +
- "Local Dirtied Blocks": N, +
- "Local Written Blocks": N, +
- "Temp Read Blocks": N, +
- "Temp Written Blocks": N +
+ "Disabled": false +
}, +
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/explain.out /tmp/cirrus-ci-build/build/testrun/regress/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/explain.out 2025-02-26 20:18:51.484936000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/explain.out 2025-02-26 20:21:28.496857000 +0000
@@ -400,29 +400,9 @@
"Actual Total Time": N.N, +
"Actual Rows": N, +
"Actual Loops": N, +
- "Disabled": false, +
- "Shared Hit Blocks": N, +
- "Shared Read Blocks": N, +
- "Shared Dirtied Blocks": N, +
- "Shared Written Blocks": N, +
- "Local Hit Blocks": N, +
- "Local Read Blocks": N, +
- "Local Dirtied Blocks": N, +
- "Local Written Blocks": N, +
- "Temp Read Blocks": N, +
- "Temp Written Blocks": N +
+ "Disabled": false +
}, +
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/explain.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/explain.out 2025-02-26 20:18:50.386126207 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/explain.out 2025-02-26 20:24:06.764659668 ...
@@ -400,29 +400,9 @@
"Actual Total Time": N.N, +
"Actual Rows": N, +
"Actual Loops": N, +
- "Disabled": false, +
- "Shared Hit Blocks": N, +
- "Shared Read Blocks": N, +
- "Shared Dirtied Blocks": N, +
- "Shared Written Blocks": N, +
- "Local Hit Blocks": N, +
- "Local Read Blocks": N, +
- "Local Dirtied Blocks": N, +
- "Local Written Blocks": N, +
- "Temp Read Blocks": N, +
- "Temp Written Blocks": N +
+ "Disabled": false +
}, +
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-02-26 20:18:48.575308071 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2025-02-26 20:24:29.325355865 +0000
@@ -2,7 +2,14 @@
-- create FDW objects
-- ===================================================================
CREATE EXTENSION postgres_fdw;
+ERROR: could not load library "/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/lib/x86_64-linux-gnu/postgres_fd...
+CONTEXT: SQL statement "CREATE FUNCTION postgres_fdw_handler()
+RETURNS fdw_handler
+AS '$libdir/postgres_fdw'
+LANGUAGE C STRICT"
+extension script file "postgres_fdw--1.0.sql", near line 6
CREATE SERVER testserver1 FOREIGN DATA WRAPPER postgres_fdw;
+ERROR: foreign-data wrapper "postgres_fdw" does not exist
DO $d$
BEGIN
EXECUTE $$CREATE SERVER loopback FOREIGN DATA WRAPPER postgres_fdw
@@ -19,11 +26,21 @@
)$$;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/explain.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/explain.out 2025-02-26 20:18:50.386126207 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/explain.out 2025-02-26 20:24:44.00589676...
@@ -400,29 +400,9 @@
"Actual Total Time": N.N, +
"Actual Rows": N, +
"Actual Loops": N, +
- "Disabled": false, +
- "Shared Hit Blocks": N, +
- "Shared Read Blocks": N, +
- "Shared Dirtied Blocks": N, +
- "Shared Written Blocks": N, +
- "Local Hit Blocks": N, +
- "Local Read Blocks": N, +
- "Local Dirtied Blocks": N, +
- "Local Written Blocks": N, +
- "Temp Read Blocks": N, +
- "Temp Written Blocks": N +
+ "Disabled": false +
}, +
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/explain.out /tmp/cirrus-ci-build/build/testrun/regress/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/explain.out 2025-02-26 20:18:50.386126207 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/explain.out 2025-02-26 20:24:02.568552566 +0000
@@ -400,29 +400,9 @@
"Actual Total Time": N.N, +
"Actual Rows": N, +
"Actual Loops": N, +
- "Disabled": false, +
- "Shared Hit Blocks": N, +
- "Shared Read Blocks": N, +
- "Shared Dirtied Blocks": N, +
- "Shared Written Blocks": N, +
- "Local Hit Blocks": N, +
- "Local Read Blocks": N, +
- "Local Dirtied Blocks": N, +
- "Local Written Blocks": N, +
- "Temp Read Blocks": N, +
- "Temp Written Blocks": N +
+ "Disabled": false +
}, +
... |
| 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 2025-02-01 02:38:28.566114000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_stat_statements/regress/results/level_tracking.out 2025-02-01 02:41:07.0340200...
@@ -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 2025-02-01 02:38:28.410197114 +0000
+++ /tmp/cirrus-ci-build/contrib/pg_stat_statements/results/level_tracking.out 2025-02-01 02:43:52.556550480 +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 2025-02-01 02:38:29.263760882 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_stat_statements/regress/results/level_tracking.out 2025-02-01 02:43:31.7688094...
@@ -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 2025-02-01 02:45:11
+++ /Users/admin/pgsql/build/testrun/pg_stat_statements/regress/results/level_tracking.out 2025-02-01 02:50:53
@@ -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 2025-02-01 02:38:29.023790600 +0000
+++ C:/cirrus/build/testrun/pg_stat_statements/regress/results/level_tracking.out 2025-02-01 02:45:10.947490000 +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/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 2025-02-01 01:49:23.500703000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/ecpg/ecpg/results/connect-test5.stderr 2025-02-01 01:52:15.611475000 +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 2025-02-01 01:49:20.015261848 +0000
+++ /tmp/cirrus-ci-build/src/interfaces/ecpg/test/results/connect-test5.stderr 2025-02-01 01:51:24.157005816 +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 2025-02-01 01:49:18.536829002 +0000
+++ /tmp/cirrus-ci-build/build/testrun/ecpg/ecpg/results/connect-test5.stderr 2025-02-01 01:52:49.741836860 +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/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 2025-02-01 00:26:18.955607478 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/pgstattuple/regress/results/pgstattuple.out 2025-02-01 00:34:33.819519131 +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/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 2025-01-31 22:47:15.913050000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/hstore/regress/results/hstore.out 2025-01-31 22:49:29.533569000 +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 2025-01-31 22:47:17.453576000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonb.out 2025-01-31 22:48:50.480975000 +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 2025-01-31 22:47:17.453576000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/jsonb.out 2025-01-31 22:49:38.224223000 ...
@@ -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 2025-01-31 22:47:17.453576000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/jsonb.out 2025-01-31 22:48:52.261387000 +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 2025-01-31 22:47:13.594812974 +0000
+++ /tmp/cirrus-ci-build/contrib/hstore/results/hstore.out 2025-01-31 22:49:55.072732913 +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 2025-01-31 22:47:15.487227431 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/jsonb.out 2025-01-31 22:52:00.069083270 +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 2025-01-31 22:47:15.487227431 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/jsonb.out 2025-01-31 22:50:16.421560904 +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 2025-01-31 22:47:13.669986652 +0000
+++ /tmp/cirrus-ci-build/build/testrun/hstore/regress/results/hstore.out 2025-01-31 22:50:03.333232574 +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 2025-01-31 22:47:15.510288965 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonb.out 2025-01-31 22:49:37.797238657 +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 2025-01-31 22:47:15.510288965 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/jsonb.out 2025-01-31 22:50:15.785219578 ...
@@ -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 2025-01-31 22:47:15.510288965 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/jsonb.out 2025-01-31 22:49:31.593233529 +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 2025-01-31 22:58:12
+++ /Users/admin/pgsql/build/testrun/hstore/regress/results/hstore.out 2025-01-31 23:02:56
@@ -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 2025-01-31 22:58:15
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonb.out 2025-01-31 23:01:25
@@ -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 2025-01-31 22:58:15
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/jsonb.out 2025-01-31 23:03:03
@@ -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 2025-01-31 22:58:15
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/jsonb.out 2025-01-31 23:01:25
@@ -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 2025-01-31 22:47:14.429352200 +0000
+++ C:/cirrus/build/testrun/hstore/regress/results/hstore.out 2025-01-31 22:53:24.056520800 +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 2025-01-31 22:47:18.744331700 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonb.out 2025-01-31 22:50:57.101447400 +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 2025-01-31 22:47:18.744331700 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/jsonb.out 2025-01-31 22:53:25.986635700 +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 2025-01-31 22:47:18.744331700 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/jsonb.out 2025-01-31 22:50:40.910527100 +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
--------
... |
| 52/5129 |
Asynchronous MergeAppend Execution |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-01-29 17:55:01.116276000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2025-01-29 17:57:07.971658000...
@@ -172,7 +172,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(23 rows)
+(24 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-01-29 17:55:01.116276000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2025-01-29 17:57:53.7440780...
@@ -172,7 +172,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(23 rows)
+(24 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-01-29 17:55:01.116276000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/sysviews.out 2025-01-29 17:57:04.155082000 +0000
@@ -172,7 +172,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(23 rows)
+(24 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-01-29 17:54:57.373774839 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/sysviews.out 2025-01-29 18:02:32.894877293 +0000
@@ -172,7 +172,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(23 rows)
+(24 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-01-29 17:54:57.373774839 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/sysviews.out 2025-01-29 18:04:07.311500397 +0000
@@ -172,7 +172,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(23 rows)
+(24 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/src/test/regress/results/sysvi...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-01-29 17:54:57.373774839 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/sysviews.out 2025-01-29 17:59:28.715208055 +0000
@@ -172,7 +172,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(23 rows)
+(24 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-01-29 17:55:03.577484649 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2025-01-29 17:59:46.678253735...
@@ -172,7 +172,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(23 rows)
+(24 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-01-29 17:55:03.577484649 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2025-01-29 18:00:31.0985385...
@@ -172,7 +172,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(23 rows)
+(24 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-01-29 17:55:03.577484649 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/sysviews.out 2025-01-29 17:59:43.190248262 +0000
@@ -172,7 +172,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(23 rows)
+(24 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/sysviews.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/sysviews.out 2025-01-29 17:54:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2025-01-29 17:56:37
@@ -172,7 +172,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(23 rows)
+(24 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/sysviews.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/sysviews.out 2025-01-29 17:54:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2025-01-29 17:57:26
@@ -172,7 +172,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(23 rows)
+(24 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/sysviews.out /Users/admin/pgsql/build/testrun/regress/regress/resu...
--- /Users/admin/pgsql/src/test/regress/expected/sysviews.out 2025-01-29 17:54:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/sysviews.out 2025-01-29 17:56:35
@@ -172,7 +172,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(23 rows)
+(24 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/sysviews.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/sysviews.out 2025-01-29 17:55:06.702610200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2025-01-29 17:58:02.780137300 +0000
@@ -172,7 +172,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(23 rows)
+(24 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/sysviews.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/sysviews.out 2025-01-29 17:55:06.702610200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2025-01-29 18:00:16.798021400 +0000
@@ -172,7 +172,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(23 rows)
+(24 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/sysviews.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/sysviews.out 2025-01-29 17:55:06.702610200 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/sysviews.out 2025-01-29 17:57:58.185310500 +0000
@@ -172,7 +172,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(23 rows)
+(24 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| 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 2025-01-06 03:21:59.302064000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress-running/regress/results/privs_in_db.out 2025-01-06 03:27:58.458701000 +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 |