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.
| 55/5323 |
Support enabling checksums online |
 |
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/stats.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgra...
--- /Users/admin/pgsql/src/test/regress/expected/stats.out 2025-08-24 03:57:11
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/stats.out 2025-08-24 03:59:49
@@ -51,14 +51,6 @@
client backend|temp relation|normal
client backend|wal|init
client backend|wal|normal
-io worker|relation|bulkread
-io worker|relation|bulkwrite
-io worker|relation|init
-io worker|relation|normal
-io worker|relation|vacuum
-io worker|temp relation|normal
-io worker|wal|init
-io worker|wal|normal
datachecksumsworker launcher|relation|bulkread
datachecksumsworker launcher|relation|bulkwrite
datachecksumsworker launcher|relation|init
@@ -75,6 +67,14 @@
datachecksumsworker worker|temp relation|normal
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/stats.out /Users/admin/pgsql/build/testrun/recovery/027_stream_reg...
--- /Users/admin/pgsql/src/test/regress/expected/stats.out 2025-08-24 03:57:11
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/stats.out 2025-08-24 04:00:38
@@ -51,14 +51,6 @@
client backend|temp relation|normal
client backend|wal|init
client backend|wal|normal
-io worker|relation|bulkread
-io worker|relation|bulkwrite
-io worker|relation|init
-io worker|relation|normal
-io worker|relation|vacuum
-io worker|temp relation|normal
-io worker|wal|init
-io worker|wal|normal
datachecksumsworker launcher|relation|bulkread
datachecksumsworker launcher|relation|bulkwrite
datachecksumsworker launcher|relation|init
@@ -75,6 +67,14 @@
datachecksumsworker worker|temp relation|normal
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/stats.out /Users/admin/pgsql/build/testrun/regress/regress/results...
--- /Users/admin/pgsql/src/test/regress/expected/stats.out 2025-08-24 03:57:11
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/stats.out 2025-08-24 03:59:50
@@ -51,14 +51,6 @@
client backend|temp relation|normal
client backend|wal|init
client backend|wal|normal
-io worker|relation|bulkread
-io worker|relation|bulkwrite
-io worker|relation|init
-io worker|relation|normal
-io worker|relation|vacuum
-io worker|temp relation|normal
-io worker|wal|init
-io worker|wal|normal
datachecksumsworker launcher|relation|bulkread
datachecksumsworker launcher|relation|bulkwrite
datachecksumsworker launcher|relation|init
@@ -75,6 +67,14 @@
datachecksumsworker worker|temp relation|normal
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/stats.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upg...
--- C:/cirrus/src/test/regress/expected/stats.out 2025-08-24 03:58:07.273910600 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/stats.out 2025-08-24 04:02:47.089688000 +0000
@@ -51,14 +51,6 @@
client backend|temp relation|normal
client backend|wal|init
client backend|wal|normal
-io worker|relation|bulkread
-io worker|relation|bulkwrite
-io worker|relation|init
-io worker|relation|normal
-io worker|relation|vacuum
-io worker|temp relation|normal
-io worker|wal|init
-io worker|wal|normal
datachecksumsworker launcher|relation|bulkread
datachecksumsworker launcher|relation|bulkwrite
datachecksumsworker launcher|relation|init
@@ -75,6 +67,14 @@
datachecksumsworker worker|temp relation|normal
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/stats.out C:/cirrus/build/testrun/recovery/027_stream_r...
--- C:/cirrus/src/test/regress/expected/stats.out 2025-08-24 03:58:07.273910600 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/stats.out 2025-08-24 04:05:39.709296200 +0000
@@ -51,14 +51,6 @@
client backend|temp relation|normal
client backend|wal|init
client backend|wal|normal
-io worker|relation|bulkread
-io worker|relation|bulkwrite
-io worker|relation|init
-io worker|relation|normal
-io worker|relation|vacuum
-io worker|temp relation|normal
-io worker|wal|init
-io worker|wal|normal
datachecksumsworker launcher|relation|bulkread
datachecksumsworker launcher|relation|bulkwrite
datachecksumsworker launcher|relation|init
@@ -75,6 +67,14 @@
datachecksumsworker worker|temp relation|normal
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/stats.out C:/cirrus/build/testrun/regress/regress/resul...
--- C:/cirrus/src/test/regress/expected/stats.out 2025-08-24 03:58:07.273910600 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/stats.out 2025-08-24 04:02:40.585786200 +0000
@@ -51,14 +51,6 @@
client backend|temp relation|normal
client backend|wal|init
client backend|wal|normal
-io worker|relation|bulkread
-io worker|relation|bulkwrite
-io worker|relation|init
-io worker|relation|normal
-io worker|relation|vacuum
-io worker|temp relation|normal
-io worker|wal|init
-io worker|wal|normal
datachecksumsworker launcher|relation|bulkread
datachecksumsworker launcher|relation|bulkwrite
datachecksumsworker launcher|relation|init
@@ -75,6 +67,14 @@
datachecksumsworker worker|temp relation|normal
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/stats.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/stats.out 2025-08-24 03:58:05.318751578 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/stats.out 2025-08-24 04:04:36.953340286 +0...
@@ -51,14 +51,6 @@
client backend|temp relation|normal
client backend|wal|init
client backend|wal|normal
-io worker|relation|bulkread
-io worker|relation|bulkwrite
-io worker|relation|init
-io worker|relation|normal
-io worker|relation|vacuum
-io worker|temp relation|normal
-io worker|wal|init
-io worker|wal|normal
datachecksumsworker launcher|relation|bulkread
datachecksumsworker launcher|relation|bulkwrite
datachecksumsworker launcher|relation|init
@@ -75,6 +67,14 @@
datachecksumsworker worker|temp relation|normal
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/stats.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream...
--- /tmp/cirrus-ci-build/src/test/regress/expected/stats.out 2025-08-24 03:58:05.318751578 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/stats.out 2025-08-24 04:05:57.533262578 ...
@@ -51,14 +51,6 @@
client backend|temp relation|normal
client backend|wal|init
client backend|wal|normal
-io worker|relation|bulkread
-io worker|relation|bulkwrite
-io worker|relation|init
-io worker|relation|normal
-io worker|relation|vacuum
-io worker|temp relation|normal
-io worker|wal|init
-io worker|wal|normal
datachecksumsworker launcher|relation|bulkread
datachecksumsworker launcher|relation|bulkwrite
datachecksumsworker launcher|relation|init
@@ -75,6 +67,14 @@
datachecksumsworker worker|temp relation|normal
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/stats.out /tmp/cirrus-ci-build/build/testrun/regress/regress/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/stats.out 2025-08-24 03:58:05.318751578 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/stats.out 2025-08-24 04:04:33.109352108 +0000
@@ -51,14 +51,6 @@
client backend|temp relation|normal
client backend|wal|init
client backend|wal|normal
-io worker|relation|bulkread
-io worker|relation|bulkwrite
-io worker|relation|init
-io worker|relation|normal
-io worker|relation|vacuum
-io worker|temp relation|normal
-io worker|wal|init
-io worker|wal|normal
datachecksumsworker launcher|relation|bulkread
datachecksumsworker launcher|relation|bulkwrite
datachecksumsworker launcher|relation|init
@@ -75,6 +67,14 @@
datachecksumsworker worker|temp relation|normal
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/stats.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/stats.out 2025-08-24 03:58:04.692718000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/stats.out 2025-08-24 04:03:11.161557000 +0...
@@ -51,14 +51,6 @@
client backend|temp relation|normal
client backend|wal|init
client backend|wal|normal
-io worker|relation|bulkread
-io worker|relation|bulkwrite
-io worker|relation|init
-io worker|relation|normal
-io worker|relation|vacuum
-io worker|temp relation|normal
-io worker|wal|init
-io worker|wal|normal
datachecksumsworker launcher|relation|bulkread
datachecksumsworker launcher|relation|bulkwrite
datachecksumsworker launcher|relation|init
@@ -75,6 +67,14 @@
datachecksumsworker worker|temp relation|normal
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/stats.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream...
--- /tmp/cirrus-ci-build/src/test/regress/expected/stats.out 2025-08-24 03:58:04.692718000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/stats.out 2025-08-24 04:04:26.179093000 ...
@@ -51,14 +51,6 @@
client backend|temp relation|normal
client backend|wal|init
client backend|wal|normal
-io worker|relation|bulkread
-io worker|relation|bulkwrite
-io worker|relation|init
-io worker|relation|normal
-io worker|relation|vacuum
-io worker|temp relation|normal
-io worker|wal|init
-io worker|wal|normal
datachecksumsworker launcher|relation|bulkread
datachecksumsworker launcher|relation|bulkwrite
datachecksumsworker launcher|relation|init
@@ -75,6 +67,14 @@
datachecksumsworker worker|temp relation|normal
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/stats.out /tmp/cirrus-ci-build/build/testrun/regress/regress/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/stats.out 2025-08-24 03:58:04.692718000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/stats.out 2025-08-24 04:03:20.466321000 +0000
@@ -51,14 +51,6 @@
client backend|temp relation|normal
client backend|wal|init
client backend|wal|normal
-io worker|relation|bulkread
-io worker|relation|bulkwrite
-io worker|relation|init
-io worker|relation|normal
-io worker|relation|vacuum
-io worker|temp relation|normal
-io worker|wal|init
-io worker|wal|normal
datachecksumsworker launcher|relation|bulkread
datachecksumsworker launcher|relation|bulkwrite
datachecksumsworker launcher|relation|init
@@ -75,6 +67,14 @@
datachecksumsworker worker|temp relation|normal
... |
| 55/5189 |
Expose the acquired_by parameter to the pg_replication_origin_session_setup function |
|
FreeBSD - Meson |
| 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-08-24 00:38:11.365675000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2025-08-24 00:45:10.7654780...
@@ -12701,8 +12701,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | f | t
-(1 row)
+(0 rows)
-- After terminating the remote backend, since the connection is closed,
-- "closed" should be TRUE, or NULL if the connection status check
@@ -12718,8 +12717,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
... |
| 55/5985 |
CREATE SCHEMA ... CREATE DOMAIN support |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_schema.out C:/cirrus/build/testrun/pg_upgrade/00...
--- C:/cirrus/src/test/regress/expected/create_schema.out 2025-08-23 17:37:05.120825800 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_schema.out 2025-08-23 17:39:46.058565500 +0000
@@ -201,23 +201,23 @@
CREATE SCHEMA regress_schema_4 AUTHORIZATION CURRENT_ROLE
CREATE COLLATION regress_schema_4.coll_icu_und FROM "und-x-icu"
CREATE TABLE t(a TEXT COLLATE regress_schema_4.coll_icu_und);
+ERROR: collation "und-x-icu" for encoding "UTF8" does not exist
\dO regress_schema_4.*
- List of collations
- Schema | Name | Provider | Collate | Ctype | Locale | ICU Rules | Deterministic?
-------------------+--------------+----------+---------+-------+--------+-----------+----------------
- regress_schema_4 | coll_icu_und | icu | | | und | | yes
-(1 row)
+ List of collations
+ Schema | Name | Provider | Collate | Ctype | Locale | ICU Rules | Deterministic?
+--------+------+----------+---------+-------+--------+-----------+----------------
+(0 rows)
--ok, no qualified schema name for collation
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_schema.out C:/cirrus/build/testrun/recovery/027_...
--- C:/cirrus/src/test/regress/expected/create_schema.out 2025-08-23 17:37:05.120825800 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/create_schema.out 2025-08-23 17:42:16.710097200 +00...
@@ -194,30 +194,30 @@
CREATE SCHEMA regress_schema_4 AUTHORIZATION CURRENT_ROLE
CREATE TABLE tts(a TEXT COLLATE coll_icu_und)
CREATE COLLATION coll_icu_und FROM "und-x-icu";
-ERROR: collation "coll_icu_und" for encoding "UTF8" does not exist
+ERROR: collation "coll_icu_und" for encoding "WIN1252" does not exist
LINE 2: CREATE TABLE tts(a TEXT COLLATE coll_icu_und)
^
--ok, qualified schema name for domain should be same as the created schema
CREATE SCHEMA regress_schema_4 AUTHORIZATION CURRENT_ROLE
CREATE COLLATION regress_schema_4.coll_icu_und FROM "und-x-icu"
CREATE TABLE t(a TEXT COLLATE regress_schema_4.coll_icu_und);
+ERROR: collation "und-x-icu" for encoding "WIN1252" does not exist
\dO regress_schema_4.*
- List of collations
- Schema | Name | Provider | Collate | Ctype | Locale | ICU Rules | Deterministic?
-------------------+--------------+----------+---------+-------+--------+-----------+----------------
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_schema.out C:/cirrus/build/testrun/regress/regre...
--- C:/cirrus/src/test/regress/expected/create_schema.out 2025-08-23 17:37:05.120825800 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/create_schema.out 2025-08-23 17:39:36.778727300 +0000
@@ -194,30 +194,30 @@
CREATE SCHEMA regress_schema_4 AUTHORIZATION CURRENT_ROLE
CREATE TABLE tts(a TEXT COLLATE coll_icu_und)
CREATE COLLATION coll_icu_und FROM "und-x-icu";
-ERROR: collation "coll_icu_und" for encoding "UTF8" does not exist
+ERROR: collation "coll_icu_und" for encoding "WIN1252" does not exist
LINE 2: CREATE TABLE tts(a TEXT COLLATE coll_icu_und)
^
--ok, qualified schema name for domain should be same as the created schema
CREATE SCHEMA regress_schema_4 AUTHORIZATION CURRENT_ROLE
CREATE COLLATION regress_schema_4.coll_icu_und FROM "und-x-icu"
CREATE TABLE t(a TEXT COLLATE regress_schema_4.coll_icu_und);
+ERROR: collation "und-x-icu" for encoding "WIN1252" does not exist
\dO regress_schema_4.*
- List of collations
- Schema | Name | Provider | Collate | Ctype | Locale | ICU Rules | Deterministic?
-------------------+--------------+----------+---------+-------+--------+-----------+----------------
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/test_ddl_deparse/expected/create_schema.out C:/cirrus/build/test...
--- C:/cirrus/src/test/modules/test_ddl_deparse/expected/create_schema.out 2025-08-23 17:37:04.845985300 +0000
+++ C:/cirrus/build/testrun/test_ddl_deparse/regress/results/create_schema.out 2025-08-23 17:44:51.780097500 +0000
@@ -16,8 +16,4 @@
CREATE VIEW bar AS SELECT * FROM foo
CREATE DOMAIN d1 AS INT
CREATE COLLATION coll_icu_und FROM "und-x-icu";
-NOTICE: DDL test: type simple, tag CREATE SCHEMA
-NOTICE: DDL test: type simple, tag CREATE TABLE
-NOTICE: DDL test: type simple, tag CREATE VIEW
-NOTICE: DDL test: type simple, tag CREATE DOMAIN
-NOTICE: DDL test: type simple, tag CREATE COLLATION
+ERROR: collation "und-x-icu" for encoding "WIN1252" does not exist |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_schema.out /tmp/cirrus-ci-build/build-32/testrun/recovery...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_schema.out 2025-08-23 17:36:59.920873753 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/recovery/027_stream_regress/data/results/create_schema.out 2025-08-23 17:48:51...
@@ -194,30 +194,30 @@
CREATE SCHEMA regress_schema_4 AUTHORIZATION CURRENT_ROLE
CREATE TABLE tts(a TEXT COLLATE coll_icu_und)
CREATE COLLATION coll_icu_und FROM "und-x-icu";
-ERROR: collation "coll_icu_und" for encoding "UTF8" does not exist
+ERROR: collation "coll_icu_und" for encoding "SQL_ASCII" does not exist
LINE 2: CREATE TABLE tts(a TEXT COLLATE coll_icu_und)
^
--ok, qualified schema name for domain should be same as the created schema
CREATE SCHEMA regress_schema_4 AUTHORIZATION CURRENT_ROLE
CREATE COLLATION regress_schema_4.coll_icu_und FROM "und-x-icu"
CREATE TABLE t(a TEXT COLLATE regress_schema_4.coll_icu_und);
+ERROR: collation "und-x-icu" for encoding "SQL_ASCII" does not exist
\dO regress_schema_4.*
- List of collations
- Schema | Name | Provider | Collate | Ctype | Locale | ICU Rules | Deterministic?
-------------------+--------------+----------+---------+-------+--------+-----------+----------------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_schema.out /tmp/cirrus-ci-build/build-32/testrun/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_schema.out 2025-08-23 17:36:59.920873753 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/create_schema.out 2025-08-23 17:47:27.685401473 +0000
@@ -194,30 +194,30 @@
CREATE SCHEMA regress_schema_4 AUTHORIZATION CURRENT_ROLE
CREATE TABLE tts(a TEXT COLLATE coll_icu_und)
CREATE COLLATION coll_icu_und FROM "und-x-icu";
-ERROR: collation "coll_icu_und" for encoding "UTF8" does not exist
+ERROR: collation "coll_icu_und" for encoding "SQL_ASCII" does not exist
LINE 2: CREATE TABLE tts(a TEXT COLLATE coll_icu_und)
^
--ok, qualified schema name for domain should be same as the created schema
CREATE SCHEMA regress_schema_4 AUTHORIZATION CURRENT_ROLE
CREATE COLLATION regress_schema_4.coll_icu_und FROM "und-x-icu"
CREATE TABLE t(a TEXT COLLATE regress_schema_4.coll_icu_und);
+ERROR: collation "und-x-icu" for encoding "SQL_ASCII" does not exist
\dO regress_schema_4.*
- List of collations
- Schema | Name | Provider | Collate | Ctype | Locale | ICU Rules | Deterministic?
-------------------+--------------+----------+---------+-------+--------+-----------+----------------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/create_schema.out /tmp/cirrus-ci-build/build-32...
--- /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/create_schema.out 2025-08-23 17:36:59.829306813 +000...
+++ /tmp/cirrus-ci-build/build-32/testrun/test_ddl_deparse/regress/results/create_schema.out 2025-08-23 17:50:23.3498008...
@@ -16,8 +16,4 @@
CREATE VIEW bar AS SELECT * FROM foo
CREATE DOMAIN d1 AS INT
CREATE COLLATION coll_icu_und FROM "und-x-icu";
-NOTICE: DDL test: type simple, tag CREATE SCHEMA
-NOTICE: DDL test: type simple, tag CREATE TABLE
-NOTICE: DDL test: type simple, tag CREATE VIEW
-NOTICE: DDL test: type simple, tag CREATE DOMAIN
-NOTICE: DDL test: type simple, tag CREATE COLLATION
+ERROR: collation "und-x-icu" for encoding "SQL_ASCII" does not exist |
| 55/5923 |
Let plan_cache_mode to be a little less strict |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/plancache.out C:/cirrus/build/testrun/pg_upgrade/002_pg...
--- C:/cirrus/src/test/regress/expected/plancache.out 2025-08-23 17:08:12.939439000 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plancache.out 2025-08-23 17:12:23.084624800 +0000
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/plancache.out C:/cirrus/build/testrun/recovery/027_stre...
--- C:/cirrus/src/test/regress/expected/plancache.out 2025-08-23 17:08:12.939439000 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/plancache.out 2025-08-23 17:15:10.622290800 +0000
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/plancache.out C:/cirrus/build/testrun/regress/regress/r...
--- C:/cirrus/src/test/regress/expected/plancache.out 2025-08-23 17:08:12.939439000 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/plancache.out 2025-08-23 17:12:18.712571100 +0000
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/plancache.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_u...
--- /Users/admin/pgsql/src/test/regress/expected/plancache.out 2025-08-23 17:07:14
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plancache.out 2025-08-23 17:09:26
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/plancache.out /Users/admin/pgsql/build/testrun/recovery/027_stream...
--- /Users/admin/pgsql/src/test/regress/expected/plancache.out 2025-08-23 17:07:14
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/plancache.out 2025-08-23 17:10:17
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/plancache.out /Users/admin/pgsql/build/testrun/regress/regress/res...
--- /Users/admin/pgsql/src/test/regress/expected/plancache.out 2025-08-23 17:07:14
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/plancache.out 2025-08-23 17:09:29
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out 2025-08-23 17:08:07.798746881 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plancache.out 2025-08-23 17:10:38.40950859...
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out /tmp/cirrus-ci-build/build/testrun/recovery/027_st...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out 2025-08-23 17:08:07.798746881 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/plancache.out 2025-08-23 17:11:58.217432...
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out /tmp/cirrus-ci-build/build/testrun/regress/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out 2025-08-23 17:08:07.798746881 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/plancache.out 2025-08-23 17:10:34.905514064 +0000
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out 2025-08-23 17:08:06.860731060 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/plancache.out 2025-08-23 17:14:06.218982463 +0000
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out 2025-08-23 17:08:06.860731060 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/plancache.out 2025-08-23 17:16:05.680021859 +0000
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out /tmp/cirrus-ci-build/src/test/regress/results/plan...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out 2025-08-23 17:08:06.860731060 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/plancache.out 2025-08-23 17:11:32.331286741 +0000
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out 2025-08-23 17:08:08.955277000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plancache.out 2025-08-23 17:11:30.59231300...
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out /tmp/cirrus-ci-build/build/testrun/recovery/027_st...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out 2025-08-23 17:08:08.955277000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/plancache.out 2025-08-23 17:12:36.900803...
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out /tmp/cirrus-ci-build/build/testrun/regress/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plancache.out 2025-08-23 17:08:08.955277000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/plancache.out 2025-08-23 17:11:40.656171000 +0000
@@ -398,3 +398,36 @@
(1 row)
drop table test_mode;
+-- Check the interference between plan_cache_mode and cursor_options
+-- EXPLAIN (COSTS OFF, GENERIC_PLAN)
+SELECT prepare_spi_plan(NULL, NULL, NULL); -- ERROR
+ERROR: query text cannot be null
+SELECT prepare_spi_plan(
+ 'EXPLAIN (COSTS OFF) SELECT * FROM pcachetest WHERE q1 = $1',
+ NULL, 'integer') AS p1 \gset
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = $2',
+ NULL, 'integer', NULL); --ERROR
+ERROR: type name cannot be NULL
+SELECT prepare_spi_plan(
+ 'SELECT * FROM pcachetest WHERE q1 = $1 OR q1 = 3',
... |
| 55/5487 |
Exists pull-up application with JoinExpr |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subselect.out C:/cirrus/build/testrun/pg_upgrade/002_pg...
--- C:/cirrus/src/test/regress/expected/subselect.out 2025-08-23 07:47:57.667432200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2025-08-23 07:50:54.638624500 +0000
@@ -1115,8 +1115,7 @@
Hash Cond: (ta1.id = tb.aval)
-> Seq Scan on ta ta1
-> Hash
- -> HashAggregate
- Group Key: tb.aval
+ -> Unique
-> Merge Join
Merge Cond: (tb.aval = tc.aid)
-> Sort
@@ -1125,7 +1124,7 @@
-> Sort
Sort Key: tc.aid
-> Seq Scan on tc
-(14 rows)
+(13 rows)
... |
| 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-08-23 07:47:57.667432200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2025-08-23 07:53:26.224987300 +0000
@@ -1115,8 +1115,7 @@
Hash Cond: (ta1.id = tb.aval)
-> Seq Scan on ta ta1
-> Hash
- -> HashAggregate
- Group Key: tb.aval
+ -> Unique
-> Merge Join
Merge Cond: (tb.aval = tc.aid)
-> Sort
@@ -1125,7 +1124,7 @@
-> Sort
Sort Key: tc.aid
-> Seq Scan on tc
-(14 rows)
+(13 rows)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subselect.out C:/cirrus/build/testrun/regress/regress/r...
--- C:/cirrus/src/test/regress/expected/subselect.out 2025-08-23 07:47:57.667432200 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/subselect.out 2025-08-23 07:50:46.786080300 +0000
@@ -1115,8 +1115,7 @@
Hash Cond: (ta1.id = tb.aval)
-> Seq Scan on ta ta1
-> Hash
- -> HashAggregate
- Group Key: tb.aval
+ -> Unique
-> Merge Join
Merge Cond: (tb.aval = tc.aid)
-> Sort
@@ -1125,7 +1124,7 @@
-> Sort
Sort Key: tc.aid
-> Seq Scan on tc
-(14 rows)
+(13 rows)
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/subselect.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_u...
--- /Users/admin/pgsql/src/test/regress/expected/subselect.out 2025-08-23 07:47:11
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2025-08-23 07:49:13
@@ -1115,8 +1115,7 @@
Hash Cond: (ta1.id = tb.aval)
-> Seq Scan on ta ta1
-> Hash
- -> HashAggregate
- Group Key: tb.aval
+ -> Unique
-> Merge Join
Merge Cond: (tb.aval = tc.aid)
-> Sort
@@ -1125,7 +1124,7 @@
-> Sort
Sort Key: tc.aid
-> Seq Scan on tc
-(14 rows)
+(13 rows)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/subselect.out /Users/admin/pgsql/build/testrun/recovery/027_stream...
--- /Users/admin/pgsql/src/test/regress/expected/subselect.out 2025-08-23 07:47:11
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2025-08-23 07:50:08
@@ -1115,8 +1115,7 @@
Hash Cond: (ta1.id = tb.aval)
-> Seq Scan on ta ta1
-> Hash
- -> HashAggregate
- Group Key: tb.aval
+ -> Unique
-> Merge Join
Merge Cond: (tb.aval = tc.aid)
-> Sort
@@ -1125,7 +1124,7 @@
-> Sort
Sort Key: tc.aid
-> Seq Scan on tc
-(14 rows)
+(13 rows)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/subselect.out /Users/admin/pgsql/build/testrun/regress/regress/res...
--- /Users/admin/pgsql/src/test/regress/expected/subselect.out 2025-08-23 07:47:11
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/subselect.out 2025-08-23 07:49:12
@@ -1115,8 +1115,7 @@
Hash Cond: (ta1.id = tb.aval)
-> Seq Scan on ta ta1
-> Hash
- -> HashAggregate
- Group Key: tb.aval
+ -> Unique
-> Merge Join
Merge Cond: (tb.aval = tc.aid)
-> Sort
@@ -1125,7 +1124,7 @@
-> Sort
Sort Key: tc.aid
-> Seq Scan on tc
-(14 rows)
+(13 rows)
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-08-23 07:47:54.691567011 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2025-08-23 07:53:03.54988570...
@@ -1115,8 +1115,7 @@
Hash Cond: (ta1.id = tb.aval)
-> Seq Scan on ta ta1
-> Hash
- -> HashAggregate
- Group Key: tb.aval
+ -> Unique
-> Merge Join
Merge Cond: (tb.aval = tc.aid)
-> Sort
@@ -1125,7 +1124,7 @@
-> Sort
Sort Key: tc.aid
-> Seq Scan on tc
-(14 rows)
+(13 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/recovery/027_st...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-08-23 07:47:54.691567011 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2025-08-23 07:54:24.997849...
@@ -1115,8 +1115,7 @@
Hash Cond: (ta1.id = tb.aval)
-> Seq Scan on ta ta1
-> Hash
- -> HashAggregate
- Group Key: tb.aval
+ -> Unique
-> Merge Join
Merge Cond: (tb.aval = tc.aid)
-> Sort
@@ -1125,7 +1124,7 @@
-> Sort
Sort Key: tc.aid
-> Seq Scan on tc
-(14 rows)
+(13 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/regress/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-08-23 07:47:54.691567011 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/subselect.out 2025-08-23 07:53:00.049888916 +0000
@@ -1115,8 +1115,7 @@
Hash Cond: (ta1.id = tb.aval)
-> Seq Scan on ta ta1
-> Hash
- -> HashAggregate
- Group Key: tb.aval
+ -> Unique
-> Merge Join
Merge Cond: (tb.aval = tc.aid)
-> Sort
@@ -1125,7 +1124,7 @@
-> Sort
Sort Key: tc.aid
-> Seq Scan on tc
-(14 rows)
+(13 rows)
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-08-23 07:47:53.815534000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2025-08-23 07:50:08.49064500...
@@ -1115,8 +1115,7 @@
Hash Cond: (ta1.id = tb.aval)
-> Seq Scan on ta ta1
-> Hash
- -> HashAggregate
- Group Key: tb.aval
+ -> Unique
-> Merge Join
Merge Cond: (tb.aval = tc.aid)
-> Sort
@@ -1125,7 +1124,7 @@
-> Sort
Sort Key: tc.aid
-> Seq Scan on tc
-(14 rows)
+(13 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/recovery/027_st...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-08-23 07:47:53.815534000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2025-08-23 07:51:05.839331...
@@ -1115,8 +1115,7 @@
Hash Cond: (ta1.id = tb.aval)
-> Seq Scan on ta ta1
-> Hash
- -> HashAggregate
- Group Key: tb.aval
+ -> Unique
-> Merge Join
Merge Cond: (tb.aval = tc.aid)
-> Sort
@@ -1125,7 +1124,7 @@
-> Sort
Sort Key: tc.aid
-> Seq Scan on tc
-(14 rows)
+(13 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/regress/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-08-23 07:47:53.815534000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/subselect.out 2025-08-23 07:49:59.681400000 +0000
@@ -1115,8 +1115,7 @@
Hash Cond: (ta1.id = tb.aval)
-> Seq Scan on ta ta1
-> Hash
- -> HashAggregate
- Group Key: tb.aval
+ -> Unique
-> Merge Join
Merge Cond: (tb.aval = tc.aid)
-> Sort
@@ -1125,7 +1124,7 @@
-> Sort
Sort Key: tc.aid
-> Seq Scan on tc
-(14 rows)
+(13 rows)
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-08-23 07:47:54.371261310 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/subselect.out 2025-08-23 07:54:11.329770495 +0000
@@ -1115,8 +1115,7 @@
Hash Cond: (ta1.id = tb.aval)
-> Seq Scan on ta ta1
-> Hash
- -> HashAggregate
- Group Key: tb.aval
+ -> Unique
-> Merge Join
Merge Cond: (tb.aval = tc.aid)
-> Sort
@@ -1125,7 +1124,7 @@
-> Sort
Sort Key: tc.aid
-> Seq Scan on tc
-(14 rows)
+(13 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-08-23 07:47:54.371261310 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/subselect.out 2025-08-23 07:56:38.313791600 +0000
@@ -1115,8 +1115,7 @@
Hash Cond: (ta1.id = tb.aval)
-> Seq Scan on ta ta1
-> Hash
- -> HashAggregate
- Group Key: tb.aval
+ -> Unique
-> Merge Join
Merge Cond: (tb.aval = tc.aid)
-> Sort
@@ -1125,7 +1124,7 @@
-> Sort
Sort Key: tc.aid
-> Seq Scan on tc
-(14 rows)
+(13 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/src/test/regress/results/subs...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-08-23 07:47:54.371261310 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/subselect.out 2025-08-23 07:51:54.845849242 +0000
@@ -1115,8 +1115,7 @@
Hash Cond: (ta1.id = tb.aval)
-> Seq Scan on ta ta1
-> Hash
- -> HashAggregate
- Group Key: tb.aval
+ -> Unique
-> Merge Join
Merge Cond: (tb.aval = tc.aid)
-> Sort
@@ -1125,7 +1124,7 @@
-> Sort
Sort Key: tc.aid
-> Seq Scan on tc
-(14 rows)
+(13 rows)
... |
| 55/5841 |
Eliminate xl_heap_visible to reduce vacuum and COPY FREEZE WAL volume |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/isolation/expected/index-killtuples.out C:/cirrus/build/testrun/isolatio...
--- C:/cirrus/src/test/isolation/expected/index-killtuples.out 2025-08-23 06:22:25.561279300 +0000
+++ C:/cirrus/build/testrun/isolation/isolation/results/index-killtuples.out 2025-08-23 06:25:04.797927100 +0000
@@ -54,7 +54,7 @@
step result: SELECT heap_blks_read + heap_blks_hit - counter.heap_accesses AS new_heap_accesses FROM counter, pg_statio...
new_heap_accesses
-----------------
- 1
+ 2
(1 row)
step measure: UPDATE counter SET heap_accesses = (SELECT heap_blks_read + heap_blks_hit FROM pg_statio_all_tables WHERE...
@@ -130,7 +130,7 @@
step result: SELECT heap_blks_read + heap_blks_hit - counter.heap_accesses AS new_heap_accesses FROM counter, pg_statio...
new_heap_accesses
-----------------
- 1
+ 2
(1 row)
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/index-killtuples.out /tmp/cirrus-ci-build/build/testrun/isolat...
--- /tmp/cirrus-ci-build/src/test/isolation/expected/index-killtuples.out 2025-08-23 06:22:23.092473751 +0000
+++ /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/index-killtuples.out 2025-08-23 06:27:37.746666961 +0...
@@ -54,7 +54,7 @@
step result: SELECT heap_blks_read + heap_blks_hit - counter.heap_accesses AS new_heap_accesses FROM counter, pg_statio...
new_heap_accesses
-----------------
- 1
+ 2
(1 row)
step measure: UPDATE counter SET heap_accesses = (SELECT heap_blks_read + heap_blks_hit FROM pg_statio_all_tables WHERE...
@@ -130,7 +130,7 @@
step result: SELECT heap_blks_read + heap_blks_hit - counter.heap_accesses AS new_heap_accesses FROM counter, pg_statio...
new_heap_accesses
-----------------
- 1
+ 2
(1 row)
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/isolation/expected/index-killtuples.out /Users/admin/pgsql/build/testrun/isolation/...
--- /Users/admin/pgsql/src/test/isolation/expected/index-killtuples.out 2025-08-23 06:22:11
+++ /Users/admin/pgsql/build/testrun/isolation/isolation/results/index-killtuples.out 2025-08-23 06:24:27
@@ -54,7 +54,7 @@
step result: SELECT heap_blks_read + heap_blks_hit - counter.heap_accesses AS new_heap_accesses FROM counter, pg_statio...
new_heap_accesses
-----------------
- 1
+ 2
(1 row)
step measure: UPDATE counter SET heap_accesses = (SELECT heap_blks_read + heap_blks_hit FROM pg_statio_all_tables WHERE...
@@ -130,7 +130,7 @@
step result: SELECT heap_blks_read + heap_blks_hit - counter.heap_accesses AS new_heap_accesses FROM counter, pg_statio...
new_heap_accesses
-----------------
- 1
+ 2
(1 row)
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/index-killtuples.out /tmp/cirrus-ci-build/build/testrun/isolat...
--- /tmp/cirrus-ci-build/src/test/isolation/expected/index-killtuples.out 2025-08-23 06:22:21.164564000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/index-killtuples.out 2025-08-23 06:24:26.437057000 +0...
@@ -54,7 +54,7 @@
step result: SELECT heap_blks_read + heap_blks_hit - counter.heap_accesses AS new_heap_accesses FROM counter, pg_statio...
new_heap_accesses
-----------------
- 1
+ 2
(1 row)
step measure: UPDATE counter SET heap_accesses = (SELECT heap_blks_read + heap_blks_hit FROM pg_statio_all_tables WHERE...
@@ -130,7 +130,7 @@
step result: SELECT heap_blks_read + heap_blks_hit - counter.heap_accesses AS new_heap_accesses FROM counter, pg_statio...
new_heap_accesses
-----------------
- 1
+ 2
(1 row)
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/index-killtuples.out /tmp/cirrus-ci-build/src/test/isolation/o...
--- /tmp/cirrus-ci-build/src/test/isolation/expected/index-killtuples.out 2025-08-23 06:22:23.129642463 +0000
+++ /tmp/cirrus-ci-build/src/test/isolation/output_iso/results/index-killtuples.out 2025-08-23 06:27:50.033169517 +0000
@@ -54,7 +54,7 @@
step result: SELECT heap_blks_read + heap_blks_hit - counter.heap_accesses AS new_heap_accesses FROM counter, pg_statio...
new_heap_accesses
-----------------
- 1
+ 2
(1 row)
step measure: UPDATE counter SET heap_accesses = (SELECT heap_blks_read + heap_blks_hit FROM pg_statio_all_tables WHERE...
@@ -130,7 +130,7 @@
step result: SELECT heap_blks_read + heap_blks_hit - counter.heap_accesses AS new_heap_accesses FROM counter, pg_statio...
new_heap_accesses
-----------------
- 1
+ 2
(1 row)
... |
| 55/5755 |
Parallel processing of indexes in autovacuum |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/lock-update-delete.out /tmp/cirrus-ci-build/build/testrun/isol...
--- /tmp/cirrus-ci-build/src/test/isolation/expected/lock-update-delete.out 2025-08-23 05:04:12.392818377 +0000
+++ /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/lock-update-delete.out 2025-08-23 05:09:14.872723987 ...
@@ -47,239 +47,4 @@
starting permutation: s2b s1l s2u s2_blocker3 s2_unlock s2c
-pg_advisory_lock
-----------------
-
-(1 row)
-
-step s2b: BEGIN;
-step s1l: SELECT * FROM foo WHERE pg_advisory_xact_lock(0) IS NOT NULL AND key = 1 FOR KEY SHARE; <waiting ...>
-step s2u: UPDATE foo SET value = 2 WHERE key = 1;
-step s2_blocker3: UPDATE foo SET value = 2 WHERE key = 1;
-step s2_unlock: SELECT pg_advisory_unlock(0);
-pg_advisory_unlock
-------------------
-t
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out /tmp/cirrus-ci-build/build/testrun/pg_upgrad...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out 2025-08-23 05:04:12.659644580 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/vacuum_parallel.out 2025-08-23 05:09:31.63...
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2025-08-23 05:04:12.631767216 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2025-08-23 05:09:32.684761...
@@ -675,1276 +675,7 @@
ALTER PUBLICATION testpub6 SET TABLE rf_tbl_abcd_part_pk;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out /tmp/cirrus-ci-build/build/testrun/recovery/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out 2025-08-23 05:04:12.659644580 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/vacuum_parallel.out 2025-08-23 05:10:30....
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/maintain_every.out /tmp/cirrus-ci-build/build/testrun/recovery/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/maintain_every.out 2025-08-23 05:04:12.599907370 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/maintain_every.out 2025-08-23 05:10:30.9...
@@ -1,33 +1,2 @@
--- Test maintenance commands that visit every eligible relation. Run as a
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out /tmp/cirrus-ci-build/build/testrun/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out 2025-08-23 05:04:12.659644580 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/vacuum_parallel.out 2025-08-23 05:09:31.420758095 +0000
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2025-08-23 05:04:12.631767216 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/publication.out 2025-08-23 05:09:32.296760322 +0000
@@ -830,1121 +830,10 @@
ALTER TABLE testpub_tbl5d REPLICA IDENTITY FULL;
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/isolation/expected/lock-update-delete.out /Users/admin/pgsql/build/testrun/isolatio...
--- /Users/admin/pgsql/src/test/isolation/expected/lock-update-delete.out 2025-08-23 05:03:11
+++ /Users/admin/pgsql/build/testrun/isolation/isolation/results/lock-update-delete.out 2025-08-23 05:05:40
@@ -47,239 +47,4 @@
starting permutation: s2b s1l s2u s2_blocker3 s2_unlock s2c
-pg_advisory_lock
-----------------
-
-(1 row)
-
-step s2b: BEGIN;
-step s1l: SELECT * FROM foo WHERE pg_advisory_xact_lock(0) IS NOT NULL AND key = 1 FOR KEY SHARE; <waiting ...>
-step s2u: UPDATE foo SET value = 2 WHERE key = 1;
-step s2_blocker3: UPDATE foo SET value = 2 WHERE key = 1;
-step s2_unlock: SELECT pg_advisory_unlock(0);
-pg_advisory_unlock
-------------------
-t
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/vacuum_parallel.out /Users/admin/pgsql/build/testrun/pg_upgrade/00...
--- /Users/admin/pgsql/src/test/regress/expected/vacuum_parallel.out 2025-08-23 05:03:11
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/vacuum_parallel.out 2025-08-23 05:06:11
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /Users/admin/pgsql/src/test/regress/expected/maintain_every.out /Users/admin/pgsql/build/testrun/pg_upgrade/002...
--- /Users/admin/pgsql/src/test/regress/expected/maintain_every.out 2025-08-23 05:03:11
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/maintain_every.out 2025-08-23 05:06:11
@@ -1,33 +1,2 @@
--- Test maintenance commands that visit every eligible relation. Run as a
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/vacuum_parallel.out /Users/admin/pgsql/build/testrun/recovery/027_...
--- /Users/admin/pgsql/src/test/regress/expected/vacuum_parallel.out 2025-08-23 05:03:11
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/vacuum_parallel.out 2025-08-23 05:07:33
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /Users/admin/pgsql/src/test/regress/expected/maintain_every.out /Users/admin/pgsql/build/testrun/recovery/027_s...
--- /Users/admin/pgsql/src/test/regress/expected/maintain_every.out 2025-08-23 05:03:11
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/maintain_every.out 2025-08-23 05:07:33
@@ -1,33 +1,2 @@
--- Test maintenance commands that visit every eligible relation. Run as a
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/vacuum_parallel.out /Users/admin/pgsql/build/testrun/regress/regre...
--- /Users/admin/pgsql/src/test/regress/expected/vacuum_parallel.out 2025-08-23 05:03:11
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/vacuum_parallel.out 2025-08-23 05:06:11
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /Users/admin/pgsql/src/test/regress/expected/maintain_every.out /Users/admin/pgsql/build/testrun/regress/regres...
--- /Users/admin/pgsql/src/test/regress/expected/maintain_every.out 2025-08-23 05:03:11
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/maintain_every.out 2025-08-23 05:06:11
@@ -1,33 +1,2 @@
--- Test maintenance commands that visit every eligible relation. Run as a
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/isolation/expected/lock-update-traversal.out C:/cirrus/build/testrun/iso...
--- C:/cirrus/src/test/isolation/expected/lock-update-traversal.out 2025-08-23 05:04:17.251197400 +0000
+++ C:/cirrus/build/testrun/isolation/isolation/results/lock-update-traversal.out 2025-08-23 05:07:37.749542000 +0000
@@ -1,63 +1,6 @@
Parsed test spec with 2 sessions
starting permutation: s1b s2b s1s s2u s1l s2c s2d1 s1c
-step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ;
-step s2b: BEGIN;
-step s1s: SELECT * FROM foo;
-key|value
----+-----
- 1| 1
-(1 row)
-
-step s2u: UPDATE foo SET value = 2 WHERE key = 1;
-step s1l: SELECT * FROM foo FOR KEY SHARE;
-key|value
----+-----
- 1| 1
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/vacuum_parallel.out C:/cirrus/build/testrun/pg_upgrade/...
--- C:/cirrus/src/test/regress/expected/vacuum_parallel.out 2025-08-23 05:04:17.956772000 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/vacuum_parallel.out 2025-08-23 05:07:45.726113000 +00...
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/maintain_every.out C:/cirrus/build/testrun/pg_upgrade/0...
--- C:/cirrus/src/test/regress/expected/maintain_every.out 2025-08-23 05:04:17.872256800 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/maintain_every.out 2025-08-23 05:07:46.204141200 +000...
@@ -1,33 +1,2 @@
--- Test maintenance commands that visit every eligible relation. Run as a
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/vacuum_parallel.out C:/cirrus/build/testrun/recovery/02...
--- C:/cirrus/src/test/regress/expected/vacuum_parallel.out 2025-08-23 05:04:17.956772000 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/vacuum_parallel.out 2025-08-23 05:09:53.120334300 +...
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/maintain_every.out C:/cirrus/build/testrun/recovery/027...
--- C:/cirrus/src/test/regress/expected/maintain_every.out 2025-08-23 05:04:17.872256800 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/maintain_every.out 2025-08-23 05:09:53.612500100 +0...
@@ -1,33 +1,2 @@
--- Test maintenance commands that visit every eligible relation. Run as a
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/vacuum_parallel.out C:/cirrus/build/testrun/regress/reg...
--- C:/cirrus/src/test/regress/expected/vacuum_parallel.out 2025-08-23 05:04:17.956772000 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/vacuum_parallel.out 2025-08-23 05:07:38.521027100 +0000
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/maintain_every.out C:/cirrus/build/testrun/regress/regr...
--- C:/cirrus/src/test/regress/expected/maintain_every.out 2025-08-23 05:04:17.872256800 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/maintain_every.out 2025-08-23 05:07:39.134237000 +0000
@@ -1,33 +1,2 @@
--- Test maintenance commands that visit every eligible relation. Run as a
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/merge-insert-update.out /tmp/cirrus-ci-build/build/testrun/iso...
--- /tmp/cirrus-ci-build/src/test/isolation/expected/merge-insert-update.out 2025-08-23 05:04:11.673888000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/merge-insert-update.out 2025-08-23 05:07:04.801088000...
@@ -70,25 +70,6 @@
step c2: COMMIT;
starting permutation: delete1 insert1 merge2 c1 select2 c2
-step delete1: DELETE FROM target WHERE key = 1;
-step insert1: INSERT INTO target VALUES (1, 'insert1');
-step merge2: MERGE INTO target t USING (SELECT 1 as key, 'merge2' as val) s ON s.key = t.key WHEN NOT MATCHED THEN INSE...
-step c1: COMMIT;
-step merge2: <... completed>
-ERROR: duplicate key value violates unique constraint "target_pkey"
-step select2: SELECT * FROM target;
-ERROR: current transaction is aborted, commands ignored until end of transaction block
-step c2: COMMIT;
-
-starting permutation: delete1 insert1 merge2i c1 select2 c2
-step delete1: DELETE FROM target WHERE key = 1;
-step insert1: INSERT INTO target VALUES (1, 'insert1');
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out /tmp/cirrus-ci-build/build/testrun/pg_upgrad...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out 2025-08-23 05:04:11.855011000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/vacuum_parallel.out 2025-08-23 05:08:04.02...
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/maintain_every.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade...
--- /tmp/cirrus-ci-build/src/test/regress/expected/maintain_every.out 2025-08-23 05:04:11.812935000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/maintain_every.out 2025-08-23 05:08:04.046...
@@ -1,33 +1,3 @@
--- Test maintenance commands that visit every eligible relation. Run as a
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out /tmp/cirrus-ci-build/build/testrun/recovery/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out 2025-08-23 05:04:11.855011000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/vacuum_parallel.out 2025-08-23 05:09:02....
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/maintain_every.out /tmp/cirrus-ci-build/build/testrun/recovery/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/maintain_every.out 2025-08-23 05:04:11.812935000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/maintain_every.out 2025-08-23 05:09:02.3...
@@ -1,33 +1,3 @@
--- Test maintenance commands that visit every eligible relation. Run as a
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out /tmp/cirrus-ci-build/build/testrun/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out 2025-08-23 05:04:11.855011000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/vacuum_parallel.out 2025-08-23 05:08:16.471101000 +0000
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/maintain_every.out /tmp/cirrus-ci-build/build/testrun/regress/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/maintain_every.out 2025-08-23 05:04:11.812935000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/maintain_every.out 2025-08-23 05:08:16.484083000 +0000
@@ -1,33 +1 @@
--- Test maintenance commands that visit every eligible relation. Run as a
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out 2025-08-23 05:04:12.196682351 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/vacuum_parallel.out 2025-08-23 05:11:38.874998648 +0000
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_chec...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2025-08-23 05:04:12.168713582 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/publication.out 2025-08-23 05:11:39.578996008 +0000
@@ -1,1950 +1,3 @@
---
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/lock-update-delete.out /tmp/cirrus-ci-build/src/test/isolation...
--- /tmp/cirrus-ci-build/src/test/isolation/expected/lock-update-delete.out 2025-08-23 05:04:11.944972704 +0000
+++ /tmp/cirrus-ci-build/src/test/isolation/output_iso/results/lock-update-delete.out 2025-08-23 05:09:20.527449333 +000...
@@ -47,239 +47,4 @@
starting permutation: s2b s1l s2u s2_blocker3 s2_unlock s2c
-pg_advisory_lock
-----------------
-
-(1 row)
-
-step s2b: BEGIN;
-step s1l: SELECT * FROM foo WHERE pg_advisory_xact_lock(0) IS NOT NULL AND key = 1 FOR KEY SHARE; <waiting ...>
-step s2u: UPDATE foo SET value = 2 WHERE key = 1;
-step s2_blocker3: UPDATE foo SET value = 2 WHERE key = 1;
-step s2_unlock: SELECT pg_advisory_unlock(0);
-pg_advisory_unlock
-------------------
-t
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out /tmp/cirrus-ci-build/src/test/regress/result...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_parallel.out 2025-08-23 05:04:12.196682351 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/vacuum_parallel.out 2025-08-23 05:09:51.535368174 +0000
@@ -43,7 +43,7 @@
-- Since vacuum_in_leader_small_index uses deduplication, we expect an
-- assertion failure with bug #17245 (in the absence of bugfix):
INSERT INTO parallel_vacuum_table SELECT i FROM generate_series(1, 10000) i;
-RESET max_parallel_maintenance_workers;
-RESET min_parallel_index_scan_size;
--- Deliberately don't drop table, to get further coverage from tools like
--- pg_amcheck in some testing scenarios
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/src/test/regress/results/pu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2025-08-23 05:04:12.168713582 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/publication.out 2025-08-23 05:09:52.595365076 +0000
@@ -194,1757 +194,7 @@
(1 row)
... |
| 55/5588 |
Improvement of var_eq_non_const() |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/subselect.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_u...
--- /Users/admin/pgsql/src/test/regress/expected/subselect.out 2025-08-22 22:23:13
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2025-08-22 22:25:43
@@ -2865,13 +2865,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/subselect.out /Users/admin/pgsql/build/testrun/recovery/027_stream...
--- /Users/admin/pgsql/src/test/regress/expected/subselect.out 2025-08-22 22:23:13
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2025-08-22 22:27:05
@@ -2865,13 +2865,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/subselect.out /Users/admin/pgsql/build/testrun/regress/regress/res...
--- /Users/admin/pgsql/src/test/regress/expected/subselect.out 2025-08-22 22:23:13
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/subselect.out 2025-08-22 22:25:36
@@ -2865,13 +2865,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subselect.out C:/cirrus/build/testrun/pg_upgrade/002_pg...
--- C:/cirrus/src/test/regress/expected/subselect.out 2025-08-22 22:24:11.914149400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2025-08-22 22:27:11.932420600 +0000
@@ -2865,13 +2865,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| 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-08-22 22:24:11.914149400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2025-08-22 22:29:52.797645700 +0000
@@ -2865,13 +2865,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subselect.out C:/cirrus/build/testrun/regress/regress/r...
--- C:/cirrus/src/test/regress/expected/subselect.out 2025-08-22 22:24:11.914149400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/subselect.out 2025-08-22 22:27:02.699503500 +0000
@@ -2865,13 +2865,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-08-22 22:24:07.084453973 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2025-08-22 22:25:55.77876120...
@@ -2865,13 +2865,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/recovery/027_st...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-08-22 22:24:07.084453973 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2025-08-22 22:27:13.687768...
@@ -2865,13 +2865,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/regress/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-08-22 22:24:07.084453973 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/subselect.out 2025-08-22 22:25:53.082790423 +0000
@@ -2865,13 +2865,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-08-22 22:24:09.221062000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2025-08-22 22:25:50.95570900...
@@ -2865,13 +2865,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/recovery/027_st...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-08-22 22:24:09.221062000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2025-08-22 22:26:53.181291...
@@ -2865,13 +2865,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/regress/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-08-22 22:24:09.221062000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/subselect.out 2025-08-22 22:25:50.883039000 +0000
@@ -2865,13 +2865,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-08-22 22:24:07.002074034 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/subselect.out 2025-08-22 22:28:09.009557689 +0000
@@ -2865,13 +2865,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/src/test/regress/results/subs...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-08-22 22:24:07.002074034 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/subselect.out 2025-08-22 22:26:01.961642314 +0000
@@ -2865,13 +2865,15 @@
EXPLAIN (COSTS OFF)
SELECT * FROM onek, (VALUES('RFAAAA'), ('VJAAAA')) AS v (i)
WHERE onek.stringu1 = v.i;
- QUERY PLAN
--------------------------------------------------------------
+ QUERY PLAN
+-------------------------------------------------------------------
Nested Loop
-> Values Scan on "*VALUES*"
- -> Index Scan using onek_stringu1 on onek
- Index Cond: (stringu1 = ("*VALUES*".column1)::text)
-(4 rows)
+ -> Bitmap Heap Scan on onek
+ Recheck Cond: (stringu1 = ("*VALUES*".column1)::text)
+ -> Bitmap Index Scan on onek_stringu1
+ Index Cond: (stringu1 = ("*VALUES*".column1)::text)
... |
| 55/5357 |
New predefined role pg_manage_extensions |
|
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-08-22 22:22:12.560336800 +0000
+++ C:/cirrus/build/testrun/plperl/regress/results/plperl_setup.out 2025-08-22 22:29:08.505693400 +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-08-22 22:22:08
+++ /Users/admin/pgsql/build/testrun/plperl/regress/results/plperl_setup.out 2025-08-22 22:25:17
@@ -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-08-22 22:22:10.349958198 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plperl/regress/results/plperl_setup.out 2025-08-22 22:25:48.439541919 +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-08-22 22:22:09.688681962 +0000
+++ /tmp/cirrus-ci-build/src/pl/plperl/results/plperl_setup.out 2025-08-22 22:24:00.528512348 +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;
... |
|
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-08-22 22:22:11.113870000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plperl/regress/results/plperl_setup.out 2025-08-22 22:24:23.036007000 +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;
... |
| 55/5553 |
starjoin join order planning |
|
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-08-22 22:09:53.610661900 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2025-08-22 22:13:31.989504100 +0000
@@ -171,8 +171,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(24 rows)
+(25 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-08-22 22:09:53.610661900 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2025-08-22 22:16:38.589106600 +0000
@@ -171,8 +171,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(24 rows)
+(25 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-08-22 22:09:53.610661900 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/sysviews.out 2025-08-22 22:13:27.646730700 +0000
@@ -171,8 +171,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(24 rows)
+(25 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-08-22 22:09:13
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2025-08-22 22:12:42
@@ -171,8 +171,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(24 rows)
+(25 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-08-22 22:09:13
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2025-08-22 22:14:11
@@ -171,8 +171,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(24 rows)
+(25 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-08-22 22:09:13
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/sysviews.out 2025-08-22 22:12:43
@@ -171,8 +171,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(24 rows)
+(25 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-08-22 22:09:50.791130252 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2025-08-22 22:15:13.080135959...
@@ -171,8 +171,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(24 rows)
+(25 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-08-22 22:09:50.791130252 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2025-08-22 22:16:37.8713360...
@@ -171,8 +171,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(24 rows)
+(25 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-08-22 22:09:50.791130252 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/sysviews.out 2025-08-22 22:15:11.356089210 +0000
@@ -171,8 +171,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(24 rows)
+(25 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-08-22 22:09:50.420156076 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/sysviews.out 2025-08-22 22:18:43.132037635 +0000
@@ -171,8 +171,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(24 rows)
+(25 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-08-22 22:09:50.420156076 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/sysviews.out 2025-08-22 22:20:03.496079820 +0000
@@ -171,8 +171,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(24 rows)
+(25 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-08-22 22:09:50.420156076 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/sysviews.out 2025-08-22 22:14:57.820359694 +0000
@@ -171,8 +171,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(24 rows)
+(25 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
|
FreeBSD - 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-08-22 22:09:50.107498000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2025-08-22 22:12:40.464308000...
@@ -171,8 +171,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(24 rows)
+(25 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-08-22 22:09:50.107498000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2025-08-22 22:13:55.8328150...
@@ -171,8 +171,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(24 rows)
+(25 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-08-22 22:09:50.107498000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/sysviews.out 2025-08-22 22:12:39.334038000 +0000
@@ -171,8 +171,9 @@
enable_self_join_elimination | on
enable_seqscan | on
enable_sort | on
+ enable_starjoin_join_search | off
enable_tidscan | on
-(24 rows)
+(25 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| 55/5901 |
Proposal to allow DELETE/UPDATE on partitioned tables with unsupported foreign partitions |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/partition_info.out C:/cirrus/build/testrun/pg_upgrade/0...
--- C:/cirrus/src/test/regress/expected/partition_info.out 2025-08-22 22:09:01.002788000 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_info.out 2025-08-22 22:13:26.034402100 +000...
@@ -365,42 +365,26 @@
OPTIONS (format 'csv', filename :'filename', header 'false', delimiter ';', quote '@', escape '"', null '');
ALTER TABLE ptif_root ATTACH PARTITION agg_csv FOR VALUES FROM (10) TO (20);
SELECT * FROM ptif_root;
- a | b
------+---------
- 5 | 0.1
- 6 | 0.2
- 56 | 7.8
- 100 | 99.097
- 0 | 0.09561
- 42 | 324.78
-(6 rows)
-
+ERROR: could not open file "C:/cirrus/src/test/regress/data/agg.csv" for reading: No such file or directory
+HINT: COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as ps...
DELETE FROM ptif_root WHERE b = 0.1;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/partition_info.out C:/cirrus/build/testrun/recovery/027...
--- C:/cirrus/src/test/regress/expected/partition_info.out 2025-08-22 22:09:01.002788000 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/partition_info.out 2025-08-22 22:16:04.886948500 +0...
@@ -365,42 +365,26 @@
OPTIONS (format 'csv', filename :'filename', header 'false', delimiter ';', quote '@', escape '"', null '');
ALTER TABLE ptif_root ATTACH PARTITION agg_csv FOR VALUES FROM (10) TO (20);
SELECT * FROM ptif_root;
- a | b
------+---------
- 5 | 0.1
- 6 | 0.2
- 56 | 7.8
- 100 | 99.097
- 0 | 0.09561
- 42 | 324.78
-(6 rows)
-
+ERROR: could not open file "C:/cirrus/src/test/regress/data/agg.csv" for reading: No such file or directory
+HINT: COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as ps...
DELETE FROM ptif_root WHERE b = 0.1;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/partition_info.out C:/cirrus/build/testrun/regress/regr...
--- C:/cirrus/src/test/regress/expected/partition_info.out 2025-08-22 22:09:01.002788000 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/partition_info.out 2025-08-22 22:13:19.604733200 +0000
@@ -365,42 +365,26 @@
OPTIONS (format 'csv', filename :'filename', header 'false', delimiter ';', quote '@', escape '"', null '');
ALTER TABLE ptif_root ATTACH PARTITION agg_csv FOR VALUES FROM (10) TO (20);
SELECT * FROM ptif_root;
- a | b
------+---------
- 5 | 0.1
- 6 | 0.2
- 56 | 7.8
- 100 | 99.097
- 0 | 0.09561
- 42 | 324.78
-(6 rows)
-
+ERROR: could not open file "C:/cirrus/src/test/regress/data/agg.csv" for reading: No such file or directory
+HINT: COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as ps...
DELETE FROM ptif_root WHERE b = 0.1;
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/partition_info.out /Users/admin/pgsql/build/testrun/pg_upgrade/002...
--- /Users/admin/pgsql/src/test/regress/expected/partition_info.out 2025-08-22 22:08:10
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_info.out 2025-08-22 22:11:55
@@ -365,42 +365,26 @@
OPTIONS (format 'csv', filename :'filename', header 'false', delimiter ';', quote '@', escape '"', null '');
ALTER TABLE ptif_root ATTACH PARTITION agg_csv FOR VALUES FROM (10) TO (20);
SELECT * FROM ptif_root;
- a | b
------+---------
- 5 | 0.1
- 6 | 0.2
- 56 | 7.8
- 100 | 99.097
- 0 | 0.09561
- 42 | 324.78
-(6 rows)
-
+ERROR: could not open file "/Users/admin/pgsql/src/test/regress/data/agg.csv" for reading: No such file or directory
+HINT: COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as ps...
DELETE FROM ptif_root WHERE b = 0.1;
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/partition_info.out /Users/admin/pgsql/build/testrun/recovery/027_s...
--- /Users/admin/pgsql/src/test/regress/expected/partition_info.out 2025-08-22 22:08:10
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/partition_info.out 2025-08-22 22:13:37
@@ -365,42 +365,26 @@
OPTIONS (format 'csv', filename :'filename', header 'false', delimiter ';', quote '@', escape '"', null '');
ALTER TABLE ptif_root ATTACH PARTITION agg_csv FOR VALUES FROM (10) TO (20);
SELECT * FROM ptif_root;
- a | b
------+---------
- 5 | 0.1
- 6 | 0.2
- 56 | 7.8
- 100 | 99.097
- 0 | 0.09561
- 42 | 324.78
-(6 rows)
-
+ERROR: could not open file "/Users/admin/pgsql/src/test/regress/data/agg.csv" for reading: No such file or directory
+HINT: COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as ps...
DELETE FROM ptif_root WHERE b = 0.1;
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/partition_info.out /Users/admin/pgsql/build/testrun/regress/regres...
--- /Users/admin/pgsql/src/test/regress/expected/partition_info.out 2025-08-22 22:08:10
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/partition_info.out 2025-08-22 22:11:57
@@ -365,42 +365,26 @@
OPTIONS (format 'csv', filename :'filename', header 'false', delimiter ';', quote '@', escape '"', null '');
ALTER TABLE ptif_root ATTACH PARTITION agg_csv FOR VALUES FROM (10) TO (20);
SELECT * FROM ptif_root;
- a | b
------+---------
- 5 | 0.1
- 6 | 0.2
- 56 | 7.8
- 100 | 99.097
- 0 | 0.09561
- 42 | 324.78
-(6 rows)
-
+ERROR: could not open file "/Users/admin/pgsql/src/test/regress/data/agg.csv" for reading: No such file or directory
+HINT: COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as ps...
DELETE FROM ptif_root WHERE b = 0.1;
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out 2025-08-22 22:08:57.799990362 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_info.out 2025-08-22 22:14:30.645...
@@ -365,42 +365,26 @@
OPTIONS (format 'csv', filename :'filename', header 'false', delimiter ';', quote '@', escape '"', null '');
ALTER TABLE ptif_root ATTACH PARTITION agg_csv FOR VALUES FROM (10) TO (20);
SELECT * FROM ptif_root;
- a | b
------+---------
- 5 | 0.1
- 6 | 0.2
- 56 | 7.8
- 100 | 99.097
- 0 | 0.09561
- 42 | 324.78
-(6 rows)
-
+ERROR: could not open file "/tmp/cirrus-ci-build/src/test/regress/data/agg.csv" for reading: No such file or directory
+HINT: COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as ps...
DELETE FROM ptif_root WHERE b = 0.1;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out /tmp/cirrus-ci-build/build/testrun/recovery/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out 2025-08-22 22:08:57.799990362 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/partition_info.out 2025-08-22 22:15:47.6...
@@ -365,42 +365,26 @@
OPTIONS (format 'csv', filename :'filename', header 'false', delimiter ';', quote '@', escape '"', null '');
ALTER TABLE ptif_root ATTACH PARTITION agg_csv FOR VALUES FROM (10) TO (20);
SELECT * FROM ptif_root;
- a | b
------+---------
- 5 | 0.1
- 6 | 0.2
- 56 | 7.8
- 100 | 99.097
- 0 | 0.09561
- 42 | 324.78
-(6 rows)
-
+ERROR: could not open file "/tmp/cirrus-ci-build/src/test/regress/data/agg.csv" for reading: No such file or directory
+HINT: COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as ps...
DELETE FROM ptif_root WHERE b = 0.1;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out /tmp/cirrus-ci-build/build/testrun/regress/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out 2025-08-22 22:08:57.799990362 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/partition_info.out 2025-08-22 22:14:28.345911386 +0000
@@ -365,42 +365,26 @@
OPTIONS (format 'csv', filename :'filename', header 'false', delimiter ';', quote '@', escape '"', null '');
ALTER TABLE ptif_root ATTACH PARTITION agg_csv FOR VALUES FROM (10) TO (20);
SELECT * FROM ptif_root;
- a | b
------+---------
- 5 | 0.1
- 6 | 0.2
- 56 | 7.8
- 100 | 99.097
- 0 | 0.09561
- 42 | 324.78
-(6 rows)
-
+ERROR: could not open file "/tmp/cirrus-ci-build/src/test/regress/data/agg.csv" for reading: No such file or directory
+HINT: COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as ps...
DELETE FROM ptif_root WHERE b = 0.1;
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out 2025-08-22 22:08:58.898167000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_info.out 2025-08-22 22:13:43.845...
@@ -365,42 +365,26 @@
OPTIONS (format 'csv', filename :'filename', header 'false', delimiter ';', quote '@', escape '"', null '');
ALTER TABLE ptif_root ATTACH PARTITION agg_csv FOR VALUES FROM (10) TO (20);
SELECT * FROM ptif_root;
- a | b
------+---------
- 5 | 0.1
- 6 | 0.2
- 56 | 7.8
- 100 | 99.097
- 0 | 0.09561
- 42 | 324.78
-(6 rows)
-
+ERROR: could not open file "/tmp/cirrus-ci-build/src/test/regress/data/agg.csv" for reading: No such file or directory
+HINT: COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as ps...
DELETE FROM ptif_root WHERE b = 0.1;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out /tmp/cirrus-ci-build/build/testrun/recovery/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out 2025-08-22 22:08:58.898167000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/partition_info.out 2025-08-22 22:15:07.7...
@@ -365,42 +365,26 @@
OPTIONS (format 'csv', filename :'filename', header 'false', delimiter ';', quote '@', escape '"', null '');
ALTER TABLE ptif_root ATTACH PARTITION agg_csv FOR VALUES FROM (10) TO (20);
SELECT * FROM ptif_root;
- a | b
------+---------
- 5 | 0.1
- 6 | 0.2
- 56 | 7.8
- 100 | 99.097
- 0 | 0.09561
- 42 | 324.78
-(6 rows)
-
+ERROR: could not open file "/tmp/cirrus-ci-build/src/test/regress/data/agg.csv" for reading: No such file or directory
+HINT: COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as ps...
DELETE FROM ptif_root WHERE b = 0.1;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out /tmp/cirrus-ci-build/build/testrun/regress/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out 2025-08-22 22:08:58.898167000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/partition_info.out 2025-08-22 22:13:47.737361000 +0000
@@ -365,42 +365,26 @@
OPTIONS (format 'csv', filename :'filename', header 'false', delimiter ';', quote '@', escape '"', null '');
ALTER TABLE ptif_root ATTACH PARTITION agg_csv FOR VALUES FROM (10) TO (20);
SELECT * FROM ptif_root;
- a | b
------+---------
- 5 | 0.1
- 6 | 0.2
- 56 | 7.8
- 100 | 99.097
- 0 | 0.09561
- 42 | 324.78
-(6 rows)
-
+ERROR: could not open file "/tmp/cirrus-ci-build/src/test/regress/data/agg.csv" for reading: No such file or directory
+HINT: COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as ps...
DELETE FROM ptif_root WHERE b = 0.1;
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_c...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out 2025-08-22 22:08:55.860414372 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/partition_info.out 2025-08-22 22:17:16.812403779 +0000
@@ -365,42 +365,26 @@
OPTIONS (format 'csv', filename :'filename', header 'false', delimiter ';', quote '@', escape '"', null '');
ALTER TABLE ptif_root ATTACH PARTITION agg_csv FOR VALUES FROM (10) TO (20);
SELECT * FROM ptif_root;
- a | b
------+---------
- 5 | 0.1
- 6 | 0.2
- 56 | 7.8
- 100 | 99.097
- 0 | 0.09561
- 42 | 324.78
-(6 rows)
-
+ERROR: could not open file "/tmp/cirrus-ci-build/src/test/regress/data/agg.csv" for reading: No such file or directory
+HINT: COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as ps...
DELETE FROM ptif_root WHERE b = 0.1;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out /tmp/cirrus-ci-build/src/test/regress/results...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_info.out 2025-08-22 22:08:55.860414372 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/partition_info.out 2025-08-22 22:15:06.116168574 +0000
@@ -365,42 +365,26 @@
OPTIONS (format 'csv', filename :'filename', header 'false', delimiter ';', quote '@', escape '"', null '');
ALTER TABLE ptif_root ATTACH PARTITION agg_csv FOR VALUES FROM (10) TO (20);
SELECT * FROM ptif_root;
- a | b
------+---------
- 5 | 0.1
- 6 | 0.2
- 56 | 7.8
- 100 | 99.097
- 0 | 0.09561
- 42 | 324.78
-(6 rows)
-
+ERROR: could not open file "/tmp/cirrus-ci-build/src/test/regress/data/agg.csv" for reading: No such file or directory
+HINT: COPY FROM instructs the PostgreSQL server process to read a file. You may want a client-side facility such as ps...
DELETE FROM ptif_root WHERE b = 0.1;
... |
| 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-08-22 21:55:59.960037395 +0000
+++ /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/without_overlaps.out 2025-08-22 22:02:21.497690968 +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-08-22 21:55:59.979860312 +0000
+++ /tmp/cirrus-ci-build/build/testrun/earthdistance/regress/results/earthdistance.out 2025-08-22 22:02:23.393707438 +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-08-22 21:56:01.973219898 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/bit.out 2025-08-22 22:00:59.249171010 +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-08-22 21:56:00.071119690 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2025-08-22 22:02:37.741835801 +0000
@@ -409,12318 +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-08-22 21:56:01.973219898 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/bit.out 2025-08-22 22:01:44.781402156 +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-08-22 21:56:01.973219898 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/bit.out 2025-08-22 22:00:56.809164687 +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-08-22 21:56:00.083026722 +0000
+++ /tmp/cirrus-ci-build/build/testrun/seg/regress/results/partition.out 2025-08-22 22:02:37.925837483 +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-08-22 21:56:00.098902763 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_decoding/regress/results/ddl.out 2025-08-22 22:02:42.501879687 +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
-
... |