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.
| 59/4971 |
[CREATE|RE] INDEX CONCURRENTLY with single heap scan |
 |
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/indexing.out 2026-04-26 10:15:56.928637900 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-26 10:20:54.127266300 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/indexing.out 2026-04-26 10:15:56.928637900 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-26 10:23:58.634578800 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/indexing.out 2026-04-26 10:15:56.928637900 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/indexing.out 2026-04-26 10:20:34.923162400 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/test_plan_advice/0...
--- C:/cirrus/src/test/regress/expected/indexing.out 2026-04-26 10:15:56.928637900 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-26 10:20:47.942205100 ...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 10:15:56.884805407 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-26 10:21:24.862997915...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 10:15:56.884805407 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-26 10:23:00.8058707...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 10:15:56.884805407 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/indexing.out 2026-04-26 10:21:25.914981743 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 10:15:56.884805407 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-26 10:21:31...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-04-26 10:16:37
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-26 10:22:38
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-04-26 10:16:37
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-26 10:23:52
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/regress/regress/resu...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-04-26 10:16:37
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/indexing.out 2026-04-26 10:22:34
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/test_plan_advice/001...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-04-26 10:16:37
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-26 10:22:39
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/pg_upgrade...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out Sun Apr 26 10:16:13 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out Sun Apr 26 10:22:33 2026
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out Sun Apr 26 10:16:13 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/indexing.out Sun Apr 26 10:25:48 2026
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/regress/re...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out Sun Apr 26 10:16:13 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/indexing.out Sun Apr 26 10:22:17 2026
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/test_plan_...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out Sun Apr 26 10:16:13 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out Sun Apr 26 10:22...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 10:15:54.075674000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-26 10:21:43.163633000...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 10:15:54.075674000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-26 10:23:29.1247090...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 10:15:54.075674000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/indexing.out 2026-04-26 10:22:02.867444000 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 10:15:54.075674000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-26 10:22:07...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/pg_upgrade...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out 2026-04-26 10:16:29.433038753 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-26 10:20:20.572808...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out 2026-04-26 10:16:29.433038753 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-26 10:21:21.2472...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/regress/re...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out 2026-04-26 10:16:29.433038753 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/indexing.out 2026-04-26 10:20:20.010041483 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/test_plan_...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out 2026-04-26 10:16:29.433038753 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-26 10:20...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 10:16:03.562872958 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/indexing.out 2026-04-26 10:26:28.549419110 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/test/modules/test_plan_adv...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 10:16:03.562872958 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/indexing.out 2026-04-26 10:28:05.566896442 ...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 10:16:03.562872958 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/indexing.out 2026-04-26 10:28:07.474925920 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/test/regress/results/index...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 10:16:03.562872958 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/indexing.out 2026-04-26 10:23:54.959258582 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| 59/6059 |
Improving the names generated for indexes on expressions |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/indexing.out 2026-04-26 08:02:20.227151200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-26 08:07:44.754768100 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/indexing.out 2026-04-26 08:02:20.227151200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-26 08:11:41.237302500 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/indexing.out 2026-04-26 08:02:20.227151200 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/indexing.out 2026-04-26 08:07:32.303576500 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/test_plan_advice/0...
--- C:/cirrus/src/test/regress/expected/indexing.out 2026-04-26 08:02:20.227151200 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-26 08:07:39.470106800 ...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-04-26 08:00:19
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-26 08:04:39
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-04-26 08:00:19
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-26 08:06:56
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/regress/regress/resu...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-04-26 08:00:19
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/indexing.out 2026-04-26 08:04:37
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/test_plan_advice/001...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-04-26 08:00:19
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-26 08:04:50
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 08:00:54.608873613 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-26 08:06:40.116973494...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 08:00:54.608873613 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-26 08:08:26.2179440...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 08:00:54.608873613 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/indexing.out 2026-04-26 08:06:43.845041355 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 08:00:54.608873613 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-26 08:06:48...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 08:00:49.398432000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-26 08:07:39.824690000...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 08:00:49.398432000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-26 08:09:05.2566640...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 08:00:49.398432000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/indexing.out 2026-04-26 08:07:26.918646000 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 08:00:49.398432000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-26 08:07:36...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/pg_upgrade...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out Sun Apr 26 08:01:40 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out Sun Apr 26 08:06:43 2026
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out Sun Apr 26 08:01:40 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/indexing.out Sun Apr 26 08:09:21 2026
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/regress/re...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out Sun Apr 26 08:01:40 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/indexing.out Sun Apr 26 08:06:36 2026
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/test_plan_...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out Sun Apr 26 08:01:40 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out Sun Apr 26 08:06...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 08:00:54.477737466 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/indexing.out 2026-04-26 08:10:31.041296215 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/test/modules/test_plan_adv...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 08:00:54.477737466 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/indexing.out 2026-04-26 08:12:21.513235939 ...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 08:00:54.477737466 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/indexing.out 2026-04-26 08:12:10.669241778 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/test/regress/results/index...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 08:00:54.477737466 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/indexing.out 2026-04-26 08:07:44.937394023 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/pg_upgrade...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out 2026-04-26 08:01:17.362686108 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-26 08:05:56.733224...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out 2026-04-26 08:01:17.362686108 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-26 08:07:00.5314...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/regress/re...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out 2026-04-26 08:01:17.362686108 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/indexing.out 2026-04-26 08:05:42.532208480 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/test_plan_...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out 2026-04-26 08:01:17.362686108 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-26 08:06...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| 59/6701 |
Fix FOR PORTION OF recomputing GENERATED STORED columns that depend on the range column |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/injection_points/expected/repack.out C:/cirrus/build/testrun/inj...
--- C:/cirrus/src/test/modules/injection_points/expected/repack.out 2026-04-26 04:09:19.029481400 +0000
+++ C:/cirrus/build/testrun/injection_points/isolation/results/repack.out 2026-04-26 04:20:52.745746500 +0000
@@ -68,46 +68,7 @@
(1 row)
-step wait_before_lock: <... completed>
-step check1:
- INSERT INTO relfilenodes(node)
- SELECT relfilenode FROM pg_class WHERE relname='repack_test';
-
- SELECT count(DISTINCT node) FROM relfilenodes;
-
- SELECT i, j FROM repack_test ORDER BY i, j;
-
- INSERT INTO data_s1(i, j)
- SELECT i, j FROM repack_test;
-
- SELECT count(*)
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/modules/injection_points/expected/repack.out /Users/admin/pgsql/build/testrun/injec...
--- /Users/admin/pgsql/src/test/modules/injection_points/expected/repack.out 2026-04-26 04:06:58
+++ /Users/admin/pgsql/build/testrun/injection_points/isolation/results/repack.out 2026-04-26 04:12:55
@@ -68,46 +68,7 @@
(1 row)
-step wait_before_lock: <... completed>
-step check1:
- INSERT INTO relfilenodes(node)
- SELECT relfilenode FROM pg_class WHERE relname='repack_test';
+PQconsumeInput failed: server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
- SELECT count(DISTINCT node) FROM relfilenodes;
-
- SELECT i, j FROM repack_test ORDER BY i, j;
-
- INSERT INTO data_s1(i, j)
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/repack.out /tmp/cirrus-ci-build/build/testrun/i...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/repack.out 2026-04-26 04:08:20.686354591 +0000
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/repack.out 2026-04-26 04:15:06.964293627 +0000
@@ -68,46 +68,7 @@
(1 row)
-step wait_before_lock: <... completed>
-step check1:
- INSERT INTO relfilenodes(node)
- SELECT relfilenode FROM pg_class WHERE relname='repack_test';
-
- SELECT count(DISTINCT node) FROM relfilenodes;
-
- SELECT i, j FROM repack_test ORDER BY i, j;
-
- INSERT INTO data_s1(i, j)
- SELECT i, j FROM repack_test;
-
- SELECT count(*)
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/repack.out /tmp/cirrus-ci-build/build/testrun/i...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/repack.out 2026-04-26 04:08:28.444379000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/repack.out 2026-04-26 04:14:16.161817000 +0000
@@ -68,46 +68,6 @@
(1 row)
-step wait_before_lock: <... completed>
-step check1:
- INSERT INTO relfilenodes(node)
- SELECT relfilenode FROM pg_class WHERE relname='repack_test';
-
- SELECT count(DISTINCT node) FROM relfilenodes;
-
- SELECT i, j FROM repack_test ORDER BY i, j;
-
- INSERT INTO data_s1(i, j)
- SELECT i, j FROM repack_test;
-
- SELECT count(*)
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/injection_points/expected/repack.out /home/postgres/postgres/build/tes...
--- /home/postgres/postgres/src/test/modules/injection_points/expected/repack.out Sun Apr 26 04:09:10 2026
+++ /home/postgres/postgres/build/testrun/injection_points/isolation/results/repack.out Sun Apr 26 04:16:22 2026
@@ -68,46 +68,7 @@
(1 row)
-step wait_before_lock: <... completed>
-step check1:
- INSERT INTO relfilenodes(node)
- SELECT relfilenode FROM pg_class WHERE relname='repack_test';
-
- SELECT count(DISTINCT node) FROM relfilenodes;
-
- SELECT i, j FROM repack_test ORDER BY i, j;
-
- INSERT INTO data_s1(i, j)
- SELECT i, j FROM repack_test;
-
- SELECT count(*)
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/repack.out /tmp/cirrus-ci-build/src/test/module...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/repack.out 2026-04-26 04:08:11.334464059 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/injection_points/output_iso/results/repack.out 2026-04-26 04:17:45.895003521 +...
@@ -68,46 +68,7 @@
(1 row)
-step wait_before_lock: <... completed>
-step check1:
- INSERT INTO relfilenodes(node)
- SELECT relfilenode FROM pg_class WHERE relname='repack_test';
-
- SELECT count(DISTINCT node) FROM relfilenodes;
-
- SELECT i, j FROM repack_test ORDER BY i, j;
-
- INSERT INTO data_s1(i, j)
- SELECT i, j FROM repack_test;
-
- SELECT count(*)
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/injection_points/expected/repack.out /home/postgres/postgres/build/tes...
--- /home/postgres/postgres/src/test/modules/injection_points/expected/repack.out 2026-04-26 04:08:21.744543413 +0000
+++ /home/postgres/postgres/build/testrun/injection_points/isolation/results/repack.out 2026-04-26 04:12:17.813327035 +0...
@@ -68,46 +68,7 @@
(1 row)
-step wait_before_lock: <... completed>
-step check1:
- INSERT INTO relfilenodes(node)
- SELECT relfilenode FROM pg_class WHERE relname='repack_test';
-
- SELECT count(DISTINCT node) FROM relfilenodes;
-
- SELECT i, j FROM repack_test ORDER BY i, j;
-
- INSERT INTO data_s1(i, j)
- SELECT i, j FROM repack_test;
-
- SELECT count(*)
... |
| 59/6673 |
More jsonpath methods: translate, split, join |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/isolation/expected/timeouts.out /home/postgres/postgres/build/testrun/isolatio...
--- /home/postgres/postgres/src/test/isolation/expected/timeouts.out Sat Apr 25 23:14:37 2026
+++ /home/postgres/postgres/build/testrun/isolation/isolation/results/timeouts.out Sat Apr 25 23:18:46 2026
@@ -11,7 +11,7 @@
step sto: SET statement_timeout = '10ms';
step locktbl: LOCK TABLE accounts; <waiting ...>
step locktbl: <... completed>
-ERROR: canceling statement due to statement timeout
+ERROR: canceling statement due to user request
starting permutation: rdtbl lto locktbl
step rdtbl: SELECT * FROM accounts; |
| 59/6534 |
amcheck: fix bug of missing corruption in allequalimage validation |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/partition_aggregate.out C:/cirrus/build/testrun/recover...
--- C:/cirrus/src/test/regress/expected/partition_aggregate.out 2026-04-25 22:52:30.158091300 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/partition_aggregate.out 2026-04-25 23:02:23.4860328...
@@ -1257,19 +1257,7 @@
(41 rows)
SELECT a, sum(b), count(*) FROM pagg_tab_ml GROUP BY a HAVING avg(b) < 3 ORDER BY 1, 2, 3;
- a | sum | count
-----+------+-------
- 0 | 0 | 1000
- 1 | 1000 | 1000
- 2 | 2000 | 1000
- 10 | 0 | 1000
- 11 | 1000 | 1000
- 12 | 2000 | 1000
- 20 | 0 | 1000
- 21 | 1000 | 1000
- 22 | 2000 | 1000
-(9 rows)
-
... |
| 59/4817 |
COPY (on_error table) saving error info to a table |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/copy2.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgra...
--- /Users/admin/pgsql/src/test/regress/expected/copy2.out 2026-04-25 13:01:36
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy2.out 2026-04-25 13:07:10
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42092, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42092, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/copy2.out /Users/admin/pgsql/build/testrun/recovery/027_stream_reg...
--- /Users/admin/pgsql/src/test/regress/expected/copy2.out 2026-04-25 13:01:36
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/copy2.out 2026-04-25 13:09:08
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42676, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42676, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/copy2.out /Users/admin/pgsql/build/testrun/regress/regress/results...
--- /Users/admin/pgsql/src/test/regress/expected/copy2.out 2026-04-25 13:01:36
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/copy2.out 2026-04-25 13:07:08
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42424, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42424, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/copy2.out /Users/admin/pgsql/build/testrun/test_plan_advice/001_re...
--- /Users/admin/pgsql/src/test/regress/expected/copy2.out 2026-04-25 13:01:36
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/copy2.out 2026-04-25 13:07:08
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43459, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43459, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/copy2.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upg...
--- C:/cirrus/src/test/regress/expected/copy2.out 2026-04-25 12:57:54.021815400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy2.out 2026-04-25 13:03:11.693798200 +0000
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42264, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42264, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/copy2.out C:/cirrus/build/testrun/recovery/027_stream_r...
--- C:/cirrus/src/test/regress/expected/copy2.out 2026-04-25 12:57:54.021815400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/copy2.out 2026-04-25 13:07:05.611714200 +0000
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 41523, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 41523, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/copy2.out C:/cirrus/build/testrun/regress/regress/resul...
--- C:/cirrus/src/test/regress/expected/copy2.out 2026-04-25 12:57:54.021815400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/copy2.out 2026-04-25 13:03:08.248982300 +0000
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43041, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43041, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/copy2.out C:/cirrus/build/testrun/test_plan_advice/001_...
--- C:/cirrus/src/test/regress/expected/copy2.out 2026-04-25 12:57:54.021815400 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/copy2.out 2026-04-25 13:03:01.687444700 +00...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43380, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43380, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:57:48.227616398 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy2.out 2026-04-25 13:01:23.083552358 +0...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43271, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43271, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:57:48.227616398 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/copy2.out 2026-04-25 13:02:59.359010510 ...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42987, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42987, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/build/testrun/regress/regress/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:57:48.227616398 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/copy2.out 2026-04-25 13:01:22.219577476 +0000
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43080, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43080, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:57:48.227616398 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/copy2.out 2026-04-25 13:01:28.22...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43167, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43167, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/copy2.out /home/postgres/postgres/build/testrun/pg_upgrade/00...
--- /home/postgres/postgres/src/test/regress/expected/copy2.out Sat Apr 25 12:58:07 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy2.out Sat Apr 25 13:02:13 2026
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43577, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43577, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/copy2.out /home/postgres/postgres/build/testrun/recovery/027_...
--- /home/postgres/postgres/src/test/regress/expected/copy2.out Sat Apr 25 12:58:07 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/copy2.out Sat Apr 25 13:05:07 2026
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43385, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43385, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/copy2.out /home/postgres/postgres/build/testrun/regress/regre...
--- /home/postgres/postgres/src/test/regress/expected/copy2.out Sat Apr 25 12:58:07 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/copy2.out Sat Apr 25 13:02:02 2026
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43397, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43397, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/copy2.out /home/postgres/postgres/build/testrun/test_plan_adv...
--- /home/postgres/postgres/src/test/regress/expected/copy2.out Sat Apr 25 12:58:07 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/copy2.out Sat Apr 25 13:02:08...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43306, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43306, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:57:45.280121000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy2.out 2026-04-25 13:02:34.414774000 +0...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43076, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43076, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:57:45.280121000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/copy2.out 2026-04-25 13:03:59.415752000 ...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43300, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43300, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/build/testrun/regress/regress/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:57:45.280121000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/copy2.out 2026-04-25 13:02:25.148187000 +0000
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43395, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43395, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:57:45.280121000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/copy2.out 2026-04-25 13:02:36.91...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43074, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43074, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/resu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:58:05.721932707 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/copy2.out 2026-04-25 13:08:10.635814744 +0000
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43297, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43297, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/src/test/modules/test_plan_advice...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:58:05.721932707 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/copy2.out 2026-04-25 13:10:11.901256677 +00...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43295, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43295, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:58:05.721932707 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/copy2.out 2026-04-25 13:09:40.904724222 +0000
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43133, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43133, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/src/test/regress/results/copy2.ou...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:58:05.721932707 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/copy2.out 2026-04-25 13:04:05.871209460 +0000
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43210, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43210, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/copy2.out /home/postgres/postgres/build/testrun/pg_upgrade/00...
--- /home/postgres/postgres/src/test/regress/expected/copy2.out 2026-04-25 12:58:52.620791196 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy2.out 2026-04-25 13:01:45.825405430...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43625, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43625, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/copy2.out /home/postgres/postgres/build/testrun/recovery/027_...
--- /home/postgres/postgres/src/test/regress/expected/copy2.out 2026-04-25 12:58:52.620791196 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/copy2.out 2026-04-25 13:02:46.7571469...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42441, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42441, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/copy2.out /home/postgres/postgres/build/testrun/regress/regre...
--- /home/postgres/postgres/src/test/regress/expected/copy2.out 2026-04-25 12:58:52.620791196 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/copy2.out 2026-04-25 13:01:47.884748339 +0000
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42566, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42566, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/copy2.out /home/postgres/postgres/build/testrun/test_plan_adv...
--- /home/postgres/postgres/src/test/regress/expected/copy2.out 2026-04-25 12:58:52.620791196 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/copy2.out 2026-04-25 13:01:56...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42220, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42220, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| 59/6664 |
Support EXCEPT for ALL SEQUENCES publications |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/publication.out C:/cirrus/build/testrun/pg_upgrade/002_...
--- C:/cirrus/src/test/regress/expected/publication.out 2026-04-25 12:36:12.761405200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2026-04-25 12:41:51.397211800 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/publication.out C:/cirrus/build/testrun/recovery/027_st...
--- C:/cirrus/src/test/regress/expected/publication.out 2026-04-25 12:36:12.761405200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/publication.out 2026-04-25 12:46:27.499710400 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/publication.out C:/cirrus/build/testrun/regress/regress...
--- C:/cirrus/src/test/regress/expected/publication.out 2026-04-25 12:36:12.761405200 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/publication.out 2026-04-25 12:41:42.002175300 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/publication.out C:/cirrus/build/testrun/test_plan_advic...
--- C:/cirrus/src/test/regress/expected/publication.out 2026-04-25 12:36:12.761405200 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/publication.out 2026-04-25 12:41:50.0519948...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/publication.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg...
--- /Users/admin/pgsql/src/test/regress/expected/publication.out 2026-04-25 12:40:13
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2026-04-25 12:44:06
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/publication.out /Users/admin/pgsql/build/testrun/recovery/027_stre...
--- /Users/admin/pgsql/src/test/regress/expected/publication.out 2026-04-25 12:40:13
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/publication.out 2026-04-25 12:45:21
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/publication.out /Users/admin/pgsql/build/testrun/regress/regress/r...
--- /Users/admin/pgsql/src/test/regress/expected/publication.out 2026-04-25 12:40:13
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/publication.out 2026-04-25 12:44:08
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/publication.out /Users/admin/pgsql/build/testrun/test_plan_advice/...
--- /Users/admin/pgsql/src/test/regress/expected/publication.out 2026-04-25 12:40:13
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/publication.out 2026-04-25 12:44:0...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
|
Linux - Debian Trixie - Meson |
| regress |
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 2026-04-25 12:36:11.010695132 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2026-04-25 12:42:38.266986...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-04-25 12:36:11.010695132 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/publication.out 2026-04-25 12:44:28.9185...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
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 2026-04-25 12:36:11.010695132 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/publication.out 2026-04-25 12:42:34.555017125 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/test_plan_adv...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-04-25 12:36:11.010695132 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/publication.out 2026-04-25 12:42...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
|
FreeBSD - Meson |
| regress |
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 2026-04-25 12:36:11.383462000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2026-04-25 12:42:35.632684...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-04-25 12:36:11.383462000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/publication.out 2026-04-25 12:44:42.5139...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
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 2026-04-25 12:36:11.383462000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/publication.out 2026-04-25 12:42:43.923309000 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/test_plan_adv...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-04-25 12:36:11.383462000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/publication.out 2026-04-25 12:43...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
|
Linux - Debian Trixie - Autoconf |
| regress |
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 2026-04-25 12:36:17.856832727 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/publication.out 2026-04-25 12:48:31.667565022 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/src/test/modules/test_plan_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-04-25 12:36:17.856832727 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/publication.out 2026-04-25 12:50:07.4114187...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-04-25 12:36:17.856832727 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/publication.out 2026-04-25 12:50:24.239388461 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
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 2026-04-25 12:36:17.856832727 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/publication.out 2026-04-25 12:45:34.479353498 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/pg_upgr...
--- /home/postgres/postgres/src/test/regress/expected/publication.out Sat Apr 25 12:36:30 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out Sat Apr 25 12:42:40 202...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/recover...
--- /home/postgres/postgres/src/test/regress/expected/publication.out Sat Apr 25 12:36:30 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/publication.out Sat Apr 25 12:45:52 2...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/regress...
--- /home/postgres/postgres/src/test/regress/expected/publication.out Sat Apr 25 12:36:30 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/publication.out Sat Apr 25 12:42:35 2026
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/test_pl...
--- /home/postgres/postgres/src/test/regress/expected/publication.out Sat Apr 25 12:36:30 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/publication.out Sat Apr 25 12...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/pg_upgr...
--- /home/postgres/postgres/src/test/regress/expected/publication.out 2026-04-25 12:36:39.980385222 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2026-04-25 12:41:13.037...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/recover...
--- /home/postgres/postgres/src/test/regress/expected/publication.out 2026-04-25 12:36:39.980385222 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/publication.out 2026-04-25 12:42:16.6...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/regress...
--- /home/postgres/postgres/src/test/regress/expected/publication.out 2026-04-25 12:36:39.980385222 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/publication.out 2026-04-25 12:41:08.896701467 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/test_pl...
--- /home/postgres/postgres/src/test/regress/expected/publication.out 2026-04-25 12:36:39.980385222 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/publication.out 2026-04-25 12...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| 59/6543 |
synchronized_standby_slots behavior inconsistent with quorum-based synchronous replication |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/modules/unsafe_tests/expected/guc_privs.out /Users/admin/pgsql/build/testrun/unsafe...
--- /Users/admin/pgsql/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-04-23 10:59:10
+++ /Users/admin/pgsql/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-04-23 11:07:16
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/unsafe_tests/expected/guc_privs.out C:/cirrus/build/testrun/unsa...
--- C:/cirrus/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-04-23 10:59:51.673780500 +0000
+++ C:/cirrus/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-04-23 11:10:49.033696100 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out /tmp/cirrus-ci-build/build/testrun/un...
--- /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-04-23 11:00:16.762061579 +0000
+++ /tmp/cirrus-ci-build/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-04-23 11:07:10.269710855 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/unsafe_tests/expected/guc_privs.out /home/postgres/postgres/build/test...
--- /home/postgres/postgres/src/test/modules/unsafe_tests/expected/guc_privs.out Thu Apr 23 10:59:48 2026
+++ /home/postgres/postgres/build/testrun/unsafe_tests/regress/results/guc_privs.out Thu Apr 23 11:06:57 2026
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out /tmp/cirrus-ci-build/build/testrun/un...
--- /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-04-23 10:59:39.646701000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-04-23 11:05:17.714380000 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out /tmp/cirrus-ci-build/src/test/modules...
--- /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-04-23 10:59:19.268809549 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/results/guc_privs.out 2026-04-23 11:08:26.315086921 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/unsafe_tests/expected/guc_privs.out /home/postgres/postgres/build/test...
--- /home/postgres/postgres/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-04-23 10:59:48.909004417 +0000
+++ /home/postgres/postgres/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-04-23 11:03:40.230976227 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
| 59/6055 |
let ALTER TABLE DROP COLUMN drop whole-row referenced object |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/triggers.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/triggers.out 2026-04-21 21:57:58.102037300 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2026-04-21 22:01:38.465237400 +0000
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/triggers.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/triggers.out 2026-04-21 21:57:58.102037300 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2026-04-21 22:05:54.093161200 +0000
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/triggers.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/triggers.out 2026-04-21 21:57:58.102037300 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/triggers.out 2026-04-21 22:01:25.116604200 +0000
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/triggers.out C:/cirrus/build/testrun/test_plan_advice/0...
--- C:/cirrus/src/test/regress/expected/triggers.out 2026-04-21 21:57:58.102037300 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/triggers.out 2026-04-21 22:01:31.951555100 ...
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/triggers.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/triggers.out 2026-04-21 21:57:55
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2026-04-21 22:02:06
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/triggers.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/triggers.out 2026-04-21 21:57:55
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2026-04-21 22:05:07
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/triggers.out /Users/admin/pgsql/build/testrun/regress/regress/resu...
--- /Users/admin/pgsql/src/test/regress/expected/triggers.out 2026-04-21 21:57:55
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/triggers.out 2026-04-21 22:02:02
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/triggers.out /Users/admin/pgsql/build/testrun/test_plan_advice/001...
--- /Users/admin/pgsql/src/test/regress/expected/triggers.out 2026-04-21 21:57:55
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/triggers.out 2026-04-21 22:02:05
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:52.387995851 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2026-04-21 22:00:27.693711738...
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:52.387995851 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2026-04-21 22:02:02.3616239...
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:52.387995851 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/triggers.out 2026-04-21 22:00:24.525715206 +0000
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:52.387995851 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/triggers.out 2026-04-21 22:00:30...
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:48.678826296 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/triggers.out 2026-04-21 22:04:44.489855094 +0000
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/test/modules/test_plan_adv...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:48.678826296 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/triggers.out 2026-04-21 22:06:53.261767864 ...
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:48.678826296 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/triggers.out 2026-04-21 22:05:55.917830271 +0000
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/test/regress/results/trigg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:48.678826296 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/triggers.out 2026-04-21 22:01:50.209796885 +0000
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/triggers.out /home/postgres/postgres/build/testrun/pg_upgrade...
--- /home/postgres/postgres/src/test/regress/expected/triggers.out Tue Apr 21 21:58:04 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out Tue Apr 21 22:00:43 2026
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/triggers.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/triggers.out Tue Apr 21 21:58:04 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/triggers.out Tue Apr 21 22:02:51 2026
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/triggers.out /home/postgres/postgres/build/testrun/regress/re...
--- /home/postgres/postgres/src/test/regress/expected/triggers.out Tue Apr 21 21:58:04 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/triggers.out Tue Apr 21 22:00:36 2026
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/triggers.out /home/postgres/postgres/build/testrun/test_plan_...
--- /home/postgres/postgres/src/test/regress/expected/triggers.out Tue Apr 21 21:58:04 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/triggers.out Tue Apr 21 22:00...
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/triggers.out /home/postgres/postgres/build/testrun/pg_upgrade...
--- /home/postgres/postgres/src/test/regress/expected/triggers.out 2026-04-21 21:58:04.278147131 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2026-04-21 21:59:51.663282...
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/triggers.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/triggers.out 2026-04-21 21:58:04.278147131 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2026-04-21 22:00:28.3844...
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/triggers.out /home/postgres/postgres/build/testrun/regress/re...
--- /home/postgres/postgres/src/test/regress/expected/triggers.out 2026-04-21 21:58:04.278147131 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/triggers.out 2026-04-21 21:59:51.082260250 +0000
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/triggers.out /home/postgres/postgres/build/testrun/test_plan_...
--- /home/postgres/postgres/src/test/regress/expected/triggers.out 2026-04-21 21:58:04.278147131 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/triggers.out 2026-04-21 21:59...
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:53.832725000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2026-04-21 21:59:47.252429000...
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:53.832725000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2026-04-21 22:01:18.5989250...
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:53.832725000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/triggers.out 2026-04-21 21:59:47.775470000 +0000
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:53.832725000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/triggers.out 2026-04-21 21:59:47...
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| 59/6397 |
extended statistic (examine_variable) ignored CollateExpr |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out /Users/admin/pgsql/build/testrun/pg_upgrade/0...
--- /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:41:58
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/collate.icu.utf8.out 2026-04-21 21:47:14
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out /Users/admin/pgsql/build/testrun/recovery/027...
--- /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:41:58
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/collate.icu.utf8.out 2026-04-21 21:49:24
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out /Users/admin/pgsql/build/testrun/regress/regr...
--- /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:41:58
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/collate.icu.utf8.out 2026-04-21 21:47:03
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out /Users/admin/pgsql/build/testrun/test_plan_ad...
--- /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:41:58
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/collate.icu.utf8.out 2026-04-21 21...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/pg_upgra...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:42:14.455850429 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/collate.icu.utf8.out 2026-04-21 21:45:59.6...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/recovery...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:42:14.455850429 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/collate.icu.utf8.out 2026-04-21 21:47:32...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:42:14.455850429 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/collate.icu.utf8.out 2026-04-21 21:45:54.683259576 +0000
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/test_pla...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:42:14.455850429 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/collate.icu.utf8.out 2026-04-21 ...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:41:52.298215014 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/collate.icu.utf8.out 2026-04-21 21:49:08.867031249 +0000
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/src/test/modules/test_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:41:52.298215014 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/collate.icu.utf8.out 2026-04-21 21:51:11.06...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/src/test/recovery/tmp_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:41:52.298215014 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/collate.icu.utf8.out 2026-04-21 21:51:00.422481716 +0000
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/src/test/regress/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:41:52.298215014 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/collate.icu.utf8.out 2026-04-21 21:46:37.227889277 +0000
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out /home/postgres/postgres/build/testrun/pg...
--- /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:42:51.520961419 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/collate.icu.utf8.out 2026-04-21 21:45:3...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out /home/postgres/postgres/build/testrun/pg...
--- /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out Tue Apr 21 21:44:01 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/collate.icu.utf8.out Tue Apr 21 21:47:2...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out /home/postgres/postgres/build/testrun/re...
--- /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out Tue Apr 21 21:44:01 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/collate.icu.utf8.out Tue Apr 21 21:49...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out /home/postgres/postgres/build/testrun/re...
--- /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out Tue Apr 21 21:44:01 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/collate.icu.utf8.out Tue Apr 21 21:47:23 2026
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out /home/postgres/postgres/build/testrun/te...
--- /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out Tue Apr 21 21:44:01 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/collate.icu.utf8.out Tue Apr ...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/pg_upgra...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:42:10.091788000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/collate.icu.utf8.out 2026-04-21 21:45:30.7...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/recovery...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:42:10.091788000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/collate.icu.utf8.out 2026-04-21 21:47:10...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:42:10.091788000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/collate.icu.utf8.out 2026-04-21 21:45:22.856301000 +0000
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/test_pla...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:42:10.091788000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/collate.icu.utf8.out 2026-04-21 ...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| 59/6274 |
Add a greedy join search algorithm to handle large join problems |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgra...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-04-19 12:49:15.874279600 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-04-19 12:53:48.950804600 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/recovery/027_stream_reg...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-04-19 12:49:15.874279600 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-04-19 12:58:27.726541900 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/regress/regress/results...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-04-19 12:49:15.874279600 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/goo.out 2026-04-19 12:53:46.505500400 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/test_plan_advice/001_re...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-04-19 12:49:15.874279600 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out 2026-04-19 12:53:49.607070700 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-19 12:47:51.702237095 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-04-19 12:50:55.246748241 +000...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-19 12:47:51.702237095 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-04-19 12:52:33.730310991 +0...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-19 12:47:51.702237095 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/goo.out 2026-04-19 12:50:52.778683289 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-19 12:47:51.702237095 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out 2026-04-19 12:50:55.7787...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/goo.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade...
--- /Users/admin/pgsql/src/test/regress/expected/goo.out 2026-04-19 12:47:55
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-04-19 12:51:13
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/goo.out /Users/admin/pgsql/build/testrun/recovery/027_stream_regre...
--- /Users/admin/pgsql/src/test/regress/expected/goo.out 2026-04-19 12:47:55
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-04-19 12:52:47
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/goo.out /Users/admin/pgsql/build/testrun/regress/regress/results/g...
--- /Users/admin/pgsql/src/test/regress/expected/goo.out 2026-04-19 12:47:55
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/goo.out 2026-04-19 12:51:18
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/goo.out /Users/admin/pgsql/build/testrun/test_plan_advice/001_repl...
--- /Users/admin/pgsql/src/test/regress/expected/goo.out 2026-04-19 12:47:55
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out 2026-04-19 12:51:20
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-19 12:48:25.358305000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-04-19 12:51:21.688262000 +000...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-19 12:48:25.358305000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-04-19 12:53:17.040060000 +0...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-19 12:48:25.358305000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/goo.out 2026-04-19 12:51:24.466030000 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-19 12:48:25.358305000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out 2026-04-19 12:51:22.8277...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/pg_upgrade/002_...
--- /home/postgres/postgres/src/test/regress/expected/goo.out Sun Apr 19 12:48:52 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out Sun Apr 19 12:53:13 2026
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/recovery/027_st...
--- /home/postgres/postgres/src/test/regress/expected/goo.out Sun Apr 19 12:48:52 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/goo.out Sun Apr 19 12:57:07 2026
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/regress/regress...
--- /home/postgres/postgres/src/test/regress/expected/goo.out Sun Apr 19 12:48:52 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/goo.out Sun Apr 19 12:53:06 2026
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/test_plan_advic...
--- /home/postgres/postgres/src/test/regress/expected/goo.out Sun Apr 19 12:48:52 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out Sun Apr 19 12:53:17 2...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/result...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-19 12:47:50.682771504 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/goo.out 2026-04-19 12:54:55.453858090 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-19 12:47:50.682771504 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/goo.out 2026-04-19 12:56:17.185720838 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/src/test/regress/results/goo.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-19 12:47:50.682771504 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/goo.out 2026-04-19 12:52:07.958092382 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/pg_upgrade/002_...
--- /home/postgres/postgres/src/test/regress/expected/goo.out 2026-04-19 12:48:11.897653584 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-04-19 12:50:34.844673195 +...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/recovery/027_st...
--- /home/postgres/postgres/src/test/regress/expected/goo.out 2026-04-19 12:48:11.897653584 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-04-19 12:51:22.796973634...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/regress/regress...
--- /home/postgres/postgres/src/test/regress/expected/goo.out 2026-04-19 12:48:11.897653584 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/goo.out 2026-04-19 12:50:35.544468749 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/test_plan_advic...
--- /home/postgres/postgres/src/test/regress/expected/goo.out 2026-04-19 12:48:11.897653584 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out 2026-04-19 12:50:40.9...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |