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/6059 |
Improving the names generated for indexes on expressions |
 |
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-22 22:55:57
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-22 23:01: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)
... |
| 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-22 22:55:57
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-22 23:04:03
@@ -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-22 22:55:57
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/indexing.out 2026-04-22 23:01:40
@@ -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-22 22:55:57
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-22 23:01:44
@@ -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)
... |
|
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-22 22:56:10.882549000 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-22 23:02:13.815032200 +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-22 22:56:10.882549000 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-22 23:06:12.308202400 +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-22 22:56:10.882549000 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/indexing.out 2026-04-22 23:01:39.588949900 +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-22 22:56:10.882549000 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-22 23:02:07.129480500 ...
@@ -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-22 22:56:06.010733807 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-22 23:02:18.114188971...
@@ -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-22 22:56:06.010733807 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-22 23:04:10.3582586...
@@ -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-22 22:56:06.010733807 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/indexing.out 2026-04-22 23:02:13.950182674 +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-22 22:56:06.010733807 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-22 23:02:21...
@@ -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-22 22:56:05.589477426 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/indexing.out 2026-04-22 23:06:10.888432051 +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-22 22:56:05.589477426 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/indexing.out 2026-04-22 23:08:00.356344877 ...
@@ -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-22 22:56:05.589477426 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/indexing.out 2026-04-22 23:07:49.904352186 +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-22 22:56:05.589477426 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/indexing.out 2026-04-22 23:03:18.496628139 +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)
... |
|
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 Wed Apr 22 22:56:23 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out Wed Apr 22 23:02:33 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 Wed Apr 22 22:56:23 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/indexing.out Wed Apr 22 23:05:41 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 Wed Apr 22 22:56:23 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/indexing.out Wed Apr 22 23:02:15 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 Wed Apr 22 22:56:23 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out Wed Apr 22 23:02...
@@ -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-22 22:56:05.718553000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-22 23:03:19.557255000...
@@ -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-22 22:56:05.718553000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-22 23:05:02.5285780...
@@ -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-22 22:56:05.718553000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/indexing.out 2026-04-22 23:03:10.057106000 +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-22 22:56:05.718553000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-22 23:03:18...
@@ -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-22 22:56:23.572736006 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-22 23:01:07.946000...
@@ -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-22 22:56:23.572736006 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-22 23:02:16.8102...
@@ -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-22 22:56:23.572736006 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/indexing.out 2026-04-22 23:01:07.512996447 +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-22 22:56:23.572736006 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-22 23:01...
@@ -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/6668 |
Implement missing join selectivity estimation for range types |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/regress-runn...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2026-04-22 22:39:58.930124000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress-running/regress/results/create_index.out 2026-04-22 22:51:04.877504000 +0...
@@ -2056,7 +2056,7 @@
QUERY PLAN
----------------------------------------------------------------------------
Aggregate
- -> Index Only Scan using tenk1_thous_tenthous on tenk1 t1
+ -> Seq Scan on tenk1 t1
Filter: ((thousand = 42) OR (thousand = (SubPlan expr_1)))
SubPlan expr_1
-> Limit
@@ -2225,9 +2225,11 @@
Filter: ((thousand = 42) OR (thousand = 41) OR (tenthous = 2))
-> Bitmap Index Scan on tenk2_hundred
Index Cond: (hundred = 42)
- -> Index Only Scan using tenk1_hundred on tenk1
- Index Cond: (hundred = 42)
-(9 rows)
+ -> Bitmap Heap Scan on tenk1
... |
| 59/6692 |
repack: clarify final phase of concurrent mode in file header comment |
|
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 Wed Apr 22 18:29:07 2026
+++ /home/postgres/postgres/build/testrun/isolation/isolation/results/timeouts.out Wed Apr 22 18:33:28 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/6701 |
Fix FOR PORTION OF recomputing GENERATED STORED columns that depend on the range column |
|
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-22 18:09:58
+++ /Users/admin/pgsql/build/testrun/injection_points/isolation/results/repack.out 2026-04-22 18:15:35
@@ -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)
... |
|
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-22 18:09:58.157560600 +0000
+++ C:/cirrus/build/testrun/injection_points/isolation/results/repack.out 2026-04-22 18:22:15.663027200 +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(*)
... |
|
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-22 18:09:59.849911349 +0000
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/repack.out 2026-04-22 18:17:06.792922033 +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(*)
... |
|
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-22 18:10:00.546065821 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/injection_points/output_iso/results/repack.out 2026-04-22 18:20:06.780638666 +...
@@ -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-22 18:09:53.803589000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/repack.out 2026-04-22 18:16:01.266758000 +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 Wed Apr 22 18:10:16 2026
+++ /home/postgres/postgres/build/testrun/injection_points/isolation/results/repack.out Wed Apr 22 18:16:58 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(*)
... |
|
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-22 18:10:18.847854702 +0000
+++ /home/postgres/postgres/build/testrun/injection_points/isolation/results/repack.out 2026-04-22 18:14:08.229612432 +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/6217 |
tuple radix sort |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/regress-runn...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2026-04-22 17:32:03.953324000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress-running/regress/results/create_index.out 2026-04-22 17:40:38.507859000 +0...
@@ -2056,7 +2056,7 @@
QUERY PLAN
----------------------------------------------------------------------------
Aggregate
- -> Index Only Scan using tenk1_thous_tenthous on tenk1 t1
+ -> Seq Scan on tenk1 t1
Filter: ((thousand = 42) OR (thousand = (SubPlan expr_1)))
SubPlan expr_1
-> Limit
@@ -2225,9 +2225,11 @@
Filter: ((thousand = 42) OR (thousand = 41) OR (tenthous = 2))
-> Bitmap Index Scan on tenk2_hundred
Index Cond: (hundred = 42)
- -> Index Only Scan using tenk1_hundred on tenk1
- Index Cond: (hundred = 42)
-(9 rows)
+ -> Bitmap Heap Scan on tenk1
... |
| 59/6422 |
ANALYZE: hash-accelerate MCV tracking for equality-only types |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/regress-runn...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2026-04-22 07:26:31.740968000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress-running/regress/results/create_index.out 2026-04-22 07:35:45.141918000 +0...
@@ -2056,7 +2056,7 @@
QUERY PLAN
----------------------------------------------------------------------------
Aggregate
- -> Index Only Scan using tenk1_thous_tenthous on tenk1 t1
+ -> Seq Scan on tenk1 t1
Filter: ((thousand = 42) OR (thousand = (SubPlan expr_1)))
SubPlan expr_1
-> Limit
@@ -2225,9 +2225,11 @@
Filter: ((thousand = 42) OR (thousand = 41) OR (tenthous = 2))
-> Bitmap Index Scan on tenk2_hundred
Index Cond: (hundred = 42)
- -> Index Only Scan using tenk1_hundred on tenk1
- Index Cond: (hundred = 42)
-(9 rows)
+ -> Bitmap Heap Scan on tenk1
... |
| 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-22 02:35:37
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy2.out 2026-04-22 02:38:53
@@ -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, 43252, 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, 43252, 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-22 02:35:37
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/copy2.out 2026-04-22 02:40:33
@@ -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, 42495, 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, 42495, 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-22 02:35:37
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/copy2.out 2026-04-22 02:38: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, 42385, 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, 42385, 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-22 02:35:37
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/copy2.out 2026-04-22 02:38:57
@@ -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, 43807, 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, 43807, 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-22 02:35:40.924730200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy2.out 2026-04-22 02:41:04.244145800 +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, 43096, 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, 43096, 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-22 02:35:40.924730200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/copy2.out 2026-04-22 02:44:56.317895600 +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, 41395, 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, 41395, 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-22 02:35:40.924730200 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/copy2.out 2026-04-22 02:40:54.642580300 +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, 41583, 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, 41583, 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-22 02:35:40.924730200 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/copy2.out 2026-04-22 02:41:01.044437500 +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, 42258, 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, 42258, 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-22 02:35:31.139624105 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy2.out 2026-04-22 02:38:33.005752396 +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, 43255, 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, 43255, 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-22 02:35:31.139624105 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/copy2.out 2026-04-22 02:40:15.269423341 ...
@@ -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, 43020, 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, 43020, 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-22 02:35:31.139624105 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/copy2.out 2026-04-22 02:38:30.409764624 +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, 43172, 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, 43172, 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-22 02:35:31.139624105 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/copy2.out 2026-04-22 02:38:42.60...
@@ -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, 43132, 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, 43132, 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-22 02:36:17.941604481 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy2.out 2026-04-22 02:39:03.911167056...
@@ -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, 43782, 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, 43782, 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-22 02:36:17.941604481 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/copy2.out 2026-04-22 02:39:52.1674376...
@@ -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, 42400, 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, 42400, 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-22 02:36:17.941604481 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/copy2.out 2026-04-22 02:38:45.814413483 +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, 42260, 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, 42260, 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-22 02:36:17.941604481 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/copy2.out 2026-04-22 02:38:59...
@@ -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, 42336, 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, 42336, 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-22 02:35:26.297720000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy2.out 2026-04-22 02:39:33.807276000 +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, 42905, 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, 42905, 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-22 02:35:26.297720000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/copy2.out 2026-04-22 02:41:06.445422000 ...
@@ -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, 43276, 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, 43276, 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-22 02:35:26.297720000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/copy2.out 2026-04-22 02:39:37.528255000 +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, 43223, 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, 43223, 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-22 02:35:26.297720000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/copy2.out 2026-04-22 02:39:51.95...
@@ -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 - 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-22 02:35:39.657213960 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/copy2.out 2026-04-22 02:42:44.164562441 +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, 43204, 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, 43204, 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-22 02:35:39.657213960 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/copy2.out 2026-04-22 02:44:52.672573587 +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, 43244, 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, 43244, 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-22 02:35:39.657213960 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/copy2.out 2026-04-22 02:44:49.492573277 +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, 43136, 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, 43136, 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-22 02:35:39.657213960 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/copy2.out 2026-04-22 02:40:15.376579870 +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, 43187, 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, 43187, 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 Wed Apr 22 02:35:42 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy2.out Wed Apr 22 02:39:00 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, 43519, 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, 43519, 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 Wed Apr 22 02:35:42 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/copy2.out Wed Apr 22 02:41:32 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, 42956, 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, 42956, 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 Wed Apr 22 02:35:42 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/copy2.out Wed Apr 22 02:38:52 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, 42988, 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, 42988, 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 Wed Apr 22 02:35:42 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/copy2.out Wed Apr 22 02:39:03...
@@ -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, 43269, 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, 43269, 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/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/5470 |
Function scan FDW pushdown |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2026-04-21 21:53:15.486714000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2026-04-21 22:02:38.2954690...
@@ -12954,8 +12954,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | f | t
-(1 row)
+(0 rows)
-- After terminating the remote backend, since the connection is closed,
-- "closed" should be TRUE, or NULL if the connection status check
@@ -12971,8 +12970,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
... |
| 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
... |
| 59/6543 |
synchronized_standby_slots behavior inconsistent with quorum-based synchronous replication |
|
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-19 10:47:04.277615300 +0000
+++ C:/cirrus/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-04-19 10:58:19.961052100 +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-19 10:44:43.660377198 +0000
+++ /tmp/cirrus-ci-build/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-04-19 10:49:56.861744736 +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 |
|
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-19 10:44:15
+++ /Users/admin/pgsql/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-04-19 10:52:50
@@ -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 Sun Apr 19 10:47:20 2026
+++ /home/postgres/postgres/build/testrun/unsafe_tests/regress/results/guc_privs.out Sun Apr 19 10:55:12 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 |
|
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-19 10:55:56.846966036 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/results/guc_privs.out 2026-04-19 11:03:34.150565332 +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-19 10:44:34.428608530 +0000
+++ /home/postgres/postgres/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-04-19 10:48:13.509517628 +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 |
|
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-19 10:44:07.350037000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-04-19 10:49:06.334365000 +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/6270 |
skip check constraints verification for unaffected columns during UPDATE |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/for_portion_of.out C:/cirrus/build/testrun/pg_upgrade/0...
--- C:/cirrus/src/test/regress/expected/for_portion_of.out 2026-04-19 06:48:25.579589200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out 2026-04-19 06:51:55.904358000 +000...
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/for_portion_of.out C:/cirrus/build/testrun/recovery/027...
--- C:/cirrus/src/test/regress/expected/for_portion_of.out 2026-04-19 06:48:25.579589200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out 2026-04-19 06:56:15.293456000 +0...
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/for_portion_of.out C:/cirrus/build/testrun/regress/regr...
--- C:/cirrus/src/test/regress/expected/for_portion_of.out 2026-04-19 06:48:25.579589200 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/for_portion_of.out 2026-04-19 06:51:44.351155300 +0000
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/for_portion_of.out C:/cirrus/build/testrun/test_plan_ad...
--- C:/cirrus/src/test/regress/expected/for_portion_of.out 2026-04-19 06:48:25.579589200 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/for_portion_of.out 2026-04-19 06:51:49.3208...
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade...
--- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-04-19 06:47:10.371701979 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out 2026-04-19 06:50:47.057...
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/recovery/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-04-19 06:47:10.371701979 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out 2026-04-19 06:52:39.6...
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/regress/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-04-19 06:47:10.371701979 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/for_portion_of.out 2026-04-19 06:50:45.913761850 +0000
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/test_plan_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-04-19 06:47:10.371701979 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/for_portion_of.out 2026-04-19 06...
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out /Users/admin/pgsql/build/testrun/pg_upgrade/002...
--- /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out 2026-04-19 06:46:55
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out 2026-04-19 06:49:34
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out /Users/admin/pgsql/build/testrun/recovery/027_s...
--- /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out 2026-04-19 06:46:55
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out 2026-04-19 06:51:01
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out /Users/admin/pgsql/build/testrun/regress/regres...
--- /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out 2026-04-19 06:46:55
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/for_portion_of.out 2026-04-19 06:49:28
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out /Users/admin/pgsql/build/testrun/test_plan_advi...
--- /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out 2026-04-19 06:46:55
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/for_portion_of.out 2026-04-19 06:4...
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/for_portion_of.out /home/postgres/postgres/build/testrun/pg_u...
--- /home/postgres/postgres/src/test/regress/expected/for_portion_of.out 2026-04-19 06:49:03.708145722 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out 2026-04-19 06:51:37....
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/for_portion_of.out /home/postgres/postgres/build/testrun/reco...
--- /home/postgres/postgres/src/test/regress/expected/for_portion_of.out 2026-04-19 06:49:03.708145722 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out 2026-04-19 06:52:3...
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/for_portion_of.out /home/postgres/postgres/build/testrun/regr...
--- /home/postgres/postgres/src/test/regress/expected/for_portion_of.out 2026-04-19 06:49:03.708145722 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/for_portion_of.out 2026-04-19 06:51:32.999318383 +0000
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/for_portion_of.out /home/postgres/postgres/build/testrun/test...
--- /home/postgres/postgres/src/test/regress/expected/for_portion_of.out 2026-04-19 06:49:03.708145722 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/for_portion_of.out 2026-04-19...
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_c...
--- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-04-19 06:48:02.978980874 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/for_portion_of.out 2026-04-19 06:54:56.026938235 +0000
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/src/test/modules/test_pl...
--- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-04-19 06:48:02.978980874 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/for_portion_of.out 2026-04-19 06:56:52.2829...
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/src/test/recovery/tmp_ch...
--- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-04-19 06:48:02.978980874 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/for_portion_of.out 2026-04-19 06:56:37.418923342 +0000
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/src/test/regress/results...
--- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-04-19 06:48:02.978980874 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/for_portion_of.out 2026-04-19 06:52:30.306969082 +0000
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/for_portion_of.out /home/postgres/postgres/build/testrun/pg_u...
--- /home/postgres/postgres/src/test/regress/expected/for_portion_of.out Sun Apr 19 06:47:37 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out Sun Apr 19 06:51:01 ...
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/for_portion_of.out /home/postgres/postgres/build/testrun/reco...
--- /home/postgres/postgres/src/test/regress/expected/for_portion_of.out Sun Apr 19 06:47:37 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out Sun Apr 19 06:53:2...
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/for_portion_of.out /home/postgres/postgres/build/testrun/regr...
--- /home/postgres/postgres/src/test/regress/expected/for_portion_of.out Sun Apr 19 06:47:37 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/for_portion_of.out Sun Apr 19 06:50:51 2026
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/for_portion_of.out /home/postgres/postgres/build/testrun/test...
--- /home/postgres/postgres/src/test/regress/expected/for_portion_of.out Sun Apr 19 06:47:37 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/for_portion_of.out Sun Apr 19...
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade...
--- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-04-19 06:46:59.400879000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out 2026-04-19 06:49:34.458...
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/recovery/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-04-19 06:46:59.400879000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out 2026-04-19 06:51:18.8...
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out 2026-04-19 06:46:59.386481000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/constraints.out 2026-04-19 06:49:55.983758000 +0000
@@ -1922,5 +1922,6 @@
DROP FUNCTION dummy_update_func_in_constr;
DROP TABLE upd_check_skip0;
DROP TABLE upd_check_skip;
+DEBUG: rehashing catalog cache id 89 for pg_type; 129 tups, 64 buckets
RESET client_min_messages;
RESET log_statement;
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/regress/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-04-19 06:46:59.400879000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/for_portion_of.out 2026-04-19 06:49:42.905651000 +0000
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/test_plan_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-04-19 06:46:59.400879000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/for_portion_of.out 2026-04-19 06...
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| 59/6553 |
Decorrelate nested tuple hash tables |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/union.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/union.out 2026-04-18 11:18:32.334416000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/union.out 2026-04-18 11:20:22.051432000 +0...
@@ -550,9 +550,9 @@
select x from (values (array[1, 2]), (array[1, 3])) _(x) union select x from (values (array[1, 2]), (array[1, 4])) _(x)...
x
-------
+ {1,2}
{1,4}
{1,3}
- {1,2}
(3 rows)
explain (costs off) |
| 59/5720 |
virtual generated column as partition key |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out /Users/admin/pgsql/build/testrun/pg_upgrade/...
--- /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out 2026-04-17 07:26:03
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-04-17 07:29:22
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out /Users/admin/pgsql/build/testrun/recovery/02...
--- /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out 2026-04-17 07:26:03
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-04-17 07:30:52
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out /Users/admin/pgsql/build/testrun/regress/reg...
--- /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out 2026-04-17 07:26:03
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/generated_virtual.out 2026-04-17 07:29:17
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out /Users/admin/pgsql/build/testrun/test_plan_a...
--- /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out 2026-04-17 07:26:03
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/generated_virtual.out 2026-04-17 0...
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/pg_upgr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-04-17 07:26:02.439405714 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-04-17 07:30:41....
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/recover...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-04-17 07:26:02.439405714 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-04-17 07:32:1...
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-04-17 07:26:02.439405714 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_virtual.out 2026-04-17 07:30:43.067439902 +0000
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/test_pl...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-04-17 07:26:02.439405714 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/generated_virtual.out 2026-04-17...
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tm...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-04-17 07:26:30.141726588 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/generated_virtual.out 2026-04-17 07:34:33.840998886 +0000
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/src/test/modules/test...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-04-17 07:26:30.141726588 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/generated_virtual.out 2026-04-17 07:37:09.0...
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/src/test/recovery/tmp...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-04-17 07:26:30.141726588 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/generated_virtual.out 2026-04-17 07:36:31.228885543 +0000
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/src/test/regress/resu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-04-17 07:26:30.141726588 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/generated_virtual.out 2026-04-17 07:32:12.693079415 +0000
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/p...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out Fri Apr 17 07:26:23 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out Fri Apr 17 07:30:...
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/r...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out Fri Apr 17 07:26:23 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out Fri Apr 17 07:3...
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/r...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out Fri Apr 17 07:26:23 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_virtual.out Fri Apr 17 07:30:39 2026
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/t...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out Fri Apr 17 07:26:23 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/generated_virtual.out Fri Apr...
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/p...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out 2026-04-17 07:26:35.355456588 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-04-17 07:29:...
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/r...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out 2026-04-17 07:26:35.355456588 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-04-17 07:3...
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/r...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out 2026-04-17 07:26:35.355456588 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_virtual.out 2026-04-17 07:29:30.964081852 +0...
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/t...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out 2026-04-17 07:26:35.355456588 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/generated_virtual.out 2026-04...
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/pg_upgr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-04-17 07:26:03.608520000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-04-17 07:29:45....
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/recover...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-04-17 07:26:03.608520000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-04-17 07:31:1...
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-04-17 07:26:03.608520000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_virtual.out 2026-04-17 07:29:33.038739000 +0000
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/test_pl...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-04-17 07:26:03.608520000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/generated_virtual.out 2026-04-17...
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/pg_upgrad...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2026-04-17 07:27:36.804331000 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-04-17 07:31:50.194091800 +...
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/recovery/...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2026-04-17 07:27:36.804331000 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-04-17 07:35:36.357473100...
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/regress/r...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2026-04-17 07:27:36.804331000 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_virtual.out 2026-04-17 07:31:42.156026200 +0000
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/test_plan...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2026-04-17 07:27:36.804331000 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/generated_virtual.out 2026-04-17 07:31:47.3...
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |