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/6601 |
pg_dump: fix NOT NULL constraint name comparison using makeObjectName |
 |
NetBSD - 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 2026-04-27 16:07:59.148775127 +0000
+++ /home/postgres/postgres/build/testrun/isolation/isolation/results/timeouts.out 2026-04-27 16:11:05.650609283 +0000
@@ -50,7 +50,7 @@
step slto: SET lock_timeout = '10s'; 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: wrtbl sto update
step wrtbl: UPDATE accounts SET balance = balance + 100; |
| 59/6303 |
refactor handling optional argument in system functions |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/rangetypes.out /home/postgres/postgres/build/testrun/test_pla...
--- /home/postgres/postgres/src/test/regress/expected/rangetypes.out 2026-04-27 14:48:38.111514725 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/rangetypes.out 2026-04-27 14:...
@@ -1,2035 +1,2 @@
--- Tests for range data types.
---
--- test input parser
--- (type textrange was already made in test_setup.sql)
---
--- negative tests; should fail
-select ''::textrange;
-ERROR: malformed range literal: ""
-LINE 1: select ''::textrange;
- ^
-DETAIL: Missing left parenthesis or bracket.
-select '-[a,z)'::textrange;
-ERROR: malformed range literal: "-[a,z)"
-LINE 1: select '-[a,z)'::textrange;
- ^
-DETAIL: Missing left parenthesis or bracket.
... |
| 59/6274 |
Add a greedy join search algorithm to handle large join problems |
|
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-27 13:02:03
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-04-27 13:06:14
@@ -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-27 13:02:03
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-04-27 13:07:58
@@ -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-27 13:02:03
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/goo.out 2026-04-27 13:06:19
@@ -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-27 13:02:03
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out 2026-04-27 13:06:23
@@ -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
... |
|
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-27 13:01:57.381978500 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-04-27 13:05:48.900717400 +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-27 13:01:57.381978500 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-04-27 13:09:30.815745400 +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-27 13:01:57.381978500 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/goo.out 2026-04-27 13:05:49.666346800 +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-27 13:01:57.381978500 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out 2026-04-27 13:05:51.218096300 +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-27 13:01:56.062509622 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-04-27 13:06:02.105593533 +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-27 13:01:56.062509622 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-04-27 13:07:53.670878383 +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-27 13:01:56.062509622 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/goo.out 2026-04-27 13:06:04.537584667 +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-27 13:01:56.062509622 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out 2026-04-27 13:06:09.2575...
@@ -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 Mon Apr 27 13:02:14 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out Mon Apr 27 13:06:10 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 Mon Apr 27 13:02:14 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/goo.out Mon Apr 27 13:08:59 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 Mon Apr 27 13:02:14 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/goo.out Mon Apr 27 13:06:03 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 Mon Apr 27 13:02:14 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out Mon Apr 27 13:06:07 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
... |
|
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-27 13:01:56.174226000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-04-27 13:05:52.215178000 +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-27 13:01:56.174226000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-04-27 13:07:59.618350000 +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-27 13:01:56.174226000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/goo.out 2026-04-27 13:05:57.083582000 +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-27 13:01:56.174226000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out 2026-04-27 13:05:59.0636...
@@ -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-27 13:02:06.533625455 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/goo.out 2026-04-27 13:08:56.418850040 +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/modules/test_plan_advice/t...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-27 13:02:06.533625455 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/goo.out 2026-04-27 13:11:36.114536292 +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-27 13:02:06.533625455 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/goo.out 2026-04-27 13:11:15.414013600 +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-27 13:02:06.533625455 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/goo.out 2026-04-27 13:06:54.549159355 +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
... |
| 59/6664 |
Support EXCEPT for ALL SEQUENCES publications |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-04-27 12:54:20.793847642 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2026-04-27 12:59:33.305436...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-04-27 12:54:20.793847642 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/publication.out 2026-04-27 13:01:06.3093...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-04-27 12:54:20.793847642 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/publication.out 2026-04-27 12:59:31.765436924 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/test_plan_adv...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-04-27 12:54:20.793847642 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/publication.out 2026-04-27 12:59...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/publication.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg...
--- /Users/admin/pgsql/src/test/regress/expected/publication.out 2026-04-27 12:54:21
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2026-04-27 12:57:59
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/publication.out /Users/admin/pgsql/build/testrun/recovery/027_stre...
--- /Users/admin/pgsql/src/test/regress/expected/publication.out 2026-04-27 12:54:21
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/publication.out 2026-04-27 12:59:21
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/publication.out /Users/admin/pgsql/build/testrun/regress/regress/r...
--- /Users/admin/pgsql/src/test/regress/expected/publication.out 2026-04-27 12:54:21
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/publication.out 2026-04-27 12:58:01
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/publication.out /Users/admin/pgsql/build/testrun/test_plan_advice/...
--- /Users/admin/pgsql/src/test/regress/expected/publication.out 2026-04-27 12:54:21
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/publication.out 2026-04-27 12:58:0...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/publication.out C:/cirrus/build/testrun/pg_upgrade/002_...
--- C:/cirrus/src/test/regress/expected/publication.out 2026-04-27 12:54:24.146374200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2026-04-27 12:58:52.486049000 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/publication.out C:/cirrus/build/testrun/recovery/027_st...
--- C:/cirrus/src/test/regress/expected/publication.out 2026-04-27 12:54:24.146374200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/publication.out 2026-04-27 13:02:36.145202600 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/publication.out C:/cirrus/build/testrun/regress/regress...
--- C:/cirrus/src/test/regress/expected/publication.out 2026-04-27 12:54:24.146374200 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/publication.out 2026-04-27 12:58:42.937710200 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/publication.out C:/cirrus/build/testrun/test_plan_advic...
--- C:/cirrus/src/test/regress/expected/publication.out 2026-04-27 12:54:24.146374200 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/publication.out 2026-04-27 12:58:51.7663345...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/pg_upgr...
--- /home/postgres/postgres/src/test/regress/expected/publication.out Mon Apr 27 12:54:36 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out Mon Apr 27 12:59:39 202...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/recover...
--- /home/postgres/postgres/src/test/regress/expected/publication.out Mon Apr 27 12:54:36 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/publication.out Mon Apr 27 13:02:17 2...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/regress...
--- /home/postgres/postgres/src/test/regress/expected/publication.out Mon Apr 27 12:54:36 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/publication.out Mon Apr 27 12:59:30 2026
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/test_pl...
--- /home/postgres/postgres/src/test/regress/expected/publication.out Mon Apr 27 12:54:36 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/publication.out Mon Apr 27 12...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/pg_upgr...
--- /home/postgres/postgres/src/test/regress/expected/publication.out 2026-04-27 12:55:16.421896096 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2026-04-27 12:59:00.662...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/recover...
--- /home/postgres/postgres/src/test/regress/expected/publication.out 2026-04-27 12:55:16.421896096 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/publication.out 2026-04-27 12:59:51.9...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/regress...
--- /home/postgres/postgres/src/test/regress/expected/publication.out 2026-04-27 12:55:16.421896096 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/publication.out 2026-04-27 12:58:53.377372113 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/test_pl...
--- /home/postgres/postgres/src/test/regress/expected/publication.out 2026-04-27 12:55:16.421896096 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/publication.out 2026-04-27 12...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-04-27 12:54:35.891165000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2026-04-27 12:59:52.787363...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-04-27 12:54:35.891165000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/publication.out 2026-04-27 13:02:01.1456...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-04-27 12:54:35.891165000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/publication.out 2026-04-27 13:00:03.309200000 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/test_plan_adv...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-04-27 12:54:35.891165000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/publication.out 2026-04-27 13:00...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_chec...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-04-27 12:54:36.131785603 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/publication.out 2026-04-27 13:03:43.727401163 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/src/test/modules/test_plan_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-04-27 12:54:36.131785603 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/publication.out 2026-04-27 13:05:35.0753984...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-04-27 12:54:36.131785603 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/publication.out 2026-04-27 13:04:38.223400430 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/src/test/regress/results/pu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-04-27 12:54:36.131785603 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/publication.out 2026-04-27 13:00:32.411408782 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| 59/6644 |
Extract numeric filed in JSONB more effectively |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/resu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2026-04-27 05:36:24.647906041 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/jsonb.out 2026-04-27 05:44:39.174473817 +0000
@@ -1714,7 +1714,7 @@
-- Section T4: silent semantics
SELECT (jsonb_path_query_first_tz('{"a":"text"}'::jsonb, '$.a', '{}', true))::int4; -- cast error not suppressed
-ERROR: cannot cast jsonb string to type integer
+ERROR: unknown jsonb type: 442280
SELECT (jsonb_path_query_first_tz('{"a":1}'::jsonb, 'strict $.b', '{}', false))::int4; -- strict error
ERROR: JSON object does not contain key "b"
SELECT (jsonb_path_query_first_tz('{"a":1}'::jsonb, 'strict $.b', '{}', true))::int4; -- suppressed, NULL
@@ -1725,7 +1725,7 @@
-- Section T5: type-mismatch errors
SELECT (jsonb_path_query_first_tz('{"a":"hello"}'::jsonb, '$.a'))::int4;
-ERROR: cannot cast jsonb string to type integer
+ERROR: unknown jsonb type: 442280
-- Section T6: direct calls to typed extractor builtins
SELECT jsonb_path_query_first_tz_int4('{"a":42}'::jsonb, '$.a'::jsonpath, '{}'::jsonb, false);
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/src/test/modules/test_plan_advice...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2026-04-27 05:36:24.647906041 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/jsonb.out 2026-04-27 05:46:12.848841877 +00...
@@ -1714,7 +1714,7 @@
-- Section T4: silent semantics
SELECT (jsonb_path_query_first_tz('{"a":"text"}'::jsonb, '$.a', '{}', true))::int4; -- cast error not suppressed
-ERROR: cannot cast jsonb string to type integer
+ERROR: unknown jsonb type: 473000
SELECT (jsonb_path_query_first_tz('{"a":1}'::jsonb, 'strict $.b', '{}', false))::int4; -- strict error
ERROR: JSON object does not contain key "b"
SELECT (jsonb_path_query_first_tz('{"a":1}'::jsonb, 'strict $.b', '{}', true))::int4; -- suppressed, NULL
@@ -1725,7 +1725,7 @@
-- Section T5: type-mismatch errors
SELECT (jsonb_path_query_first_tz('{"a":"hello"}'::jsonb, '$.a'))::int4;
-ERROR: cannot cast jsonb string to type integer
+ERROR: unknown jsonb type: 473000
-- Section T6: direct calls to typed extractor builtins
SELECT jsonb_path_query_first_tz_int4('{"a":42}'::jsonb, '$.a'::jsonpath, '{}'::jsonb, false);
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2026-04-27 05:36:24.647906041 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/jsonb.out 2026-04-27 05:46:12.764839674 +0000
@@ -1714,7 +1714,7 @@
-- Section T4: silent semantics
SELECT (jsonb_path_query_first_tz('{"a":"text"}'::jsonb, '$.a', '{}', true))::int4; -- cast error not suppressed
-ERROR: cannot cast jsonb string to type integer
+ERROR: unknown jsonb type: 442808
SELECT (jsonb_path_query_first_tz('{"a":1}'::jsonb, 'strict $.b', '{}', false))::int4; -- strict error
ERROR: JSON object does not contain key "b"
SELECT (jsonb_path_query_first_tz('{"a":1}'::jsonb, 'strict $.b', '{}', true))::int4; -- suppressed, NULL
@@ -1725,7 +1725,7 @@
-- Section T5: type-mismatch errors
SELECT (jsonb_path_query_first_tz('{"a":"hello"}'::jsonb, '$.a'))::int4;
-ERROR: cannot cast jsonb string to type integer
+ERROR: unknown jsonb type: 442808
-- Section T6: direct calls to typed extractor builtins
SELECT jsonb_path_query_first_tz_int4('{"a":42}'::jsonb, '$.a'::jsonpath, '{}'::jsonb, false);
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/src/test/regress/results/jsonb.ou...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2026-04-27 05:36:24.647906041 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/jsonb.out 2026-04-27 05:41:49.251155826 +0000
@@ -1714,7 +1714,7 @@
-- Section T4: silent semantics
SELECT (jsonb_path_query_first_tz('{"a":"text"}'::jsonb, '$.a', '{}', true))::int4; -- cast error not suppressed
-ERROR: cannot cast jsonb string to type integer
+ERROR: unknown jsonb type: 442280
SELECT (jsonb_path_query_first_tz('{"a":1}'::jsonb, 'strict $.b', '{}', false))::int4; -- strict error
ERROR: JSON object does not contain key "b"
SELECT (jsonb_path_query_first_tz('{"a":1}'::jsonb, 'strict $.b', '{}', true))::int4; -- suppressed, NULL
@@ -1725,7 +1725,7 @@
-- Section T5: type-mismatch errors
SELECT (jsonb_path_query_first_tz('{"a":"hello"}'::jsonb, '$.a'))::int4;
-ERROR: cannot cast jsonb string to type integer
+ERROR: unknown jsonb type: 442280
-- Section T6: direct calls to typed extractor builtins
SELECT jsonb_path_query_first_tz_int4('{"a":42}'::jsonb, '$.a'::jsonpath, '{}'::jsonb, false);
... |
| 59/6610 |
ORDER BY ALL |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_misc.out /tmp/cirrus-ci-build/build/testrun/plpgsql/re...
--- /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_misc.out 2026-04-27 04:01:04.108080988 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plpgsql/regress/results/plpgsql_misc.out 2026-04-27 04:07:40.918240415 +0000
@@ -194,7 +194,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_return();
- a | b | c
+ a | b | c
---+-----+-----
1 | bar | 2.5
1 | qux | 1.5
@@ -210,7 +210,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_desc_return();
- a | b | c
+ a | b | c
---+-----+-----
3 | foo | 1.5
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/pl/plpgsql/src/expected/plpgsql_misc.out /Users/admin/pgsql/build/testrun/plpgsql/regres...
--- /Users/admin/pgsql/src/pl/plpgsql/src/expected/plpgsql_misc.out 2026-04-27 04:01:13
+++ /Users/admin/pgsql/build/testrun/plpgsql/regress/results/plpgsql_misc.out 2026-04-27 04:08:18
@@ -194,7 +194,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_return();
- a | b | c
+ a | b | c
---+-----+-----
1 | bar | 2.5
1 | qux | 1.5
@@ -210,7 +210,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_desc_return();
- a | b | c
+ a | b | c
---+-----+-----
3 | foo | 1.5
... |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/pl/plpgsql/src/expected/plpgsql_misc.out C:/cirrus/build/testrun/plpgsql/regr...
--- C:/cirrus/src/pl/plpgsql/src/expected/plpgsql_misc.out 2026-04-27 04:01:06.564122100 +0000
+++ C:/cirrus/build/testrun/plpgsql/regress/results/plpgsql_misc.out 2026-04-27 04:10:14.938484200 +0000
@@ -194,7 +194,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_return();
- a | b | c
+ a | b | c
---+-----+-----
1 | bar | 2.5
1 | qux | 1.5
@@ -210,7 +210,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_desc_return();
- a | b | c
+ a | b | c
---+-----+-----
3 | foo | 1.5
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/pl/plpgsql/src/expected/plpgsql_misc.out /home/postgres/postgres/build/testrun/plpg...
--- /home/postgres/postgres/src/pl/plpgsql/src/expected/plpgsql_misc.out Mon Apr 27 04:01:14 2026
+++ /home/postgres/postgres/build/testrun/plpgsql/regress/results/plpgsql_misc.out Mon Apr 27 04:07:42 2026
@@ -194,7 +194,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_return();
- a | b | c
+ a | b | c
---+-----+-----
1 | bar | 2.5
1 | qux | 1.5
@@ -210,7 +210,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_desc_return();
- a | b | c
+ a | b | c
---+-----+-----
3 | foo | 1.5
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_misc.out /tmp/cirrus-ci-build/src/pl/plpgsql/src/resul...
--- /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_misc.out 2026-04-27 04:01:08.242381028 +0000
+++ /tmp/cirrus-ci-build/src/pl/plpgsql/src/results/plpgsql_misc.out 2026-04-27 04:05:19.481299977 +0000
@@ -194,7 +194,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_return();
- a | b | c
+ a | b | c
---+-----+-----
1 | bar | 2.5
1 | qux | 1.5
@@ -210,7 +210,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_desc_return();
- a | b | c
+ a | b | c
---+-----+-----
3 | foo | 1.5
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/pl/plpgsql/src/expected/plpgsql_misc.out /home/postgres/postgres/build/testrun/plpg...
--- /home/postgres/postgres/src/pl/plpgsql/src/expected/plpgsql_misc.out 2026-04-27 04:01:31.357454487 +0000
+++ /home/postgres/postgres/build/testrun/plpgsql/regress/results/plpgsql_misc.out 2026-04-27 04:05:37.655346565 +0000
@@ -194,7 +194,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_return();
- a | b | c
+ a | b | c
---+-----+-----
1 | bar | 2.5
1 | qux | 1.5
@@ -210,7 +210,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_desc_return();
- a | b | c
+ a | b | c
---+-----+-----
3 | foo | 1.5
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_misc.out /tmp/cirrus-ci-build/build/testrun/plpgsql/re...
--- /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_misc.out 2026-04-27 04:01:03.765882000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plpgsql/regress/results/plpgsql_misc.out 2026-04-27 04:04:58.431789000 +0000
@@ -194,7 +194,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_return();
- a | b | c
+ a | b | c
---+-----+-----
1 | bar | 2.5
1 | qux | 1.5
@@ -210,7 +210,7 @@
end;
$$ language plpgsql;
select * from test_order_by_all_desc_return();
- a | b | c
+ a | b | c
---+-----+-----
3 | foo | 1.5
... |
| 59/4971 |
[CREATE|RE] INDEX CONCURRENTLY with single heap scan |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/indexing.out 2026-04-26 10:15:56.928637900 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-26 10:20:54.127266300 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/indexing.out 2026-04-26 10:15:56.928637900 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-26 10:23:58.634578800 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/indexing.out 2026-04-26 10:15:56.928637900 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/indexing.out 2026-04-26 10:20:34.923162400 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/test_plan_advice/0...
--- C:/cirrus/src/test/regress/expected/indexing.out 2026-04-26 10:15:56.928637900 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-26 10:20:47.942205100 ...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 10:15:56.884805407 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-26 10:21:24.862997915...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 10:15:56.884805407 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-26 10:23:00.8058707...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 10:15:56.884805407 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/indexing.out 2026-04-26 10:21:25.914981743 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 10:15:56.884805407 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-26 10:21:31...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-04-26 10:16:37
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-26 10:22:38
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-04-26 10:16:37
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-26 10:23:52
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/regress/regress/resu...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-04-26 10:16:37
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/indexing.out 2026-04-26 10:22:34
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/test_plan_advice/001...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-04-26 10:16:37
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-26 10:22:39
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/pg_upgrade...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out Sun Apr 26 10:16:13 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out Sun Apr 26 10:22:33 2026
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out Sun Apr 26 10:16:13 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/indexing.out Sun Apr 26 10:25:48 2026
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/regress/re...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out Sun Apr 26 10:16:13 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/indexing.out Sun Apr 26 10:22:17 2026
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/test_plan_...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out Sun Apr 26 10:16:13 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out Sun Apr 26 10:22...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 10:15:54.075674000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-26 10:21:43.163633000...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 10:15:54.075674000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-26 10:23:29.1247090...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 10:15:54.075674000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/indexing.out 2026-04-26 10:22:02.867444000 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 10:15:54.075674000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-26 10:22:07...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/pg_upgrade...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out 2026-04-26 10:16:29.433038753 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-26 10:20:20.572808...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out 2026-04-26 10:16:29.433038753 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-26 10:21:21.2472...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/regress/re...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out 2026-04-26 10:16:29.433038753 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/indexing.out 2026-04-26 10:20:20.010041483 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/test_plan_...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out 2026-04-26 10:16:29.433038753 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-26 10:20...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 10:16:03.562872958 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/indexing.out 2026-04-26 10:26:28.549419110 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/test/modules/test_plan_adv...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 10:16:03.562872958 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/indexing.out 2026-04-26 10:28:05.566896442 ...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 10:16:03.562872958 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/indexing.out 2026-04-26 10:28:07.474925920 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/test/regress/results/index...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 10:16:03.562872958 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/indexing.out 2026-04-26 10:23:54.959258582 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| 59/6059 |
Improving the names generated for indexes on expressions |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/indexing.out 2026-04-26 08:02:20.227151200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-26 08:07:44.754768100 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/indexing.out 2026-04-26 08:02:20.227151200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-26 08:11:41.237302500 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/indexing.out 2026-04-26 08:02:20.227151200 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/indexing.out 2026-04-26 08:07:32.303576500 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/test_plan_advice/0...
--- C:/cirrus/src/test/regress/expected/indexing.out 2026-04-26 08:02:20.227151200 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-26 08:07:39.470106800 ...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-04-26 08:00:19
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-26 08:04:39
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-04-26 08:00:19
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-26 08:06:56
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/regress/regress/resu...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-04-26 08:00:19
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/indexing.out 2026-04-26 08:04:37
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/test_plan_advice/001...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-04-26 08:00:19
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-26 08:04:50
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 08:00:54.608873613 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-26 08:06:40.116973494...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 08:00:54.608873613 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-26 08:08:26.2179440...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 08:00:54.608873613 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/indexing.out 2026-04-26 08:06:43.845041355 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 08:00:54.608873613 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-26 08:06:48...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 08:00:49.398432000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-26 08:07:39.824690000...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 08:00:49.398432000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-26 08:09:05.2566640...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 08:00:49.398432000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/indexing.out 2026-04-26 08:07:26.918646000 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 08:00:49.398432000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-26 08:07:36...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/pg_upgrade...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out Sun Apr 26 08:01:40 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out Sun Apr 26 08:06:43 2026
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out Sun Apr 26 08:01:40 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/indexing.out Sun Apr 26 08:09:21 2026
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/regress/re...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out Sun Apr 26 08:01:40 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/indexing.out Sun Apr 26 08:06:36 2026
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/test_plan_...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out Sun Apr 26 08:01:40 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out Sun Apr 26 08:06...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 08:00:54.477737466 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/indexing.out 2026-04-26 08:10:31.041296215 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/test/modules/test_plan_adv...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 08:00:54.477737466 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/indexing.out 2026-04-26 08:12:21.513235939 ...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 08:00:54.477737466 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/indexing.out 2026-04-26 08:12:10.669241778 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/test/regress/results/index...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-26 08:00:54.477737466 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/indexing.out 2026-04-26 08:07:44.937394023 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/pg_upgrade...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out 2026-04-26 08:01:17.362686108 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-26 08:05:56.733224...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out 2026-04-26 08:01:17.362686108 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-26 08:07:00.5314...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/regress/re...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out 2026-04-26 08:01:17.362686108 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/indexing.out 2026-04-26 08:05:42.532208480 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/test_plan_...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out 2026-04-26 08:01:17.362686108 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-26 08:06...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| 59/6701 |
Fix FOR PORTION OF recomputing GENERATED STORED columns that depend on the range column |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/injection_points/expected/repack.out C:/cirrus/build/testrun/inj...
--- C:/cirrus/src/test/modules/injection_points/expected/repack.out 2026-04-26 04:09:19.029481400 +0000
+++ C:/cirrus/build/testrun/injection_points/isolation/results/repack.out 2026-04-26 04:20:52.745746500 +0000
@@ -68,46 +68,7 @@
(1 row)
-step wait_before_lock: <... completed>
-step check1:
- INSERT INTO relfilenodes(node)
- SELECT relfilenode FROM pg_class WHERE relname='repack_test';
-
- SELECT count(DISTINCT node) FROM relfilenodes;
-
- SELECT i, j FROM repack_test ORDER BY i, j;
-
- INSERT INTO data_s1(i, j)
- SELECT i, j FROM repack_test;
-
- SELECT count(*)
... |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/modules/injection_points/expected/repack.out /Users/admin/pgsql/build/testrun/injec...
--- /Users/admin/pgsql/src/test/modules/injection_points/expected/repack.out 2026-04-26 04:06:58
+++ /Users/admin/pgsql/build/testrun/injection_points/isolation/results/repack.out 2026-04-26 04:12:55
@@ -68,46 +68,7 @@
(1 row)
-step wait_before_lock: <... completed>
-step check1:
- INSERT INTO relfilenodes(node)
- SELECT relfilenode FROM pg_class WHERE relname='repack_test';
+PQconsumeInput failed: server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
- SELECT count(DISTINCT node) FROM relfilenodes;
-
- SELECT i, j FROM repack_test ORDER BY i, j;
-
- INSERT INTO data_s1(i, j)
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/repack.out /tmp/cirrus-ci-build/build/testrun/i...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/repack.out 2026-04-26 04:08:20.686354591 +0000
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/repack.out 2026-04-26 04:15:06.964293627 +0000
@@ -68,46 +68,7 @@
(1 row)
-step wait_before_lock: <... completed>
-step check1:
- INSERT INTO relfilenodes(node)
- SELECT relfilenode FROM pg_class WHERE relname='repack_test';
-
- SELECT count(DISTINCT node) FROM relfilenodes;
-
- SELECT i, j FROM repack_test ORDER BY i, j;
-
- INSERT INTO data_s1(i, j)
- SELECT i, j FROM repack_test;
-
- SELECT count(*)
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/repack.out /tmp/cirrus-ci-build/build/testrun/i...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/repack.out 2026-04-26 04:08:28.444379000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/repack.out 2026-04-26 04:14:16.161817000 +0000
@@ -68,46 +68,6 @@
(1 row)
-step wait_before_lock: <... completed>
-step check1:
- INSERT INTO relfilenodes(node)
- SELECT relfilenode FROM pg_class WHERE relname='repack_test';
-
- SELECT count(DISTINCT node) FROM relfilenodes;
-
- SELECT i, j FROM repack_test ORDER BY i, j;
-
- INSERT INTO data_s1(i, j)
- SELECT i, j FROM repack_test;
-
- SELECT count(*)
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/injection_points/expected/repack.out /home/postgres/postgres/build/tes...
--- /home/postgres/postgres/src/test/modules/injection_points/expected/repack.out Sun Apr 26 04:09:10 2026
+++ /home/postgres/postgres/build/testrun/injection_points/isolation/results/repack.out Sun Apr 26 04:16:22 2026
@@ -68,46 +68,7 @@
(1 row)
-step wait_before_lock: <... completed>
-step check1:
- INSERT INTO relfilenodes(node)
- SELECT relfilenode FROM pg_class WHERE relname='repack_test';
-
- SELECT count(DISTINCT node) FROM relfilenodes;
-
- SELECT i, j FROM repack_test ORDER BY i, j;
-
- INSERT INTO data_s1(i, j)
- SELECT i, j FROM repack_test;
-
- SELECT count(*)
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/repack.out /tmp/cirrus-ci-build/src/test/module...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/repack.out 2026-04-26 04:08:11.334464059 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/injection_points/output_iso/results/repack.out 2026-04-26 04:17:45.895003521 +...
@@ -68,46 +68,7 @@
(1 row)
-step wait_before_lock: <... completed>
-step check1:
- INSERT INTO relfilenodes(node)
- SELECT relfilenode FROM pg_class WHERE relname='repack_test';
-
- SELECT count(DISTINCT node) FROM relfilenodes;
-
- SELECT i, j FROM repack_test ORDER BY i, j;
-
- INSERT INTO data_s1(i, j)
- SELECT i, j FROM repack_test;
-
- SELECT count(*)
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/injection_points/expected/repack.out /home/postgres/postgres/build/tes...
--- /home/postgres/postgres/src/test/modules/injection_points/expected/repack.out 2026-04-26 04:08:21.744543413 +0000
+++ /home/postgres/postgres/build/testrun/injection_points/isolation/results/repack.out 2026-04-26 04:12:17.813327035 +0...
@@ -68,46 +68,7 @@
(1 row)
-step wait_before_lock: <... completed>
-step check1:
- INSERT INTO relfilenodes(node)
- SELECT relfilenode FROM pg_class WHERE relname='repack_test';
-
- SELECT count(DISTINCT node) FROM relfilenodes;
-
- SELECT i, j FROM repack_test ORDER BY i, j;
-
- INSERT INTO data_s1(i, j)
- SELECT i, j FROM repack_test;
-
- SELECT count(*)
... |
| 59/4817 |
COPY (on_error table) saving error info to a table |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/copy2.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgra...
--- /Users/admin/pgsql/src/test/regress/expected/copy2.out 2026-04-25 13:01:36
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy2.out 2026-04-25 13:07:10
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42092, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42092, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/copy2.out /Users/admin/pgsql/build/testrun/recovery/027_stream_reg...
--- /Users/admin/pgsql/src/test/regress/expected/copy2.out 2026-04-25 13:01:36
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/copy2.out 2026-04-25 13:09:08
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42676, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42676, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/copy2.out /Users/admin/pgsql/build/testrun/regress/regress/results...
--- /Users/admin/pgsql/src/test/regress/expected/copy2.out 2026-04-25 13:01:36
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/copy2.out 2026-04-25 13:07:08
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42424, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42424, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/copy2.out /Users/admin/pgsql/build/testrun/test_plan_advice/001_re...
--- /Users/admin/pgsql/src/test/regress/expected/copy2.out 2026-04-25 13:01:36
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/copy2.out 2026-04-25 13:07:08
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43459, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43459, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/copy2.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upg...
--- C:/cirrus/src/test/regress/expected/copy2.out 2026-04-25 12:57:54.021815400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy2.out 2026-04-25 13:03:11.693798200 +0000
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42264, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42264, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/copy2.out C:/cirrus/build/testrun/recovery/027_stream_r...
--- C:/cirrus/src/test/regress/expected/copy2.out 2026-04-25 12:57:54.021815400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/copy2.out 2026-04-25 13:07:05.611714200 +0000
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 41523, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 41523, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/copy2.out C:/cirrus/build/testrun/regress/regress/resul...
--- C:/cirrus/src/test/regress/expected/copy2.out 2026-04-25 12:57:54.021815400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/copy2.out 2026-04-25 13:03:08.248982300 +0000
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43041, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43041, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/copy2.out C:/cirrus/build/testrun/test_plan_advice/001_...
--- C:/cirrus/src/test/regress/expected/copy2.out 2026-04-25 12:57:54.021815400 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/copy2.out 2026-04-25 13:03:01.687444700 +00...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43380, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43380, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:57:48.227616398 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy2.out 2026-04-25 13:01:23.083552358 +0...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43271, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43271, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:57:48.227616398 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/copy2.out 2026-04-25 13:02:59.359010510 ...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42987, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42987, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/build/testrun/regress/regress/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:57:48.227616398 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/copy2.out 2026-04-25 13:01:22.219577476 +0000
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43080, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43080, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:57:48.227616398 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/copy2.out 2026-04-25 13:01:28.22...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43167, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43167, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/copy2.out /home/postgres/postgres/build/testrun/pg_upgrade/00...
--- /home/postgres/postgres/src/test/regress/expected/copy2.out Sat Apr 25 12:58:07 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy2.out Sat Apr 25 13:02:13 2026
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43577, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43577, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/copy2.out /home/postgres/postgres/build/testrun/recovery/027_...
--- /home/postgres/postgres/src/test/regress/expected/copy2.out Sat Apr 25 12:58:07 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/copy2.out Sat Apr 25 13:05:07 2026
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43385, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43385, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/copy2.out /home/postgres/postgres/build/testrun/regress/regre...
--- /home/postgres/postgres/src/test/regress/expected/copy2.out Sat Apr 25 12:58:07 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/copy2.out Sat Apr 25 13:02:02 2026
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43397, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43397, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/copy2.out /home/postgres/postgres/build/testrun/test_plan_adv...
--- /home/postgres/postgres/src/test/regress/expected/copy2.out Sat Apr 25 12:58:07 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/copy2.out Sat Apr 25 13:02:08...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43306, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43306, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:57:45.280121000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy2.out 2026-04-25 13:02:34.414774000 +0...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43076, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43076, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:57:45.280121000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/copy2.out 2026-04-25 13:03:59.415752000 ...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43300, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43300, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/build/testrun/regress/regress/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:57:45.280121000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/copy2.out 2026-04-25 13:02:25.148187000 +0000
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43395, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43395, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:57:45.280121000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/copy2.out 2026-04-25 13:02:36.91...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43074, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43074, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/resu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:58:05.721932707 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/copy2.out 2026-04-25 13:08:10.635814744 +0000
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43297, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43297, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/src/test/modules/test_plan_advice...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:58:05.721932707 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/copy2.out 2026-04-25 13:10:11.901256677 +00...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43295, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43295, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:58:05.721932707 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/copy2.out 2026-04-25 13:09:40.904724222 +0000
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43133, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43133, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/src/test/regress/results/copy2.ou...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:58:05.721932707 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/copy2.out 2026-04-25 13:04:05.871209460 +0000
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43210, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43210, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/copy2.out /home/postgres/postgres/build/testrun/pg_upgrade/00...
--- /home/postgres/postgres/src/test/regress/expected/copy2.out 2026-04-25 12:58:52.620791196 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy2.out 2026-04-25 13:01:45.825405430...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43625, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 43625, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/copy2.out /home/postgres/postgres/build/testrun/recovery/027_...
--- /home/postgres/postgres/src/test/regress/expected/copy2.out 2026-04-25 12:58:52.620791196 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/copy2.out 2026-04-25 13:02:46.7571469...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42441, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42441, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/copy2.out /home/postgres/postgres/build/testrun/regress/regre...
--- /home/postgres/postgres/src/test/regress/expected/copy2.out 2026-04-25 12:58:52.620791196 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/copy2.out 2026-04-25 13:01:47.884748339 +0000
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42566, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42566, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/copy2.out /home/postgres/postgres/build/testrun/test_plan_adv...
--- /home/postgres/postgres/src/test/regress/expected/copy2.out 2026-04-25 12:58:52.620791196 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/copy2.out 2026-04-25 13:01:56...
@@ -969,13 +969,13 @@
ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2);
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: new row for relation "err_tbl" violates check constraint "cc2"
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42220, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc2;
ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail;
COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl);
ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint
-DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
+DETAIL: Failing row contains (10, 42220, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22...
CONTEXT: COPY save_error, line 1, column a: "a"
ALTER TABLE err_tbl DROP CONSTRAINT cc3;
BEGIN; |
| 59/6543 |
synchronized_standby_slots behavior inconsistent with quorum-based synchronous replication |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/modules/unsafe_tests/expected/guc_privs.out /Users/admin/pgsql/build/testrun/unsafe...
--- /Users/admin/pgsql/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-04-23 10:59:10
+++ /Users/admin/pgsql/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-04-23 11:07:16
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/unsafe_tests/expected/guc_privs.out C:/cirrus/build/testrun/unsa...
--- C:/cirrus/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-04-23 10:59:51.673780500 +0000
+++ C:/cirrus/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-04-23 11:10:49.033696100 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out /tmp/cirrus-ci-build/build/testrun/un...
--- /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-04-23 11:00:16.762061579 +0000
+++ /tmp/cirrus-ci-build/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-04-23 11:07:10.269710855 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/unsafe_tests/expected/guc_privs.out /home/postgres/postgres/build/test...
--- /home/postgres/postgres/src/test/modules/unsafe_tests/expected/guc_privs.out Thu Apr 23 10:59:48 2026
+++ /home/postgres/postgres/build/testrun/unsafe_tests/regress/results/guc_privs.out Thu Apr 23 11:06:57 2026
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out /tmp/cirrus-ci-build/build/testrun/un...
--- /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-04-23 10:59:39.646701000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-04-23 11:05:17.714380000 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out /tmp/cirrus-ci-build/src/test/modules...
--- /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-04-23 10:59:19.268809549 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/results/guc_privs.out 2026-04-23 11:08:26.315086921 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/modules/unsafe_tests/expected/guc_privs.out /home/postgres/postgres/build/test...
--- /home/postgres/postgres/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-04-23 10:59:48.909004417 +0000
+++ /home/postgres/postgres/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-04-23 11:03:40.230976227 +0000
@@ -590,8 +590,7 @@
-- Cannot set synchronized_standby_slots to an invalid slot name
ALTER SYSTEM SET synchronized_standby_slots='invalid*';
ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*"
-DETAIL: replication slot name "invalid*" contains invalid character
-HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character.
+DETAIL: syntax error at or near "*"
-- Can set synchronized_standby_slots to a non-existent slot name
ALTER SYSTEM SET synchronized_standby_slots='missing';
-- Reset the GUC |
| 59/6055 |
let ALTER TABLE DROP COLUMN drop whole-row referenced object |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/triggers.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/triggers.out 2026-04-21 21:57:58.102037300 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2026-04-21 22:01:38.465237400 +0000
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/triggers.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/triggers.out 2026-04-21 21:57:58.102037300 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2026-04-21 22:05:54.093161200 +0000
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/triggers.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/triggers.out 2026-04-21 21:57:58.102037300 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/triggers.out 2026-04-21 22:01:25.116604200 +0000
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/triggers.out C:/cirrus/build/testrun/test_plan_advice/0...
--- C:/cirrus/src/test/regress/expected/triggers.out 2026-04-21 21:57:58.102037300 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/triggers.out 2026-04-21 22:01:31.951555100 ...
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/triggers.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/triggers.out 2026-04-21 21:57:55
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2026-04-21 22:02:06
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/triggers.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/triggers.out 2026-04-21 21:57:55
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2026-04-21 22:05:07
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/triggers.out /Users/admin/pgsql/build/testrun/regress/regress/resu...
--- /Users/admin/pgsql/src/test/regress/expected/triggers.out 2026-04-21 21:57:55
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/triggers.out 2026-04-21 22:02:02
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/triggers.out /Users/admin/pgsql/build/testrun/test_plan_advice/001...
--- /Users/admin/pgsql/src/test/regress/expected/triggers.out 2026-04-21 21:57:55
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/triggers.out 2026-04-21 22:02:05
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:52.387995851 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2026-04-21 22:00:27.693711738...
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:52.387995851 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2026-04-21 22:02:02.3616239...
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:52.387995851 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/triggers.out 2026-04-21 22:00:24.525715206 +0000
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:52.387995851 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/triggers.out 2026-04-21 22:00:30...
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:48.678826296 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/triggers.out 2026-04-21 22:04:44.489855094 +0000
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/test/modules/test_plan_adv...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:48.678826296 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/triggers.out 2026-04-21 22:06:53.261767864 ...
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:48.678826296 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/triggers.out 2026-04-21 22:05:55.917830271 +0000
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/test/regress/results/trigg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:48.678826296 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/triggers.out 2026-04-21 22:01:50.209796885 +0000
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/triggers.out /home/postgres/postgres/build/testrun/pg_upgrade...
--- /home/postgres/postgres/src/test/regress/expected/triggers.out Tue Apr 21 21:58:04 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out Tue Apr 21 22:00:43 2026
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/triggers.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/triggers.out Tue Apr 21 21:58:04 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/triggers.out Tue Apr 21 22:02:51 2026
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/triggers.out /home/postgres/postgres/build/testrun/regress/re...
--- /home/postgres/postgres/src/test/regress/expected/triggers.out Tue Apr 21 21:58:04 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/triggers.out Tue Apr 21 22:00:36 2026
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/triggers.out /home/postgres/postgres/build/testrun/test_plan_...
--- /home/postgres/postgres/src/test/regress/expected/triggers.out Tue Apr 21 21:58:04 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/triggers.out Tue Apr 21 22:00...
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/triggers.out /home/postgres/postgres/build/testrun/pg_upgrade...
--- /home/postgres/postgres/src/test/regress/expected/triggers.out 2026-04-21 21:58:04.278147131 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2026-04-21 21:59:51.663282...
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/triggers.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/triggers.out 2026-04-21 21:58:04.278147131 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2026-04-21 22:00:28.3844...
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/triggers.out /home/postgres/postgres/build/testrun/regress/re...
--- /home/postgres/postgres/src/test/regress/expected/triggers.out 2026-04-21 21:58:04.278147131 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/triggers.out 2026-04-21 21:59:51.082260250 +0000
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/triggers.out /home/postgres/postgres/build/testrun/test_plan_...
--- /home/postgres/postgres/src/test/regress/expected/triggers.out 2026-04-21 21:58:04.278147131 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/triggers.out 2026-04-21 21:59...
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:53.832725000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2026-04-21 21:59:47.252429000...
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:53.832725000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2026-04-21 22:01:18.5989250...
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:53.832725000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/triggers.out 2026-04-21 21:59:47.775470000 +0000
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:53.832725000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/triggers.out 2026-04-21 21:59:47...
@@ -250,7 +250,8 @@
--------+---------+-----------+----------+---------+---------+--------------+-------------
a | integer | | | | plain | |
Partition key: RANGE (a)
-Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000)
+Partitions:
+ test_tbl1p1 FOR VALUES FROM (0) TO (1000)
DROP TABLE test_tbl1;
-- |
| 59/6397 |
extended statistic (examine_variable) ignored CollateExpr |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out /Users/admin/pgsql/build/testrun/pg_upgrade/0...
--- /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:41:58
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/collate.icu.utf8.out 2026-04-21 21:47:14
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out /Users/admin/pgsql/build/testrun/recovery/027...
--- /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:41:58
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/collate.icu.utf8.out 2026-04-21 21:49:24
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out /Users/admin/pgsql/build/testrun/regress/regr...
--- /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:41:58
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/collate.icu.utf8.out 2026-04-21 21:47:03
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out /Users/admin/pgsql/build/testrun/test_plan_ad...
--- /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:41:58
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/collate.icu.utf8.out 2026-04-21 21...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/pg_upgra...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:42:14.455850429 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/collate.icu.utf8.out 2026-04-21 21:45:59.6...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/recovery...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:42:14.455850429 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/collate.icu.utf8.out 2026-04-21 21:47:32...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:42:14.455850429 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/collate.icu.utf8.out 2026-04-21 21:45:54.683259576 +0000
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/test_pla...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:42:14.455850429 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/collate.icu.utf8.out 2026-04-21 ...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:41:52.298215014 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/collate.icu.utf8.out 2026-04-21 21:49:08.867031249 +0000
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/src/test/modules/test_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:41:52.298215014 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/collate.icu.utf8.out 2026-04-21 21:51:11.06...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/src/test/recovery/tmp_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:41:52.298215014 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/collate.icu.utf8.out 2026-04-21 21:51:00.422481716 +0000
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/src/test/regress/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:41:52.298215014 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/collate.icu.utf8.out 2026-04-21 21:46:37.227889277 +0000
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out /home/postgres/postgres/build/testrun/pg...
--- /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:42:51.520961419 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/collate.icu.utf8.out 2026-04-21 21:45:3...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out /home/postgres/postgres/build/testrun/pg...
--- /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out Tue Apr 21 21:44:01 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/collate.icu.utf8.out Tue Apr 21 21:47:2...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out /home/postgres/postgres/build/testrun/re...
--- /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out Tue Apr 21 21:44:01 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/collate.icu.utf8.out Tue Apr 21 21:49...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out /home/postgres/postgres/build/testrun/re...
--- /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out Tue Apr 21 21:44:01 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/collate.icu.utf8.out Tue Apr 21 21:47:23 2026
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out /home/postgres/postgres/build/testrun/te...
--- /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out Tue Apr 21 21:44:01 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/collate.icu.utf8.out Tue Apr ...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/pg_upgra...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:42:10.091788000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/collate.icu.utf8.out 2026-04-21 21:45:30.7...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/recovery...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:42:10.091788000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/collate.icu.utf8.out 2026-04-21 21:47:10...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:42:10.091788000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/collate.icu.utf8.out 2026-04-21 21:45:22.856301000 +0000
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/test_pla...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:42:10.091788000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/collate.icu.utf8.out 2026-04-21 ...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |