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/6812 |
Fix qual pushdown past grouping with mismatched equivalence |
 |
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/subselect.out /home/postgres/postgres/build/testrun/recovery/...
--- /home/postgres/postgres/src/test/regress/expected/subselect.out 2026-06-01 17:07:29.177649285 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2026-06-01 17:09:46.097...
@@ -2036,159 +2036,82 @@
--
BEGIN;
CREATE TYPE t_rec AS (x numeric);
+ERROR: type "t_rec" already exists
CREATE TEMP TABLE pdt (id int, a t_rec);
+ERROR: current transaction is aborted, commands ignored until end of transaction block
INSERT INTO pdt VALUES
(1, ROW(1.00)::t_rec),
(2, ROW(1.0)::t_rec),
(3, ROW(2)::t_rec);
+ERROR: current transaction is aborted, commands ignored until end of transaction block
-- DISTINCT ON: conflict, qual stays in outer query
EXPLAIN (COSTS OFF)
SELECT * FROM (SELECT DISTINCT ON (a) id, a FROM pdt ORDER BY a, id) s
WHERE a *= ROW(1.0)::t_rec;
- QUERY PLAN
... |
| tap |
[17:11:06.959](107.434s) not ok 2 - regression tests pass |
| tap |
[17:09:59.191](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2026-06-01 17:07:28.919396115 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/subselect.out 2026-06-01 17:15:29.350395983 +0000
@@ -2036,159 +2036,82 @@
--
BEGIN;
CREATE TYPE t_rec AS (x numeric);
+ERROR: type "t_rec" already exists
CREATE TEMP TABLE pdt (id int, a t_rec);
+ERROR: current transaction is aborted, commands ignored until end of transaction block
INSERT INTO pdt VALUES
(1, ROW(1.00)::t_rec),
(2, ROW(1.0)::t_rec),
(3, ROW(2)::t_rec);
+ERROR: current transaction is aborted, commands ignored until end of transaction block
-- DISTINCT ON: conflict, qual stays in outer query
EXPLAIN (COSTS OFF)
SELECT * FROM (SELECT DISTINCT ON (a) id, a FROM pdt ORDER BY a, id) s
WHERE a *= ROW(1.0)::t_rec;
- QUERY PLAN
... |
| tap |
[17:18:00.191](208.514s) not ok 2 - regression tests pass |
| tap |
[17:20:16.633](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 59/6815 |
BUG Segfault triggered by reentrancy in ri_triggers.c |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/build/testrun/regress-r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2026-06-01 16:27:47.933623000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress-running/regress/results/select_parallel.out 2026-06-01 16:37:08.513911000...
@@ -593,9 +593,9 @@
-> Gather (actual rows=9800.00 loops=10)
Workers Planned: 4
Workers Launched: 4
- -> Parallel Seq Scan on tenk1 (actual rows=1960.00 loops=50)
+ -> Parallel Seq Scan on tenk1 (actual rows=2882.35 loops=34)
Filter: (hundred > 1)
- Rows Removed by Filter: 40
+ Rows Removed by Filter: 59
(11 rows)
alter table tenk2 reset (parallel_workers); |
| tap |
[16:31:10.253](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 59/6216 |
Reduce unnecessary locking of pruned partitions when reusing cached plans |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/plancache.out /home/postgres/postgres/build/testrun/test_plan...
--- /home/postgres/postgres/src/test/regress/expected/plancache.out 2026-06-01 15:37:20.279325703 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/plancache.out 2026-06-01 15:4...
@@ -451,7 +451,6 @@
-- during this execution, which should force replanning without errors.
update inval_during_pruning_signal set create_idx = true;
explain (verbose, costs off) execute inval_during_pruning_q;
-NOTICE: creating index on partition inval_during_pruning_p1
QUERY PLAN
---------------------------------------------------------------------------
Append |
| tap |
[15:40:54.040](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[15:41:12.912](108.613s) not ok 1 - regression tests pass |
| 59/6479 |
SLOPE - Planner optimizations on monotonic expressions. |
|
CompilerWarnings |
| compiler |
[13:57:08.170] misc.c:1130:27: error: mixing declarations and code is incompatible with standards before C99 [-Werror,-W... |
| compiler |
[13:55:08.711] misc.c:1130:27: error: mixing declarations and code is incompatible with standards before C99 [-Werror,-W... |
| compiler |
[13:52:50.858] misc.c:1130:9: error: ISO C90 forbids mixed declarations and code [-Werror=declaration-after-statement] |
| compiler |
[13:51:00.332] misc.c:1130:9: error: ISO C90 forbids mixed declarations and code [-Werror=declaration-after-statement] |
| compiler |
[14:00:50.203] misc.c:1130:9: error: ISO C90 forbids mixed declarations and code [-Werror=declaration-after-statement] |
| 59/6653 |
SLOPE - Planner optimizations on monotonic expressions. |
|
CompilerWarnings |
| compiler |
[13:54:49.956] misc.c:1130:27: error: mixing declarations and code is incompatible with standards before C99 [-Werror,-W... |
| compiler |
[13:52:47.250] misc.c:1130:27: error: mixing declarations and code is incompatible with standards before C99 [-Werror,-W... |
| compiler |
[13:50:30.161] misc.c:1130:9: error: ISO C90 forbids mixed declarations and code [-Werror=declaration-after-statement] |
| compiler |
[13:48:39.684] misc.c:1130:9: error: ISO C90 forbids mixed declarations and code [-Werror=declaration-after-statement] |
| compiler |
[13:58:28.702] misc.c:1130:9: error: ISO C90 forbids mixed declarations and code [-Werror=declaration-after-statement] |
| 59/6584 |
ECPG: inconsistent behavior with the document in “GET/SET DESCRIPTOR.” |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| tap |
[09:46:33.683](0.035s) not ok 28 - ecpg rejects duplicate GET DESCRIPTOR header items: exit code not 0
[09:46:33.684](0.001s) not ok 29 - ecpg rejects duplicate GET DESCRIPTOR header items: matches
[09:46:33.719](0.034s) not ok 30 - ecpg rejects duplicate SET DESCRIPTOR header items: exit code not 0
[09:46:33.721](0.001s) not ok 31 - ecpg rejects duplicate SET DESCRIPTOR header items: matches |
| tap |
[09:40:42.933](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
macOS - Sequoia - Meson |
| core |
[09:48:44.452] * frame #0: 0x000000018bc92c04 dyld`stat + 8
[09:48:44.452] frame #1: 0x000000018bcfdf40 dyld`stat_with_subsystem + 56
[09:48:44.452] frame #2: 0x000000018bce26bc dyld`dyld3::stat(char const*, stat*) + 28
[09:48:44.452] frame #3: 0x000000018bcc078c dyld`dyld4::SyscallDelegate::fileExists(char const*, dyld4::FileID*, int...
[09:48:44.452] frame #4: 0x000000018bcbe310 dyld`invocation function for block in dyld4::PrebuiltLoader::invalidateI...
[09:48:44.452] frame #5: 0x000000018bc9a118 dyld`dyld4::ProcessConfig::PathOverrides::forEachPathVariant(char const*...
[09:48:44.452] frame #6: 0x000000018bcbe0e4 dyld`dyld4::PrebuiltLoader::invalidateInIsolation(dyld4::RuntimeState co...
[09:48:44.452] frame #7: 0x000000018bcbdd20 dyld`dyld4::PrebuiltLoader::isValid(dyld4::RuntimeState const&) const + ...
[09:48:44.452] frame #8: 0x000000018bca8e78 dyld`dyld4::RuntimeState::findPrebuiltLoader(char const*) const + 104
[09:48:44.452] frame #9: 0x000000018bcae928 dyld`dyld4::Loader::makeDyldCacheLoader(Diagnostics&, dyld4::RuntimeStat... |
| core |
[09:49:27.085] * frame #0: 0x000000018c001640 libsystem_kernel.dylib`stat + 8
[09:49:27.085] frame #1: 0x0000000102214cac bash`___lldb_unnamed_symbol671 + 48
[09:49:27.085] frame #2: 0x000000010221548c bash`___lldb_unnamed_symbol683 + 148
[09:49:27.085] frame #3: 0x00000001022150cc bash`___lldb_unnamed_symbol679 + 268
[09:49:27.085] frame #4: 0x0000000102214ec4 bash`___lldb_unnamed_symbol678 + 88
[09:49:27.085] frame #5: 0x000000010220fd90 bash`___lldb_unnamed_symbol626 + 1912
[09:49:27.085] frame #6: 0x000000010220eb14 bash`___lldb_unnamed_symbol619 + 1760
[09:49:27.085] frame #7: 0x00000001022025cc bash`___lldb_unnamed_symbol467 + 1168
[09:49:27.085] frame #8: 0x00000001021f2450 bash`___lldb_unnamed_symbol211 + 176
[09:49:27.085] frame #9: 0x00000001021f1a88 bash`___lldb_unnamed_symbol203 + 4992 |
| tap |
[09:42:44.218](0.025s) not ok 28 - ecpg rejects duplicate GET DESCRIPTOR header items: exit code not 0
[09:42:44.219](0.001s) not ok 29 - ecpg rejects duplicate GET DESCRIPTOR header items: matches
[09:42:44.241](0.022s) not ok 30 - ecpg rejects duplicate SET DESCRIPTOR header items: exit code not 0
[09:42:44.242](0.000s) not ok 31 - ecpg rejects duplicate SET DESCRIPTOR header items: matches |
| tap |
[09:38:59.239](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
Linux - Debian Trixie - Meson |
| tap |
[09:37:22.295](0.011s) not ok 28 - ecpg rejects duplicate GET DESCRIPTOR header items: exit code not 0
[09:37:22.299](0.002s) not ok 29 - ecpg rejects duplicate GET DESCRIPTOR header items: matches
[09:37:22.308](0.009s) not ok 30 - ecpg rejects duplicate SET DESCRIPTOR header items: exit code not 0
[09:37:22.309](0.000s) not ok 31 - ecpg rejects duplicate SET DESCRIPTOR header items: matches |
| test |
[09:39:31.628] 256/402 postgresql:ecpg / ecpg/001_ecpg_err_warn_msg ERROR ... |
|
NetBSD - Meson |
| tap |
[09:35:29.885](0.005s) not ok 28 - ecpg rejects duplicate GET DESCRIPTOR header items: exit code not 0
[09:35:29.886](0.000s) not ok 29 - ecpg rejects duplicate GET DESCRIPTOR header items: matches
[09:35:29.890](0.005s) not ok 30 - ecpg rejects duplicate SET DESCRIPTOR header items: exit code not 0
[09:35:29.891](0.000s) not ok 31 - ecpg rejects duplicate SET DESCRIPTOR header items: matches |
| tap |
[09:33:28.813](0.002s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
FreeBSD - Meson |
| core |
[09:43:53.990] #0 0x000000082bf735da in _sigprocmask () from /lib/libc.so.7
[09:43:53.990] #1 0x000000082bfb0a3c in _system () from /lib/libc.so.7
[09:43:53.990] #2 0x000000082b0a3953 in ?? () from /lib/libthr.so.3
[09:43:53.990] #3 0x00000000006b3909 in RestoreArchivedFile (path=path@entry=0x82152f1b0 "pg_wal/00000002", '0' <repeat...
[09:43:53.990] #4 0x00000000006999c8 in existsTimeLineHistory (probeTLI=probeTLI@entry=3) at ../src/backend/access/tran...
[09:43:53.990] #5 0x0000000000699a88 in findNewestTimeLine (startTLI=startTLI@entry=2) at ../src/backend/access/transam...
[09:43:53.990] #6 0x00000000006bf2fb in rescanLatestTimeLine (replayTLI=replayTLI@entry=2, replayLSN=replayLSN@entry=10...
[09:43:53.990] #7 0x00000000006bb020 in WaitForWALToBecomeAvailable (RecPtr=105376928, randAccess=false, fetching_ckpt=...
[09:43:53.990] #8 XLogPageRead (xlogreader=0x285791426c78, targetPagePtr=105373696, reqLen=3232, targetRecPtr=105376904...
[09:43:53.990] #9 0x00000000006c2b8c in ReadPageInternal (state=0x285791426c78, pageptr=pageptr@entry=105373696, reqLen... |
| tap |
[09:38:47.476](0.006s) not ok 28 - ecpg rejects duplicate GET DESCRIPTOR header items: exit code not 0
[09:38:47.477](0.000s) not ok 29 - ecpg rejects duplicate GET DESCRIPTOR header items: matches
[09:38:47.483](0.005s) not ok 30 - ecpg rejects duplicate SET DESCRIPTOR header items: exit code not 0
[09:38:47.485](0.001s) not ok 31 - ecpg rejects duplicate SET DESCRIPTOR header items: matches |
| tap |
[09:34:44.814](0.001s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
Linux - Debian Trixie - Autoconf |
| tap |
[09:32:24.945](0.021s) not ok 28 - ecpg rejects duplicate GET DESCRIPTOR header items: exit code not 0
[09:32:24.945](0.000s) not ok 29 - ecpg rejects duplicate GET DESCRIPTOR header items: matches
[09:32:24.970](0.024s) not ok 30 - ecpg rejects duplicate SET DESCRIPTOR header items: exit code not 0
[09:32:24.971](0.000s) not ok 31 - ecpg rejects duplicate SET DESCRIPTOR header items: matches |
| tap |
[09:42:51.401](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 59/6392 |
ALTER TABLE: notice when actions do not recurse to partitions |
 |
Windows - Server 2022, VS 2019 - Meson & ninja |
| compiler |
[09:31:42.892] ../src/test/modules/test_ddl_deparse/test_ddl_deparse.c(318): warning C4062: enumerator 'AT_SetSchema' in... |
| 59/6728 |
md: measure just FileSync() for pgstat_io without FileClose() |
|
FreeBSD - Meson |
| tap |
[04:15:30.067](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 59/6822 |
Update our timezone code to IANA tzcode2026b |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| compiler |
[01:23:28.495] ../src/timezone/zic.c(1654): warning C4146: unary minus operator applied to unsigned type, result still u... |
| 59/6482 |
Add table COMMENTS in CREATE TABLE LIKE |
|
NetBSD - Meson |
| tap |
[20:04:34.991](0.303s) not ok 22 - last inactive time for an active physical slot is NULL |
| tap |
[20:05:08.662](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 59/6763 |
Improve pg_stat_statements scalability |
|
Linux - Debian Trixie - Autoconf |
| core |
[18:06:22.913] #0 0x00007f8208e5c2c0 in ?? ()
[18:06:22.913] #1 0x0000000000000004 in ?? ()
[18:06:22.913] #2 0x00007ffe695cad77 in ?? ()
[18:06:22.913] #3 0x00007ffe695cad7a in ?? ()
[18:06:22.913] #4 0x00007ffe695cad7d in ?? ()
[18:06:22.913] #5 0x00007ffe695cad80 in ?? ()
[18:06:22.913] #6 0x0000000000000000 in ?? () |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/select.out /tmp/cirrus-ci-build/contrib/pg_stat_statem...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/select.out 2026-05-31 17:50:19.975968877 +0000
+++ /tmp/cirrus-ci-build/contrib/pg_stat_statements/results/select.out 2026-05-31 17:58:32.406714251 +0000
@@ -2,14 +2,14 @@
-- SELECT statements
--
CREATE EXTENSION pg_stat_statements;
+ERROR: extension "pg_stat_statements" has no installation script nor update path for version "1.14"
SET pg_stat_statements.track_utility = FALSE;
SET pg_stat_statements.track_planning = TRUE;
SELECT pg_stat_statements_reset() IS NOT NULL AS t;
- t
----
- t
-(1 row)
-
+ERROR: function pg_stat_statements_reset() does not exist
+LINE 1: SELECT pg_stat_statements_reset() IS NOT NULL AS t;
+ ^
+DETAIL: There is no function of that name.
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/create_extension.out /tmp/cirrus-ci-build/src/t...
--- /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/expected/create_extension.out 2026-05-31 17:50:21.627968912 +...
+++ /tmp/cirrus-ci-build/src/test/modules/test_ddl_deparse/results/create_extension.out 2026-05-31 17:58:35.990708071 +0...
@@ -2,4 +2,4 @@
--- CREATE_EXTENSION
---
CREATE EXTENSION pg_stat_statements;
-NOTICE: DDL test: type simple, tag CREATE EXTENSION
+ERROR: extension "pg_stat_statements" has no installation script nor update path for version "1.14" |
| tap |
[18:03:28.210](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 59/6749 |
Disallow whole-row index references with virtual generated columns? |
|
NetBSD - Meson |
| tap |
[15:27:25.200](0.001s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 59/6390 |
Add ldapservice connection parameter |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/date.out /home/postgres/postgres/build/testrun/test_plan_advi...
--- /home/postgres/postgres/src/test/regress/expected/date.out 2026-05-31 13:32:13.154793184 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/date.out 2026-05-31 13:33:11....
@@ -1,1536 +1,2 @@
---
--- DATE
---
-CREATE TABLE DATE_TBL (f1 date);
-INSERT INTO DATE_TBL VALUES ('1957-04-09');
-INSERT INTO DATE_TBL VALUES ('1957-06-13');
-INSERT INTO DATE_TBL VALUES ('1996-02-28');
-INSERT INTO DATE_TBL VALUES ('1996-02-29');
-INSERT INTO DATE_TBL VALUES ('1996-03-01');
-INSERT INTO DATE_TBL VALUES ('1996-03-02');
-INSERT INTO DATE_TBL VALUES ('1997-02-28');
-INSERT INTO DATE_TBL VALUES ('1997-02-29');
-ERROR: date/time field value out of range: "1997-02-29"
-LINE 1: INSERT INTO DATE_TBL VALUES ('1997-02-29');
- ^
-INSERT INTO DATE_TBL VALUES ('1997-03-01');
... |
| tap |
[13:34:28.467](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[13:34:46.046](96.204s) not ok 1 - regression tests pass |
| 59/6426 |
Avoid recalculating pgprocno in ProcArrayAdd() |
|
FreeBSD - Meson |
| core |
[11:42:46.315] #0 0x000000082b27a5da in _sigprocmask () from /lib/libc.so.7
[11:42:46.315] #1 0x000000082b2b7a3c in _system () from /lib/libc.so.7
[11:42:46.315] #2 0x000000082bfcd953 in ?? () from /lib/libthr.so.3
[11:42:46.315] #3 0x00000000006b3909 in RestoreArchivedFile (path=path@entry=0x8213021b0 "pg_wal/00000003.history", xlo...
[11:42:46.315] #4 0x00000000006bf510 in XLogFileRead (segno=segno@entry=6, tli=tli@entry=2, source=source@entry=XLOG_FR...
[11:42:46.315] #5 0x00000000006bb2ab in XLogFileReadAnyTLI (segno=6, source=XLOG_FROM_ANY) at ../src/backend/access/tra...
[11:42:46.315] #6 WaitForWALToBecomeAvailable (RecPtr=105376928, randAccess=false, fetching_ckpt=false, tliRecPtr=10537...
[11:42:46.315] #7 XLogPageRead (xlogreader=0x3059c5626c78, targetPagePtr=105373696, reqLen=3232, targetRecPtr=105376904...
[11:42:46.315] #8 0x00000000006c2b8c in ReadPageInternal (state=0x3059c5626c78, pageptr=pageptr@entry=105373696, reqLen...
[11:42:46.315] #9 0x00000000006c1935 in XLogDecodeNextRecord (state=0x3059c5626c78, nonblocking=false) at ../src/backen... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2026-05-31 11:28:55.110280000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw-running/regress/results/postgres_fdw.out 2026-05-31 11:39:23.7216590...
@@ -12966,8 +12966,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | f | t
-(1 row)
+(0 rows)
-- After terminating the remote backend, since the connection is closed,
-- "closed" should be TRUE, or NULL if the connection status check
@@ -12983,8 +12982,7 @@
FROM postgres_fdw_get_connections(true);
server_name | closed | remote_backend_pid
-------------+--------+--------------------
- loopback | t | t
-(1 row)
+(0 rows)
... |
| tap |
[11:33:01.480](0.001s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 59/6574 |
Compress prune/freeze records with Delta Frame of Reference algorithm |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| compiler |
[11:29:04.188] ../src/test/dfor/test_dfor_u16.c(441): warning C4305: 'function': truncation from 'double' to 'float' |
| compiler |
[11:29:04.188] ../src/test/dfor/test_dfor_u16.c(529): warning C4305: 'function': truncation from 'double' to 'float' |
| compiler |
[11:29:04.188] ../src/test/dfor/test_dfor_u16.c(487): warning C4305: 'function': truncation from 'double' to 'float' |
| compiler |
[11:29:04.188] ../src/test/dfor/test_dfor_u16.c(469): warning C4305: 'function': truncation from 'double' to 'float' |
| compiler |
[11:29:04.188] ../src/test/dfor/test_dfor_u16.c(501): warning C4305: 'function': truncation from 'double' to 'float' |
| compiler |
[11:29:04.188] ../src/test/dfor/test_dfor_u16.c(428): warning C4305: 'function': truncation from 'double' to 'float' |
| 59/4337 |
Incremental View Maintenance (IVM), take 2 |
|
CompilerWarnings |
| compiler |
[05:24:49.118] matview.c:168:22: error: no previous extern declaration for non-static variable 'IvmShmemCallbacks' [-Wer... |
| compiler |
[05:24:04.932] matview.c:168:22: error: no previous extern declaration for non-static variable 'IvmShmemCallbacks' [-Wer... |
| compiler |
[05:22:59.713] matview.c:168:22: error: no previous declaration for ‘IvmShmemCallbacks’ [-Werror=missing-variable-declar... |
| compiler |
[05:22:23.122] matview.c:168:22: error: no previous declaration for ‘IvmShmemCallbacks’ [-Werror=missing-variable-declar... |
| compiler |
[05:26:15.221] matview.c:168:22: error: no previous declaration for ‘IvmShmemCallbacks’ [-Werror=missing-variable-declar... |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/incremental_matview.out C:/cirrus/build/testrun/pg_upgr...
--- C:/cirrus/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:16.952357200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/incremental_matview.out 2026-05-31 05:25:42.313678500...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/incremental_matview.out C:/cirrus/build/testrun/recover...
--- C:/cirrus/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:16.952357200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/incremental_matview.out 2026-05-31 05:29:43.1960107...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/incremental_matview.out C:/cirrus/build/testrun/regress...
--- C:/cirrus/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:16.952357200 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/incremental_matview.out 2026-05-31 05:25:36.112985300 +0000
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/incremental_matview.out C:/cirrus/build/testrun/test_pl...
--- C:/cirrus/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:16.952357200 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/incremental_matview.out 2026-05-31 05:25:41...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| tap |
[05:27:13.294](193.444s) not ok 5 - regression tests in old instance |
| tap |
[05:31:02.754](172.601s) not ok 2 - regression tests pass |
| tap |
[05:30:28.093](0.001s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[05:27:14.171](203.634s) not ok 1 - regression tests pass |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/incremental_matview.out /Users/admin/pgsql/build/testrun/pg_upgrad...
--- /Users/admin/pgsql/src/test/regress/expected/incremental_matview.out 2026-05-31 05:20:33
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/incremental_matview.out 2026-05-31 05:26:53
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/incremental_matview.out /Users/admin/pgsql/build/testrun/recovery/...
--- /Users/admin/pgsql/src/test/regress/expected/incremental_matview.out 2026-05-31 05:20:33
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/incremental_matview.out 2026-05-31 05:28:4...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/incremental_matview.out /Users/admin/pgsql/build/testrun/regress/r...
--- /Users/admin/pgsql/src/test/regress/expected/incremental_matview.out 2026-05-31 05:20:33
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/incremental_matview.out 2026-05-31 05:26:49
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/incremental_matview.out /Users/admin/pgsql/build/testrun/test_plan...
--- /Users/admin/pgsql/src/test/regress/expected/incremental_matview.out 2026-05-31 05:20:33
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/incremental_matview.out 2026-05-31...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| tap |
[05:27:44.895](130.626s) not ok 5 - regression tests in old instance |
| tap |
[05:29:18.741](70.788s) not ok 2 - regression tests pass |
| tap |
[05:28:52.403](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[05:27:49.224](142.315s) not ok 1 - regression tests pass |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out /tmp/cirrus-ci-build/build/testrun/pg_up...
--- /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:18.581622911 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/incremental_matview.out 2026-05-31 05:26:3...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out /tmp/cirrus-ci-build/build/testrun/recov...
--- /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:18.581622911 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/incremental_matview.out 2026-05-31 05:28...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out /tmp/cirrus-ci-build/build/testrun/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:18.581622911 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/incremental_matview.out 2026-05-31 05:26:29.648393454 +00...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out /tmp/cirrus-ci-build/build/testrun/test_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:18.581622911 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/incremental_matview.out 2026-05-...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| tap |
[05:27:14.292](93.500s) not ok 5 - regression tests in old instance |
| tap |
[05:28:53.913](88.311s) not ok 2 - regression tests pass |
| tap |
[05:27:18.145](100.993s) not ok 1 - regression tests pass |
| test |
[05:32:47.891] 11/402 postgresql:regress / regress/regress ERROR ...
[05:32:47.891] 30/402 postgresql:test_plan_advice / test_plan_advice/001_replan_regress ERROR 1...
[05:32:47.891] 44/402 postgresql:isolation / isolation/isolation ERROR ...
[05:32:47.891] 27/402 postgresql:pg_upgrade / pg_upgrade/002_pg_upgrade ERROR 1...
[05:32:47.891] 113/402 postgresql:recovery / recovery/027_stream_regress ERROR 1... |
|
FreeBSD - Meson |
| core |
[05:33:45.732] #0 0x0000000828e825da in _sigprocmask () from /lib/libc.so.7
[05:33:45.732] #1 0x0000000828ebfa3c in _system () from /lib/libc.so.7
[05:33:45.732] #2 0x000000082a38f953 in ?? () from /lib/libthr.so.3
[05:33:45.732] #3 0x00000000006b6999 in RestoreArchivedFile (path=path@entry=0x8211ec1b0 "\006", xlogfname=xlogfname@en...
[05:33:45.732] #4 0x00000000006c25a0 in XLogFileRead (segno=segno@entry=4, tli=tli@entry=2, source=source@entry=XLOG_FR...
[05:33:45.732] #5 0x00000000006be33b in XLogFileReadAnyTLI (segno=4, source=XLOG_FROM_ANY) at ../src/backend/access/tra...
[05:33:45.732] #6 WaitForWALToBecomeAvailable (RecPtr=67202840, randAccess=false, fetching_ckpt=false, tliRecPtr=672028...
[05:33:45.732] #7 XLogPageRead (xlogreader=0x1b2ecfe27068, targetPagePtr=67198976, reqLen=3864, targetRecPtr=67202816, ...
[05:33:45.732] #8 0x00000000006c5c1c in ReadPageInternal (state=0x1b2ecfe27068, pageptr=pageptr@entry=67198976, reqLen=...
[05:33:45.732] #9 0x00000000006c49c5 in XLogDecodeNextRecord (state=0x1b2ecfe27068, nonblocking=false) at ../src/backen... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out /tmp/cirrus-ci-build/build/testrun/pg_up...
--- /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:15.700393000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/incremental_matview.out 2026-05-31 05:25:1...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out /tmp/cirrus-ci-build/build/testrun/recov...
--- /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:15.700393000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/incremental_matview.out 2026-05-31 05:26...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out /tmp/cirrus-ci-build/build/testrun/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:15.700393000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/incremental_matview.out 2026-05-31 05:25:03.827821000 +00...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out /tmp/cirrus-ci-build/build/testrun/test_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:15.700393000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/incremental_matview.out 2026-05-...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| tap |
[05:27:35.624](266.999s) not ok 5 - regression tests in old instance |
| tap |
[05:28:40.700](260.415s) not ok 2 - regression tests pass |
| tap |
[05:25:16.073](0.002s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[05:27:42.493](276.120s) not ok 1 - regression tests pass |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/incremental_matview.out /home/postgres/postgres/build/testrun...
--- /home/postgres/postgres/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:40.864677627 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/incremental_matview.out 2026-05-31 05:2...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/incremental_matview.out /home/postgres/postgres/build/testrun...
--- /home/postgres/postgres/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:40.864677627 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/incremental_matview.out 2026-05-31 05...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/incremental_matview.out /home/postgres/postgres/build/testrun...
--- /home/postgres/postgres/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:40.864677627 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/incremental_matview.out 2026-05-31 05:24:55.926112296 ...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/incremental_matview.out /home/postgres/postgres/build/testrun...
--- /home/postgres/postgres/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:40.864677627 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/incremental_matview.out 2026-...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| tap |
[05:25:44.095](93.474s) not ok 5 - regression tests in old instance |
| tap |
[05:26:32.908](100.205s) not ok 2 - regression tests pass |
| tap |
[05:25:33.121](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[05:25:55.753](107.931s) not ok 1 - regression tests pass |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:25.430109571 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/incremental_matview.out 2026-05-31 05:30:20.565769961 +000...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out /tmp/cirrus-ci-build/src/test/modules/te...
--- /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:25.430109571 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/incremental_matview.out 2026-05-31 05:33:36...
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out /tmp/cirrus-ci-build/src/test/recovery/t...
--- /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:25.430109571 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/incremental_matview.out 2026-05-31 05:32:37.049716856 +0000
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out /tmp/cirrus-ci-build/src/test/regress/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/incremental_matview.out 2026-05-31 05:21:25.430109571 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/incremental_matview.out 2026-05-31 05:27:47.685846531 +0000
@@ -544,7 +544,7 @@
ROLLBACK;
BEGIN;
CREATE INCREMENTAL MATERIALIZED VIEW mv_ivm_agg(a,b,c) AS SELECT i, SUM(j) FROM mv_base_a GROUP BY i;
-ERROR: too many column names were specified
+NOTICE: created index "mv_ivm_agg_index" on materialized view "mv_ivm_agg"
ROLLBACK;
-- support self join view and multiple change on the same table
BEGIN; |
| tap |
[05:32:10.848](193.017s) not ok 5 - regression tests in old instance |
| tap |
[05:34:35.284](153.548s) not ok 1 - regression tests pass |
| tap |
[05:34:08.849](206.760s) not ok 2 - regression tests pass |
| tap |
[05:36:20.260](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 59/6428 |
BUG #19369: Not documented that io_uring on kernel versions between 5.1 and below 5.6 does not work |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| tap |
[04:01:29.032](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[04:15:18.812](382.884s) # poll_query_until timed out executing this query:
[04:15:18.880](0.001s) # die: timed out waiting for catchup at C:/cirrus/src/test/subscription/t/001_rep_changes.pl line...
timed out waiting for catchup at C:/cirrus/src/test/subscription/t/001_rep_changes.pl line 509. |
| 59/6543 |
synchronized_standby_slots behavior inconsistent with quorum-based synchronous replication |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/unsafe_tests/expected/guc_privs.out C:/cirrus/build/testrun/unsa...
--- C:/cirrus/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-05-31 00:43:34.551149400 +0000
+++ C:/cirrus/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-05-31 00:53:49.964206300 +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 |
| tap |
[00:51:41.751](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
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-05-31 00:43:24
+++ /Users/admin/pgsql/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-05-31 00:50:21
@@ -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 |
| tap |
[00:49:03.870](0.002s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
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-05-31 00:43:30.913913697 +0000
+++ /tmp/cirrus-ci-build/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-05-31 00:48:45.972040833 +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 |
| test |
[00:52:04.197] 169/402 postgresql:unsafe_tests / unsafe_tests/regress ERROR ... |
|
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-05-31 00:43:39.906504790 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/results/guc_privs.out 2026-05-31 00:51:33.474593210 +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 |
| tap |
[00:55:35.441](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
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-05-31 00:43:49.460238952 +0000
+++ /home/postgres/postgres/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-05-31 00:46:50.137671686 +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 |
| tap |
[00:46:11.400](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
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-05-31 00:43:29.451504000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-05-31 00:48:13.359436000 +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 |
| tap |
[00:46:16.924](0.001s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 59/6526 |
amcheck: add index-all-keys-match verification for B-Tree |
|
macOS - Sequoia - Meson |
| tap |
[21:53:52.809](0.243s) Bail out! rename failed: No such file or directory |
| tap |
[21:52:00.264](0.044s) not ok 46 - pg_amcheck over schema s2 with corrupt tables excluded reports no corruption status (...
[21:52:00.264](0.000s) not ok 47 - pg_amcheck over schema s2 with corrupt tables excluded reports no corruption stdout /... |
| tap |
[21:51:05.821](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| tap |
[22:02:03.474](0.286s) Bail out! rename failed: No such file or directory |
| tap |
[21:58:37.624](0.075s) not ok 46 - pg_amcheck over schema s2 with corrupt tables excluded reports no corruption status (...
[21:58:37.624](0.000s) not ok 47 - pg_amcheck over schema s2 with corrupt tables excluded reports no corruption stdout /... |
| tap |
[21:55:56.202](0.001s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
Linux - Debian Trixie - Meson |
| tap |
[21:54:44.755](0.182s) Bail out! rename failed: No such file or directory |
| tap |
[21:53:29.461](0.055s) not ok 46 - pg_amcheck over schema s2 with corrupt tables excluded reports no corruption status (...
[21:53:29.462](0.000s) not ok 47 - pg_amcheck over schema s2 with corrupt tables excluded reports no corruption stdout /... |
| test |
[21:56:37.262] 182/404 postgresql:pg_amcheck / pg_amcheck/003_check ERROR ...
[21:56:37.262] 270/404 postgresql:amcheck / amcheck/008_verify_nbtree_lost_segments ERROR ... |
|
FreeBSD - Meson |
| core |
[21:58:55.427] #0 0x000056ab1e774348 in ?? () from /libexec/ld-elf.so.1
[21:58:55.427] #1 0x0000000000000000 in ?? () |
| tap |
[21:54:20.566](0.166s) Bail out! rename failed: No such file or directory |
| tap |
[21:52:52.354](0.050s) not ok 46 - pg_amcheck over schema s2 with corrupt tables excluded reports no corruption status (...
[21:52:52.357](0.001s) not ok 47 - pg_amcheck over schema s2 with corrupt tables excluded reports no corruption stdout /... |
| tap |
[21:50:19.800](0.001s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
NetBSD - Meson |
| tap |
[21:51:48.636](0.140s) Bail out! rename failed: No such file or directory |
| tap |
[21:50:51.100](0.048s) not ok 46 - pg_amcheck over schema s2 with corrupt tables excluded reports no corruption status (...
[21:50:51.101](0.000s) not ok 47 - pg_amcheck over schema s2 with corrupt tables excluded reports no corruption stdout /... |
| tap |
[21:50:00.287](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
Linux - Debian Trixie - Autoconf |
| tap |
[21:50:07.256](0.153s) not ok 46 - pg_amcheck over schema s2 with corrupt tables excluded reports no corruption status (...
[21:50:07.257](0.000s) not ok 47 - pg_amcheck over schema s2 with corrupt tables excluded reports no corruption stdout /... |
| tap |
[21:57:54.167](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 60/6148 |
CI: Add task that runs pgindent |
|
FreeBSD - Meson |
| tap |
[12:34:18.558](0.024s) not ok 16 - startup deadlock: stats show conflict on standby |
| tap |
[12:35:04.342](0.001s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 59/6610 |
ORDER BY ALL |
|
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-05-29 04:15:50.119810500 +0000
+++ C:/cirrus/build/testrun/plpgsql/regress/results/plpgsql_misc.out 2026-05-29 04:23:56.552652700 +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
... |
| tap |
[04:23:52.223](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
macOS - Sequoia - Meson |
| core |
[04:29:57.278] * frame #0: 0x00000001026207c0 dyld`_dyld_start |
| core |
[04:30:37.170] * frame #0: 0x00000001871caf24 dyld`invocation function for block in dyld4::Loader::findAndRunAllInitia...
[04:30:37.170] frame #1: 0x000000018720789c dyld`invocation function for block in dyld3::MachOAnalyzer::forEachIniti...
[04:30:37.170] frame #2: 0x00000001872275cc dyld`invocation function for block in mach_o::Header::forEachSection(voi...
[04:30:37.170] frame #3: 0x0000000187224358 dyld`mach_o::Header::forEachLoadCommand(void (load_command const*, bool&...
[04:30:37.170] frame #4: 0x0000000187225a98 dyld`mach_o::Header::forEachSection(void (mach_o::Header::SectionInfo co...
[04:30:37.170] frame #5: 0x000000018720736c dyld`dyld3::MachOAnalyzer::forEachInitializer(Diagnostics&, dyld3::MachO...
[04:30:37.170] frame #6: 0x00000001871cacb4 dyld`dyld4::Loader::findAndRunAllInitializers(dyld4::RuntimeState&) cons...
[04:30:37.170] frame #7: 0x00000001871d6530 dyld`dyld4::PrebuiltLoader::runInitializers(dyld4::RuntimeState&) const ...
[04:30:37.170] frame #8: 0x00000001871ec8f0 dyld`dyld4::APIs::runAllInitializersForMain() + 88
[04:30:37.170] frame #9: 0x00000001871afe00 dyld`dyld4::prepare(dyld4::APIs&, mach_o::Header const*) + 3092 |
| 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-05-29 04:15:16
+++ /Users/admin/pgsql/build/testrun/plpgsql/regress/results/plpgsql_misc.out 2026-05-29 04:20:50
@@ -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
... |
| tap |
[04:20:33.550](0.011s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
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-05-29 04:16:12.944027376 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plpgsql/regress/results/plpgsql_misc.out 2026-05-29 04:22:47.935802167 +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
... |
| test |
[04:27:10.455] 63/402 postgresql:plpgsql / plpgsql/regress ERROR ... |
|
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-05-29 04:16:14.222286765 +0000
+++ /home/postgres/postgres/build/testrun/plpgsql/regress/results/plpgsql_misc.out 2026-05-29 04:20:11.431788728 +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
... |
| tap |
[04:20:10.041](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[04:22:43.183](0.111s) not ok 3 - ensure checksums are set to off on injection_node |
|
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-05-29 04:15:34.546408934 +0000
+++ /tmp/cirrus-ci-build/src/pl/plpgsql/src/results/plpgsql_misc.out 2026-05-29 04:19:37.441094521 +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
... |
| tap |
[04:30:22.546](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
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-05-29 04:15:53.914402000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plpgsql/regress/results/plpgsql_misc.out 2026-05-29 04:20:10.074342000 +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
... |
| tap |
[04:20:00.803](0.002s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 59/5893 |
Adding pg_dump flag for parallel export to pipes |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| tap |
[20:29:04.543](0.567s) not ok 1909 - defaults_complex_pipe: pg_dump runs
[20:29:04.699](0.151s) not ok 1910 - defaults_complex_pipe: pg_restore runs |
| tap |
[20:28:47.516](0.531s) not ok 5 - parallel dump with pipe
[20:28:47.835](0.317s) not ok 6 - parallel restore with pipe |
| tap |
[20:24:45.910](0.002s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 59/6796 |
Reject degenerate SPLIT PARTITION with DEFAULT partition |
|
NetBSD - Meson |
| tap |
[18:16:37.277](0.001s) not ok 2 - run of pg_upgrade where the new cluster has insufficient max_active_replication_origin... |
| tap |
[18:18:15.440](0.001s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 59/6805 |
BUG Segfault triggered by reentrancy in ri_triggers.c |
|
Linux - Debian Trixie - Meson |
| assertion |
TRAP: failed Assert("plan->magic == _SPI_PLAN_MAGIC"), File: "../src/backend/executor/spi.c", Line: 1953, PID: 34430 |
| core |
[15:00:42.874] #0 0x00007f61ad6a095c in ?? () from /lib/x86_64-linux-gnu/libc.so.6
[15:00:42.874] #1 0x00007f61ad64bcc2 in raise () from /lib/x86_64-linux-gnu/libc.so.6
[15:00:42.874] #2 0x00007f61ad6344ac in abort () from /lib/x86_64-linux-gnu/libc.so.6
[15:00:42.874] #3 0x0000555aba4b94c9 in ExceptionalCondition (conditionName=conditionName@entry=0x555aba754ee0 "plan->m...
[15:00:42.874] #4 0x0000555ab9e9861e in SPI_plan_is_valid (plan=plan@entry=0x555ad4274360) at ../src/backend/executor/s...
[15:00:42.874] #5 0x0000555aba3c818a in ri_FetchPreparedPlan (key=key@entry=0x7ffcad78ace8) at ../src/backend/utils/adt...
[15:00:42.874] #6 0x0000555aba3cf3b6 in ri_set (trigdata=0x7ffcad78aef0, is_set_null=is_set_null@entry=false, tgkind=tg...
[15:00:42.874] #7 0x0000555aba3d0a5a in RI_FKey_setdefault_del (fcinfo=0x7ffcad78ae60) at ../src/backend/utils/adt/ri_t...
[15:00:42.874] #8 0x0000555ab9d7510c in ExecCallTriggerFunc (trigdata=trigdata@entry=0x7ffcad78aef0, tgindx=tgindx@entr...
[15:00:42.874] #9 0x0000555ab9d75f1f in AfterTriggerExecute (estate=estate@entry=0x555ad4254040, event=event@entry=0x55... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/build/testrun/test_plan_adv...
--- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out 2026-05-27 14:46:57.030826226 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/foreign_key.out 2026-05-27 14:51...
@@ -262,3453 +262,7 @@
-- Delete another row from PK TABLE
DELETE FROM PKTABLE WHERE ptest1=5 and ptest2=10;
--- Check FKTABLE (should be no change)
-SELECT * FROM FKTABLE;
- ftest1 | ftest2 | ftest3
---------+--------+--------
- 1 | 3 | 5
- 2 | 4 | 8
- 3 | 6 | 12
- | | 0
- -1 | -2 | 4
-(5 rows)
-
--- Update a row from PK TABLE
-UPDATE PKTABLE SET ptest1=1 WHERE ptest1=2;
... |
| tap |
[14:51:52.509](68.226s) not ok 1 - regression tests pass |
| test |
[14:57:40.645] 17/402 postgresql:test_plan_advice / test_plan_advice/001_replan_regress ERROR ... |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| assertion |
TRAP: failed Assert("plan->magic == _SPI_PLAN_MAGIC"), File: "../src/backend/executor/spi.c", Line: 1953, PID: 8896 |
| assertion |
TRAP: failed Assert("plan->magic == _SPI_PLAN_MAGIC"), File: "../src/backend/executor/spi.c", Line: 1953, PID: 8312 |
| core |
00000065`225ffbb8 00007ffb`e122b77f ntdll!NtWaitForWorkViaWorkerFactory+0x14
00000065`225ffbc0 00007ffb`df1c4cb0 ntdll!TppWorkerThread+0x2df
00000065`225ffeb0 00007ffb`e129edeb KERNEL32!BaseThreadInitThunk+0x10
00000065`225ffee0 00000000`00000000 ntdll!RtlUserThreadStart+0x2b |
| core |
00000065`219fe700 00007ff7`47f25598 ucrtbased!abort(void)+0x5a [minkernel\crts\ucrt\src\appcrt\startup\abort.cpp @ 7...
00000065`219fe740 00007ff7`47a4933f postgres!ExceptionalCondition(
00000065`219fe780 00007ff7`47e67820 postgres!SPI_plan_is_valid(
00000065`219fe7e0 00007ff7`47e6b559 postgres!ri_FetchPreparedPlan(
00000065`219fe820 00007ff7`47e64fde postgres!RI_FKey_check(
00000065`219feb50 00007ff7`4798399e postgres!RI_FKey_check_ins(
00000065`219feb80 00007ff7`4798557d postgres!ExecCallTriggerFunc(
00000065`219fed30 00007ff7`479873b7 postgres!AfterTriggerExecute(
00000065`219fee40 00007ff7`47980c2e postgres!afterTriggerInvokeEvents(
00000065`219fef50 00007ff7`479cda0b postgres!AfterTriggerEndQuery( |
| core |
00000065`229ffd88 00007ffb`de85d4fe ntdll!NtWaitForSingleObject+0x14
00000065`229ffd90 00007ff7`47bc80ac KERNELBASE!WaitForSingleObjectEx+0x8e
00000065`229ffe30 00007ffb`df1c4cb0 postgres!pg_timer_thread(
00000065`229ffe70 00007ffb`e129edeb KERNEL32!BaseThreadInitThunk+0x10
00000065`229ffea0 00000000`00000000 ntdll!RtlUserThreadStart+0x2b |
| core |
00000065`21dff748 00007ffb`e122b77f ntdll!NtWaitForWorkViaWorkerFactory+0x14
00000065`21dff750 00007ffb`df1c4cb0 ntdll!TppWorkerThread+0x2df
00000065`21dffa40 00007ffb`e129edeb KERNEL32!BaseThreadInitThunk+0x10
00000065`21dffa70 00000000`00000000 ntdll!RtlUserThreadStart+0x2b |
| core |
00000065`221ffca8 00007ffb`de8a466a ntdll!NtFsControlFile+0x14
00000065`221ffcb0 00007ff7`47bc666b KERNELBASE!ConnectNamedPipe+0x6a
00000065`221ffd20 00007ffb`df1c4cb0 postgres!pg_signal_thread(
00000065`221ffe20 00007ffb`e129edeb KERNEL32!BaseThreadInitThunk+0x10
00000065`221ffe50 00000000`00000000 ntdll!RtlUserThreadStart+0x2b |
| core |
0000001e`5b5ffa58 00007ffb`e122b77f ntdll!NtWaitForWorkViaWorkerFactory+0x14
0000001e`5b5ffa60 00007ffb`df1c4cb0 ntdll!TppWorkerThread+0x2df
0000001e`5b5ffd50 00007ffb`e129edeb KERNEL32!BaseThreadInitThunk+0x10
0000001e`5b5ffd80 00000000`00000000 ntdll!RtlUserThreadStart+0x2b |
| core |
0000001e`5c1ff738 00007ffb`e122b77f ntdll!NtWaitForWorkViaWorkerFactory+0x14
0000001e`5c1ff740 00007ffb`df1c4cb0 ntdll!TppWorkerThread+0x2df
0000001e`5c1ffa30 00007ffb`e129edeb KERNEL32!BaseThreadInitThunk+0x10
0000001e`5c1ffa60 00000000`00000000 ntdll!RtlUserThreadStart+0x2b |
| core |
0000001e`5bdff738 00007ffb`de85d4fe ntdll!NtWaitForSingleObject+0x14
0000001e`5bdff740 00007ff7`47bc80ac KERNELBASE!WaitForSingleObjectEx+0x8e
0000001e`5bdff7e0 00007ffb`df1c4cb0 postgres!pg_timer_thread(
0000001e`5bdff820 00007ffb`e129edeb KERNEL32!BaseThreadInitThunk+0x10
0000001e`5bdff850 00000000`00000000 ntdll!RtlUserThreadStart+0x2b |
| core |
0000001e`5b9ffd58 00007ffb`de8a466a ntdll!NtFsControlFile+0x14
0000001e`5b9ffd60 00007ff7`47bc666b KERNELBASE!ConnectNamedPipe+0x6a
0000001e`5b9ffdd0 00007ffb`df1c4cb0 postgres!pg_signal_thread(
0000001e`5b9ffed0 00007ffb`e129edeb KERNEL32!BaseThreadInitThunk+0x10
0000001e`5b9fff00 00000000`00000000 ntdll!RtlUserThreadStart+0x2b |
| core |
0000001e`5b1fe5b0 00007ff7`47f25598 ucrtbased!abort(void)+0x5a [minkernel\crts\ucrt\src\appcrt\startup\abort.cpp @ 7...
0000001e`5b1fe5f0 00007ff7`47a4933f postgres!ExceptionalCondition(
0000001e`5b1fe630 00007ff7`47e67820 postgres!SPI_plan_is_valid(
0000001e`5b1fe690 00007ff7`47e660af postgres!ri_FetchPreparedPlan(
0000001e`5b1fe6d0 00007ff7`47e65aa0 postgres!ri_restrict(
0000001e`5b1febe0 00007ff7`4798399e postgres!RI_FKey_noaction_upd(
0000001e`5b1fec10 00007ff7`4798557d postgres!ExecCallTriggerFunc(
0000001e`5b1fedc0 00007ff7`479873b7 postgres!AfterTriggerExecute(
0000001e`5b1feed0 00007ff7`47980c2e postgres!afterTriggerInvokeEvents(
0000001e`5b1fefe0 00007ff7`479cda0b postgres!AfterTriggerEndQuery( |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/foreign_key.out C:/cirrus/build/testrun/pg_upgrade/002_...
--- C:/cirrus/src/test/regress/expected/foreign_key.out 2026-05-27 14:47:38.829100200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/foreign_key.out 2026-05-27 14:52:55.150134200 +0000
@@ -1612,2103 +1612,7 @@
update pp set f1=f1+1;
insert into cc values(13);
update pp set f1=f1+1;
-update pp set f1=f1+1; -- fail
-ERROR: update or delete on table "pp" violates foreign key constraint "cc_f1_fkey" on table "cc"
-DETAIL: Key (f1)=(13) is still referenced from table "cc".
-delete from pp where f1 = 13; -- fail
-ERROR: update or delete on table "pp" violates foreign key constraint "cc_f1_fkey" on table "cc"
-DETAIL: Key (f1)=(13) is still referenced from table "cc".
-drop table pp, cc;
-create temp table pp (f1 int primary key);
-create temp table cc (f1 int references pp on update restrict on delete restrict);
-insert into pp values(12);
-insert into pp values(11);
-update pp set f1=f1+1;
-insert into cc values(13);
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/graph_table.out C:/cirrus/build/testrun/regress/regress...
--- C:/cirrus/src/test/regress/expected/graph_table.out 2026-05-27 14:47:38.839785400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/graph_table.out 2026-05-27 14:52:53.775135400 +0000
@@ -890,158 +890,7 @@
CREATE TABLE ptne1 PARTITION OF ptne FOR VALUES IN (1, 2);
CREATE TABLE ptne2 PARTITION OF ptne FOR VALUES IN (3);
INSERT INTO ptne VALUES (1, 1, 2, 100), (2, 2, 3, 200), (3, 3, 1, 300);
-CREATE PROPERTY GRAPH g4
- VERTEX TABLES (ptnv)
- EDGE TABLES (
- ptne
- SOURCE KEY (src) REFERENCES ptnv(id)
- DESTINATION KEY (dest) REFERENCES ptnv(id)
- );
-SELECT * FROM GRAPH_TABLE (g4 MATCH (s IS ptnv)-[e IS ptne]->(d IS ptnv) COLUMNS (s.val, e.val, d.val)) ORDER BY 1, 2, ...
- val | val | val
------+-----+-----
- 10 | 100 | 20
- 20 | 200 | 30
- 30 | 300 | 10
... |
| tap |
[14:53:45.596](198.067s) not ok 5 - regression tests in old instance
[14:53:45.598](0.000s) # not ok 219 + partition_merge 632 ms
# not ok 220 + partition_split 600 ms
# not ok 221 + partition_join 586 ms
# not ok 222 + partition_prune 660 ms
# not ok 223 + reloptions 657 ms
# not ok 224 + hash_part 575 ms
# not ok 225 + indexing 650 ms
# not ok 226 + partition_aggregate 647 ms
# not ok 227 + partition_info 582 ms
# not ok 228 + tuplesort 640 ms
# not ok 229 + explain 637 ms
# not ok 230 + memoize 632 ms
# not ok 231 + stats 627 ms
# not ok 232 + predicate 622 ms
# not ok 233 + numa 638 ms
# not ok 234 + eager_aggregate 629 ms
# not ok 235 + graph_table_rls 667 ms
# not ok 236 + planner_est 629 ms
# not ok 237 + compression 183 ms
# not ok 238 + compression_lz4 175 ms
# not ok 239 + compression_pglz 237 ms
# not ok 240 + cluster 177 ms
# not ok 241 + oidjoins 72 ms
# not ok 242 + event_trigger 72 ms
# not ok 243 - event_trigger_login 79 ms
# not ok 244 - fast_default 73 ms
# not ok 245 - tablespace 134 ms
[14:54:28.501](15.501s) not ok 16 - run of pg_upgrade for new instance
[14:54:28.505](0.001s) not ok 17 - pg_upgrade_output.d/ removed after pg_upgrade success
[14:54:30.724](0.108s) not ok 20 - old and new dumps match after pg_upgrade |
| tap |
[14:56:53.978](0.001s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 59/5007 |
relfilenode statistics |
|
CompilerWarnings |
| compiler |
[04:58:06.011] autovacuum.c:2153:32: error: variable ‘locator’ set but not used [-Werror=unused-but-set-variable] |
| compiler |
[04:58:06.011] autovacuum.c:2044:32: error: variable ‘locator’ set but not used [-Werror=unused-but-set-variable] |
| compiler |
[04:57:20.695] autovacuum.c:2044:32: error: variable ‘locator’ set but not used [-Werror=unused-but-set-variable] |
| compiler |
[04:57:20.695] autovacuum.c:2153:32: error: variable ‘locator’ set but not used [-Werror=unused-but-set-variable] |
| compiler |
[05:04:13.933] autovacuum.c:2044:32: error: variable ‘locator’ set but not used [-Werror=unused-but-set-variable] |
| compiler |
[05:04:13.933] autovacuum.c:2153:32: error: variable ‘locator’ set but not used [-Werror=unused-but-set-variable] |
| 59/6606 |
log_checkpoints: count WAL segment creations from all processes |
|
macOS - Sequoia - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/rules.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgra...
--- /Users/admin/pgsql/src/test/regress/expected/rules.out 2026-05-25 19:25:24
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rules.out 2026-05-25 19:32:01
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/rules.out /Users/admin/pgsql/build/testrun/recovery/027_stream_reg...
--- /Users/admin/pgsql/src/test/regress/expected/rules.out 2026-05-25 19:25:24
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/rules.out 2026-05-25 19:33:47
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/rules.out /Users/admin/pgsql/build/testrun/regress/regress/results...
--- /Users/admin/pgsql/src/test/regress/expected/rules.out 2026-05-25 19:25:24
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/rules.out 2026-05-25 19:31:58
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/rules.out /Users/admin/pgsql/build/testrun/test_plan_advice/001_re...
--- /Users/admin/pgsql/src/test/regress/expected/rules.out 2026-05-25 19:25:24
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/rules.out 2026-05-25 19:32:01
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| tap |
[19:32:47.572](124.045s) not ok 5 - regression tests in old instance |
| tap |
[19:34:20.054](66.236s) not ok 2 - regression tests pass |
| tap |
[19:33:57.067](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[19:32:51.788](136.397s) not ok 1 - regression tests pass |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/rules.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upg...
--- C:/cirrus/src/test/regress/expected/rules.out 2026-05-25 19:26:22.567120700 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rules.out 2026-05-25 19:30:19.587412100 +0000
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/rules.out C:/cirrus/build/testrun/recovery/027_stream_r...
--- C:/cirrus/src/test/regress/expected/rules.out 2026-05-25 19:26:22.567120700 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/rules.out 2026-05-25 19:33:48.821293900 +0000
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/rules.out C:/cirrus/build/testrun/regress/regress/resul...
--- C:/cirrus/src/test/regress/expected/rules.out 2026-05-25 19:26:22.567120700 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/rules.out 2026-05-25 19:30:08.469247300 +0000
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/rules.out C:/cirrus/build/testrun/test_plan_advice/001_...
--- C:/cirrus/src/test/regress/expected/rules.out 2026-05-25 19:26:22.567120700 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/rules.out 2026-05-25 19:30:13.404303200 +00...
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| tap |
[19:31:34.391](168.253s) not ok 5 - regression tests in old instance |
| tap |
[19:34:54.494](150.895s) not ok 2 - regression tests pass |
| tap |
[19:34:14.995](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[19:31:30.995](171.737s) not ok 1 - regression tests pass |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2026-05-25 19:25:12.260263912 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rules.out 2026-05-25 19:30:16.857921530 +0...
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2026-05-25 19:25:12.260263912 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/rules.out 2026-05-25 19:31:49.478009585 ...
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/build/testrun/regress/regress/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2026-05-25 19:25:12.260263912 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/rules.out 2026-05-25 19:30:17.593922505 +0000
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2026-05-25 19:25:12.260263912 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/rules.out 2026-05-25 19:30:19.55...
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| tap |
[19:30:56.281](85.603s) not ok 5 - regression tests in old instance |
| tap |
[19:32:30.430](82.540s) not ok 2 - regression tests pass |
| tap |
[19:30:58.288](90.597s) not ok 1 - regression tests pass |
| test |
[19:36:10.283] 13/401 postgresql:regress / regress/regress ERROR ...
[19:36:10.283] 28/401 postgresql:test_plan_advice / test_plan_advice/001_replan_regress ERROR ...
[19:36:10.283] 26/401 postgresql:pg_upgrade / pg_upgrade/002_pg_upgrade ERROR 1...
[19:36:10.283] 112/401 postgresql:recovery / recovery/027_stream_regress ERROR 1... |
|
FreeBSD - Meson |
| core |
[19:37:38.144] #0 0x000000082b8cc5da in _sigprocmask () from /lib/libc.so.7
[19:37:38.144] #1 0x000000082b909a3c in _system () from /lib/libc.so.7
[19:37:38.144] #2 0x000000082acb0953 in ?? () from /lib/libthr.so.3
[19:37:38.144] #3 0x00000000006b3929 in RestoreArchivedFile (path=path@entry=0x8211851b0 "pg_wal/00000003.history", xlo...
[19:37:38.144] #4 0x00000000006bf530 in XLogFileRead (segno=segno@entry=6, tli=tli@entry=2, source=source@entry=XLOG_FR...
[19:37:38.144] #5 0x00000000006bb2cb in XLogFileReadAnyTLI (segno=6, source=XLOG_FROM_ANY) at ../src/backend/access/tra...
[19:37:38.144] #6 WaitForWALToBecomeAvailable (RecPtr=105378904, randAccess=false, fetching_ckpt=false, tliRecPtr=10537...
[19:37:38.144] #7 XLogPageRead (xlogreader=0x30f0d9626c78, targetPagePtr=105373696, reqLen=5208, targetRecPtr=105378880...
[19:37:38.144] #8 0x00000000006c2bac in ReadPageInternal (state=0x30f0d9626c78, pageptr=pageptr@entry=105373696, reqLen...
[19:37:38.144] #9 0x00000000006c1955 in XLogDecodeNextRecord (state=0x30f0d9626c78, nonblocking=false) at ../src/backen... |
| core |
[19:37:38.243] #0 0x0000220c6b6f2f30 in ?? ()
[19:37:38.243] #1 0x0000000000000003 in ?? ()
[19:37:38.243] #2 0x00001001c8cac110 in ?? ()
[19:37:38.243] #3 0x00001001c8cac113 in ?? ()
[19:37:38.243] #4 0x00001001c8cac116 in ?? ()
[19:37:38.243] #5 0x0000000000000000 in ?? () |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2026-05-25 19:25:10.250268000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rules.out 2026-05-25 19:29:10.030700000 +0...
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2026-05-25 19:25:10.250268000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/rules.out 2026-05-25 19:30:43.078920000 ...
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/build/testrun/regress/regress/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2026-05-25 19:25:10.250268000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/rules.out 2026-05-25 19:29:09.928914000 +0000
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2026-05-25 19:25:10.250268000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/rules.out 2026-05-25 19:29:09.87...
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| tap |
[19:31:30.201](263.304s) not ok 5 - regression tests in old instance |
| tap |
[19:32:42.371](264.803s) not ok 2 - regression tests pass |
| tap |
[19:29:12.203](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[19:31:40.175](275.611s) not ok 1 - regression tests pass |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/resu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2026-05-25 19:25:13.920292372 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/rules.out 2026-05-25 19:33:30.446858193 +0000
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/src/test/modules/test_plan_advice...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2026-05-25 19:25:13.920292372 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/rules.out 2026-05-25 19:35:36.799282777 +00...
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2026-05-25 19:25:13.920292372 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/rules.out 2026-05-25 19:35:34.723276952 +0000
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/rules.out /tmp/cirrus-ci-build/src/test/regress/results/rules.ou...
--- /tmp/cirrus-ci-build/src/test/regress/expected/rules.out 2026-05-25 19:25:13.920292372 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/rules.out 2026-05-25 19:31:27.542170594 +0000
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| tap |
[19:34:43.029](136.303s) not ok 5 - regression tests in old instance |
| tap |
[19:36:27.594](133.912s) not ok 1 - regression tests pass |
| tap |
[19:36:29.528](139.225s) not ok 2 - regression tests pass |
| tap |
[19:38:15.486](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/rules.out /home/postgres/postgres/build/testrun/pg_upgrade/00...
--- /home/postgres/postgres/src/test/regress/expected/rules.out 2026-05-25 19:25:59.945520780 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/rules.out 2026-05-25 19:29:16.327871888...
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/rules.out /home/postgres/postgres/build/testrun/recovery/027_...
--- /home/postgres/postgres/src/test/regress/expected/rules.out 2026-05-25 19:25:59.945520780 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/rules.out 2026-05-25 19:30:07.8442491...
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/rules.out /home/postgres/postgres/build/testrun/regress/regre...
--- /home/postgres/postgres/src/test/regress/expected/rules.out 2026-05-25 19:25:59.945520780 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/rules.out 2026-05-25 19:29:15.862858321 +0000
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/rules.out /home/postgres/postgres/build/testrun/test_plan_adv...
--- /home/postgres/postgres/src/test/regress/expected/rules.out 2026-05-25 19:25:59.945520780 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/rules.out 2026-05-25 19:29:20...
@@ -1889,6 +1889,9 @@
pg_stat_get_checkpointer_sync_time() AS sync_time,
pg_stat_get_checkpointer_buffers_written() AS buffers_written,
pg_stat_get_checkpointer_slru_written() AS slru_written,
+ pg_stat_get_checkpointer_segs_added() AS segs_added,
+ pg_stat_get_checkpointer_segs_removed() AS segs_removed,
+ pg_stat_get_checkpointer_segs_recycled() AS segs_recycled,
pg_stat_get_checkpointer_stat_reset_time() AS stats_reset;
pg_stat_database| SELECT oid AS datid,
datname, |
| tap |
[19:30:04.135](92.998s) not ok 5 - regression tests in old instance |
| tap |
[19:30:59.475](105.764s) not ok 2 - regression tests pass |
| tap |
[19:29:54.700](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[19:30:08.823](100.389s) not ok 1 - regression tests pass |
| 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-05-24 11:01:18.279820400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-05-24 11:06:34.633954600 +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-05-24 11:01:18.279820400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-05-24 11:09:50.552407900 +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-05-24 11:01:18.279820400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/indexing.out 2026-05-24 11:06:06.139822200 +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-05-24 11:01:18.279820400 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-05-24 11:06:28.167646100 ...
@@ -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
... |
| tap |
[11:06:45.401](177.625s) not ok 5 - regression tests in old instance
# not ok 225 + indexing 5443 ms |
| tap |
[11:10:03.950](150.057s) not ok 2 - regression tests pass
# not ok 225 + indexing 7774 ms |
| tap |
[11:09:35.460](0.001s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[11:06:42.067](182.249s) not ok 1 - regression tests pass |
|
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-05-24 11:01:13
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-05-24 11:06:47
@@ -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-05-24 11:01:13
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-05-24 11:09:06
@@ -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-05-24 11:01:13
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/indexing.out 2026-05-24 11:06:47
@@ -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-05-24 11:01:13
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-05-24 11:06:49
@@ -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
... |
| tap |
[11:06:54.075](117.208s) not ok 5 - regression tests in old instance
# not ok 225 + indexing 6029 ms |
| tap |
[11:09:16.112](121.846s) not ok 2 - regression tests pass
# not ok 225 + indexing 9278 ms |
| tap |
[11:08:25.875](0.011s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[11:06:56.135](124.884s) not ok 1 - regression tests pass |
|
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-05-24 11:01:14.759560371 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-05-24 11:06:58.310831594...
@@ -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-05-24 11:01:14.759560371 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-05-24 11:08:39.3547629...
@@ -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-05-24 11:01:14.759560371 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/indexing.out 2026-05-24 11:06:58.038831805 +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-05-24 11:01:14.759560371 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-05-24 11:07:06...
@@ -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
... |
| tap |
[11:07:04.173](86.928s) not ok 5 - regression tests in old instance
# not ok 225 + indexing 6686 ms |
| tap |
[11:08:46.442](88.054s) not ok 2 - regression tests pass
# not ok 225 + indexing 9024 ms |
| tap |
[11:07:10.153](96.345s) not ok 1 - regression tests pass |
| test |
[11:12:40.300] 20/402 postgresql:regress / regress/regress ERROR ...
[11:12:40.300] 28/402 postgresql:test_plan_advice / test_plan_advice/001_replan_regress ERROR ...
[11:12:40.300] 24/402 postgresql:pg_upgrade / pg_upgrade/002_pg_upgrade ERROR 1...
[11:12:40.300] 117/402 postgresql:recovery / recovery/027_stream_regress ERROR 1... |
|
FreeBSD - Meson |
| core |
[11:13:57.259] #0 0x000035b2ce993efa in ?? () from /libexec/ld-elf.so.1
[11:13:57.259] #1 0x000035b2ce98df6c in ?? () from /libexec/ld-elf.so.1
[11:13:57.259] #2 0x0000000000000000 in ?? () |
| 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-05-24 11:01:14.631983000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-05-24 11:06:50.781580000...
@@ -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-05-24 11:01:14.631983000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-05-24 11:08:41.6434830...
@@ -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-05-24 11:01:14.631983000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/indexing.out 2026-05-24 11:07:12.354098000 +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-05-24 11:01:14.631983000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-05-24 11:07: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
... |
| tap |
[11:07:02.675](231.396s) not ok 5 - regression tests in old instance
# not ok 225 + indexing 17586 ms |
| tap |
[11:08:53.905](271.610s) not ok 2 - regression tests pass
# not ok 225 + indexing 14534 ms |
| tap |
[11:05:15.603](0.001s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[11:07:39.151](271.320s) not ok 1 - regression tests pass |
|
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-05-24 11:01:22.352965665 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/indexing.out 2026-05-24 11:09:48.709621941 +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-05-24 11:01:22.352965665 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/indexing.out 2026-05-24 11:12:36.861554054 ...
@@ -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-05-24 11:01:22.352965665 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/indexing.out 2026-05-24 11:12:55.049569599 +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-05-24 11:01:22.352965665 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/indexing.out 2026-05-24 11:09:49.289620653 +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
... |
| tap |
[11:09:57.841](147.657s) not ok 5 - regression tests in old instance
# not ok 225 + indexing 13323 ms |
| tap |
[11:12:45.150](123.888s) not ok 1 - regression tests pass |
| tap |
[11:13:00.265](124.541s) not ok 2 - regression tests pass
# not ok 225 + indexing 7957 ms |
| tap |
[11:14:47.009](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
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-05-24 11:01:42.700845704 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-05-24 11:05:37.730504...
@@ -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-05-24 11:01:42.700845704 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-05-24 11:06:35.3269...
@@ -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-05-24 11:01:42.700845704 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/indexing.out 2026-05-24 11:05:31.258216841 +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-05-24 11:01:42.700845704 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-05-24 11:05...
@@ -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
... |
| tap |
[11:05:46.683](92.088s) not ok 5 - regression tests in old instance
# not ok 225 + indexing 4056 ms |
| tap |
[11:06:42.213](108.295s) not ok 2 - regression tests pass
# not ok 225 + indexing 5862 ms |
| tap |
[11:05:34.154](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[11:05:53.165](102.836s) not ok 1 - regression tests pass |
| 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-05-24 08:43:55.842219800 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-05-24 08:49:47.513014100 +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-05-24 08:43:55.842219800 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-05-24 08:53:44.739267600 +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-05-24 08:43:55.842219800 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/indexing.out 2026-05-24 08:49:41.907623400 +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-05-24 08:43:55.842219800 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-05-24 08:49:34.868967400 ...
@@ -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)
... |
| tap |
[08:50:03.831](200.868s) not ok 5 - regression tests in old instance
# not ok 225 + indexing 6023 ms |
| tap |
[08:54:06.257](184.273s) not ok 2 - regression tests pass
# not ok 225 + indexing 8345 ms |
| tap |
[08:53:28.937](0.001s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[08:49:58.791](204.932s) not ok 1 - regression tests pass |
|
macOS - Sequoia - Meson |
| core |
[09:00:56.410] * frame #0: 0x0000000100c1c7c0 dyld`_dyld_start |
| 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-05-24 08:43:14
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-05-24 08:47:55
@@ -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-05-24 08:43:14
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-05-24 08:50:31
@@ -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-05-24 08:43:14
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/indexing.out 2026-05-24 08:47: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/test_plan_advice/001...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-05-24 08:43:14
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-05-24 08:48:02
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| tap |
[08:48:03.341](124.618s) not ok 5 - regression tests in old instance
# not ok 225 + indexing 6822 ms |
| tap |
[08:50:40.029](134.195s) not ok 2 - regression tests pass
# not ok 225 + indexing 6910 ms |
| tap |
[08:49:44.483](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[08:48:09.698](133.765s) not ok 1 - regression tests pass |
|
Linux - Debian Trixie - Meson |
| core |
[08:57:02.423] #0 0x00007faf54519012 in ?? () from /lib64/ld-linux-x86-64.so.2
[08:57:02.423] #1 0x00007faf544fe202 in ?? () from /lib64/ld-linux-x86-64.so.2
[08:57:02.423] #2 0x00007faf544ff5db in ?? () from /lib64/ld-linux-x86-64.so.2
[08:57:02.423] #3 0x00007faf544f9671 in ?? () from /lib64/ld-linux-x86-64.so.2
[08:57:02.423] #4 0x00007faf544f8399 in _dl_catch_exception () from /lib64/ld-linux-x86-64.so.2
[08:57:02.423] #5 0x00007faf544f99d4 in ?? () from /lib64/ld-linux-x86-64.so.2
[08:57:02.423] #6 0x00007faf545160bf in ?? () from /lib64/ld-linux-x86-64.so.2
[08:57:02.423] #7 0x00007faf54512c8f in ?? () from /lib64/ld-linux-x86-64.so.2
[08:57:02.423] #8 0x00007faf5451443a in ?? () from /lib64/ld-linux-x86-64.so.2
[08:57:02.423] #9 0x00007faf545132c8 in ?? () from /lib64/ld-linux-x86-64.so.2 |
| core |
[08:57:02.284] #0 0x00007f8aaf15da14 in pthread_sigmask () from /lib/x86_64-linux-gnu/libc.so.6
[08:57:02.284] #1 0x00007f8aaf103fd9 in sigprocmask () from /lib/x86_64-linux-gnu/libc.so.6
[08:57:02.284] #2 0x00007f8aaf1041d5 in sigsetmask () from /lib/x86_64-linux-gnu/libc.so.6
[08:57:02.284] #3 0x000055bbc2692da9 in ?? ()
[08:57:02.284] #4 0x000055bbc268c246 in ?? ()
[08:57:02.284] #5 0x000055bbc268b297 in ?? ()
[08:57:02.284] #6 0x000055bbc268bceb in ?? ()
[08:57:02.284] #7 0x000055bbc2689677 in ?? ()
[08:57:02.284] #8 0x00007f8aaf0edca8 in ?? () from /lib/x86_64-linux-gnu/libc.so.6
[08:57:02.284] #9 0x00007f8aaf0edd65 in __libc_start_main () from /lib/x86_64-linux-gnu/libc.so.6 |
| 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-05-24 08:43:44.838754761 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-05-24 08:49:00.380089319...
@@ -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-05-24 08:43:44.838754761 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-05-24 08:50:33.9072683...
@@ -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-05-24 08:43:44.838754761 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/indexing.out 2026-05-24 08:48:59.576098630 +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-05-24 08:43:44.838754761 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-05-24 08:49: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)
... |
| tap |
[08:49:06.279](83.722s) not ok 5 - regression tests in old instance
# not ok 225 + indexing 5205 ms |
| tap |
[08:50:41.350](82.410s) not ok 2 - regression tests pass
# not ok 225 + indexing 8599 ms |
| tap |
[08:49:10.547](90.888s) not ok 1 - regression tests pass |
| test |
[08:54:20.625] 20/401 postgresql:regress / regress/regress ERROR ...
[08:54:20.625] 28/401 postgresql:test_plan_advice / test_plan_advice/001_replan_regress ERROR ...
[08:54:20.625] 24/401 postgresql:pg_upgrade / pg_upgrade/002_pg_upgrade ERROR 1...
[08:54:20.625] 112/401 postgresql:recovery / recovery/027_stream_regress ERROR 1... |
|
Linux - Debian Trixie - Autoconf |
| core |
[09:00:28.675] #0 0x00007fbac54012c0 in ?? ()
[09:00:28.675] #1 0x0000000000000004 in ?? ()
[09:00:28.675] #2 0x00007fff363bed62 in ?? ()
[09:00:28.675] #3 0x00007fff363bed65 in ?? ()
[09:00:28.675] #4 0x00007fff363bed68 in ?? ()
[09:00:28.675] #5 0x00007fff363bed6b in ?? ()
[09:00:28.675] #6 0x0000000000000000 in ?? () |
| 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-05-24 08:43:18.402352305 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/indexing.out 2026-05-24 08:53:29.515985330 +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-05-24 08:43:18.402352305 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/indexing.out 2026-05-24 08:55:32.397937452 ...
@@ -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-05-24 08:43:18.402352305 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/indexing.out 2026-05-24 08:55:00.853220793 +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-05-24 08:43:18.402352305 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/indexing.out 2026-05-24 08:50:21.421872802 +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)
... |
| tap |
[08:53:46.573](168.283s) not ok 5 - regression tests in old instance
# not ok 225 + indexing 12186 ms |
| tap |
[08:55:37.220](128.865s) not ok 1 - regression tests pass |
| tap |
[08:55:07.353](184.542s) not ok 2 - regression tests pass
# not ok 225 + indexing 10215 ms |
| tap |
[08:57:10.064](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
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-05-24 08:44:35.224771940 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-05-24 08:48:26.487456...
@@ -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-05-24 08:44:35.224771940 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-05-24 08:49:13.1701...
@@ -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-05-24 08:44:35.224771940 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/indexing.out 2026-05-24 08:48:15.447190701 +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-05-24 08:44:35.224771940 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-05-24 08: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)
... |
| tap |
[08:48:31.454](96.238s) not ok 5 - regression tests in old instance
# not ok 225 + indexing 8285 ms |
| tap |
[08:49:21.548](103.634s) not ok 2 - regression tests pass
# not ok 225 + indexing 6254 ms |
| tap |
[08:48:17.674](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[08:48:37.124](105.171s) not ok 1 - regression tests pass |
|
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-05-24 08:43:46.276595000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-05-24 08:49:55.651272000...
@@ -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-05-24 08:43:46.276595000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-05-24 08:51:20.8855050...
@@ -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-05-24 08:43:46.276595000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/indexing.out 2026-05-24 08:49:51.307955000 +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-05-24 08:43:46.276595000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-05-24 08:50:04...
@@ -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)
... |
| tap |
[08:50:07.848](267.866s) not ok 5 - regression tests in old instance
# not ok 225 + indexing 19400 ms |
| tap |
[08:51:36.111](283.585s) not ok 2 - regression tests pass
# not ok 225 + indexing 18006 ms |
| tap |
[08:47:52.920](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[08:50:19.766](282.071s) not ok 1 - regression tests pass |
| 59/6332 |
json_table function PLAN clause |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| compiler |
[15:11:49.476] ../src/backend/libpq/auth-oauth.c(873): warning C4129: '%': unrecognized character escape sequence |
|
NetBSD - Meson |
| tap |
[15:12:55.114](1.033s) not ok 2 - check the catching-up state
[15:12:55.191](0.075s) not ok 3 - check that it is safe if WAL fits in max_wal_size
[15:12:55.337](0.145s) not ok 4 - check that slot is working |
| tap |
[15:13:52.306](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 59/6590 |
SQL/JSON json_table() function PLAN clause |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| compiler |
[14:53:34.862] ../src/backend/libpq/auth-oauth.c(873): warning C4129: '%': unrecognized character escape sequence |
| 59/6774 |
Fix bug of COPY (on_error set_null) |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| compiler |
[04:40:06.660] ../src/backend/libpq/auth-oauth.c(873): warning C4129: '%': unrecognized character escape sequence |
| 59/5099 |
Add OR REPLACE option to CREATE MATERIALIZED VIEW |
|
CompilerWarnings |
| compiler |
[00:10:59.031] createas.c:181:17: error: ‘static’ is not at beginning of declaration [-Werror=old-style-declaration] |
| compiler |
[00:10:30.776] createas.c:181:17: error: ‘static’ is not at beginning of declaration [-Werror=old-style-declaration] |
| compiler |
[00:17:23.735] createas.c:181:17: error: ‘static’ is not at beginning of declaration [-Werror=old-style-declaration] |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| compiler |
[00:10:20.611] ../src/backend/libpq/auth-oauth.c(873): warning C4129: '%': unrecognized character escape sequence |
| 59/6775 |
Simplify signature of ProcessStartupPacket() |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| compiler |
[20:09:25.040] ../src/backend/libpq/auth-oauth.c(873): warning C4129: '%': unrecognized character escape sequence |
| 59/6397 |
extended statistic (examine_variable) ignored CollateExpr |
|
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-05-15 22:13:00.003948155 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/collate.icu.utf8.out 2026-05-15 22:16:20.8...
@@ -3321,15 +3321,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-05-15 22:13:00.003948155 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/collate.icu.utf8.out 2026-05-15 22:17:55...
@@ -3321,15 +3321,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-05-15 22:13:00.003948155 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/collate.icu.utf8.out 2026-05-15 22:16:17.094675949 +0000
@@ -3321,15 +3321,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-05-15 22:13:00.003948155 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/collate.icu.utf8.out 2026-05-15 ...
@@ -3321,15 +3321,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
... |
| tap |
[22:17:03.504](89.749s) not ok 5 - regression tests in old instance |
| tap |
[22:18:42.442](88.238s) not ok 2 - regression tests pass |
| tap |
[22:17:06.647](95.869s) not ok 1 - regression tests pass |
| test |
[22:22:28.150] 11/401 postgresql:regress / regress/regress ERROR ...
[22:22:28.150] 28/401 postgresql:test_plan_advice / test_plan_advice/001_replan_regress ERROR ...
[22:22:28.150] 27/401 postgresql:pg_upgrade / pg_upgrade/002_pg_upgrade ERROR 1...
[22:22:28.150] 112/401 postgresql:recovery / recovery/027_stream_regress ERROR 1... |
|
macOS - Sequoia - Meson |
| core |
[22:30:49.887] * frame #0: 0x0000000100e807c0 dyld`_dyld_start |
| core |
[22:31:47.941] * frame #0: 0x000000019a535640 libsystem_kernel.dylib`stat + 8
[22:31:47.941] frame #1: 0x0000000102348cac bash`___lldb_unnamed_symbol671 + 48
[22:31:47.941] frame #2: 0x000000010234948c bash`___lldb_unnamed_symbol683 + 148
[22:31:47.941] frame #3: 0x00000001023490cc bash`___lldb_unnamed_symbol679 + 268
[22:31:47.941] frame #4: 0x0000000102348ec4 bash`___lldb_unnamed_symbol678 + 88
[22:31:47.941] frame #5: 0x0000000102343d90 bash`___lldb_unnamed_symbol626 + 1912
[22:31:47.941] frame #6: 0x0000000102342b14 bash`___lldb_unnamed_symbol619 + 1760
[22:31:47.941] frame #7: 0x00000001023365cc bash`___lldb_unnamed_symbol467 + 1168
[22:31:47.941] frame #8: 0x0000000102326450 bash`___lldb_unnamed_symbol211 + 176
[22:31:47.941] frame #9: 0x0000000102325a88 bash`___lldb_unnamed_symbol203 + 4992 |
| 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-05-15 22:13:01
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/collate.icu.utf8.out 2026-05-15 22:17:35
@@ -3321,15 +3321,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-05-15 22:13:01
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/collate.icu.utf8.out 2026-05-15 22:20:49
@@ -3321,15 +3321,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-05-15 22:13:01
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/collate.icu.utf8.out 2026-05-15 22:17:29
@@ -3321,15 +3321,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-05-15 22:13:01
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/collate.icu.utf8.out 2026-05-15 22...
@@ -3321,15 +3321,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
... |
| tap |
[22:18:47.229](136.298s) not ok 5 - regression tests in old instance |
| tap |
[22:21:56.819](149.457s) not ok 2 - regression tests pass |
| tap |
[22:21:06.001](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[22:18:52.273](146.562s) not ok 1 - regression tests pass |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| compiler |
[22:14:44.371] ../src/backend/libpq/auth-oauth.c(873): warning C4129: '%': unrecognized character escape sequence |
|
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-05-15 22:13:28.525096246 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/collate.icu.utf8.out 2026-05-15 22:16:1...
@@ -3321,15 +3321,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
... |
| tap |
[22:17:17.260](121.175s) not ok 5 - regression tests in old instance |
| tap |
[22:16:56.937](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
|
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-05-15 22:13:16.985472000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/collate.icu.utf8.out 2026-05-15 22:16:28.9...
@@ -3321,15 +3321,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-05-15 22:13:16.985472000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/collate.icu.utf8.out 2026-05-15 22:18:10...
@@ -3321,15 +3321,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-05-15 22:13:16.985472000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/collate.icu.utf8.out 2026-05-15 22:16:23.767570000 +0000
@@ -3321,15 +3321,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-05-15 22:13:16.985472000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/collate.icu.utf8.out 2026-05-15 ...
@@ -3321,15 +3321,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
... |
| tap |
[22:18:54.323](261.971s) not ok 5 - regression tests in old instance |
| tap |
[22:20:14.505](270.645s) not ok 2 - regression tests pass |
| tap |
[22:16:40.204](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[22:18:59.193](270.143s) not ok 1 - regression tests pass |
|
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-05-15 22:13:14.141404063 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/collate.icu.utf8.out 2026-05-15 22:20:41.984142334 +0000
@@ -3321,15 +3321,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-05-15 22:13:14.141404063 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/collate.icu.utf8.out 2026-05-15 22:23:21.26...
@@ -3321,15 +3321,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-05-15 22:13:14.141404063 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/collate.icu.utf8.out 2026-05-15 22:22:11.244103875 +0000
@@ -3321,15 +3321,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-05-15 22:13:14.141404063 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/collate.icu.utf8.out 2026-05-15 22:18:02.308055377 +0000
@@ -3321,15 +3321,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
... |
| tap |
[22:22:26.486](172.124s) not ok 5 - regression tests in old instance |
| tap |
[22:24:14.374](131.142s) not ok 1 - regression tests pass |
| tap |
[22:23:42.982](188.071s) not ok 2 - regression tests pass |
| tap |
[22:25:48.562](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| 59/6750 |
Fix FOR PORTION OF with non-updatable view columns |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| compiler |
[17:59:44.796] ../src/backend/libpq/auth-oauth.c(873): warning C4129: '%': unrecognized character escape sequence |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| compiler |
[17:31:04.356] ../src/backend/libpq/auth-oauth.c(873): warning C4129: '%': unrecognized character escape sequence |
| 59/6772 |
fix seg-fault in refint |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| compiler |
[16:51:59.999] ../src/backend/libpq/auth-oauth.c(873): warning C4129: '%': unrecognized character escape sequence |
| 59/6769 |
Fix bug of COPY TO support partition table |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| compiler |
[11:11:47.685] ../src/backend/libpq/auth-oauth.c(873): warning C4129: '%': unrecognized character escape sequence |
| 59/6759 |
Fix jsonpath .split_part() to honor silent mode |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| compiler |
[14:42:30.319] ../src/backend/libpq/auth-oauth.c(873): warning C4129: '%': unrecognized character escape sequence |
|
FreeBSD - Meson |
| tap |
[14:44:13.952](0.000s) ok 11 - second WAIT FOR LSN timed out after savepoint rollback |
| tap |
[14:51:09.417](0.000s) not ok 45 - hit injection point exec-insert-before-insert-speculative |
| 59/6508 |
Improve pgindent's formatting named fields in struct literals and varidic functions |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| compiler |
[23:26:42.303] ../src/backend/libpq/auth-oauth.c(873): warning C4129: '%': unrecognized character escape sequence |
| 59/6762 |
Decipher the comment in tsrank.c |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| compiler |
[19:46:29.105] ../src/backend/libpq/auth-oauth.c(873): warning C4129: '%': unrecognized character escape sequence |
| 59/5831 |
pgindent: improve formatting of multiline comments |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| compiler |
[19:44:41.632] ../src/backend/libpq/auth-oauth.c(873): warning C4129: '%': unrecognized character escape sequence |
| 59/6739 |
pgindent versus struct members and typedefs |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| compiler |
[10:47:42.426] ../src/backend/libpq/auth-oauth.c(873): warning C4129: '%': unrecognized character escape sequence |
| 59/6758 |
Fix unsafe PlannedStmt access in pg_stat_statements |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| compiler |
[03:35:28.740] ../src/backend/libpq/auth-oauth.c(873): warning C4129: '%': unrecognized character escape sequence |
| 59/6756 |
Fix pg_stat_statements display of normalized FETCH counts |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| compiler |
[02:45:44.937] ../src/backend/libpq/auth-oauth.c(873): warning C4129: '%': unrecognized character escape sequence |
| 59/6748 |
Fix REPACK with WITHOUT OVERLAPS replica identity indexes |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| compiler |
[07:08:34.861] ../src/backend/libpq/auth-oauth.c(873): warning C4129: '%': unrecognized character escape sequence |
| 59/6651 |
Optimize numeric comparison and aggregation via packed-datum extraction |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| compiler |
[20:00:34.361] ../src/backend/libpq/auth-oauth.c(873): warning C4129: '%': unrecognized character escape sequence |
| 59/6614 |
Add http connection service file functionality |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| compiler |
[20:27:39.191] ../src/backend/libpq/auth-oauth.c(873): warning C4129: '%': unrecognized character escape sequence |
|
CompilerWarnings |
| compiler |
[20:28:23.347] fe-connect.c:6089:7: error: call to undeclared function 'oauth_unsafe_debugging_enabled'; ISO C99 and lat... |
| compiler |
[20:28:23.347] fe-connect.c:6080:7: error: call to undeclared function 'oauth_unsafe_debugging_enabled'; ISO C99 and lat... |
| compiler |
[20:28:13.343] fe-connect.c:6089:7: error: call to undeclared function 'oauth_unsafe_debugging_enabled'; ISO C99 and lat... |
| compiler |
[20:28:13.343] fe-connect.c:6080:7: error: call to undeclared function 'oauth_unsafe_debugging_enabled'; ISO C99 and lat... |
| compiler |
[20:27:39.743] fe-connect.c:6080:21: error: implicit declaration of function ‘oauth_unsafe_debugging_enabled’ [-Wimplici... |
| compiler |
[20:27:30.269] fe-connect.c:6080:21: error: implicit declaration of function ‘oauth_unsafe_debugging_enabled’ [-Wimplici... |
| 59/6694 |
Fix duplicate errmsg in ALTER TABLE SPLIT PARTITION |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| compiler |
[12:44:19.356] ../src/backend/libpq/auth-oauth.c(873): warning C4129: '%': unrecognized character escape sequence |
| 59/6588 |
Speed up COPY TO text/CSV parsing using SIMD |
|
CompilerWarnings |
| compiler |
[21:35:27.922] copyto.c:273:16: error: mixing declarations and code is incompatible with standards before C99 [-Werror,-... |
| compiler |
[21:35:27.922] copyto.c:217:16: error: mixing declarations and code is incompatible with standards before C99 [-Werror,-... |
| compiler |
[21:35:07.838] copyto.c:217:16: error: mixing declarations and code is incompatible with standards before C99 [-Werror,-... |
| compiler |
[21:35:07.838] copyto.c:273:16: error: mixing declarations and code is incompatible with standards before C99 [-Werror,-... |
| compiler |
[21:34:26.294] copyto.c:217:9: error: ISO C90 forbids mixed declarations and code [-Werror=declaration-after-statement] |
| compiler |
[21:34:26.294] copyto.c:273:9: error: ISO C90 forbids mixed declarations and code [-Werror=declaration-after-statement] |
| compiler |
[21:34:10.033] copyto.c:217:9: error: ISO C90 forbids mixed declarations and code [-Werror=declaration-after-statement] |
| compiler |
[21:34:10.033] copyto.c:273:9: error: ISO C90 forbids mixed declarations and code [-Werror=declaration-after-statement] |
| compiler |
[21:36:14.278] copyto.c:217:9: error: ISO C90 forbids mixed declarations and code [-Werror=declaration-after-statement] |
| compiler |
[21:36:14.278] copyto.c:273:9: error: ISO C90 forbids mixed declarations and code [-Werror=declaration-after-statement] |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| compiler |
[21:34:23.173] ../src/backend/libpq/auth-oauth.c(873): warning C4129: '%': unrecognized character escape sequence |
| 59/6741 |
Fix WAIT FOR LSN cleanup on subtransaction abort |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| compiler |
[09:05:30.723] ../src/backend/libpq/auth-oauth.c(873): warning C4129: '%': unrecognized character escape sequence |
| 59/6566 |
guc: make dereference style consistent in check_backtrace_functions |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| compiler |
[19:01:27.074] ../src/backend/libpq/auth-oauth.c(873): warning C4129: '%': unrecognized character escape sequence |
| 59/6270 |
skip check constraints verification for unaffected columns during UPDATE |
|
macOS - Sequoia - Meson |
| core |
[07:23:30.486] * frame #0: 0x0000000104b187c0 dyld`_dyld_start |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out /Users/admin/pgsql/build/testrun/pg_upgrade/002...
--- /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out 2026-05-05 07:10:48
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out 2026-05-05 07:13:30
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out /Users/admin/pgsql/build/testrun/recovery/027_s...
--- /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out 2026-05-05 07:10:48
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out 2026-05-05 07:14:55
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out /Users/admin/pgsql/build/testrun/regress/regres...
--- /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out 2026-05-05 07:10:48
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/for_portion_of.out 2026-05-05 07:13:25
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out /Users/admin/pgsql/build/testrun/test_plan_advi...
--- /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out 2026-05-05 07:10:48
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/for_portion_of.out 2026-05-05 07:1...
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| tap |
[07:14:26.723](72.626s) not ok 5 - regression tests in old instance |
| tap |
[07:15:53.761](72.168s) not ok 2 - regression tests pass |
| tap |
[07:14:32.563](82.273s) not ok 1 - regression tests pass |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/for_portion_of.out C:/cirrus/build/testrun/pg_upgrade/0...
--- C:/cirrus/src/test/regress/expected/for_portion_of.out 2026-05-05 07:12:28.222315600 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out 2026-05-05 07:15:51.836766400 +000...
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/for_portion_of.out C:/cirrus/build/testrun/recovery/027...
--- C:/cirrus/src/test/regress/expected/for_portion_of.out 2026-05-05 07:12:28.222315600 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out 2026-05-05 07:19:49.775743200 +0...
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/for_portion_of.out C:/cirrus/build/testrun/regress/regr...
--- C:/cirrus/src/test/regress/expected/for_portion_of.out 2026-05-05 07:12:28.222315600 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/for_portion_of.out 2026-05-05 07:15:37.093581800 +0000
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/for_portion_of.out C:/cirrus/build/testrun/test_plan_ad...
--- C:/cirrus/src/test/regress/expected/for_portion_of.out 2026-05-05 07:12:28.222315600 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/for_portion_of.out 2026-05-05 07:15:42.1458...
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| tap |
[07:18:13.551](184.623s) not ok 5 - regression tests in old instance |
| tap |
[07:21:52.191](160.332s) not ok 2 - regression tests pass |
| tap |
[07:18:17.314](197.231s) not ok 1 - regression tests pass |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade...
--- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-05-05 07:11:09.594871958 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out 2026-05-05 07:14:54.484...
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/recovery/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-05-05 07:11:09.594871958 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out 2026-05-05 07:16:41.8...
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/regress/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-05-05 07:11:09.594871958 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/for_portion_of.out 2026-05-05 07:14:54.676257881 +0000
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/test_plan_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-05-05 07:11:09.594871958 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/for_portion_of.out 2026-05-05 07...
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| tap |
[07:16:14.108](95.764s) not ok 5 - regression tests in old instance |
| tap |
[07:18:00.068](93.635s) not ok 2 - regression tests pass |
| tap |
[07:16:19.064](103.765s) not ok 1 - regression tests pass |
| test |
[07:21:59.269] 6/399 postgresql:regress / regress/regress ERROR ...
[07:21:59.269] 28/399 postgresql:test_plan_advice / test_plan_advice/001_replan_regress ERROR 1...
[07:21:59.269] 25/399 postgresql:pg_upgrade / pg_upgrade/002_pg_upgrade ERROR 1...
[07:21:59.269] 116/399 postgresql:recovery / recovery/027_stream_regress ERROR 1... |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/for_portion_of.out /home/postgres/postgres/build/testrun/pg_u...
--- /home/postgres/postgres/src/test/regress/expected/for_portion_of.out Tue May 5 07:11:28 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out Tue May 5 07:14:54 ...
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/for_portion_of.out /home/postgres/postgres/build/testrun/reco...
--- /home/postgres/postgres/src/test/regress/expected/for_portion_of.out Tue May 5 07:11:28 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out Tue May 5 07:17:1...
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/for_portion_of.out /home/postgres/postgres/build/testrun/regr...
--- /home/postgres/postgres/src/test/regress/expected/for_portion_of.out Tue May 5 07:11:28 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/for_portion_of.out Tue May 5 07:14:47 2026
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/for_portion_of.out /home/postgres/postgres/build/testrun/test...
--- /home/postgres/postgres/src/test/regress/expected/for_portion_of.out Tue May 5 07:11:28 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/for_portion_of.out Tue May 5...
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| tap |
[07:17:02.648](156.648s) not ok 5 - regression tests in old instance |
| tap |
[07:20:18.371](226.688s) not ok 2 - regression tests pass |
| tap |
[07:17:01.303](163.140s) not ok 1 - regression tests pass |
| test |
[07:24:46.479] 9/397 postgresql:regress / regress/regress ERROR 1...
[07:24:46.479] 41/397 postgresql:test_plan_advice / test_plan_advice/001_replan_regress ERROR 1...
[07:24:46.479] 43/397 postgresql:pg_upgrade / pg_upgrade/002_pg_upgrade ERROR 2...
[07:24:46.479] 191/397 postgresql:recovery / recovery/027_stream_regress ERROR 2... |
|
Linux - Debian Trixie - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_c...
--- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-05-05 07:12:03.251281978 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/for_portion_of.out 2026-05-05 07:19:09.003976079 +0000
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/src/test/modules/test_pl...
--- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-05-05 07:12:03.251281978 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/for_portion_of.out 2026-05-05 07:20:58.2588...
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/src/test/recovery/tmp_ch...
--- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-05-05 07:12:03.251281978 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/for_portion_of.out 2026-05-05 07:20:40.450907440 +0000
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/src/test/regress/results...
--- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-05-05 07:12:03.251281978 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/for_portion_of.out 2026-05-05 07:16:50.062217867 +0000
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| tap |
[07:21:12.586](144.596s) not ok 5 - regression tests in old instance |
| tap |
[07:22:35.390](135.121s) not ok 1 - regression tests pass |
| tap |
[07:22:35.187](149.323s) not ok 2 - regression tests pass |
|
FreeBSD - Meson |
| core |
[07:22:59.838] #0 0x000000082bcab5da in _sigprocmask () from /lib/libc.so.7
[07:22:59.838] #1 0x000000082bce8a3c in _system () from /lib/libc.so.7
[07:22:59.838] #2 0x000000082cb63953 in ?? () from /lib/libthr.so.3
[07:22:59.838] #3 0x00000000006b5329 in RestoreArchivedFile (path=path@entry=0x820f3c1b0 "\006", xlogfname=xlogfname@en...
[07:22:59.838] #4 0x00000000006c0f30 in XLogFileRead (segno=segno@entry=6, tli=tli@entry=2, source=source@entry=XLOG_FR...
[07:22:59.838] #5 0x00000000006bcccb in XLogFileReadAnyTLI (segno=6, source=XLOG_FROM_ANY) at ../src/backend/access/tra...
[07:22:59.838] #6 WaitForWALToBecomeAvailable (RecPtr=100671488, randAccess=false, fetching_ckpt=false, tliRecPtr=10537...
[07:22:59.838] #7 XLogPageRead (xlogreader=0x312bf8a26c78, targetPagePtr=100663296, reqLen=8192, targetRecPtr=105376960...
[07:22:59.838] #8 0x00000000006c4535 in ReadPageInternal (state=0x312bf8a26c78, pageptr=pageptr@entry=105373696, reqLen...
[07:22:59.838] #9 0x00000000006c3355 in XLogDecodeNextRecord (state=0x312bf8a26c78, nonblocking=false) at ../src/backen... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade...
--- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-05-05 07:11:03.195678000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out 2026-05-05 07:13:14.356...
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/recovery/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-05-05 07:11:03.195678000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out 2026-05-05 07:14:37.3...
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/regress/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-05-05 07:11:03.195678000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/for_portion_of.out 2026-05-05 07:13:15.914564000 +0000
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/test_plan_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-05-05 07:11:03.195678000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/for_portion_of.out 2026-05-05 07...
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| tap |
[07:16:52.635](262.015s) not ok 5 - regression tests in old instance |
| tap |
[07:17:58.544](258.485s) not ok 2 - regression tests pass |
| tap |
[07:17:02.563](275.185s) not ok 1 - regression tests pass |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/for_portion_of.out /home/postgres/postgres/build/testrun/pg_u...
--- /home/postgres/postgres/src/test/regress/expected/for_portion_of.out 2026-05-05 07:12:29.328544742 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out 2026-05-05 07:14:56....
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/for_portion_of.out /home/postgres/postgres/build/testrun/reco...
--- /home/postgres/postgres/src/test/regress/expected/for_portion_of.out 2026-05-05 07:12:29.328544742 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out 2026-05-05 07:15:4...
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/for_portion_of.out /home/postgres/postgres/build/testrun/regr...
--- /home/postgres/postgres/src/test/regress/expected/for_portion_of.out 2026-05-05 07:12:29.328544742 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/for_portion_of.out 2026-05-05 07:14:56.619044013 +0000
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/for_portion_of.out /home/postgres/postgres/build/testrun/test...
--- /home/postgres/postgres/src/test/regress/expected/for_portion_of.out 2026-05-05 07:12:29.328544742 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/for_portion_of.out 2026-05-05...
@@ -1099,8 +1099,6 @@
FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11'
SET name = 'one^3'
WHERE id = 1;
-ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check"
-DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3).
ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check;
-- test inserts violating CHECK constraints
ALTER TABLE for_portion_of_test2
@@ -1115,12 +1113,13 @@
SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at;
id | valid_at | name
----+-------------------------+-------
- 1 | [2000-01-01,2010-01-01) | one
+ 1 | [2000-01-01,2001-01-11) | one^3
+ 1 | [2001-01-11,2010-01-01) | one
1 | [2010-01-01,2010-01-05) | one^1
... |
| tap |
[07:16:22.314](104.343s) not ok 5 - regression tests in old instance |
| tap |
[07:17:18.455](115.267s) not ok 2 - regression tests pass |
| tap |
[07:16:25.566](110.762s) not ok 1 - regression tests pass |
| 59/6553 |
Decorrelate nested tuple hash tables |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/union.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream...
--- /tmp/cirrus-ci-build/src/test/regress/expected/union.out 2026-05-04 11:33:35.379872000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/union.out 2026-05-04 11:37:15.586826000 ...
@@ -550,9 +550,9 @@
select x from (values (array[1, 2]), (array[1, 3])) _(x) union select x from (values (array[1, 2]), (array[1, 4])) _(x)...
x
-------
+ {1,2}
{1,4}
{1,3}
- {1,2}
(3 rows)
explain (costs off) |
| tap |
[11:40:47.474](305.493s) not ok 2 - regression tests pass |
| 59/6715 |
Fix race condition in pg_get_publication_tables with concurrent DROP TABLE |
|
FreeBSD - Meson |
| core |
[10:43:58.418] #0 0x000000082c9e85da in _sigprocmask () from /lib/libc.so.7
[10:43:58.418] #1 0x000000082ca25a3c in _system () from /lib/libc.so.7
[10:43:58.418] #2 0x000000082af49953 in ?? () from /lib/libthr.so.3
[10:43:58.418] #3 0x00000000006b4379 in RestoreArchivedFile (path=path@entry=0x821abe1b0 "\006", xlogfname=xlogfname@en...
[10:43:58.418] #4 0x00000000006bffa0 in XLogFileRead (segno=segno@entry=5, tli=tli@entry=1, source=source@entry=XLOG_FR...
[10:43:58.418] #5 0x00000000006bbd1b in XLogFileReadAnyTLI (segno=5, source=XLOG_FROM_ANY) at ../src/backend/access/tra...
[10:43:58.418] #6 WaitForWALToBecomeAvailable (RecPtr=83886104, randAccess=false, fetching_ckpt=false, tliRecPtr=838860...
[10:43:58.418] #7 XLogPageRead (xlogreader=0x147de1826c78, targetPagePtr=83886080, reqLen=24, targetRecPtr=83886080, re...
[10:43:58.418] #8 0x00000000006c362c in ReadPageInternal (state=0x147de1826c78, pageptr=pageptr@entry=83886080, reqLen=...
[10:43:58.418] #9 0x00000000006c23d5 in XLogDecodeNextRecord (state=0x147de1826c78, nonblocking=false) at ../src/backen... |
| tap |
[10:41:14.340](213.340s) # poll_query_until timed out executing this query:
[10:41:14.340](0.001s) # die: timed out when waiting for client backend to reach wait event 'pg-get-publication-tables-a...
timed out when waiting for client backend to reach wait event 'pg-get-publication-tables-after-list-built' at /tmp/cirru... |
| 59/5720 |
virtual generated column as partition key |
|
Windows - Server 2022, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/pg_upgrad...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2026-05-03 07:41:03.831515400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-05-03 07:45:12.669426200 +...
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/recovery/...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2026-05-03 07:41:03.831515400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-05-03 07:49:15.916023400...
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/regress/r...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2026-05-03 07:41:03.831515400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/generated_virtual.out 2026-05-03 07:45:05.280775600 +0000
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/generated_virtual.out C:/cirrus/build/testrun/test_plan...
--- C:/cirrus/src/test/regress/expected/generated_virtual.out 2026-05-03 07:41:03.831515400 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/generated_virtual.out 2026-05-03 07:45:08.1...
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| tap |
[07:46:43.874](183.592s) not ok 5 - regression tests in old instance |
| tap |
[07:50:36.301](174.224s) not ok 2 - regression tests pass |
| tap |
[07:46:41.872](190.092s) not ok 1 - regression tests pass |
|
Linux - Debian Trixie - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/pg_upgr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-05-03 07:40:57.065096072 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-05-03 07:45:38....
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/recover...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-05-03 07:40:57.065096072 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-05-03 07:47:1...
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-05-03 07:40:57.065096072 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_virtual.out 2026-05-03 07:45:36.936387384 +0000
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/test_pl...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-05-03 07:40:57.065096072 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/generated_virtual.out 2026-05-03...
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| tap |
[07:46:21.028](89.503s) not ok 5 - regression tests in old instance |
| tap |
[07:47:58.632](85.588s) not ok 2 - regression tests pass |
| tap |
[07:46:25.160](96.603s) not ok 1 - regression tests pass |
| test |
[07:51:38.917] 11/399 postgresql:regress / regress/regress ERROR ...
[07:51:38.917] 28/399 postgresql:test_plan_advice / test_plan_advice/001_replan_regress ERROR ...
[07:51:38.917] 25/399 postgresql:pg_upgrade / pg_upgrade/002_pg_upgrade ERROR 1...
[07:51:38.917] 114/399 postgresql:recovery / recovery/027_stream_regress ERROR 1... |
|
macOS - Sequoia - Meson |
| core |
[07:59:24.723] * frame #0: 0x00000001050247c0 dyld`_dyld_start |
| core |
[08:00:07.300] * frame #0: 0x0000000199082a80 libsystem_platform.dylib`_platform_strlen + 64
[08:00:07.300] frame #1: 0x0000000199084f1c libsystem_platform.dylib`_simple_getenv + 56
[08:00:07.300] frame #2: 0x00000001990460f4 libsystem_pthread.dylib`_pthread_key_global_init + 64
[08:00:07.300] frame #3: 0x0000000199045d24 libsystem_pthread.dylib`__pthread_init + 916
[08:00:07.300] frame #4: 0x00000001a72aa29c libSystem.B.dylib`libSystem_initializer + 136
[08:00:07.300] frame #5: 0x0000000198cc6efc dyld`invocation function for block in dyld4::Loader::findAndRunAllInitia...
[08:00:07.300] frame #6: 0x0000000198d0389c dyld`invocation function for block in dyld3::MachOAnalyzer::forEachIniti...
[08:00:07.300] frame #7: 0x0000000198d235cc dyld`invocation function for block in mach_o::Header::forEachSection(voi...
[08:00:07.300] frame #8: 0x0000000198d20358 dyld`mach_o::Header::forEachLoadCommand(void (load_command const*, bool&...
[08:00:07.300] frame #9: 0x0000000198d21a98 dyld`mach_o::Header::forEachSection(void (mach_o::Header::SectionInfo co... |
| core |
[08:00:49.343] * frame #0: 0x0000000198cc1fe0 dyld`dyld4::Loader::applyFixups(Diagnostics&, dyld4::RuntimeState&, dyld...
[08:00:49.343] frame #1: 0x0000000198cab858 dyld`dyld4::prepare(dyld4::APIs&, mach_o::Header const*) + 1644
[08:00:49.343] frame #2: 0x0000000198cab1d8 dyld`dyld4::start(dyld4::KernelArgs*, void*, void*)::$_0::operator()() c...
[08:00:49.343] frame #3: 0x0000000198caab4c dyld`start + 6000 |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out /Users/admin/pgsql/build/testrun/pg_upgrade/...
--- /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out 2026-05-03 07:41:02
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-05-03 07:45:57
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out /Users/admin/pgsql/build/testrun/recovery/02...
--- /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out 2026-05-03 07:41:02
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-05-03 07:48:49
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out /Users/admin/pgsql/build/testrun/regress/reg...
--- /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out 2026-05-03 07:41:02
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/generated_virtual.out 2026-05-03 07:45:46
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out /Users/admin/pgsql/build/testrun/test_plan_a...
--- /Users/admin/pgsql/src/test/regress/expected/generated_virtual.out 2026-05-03 07:41:02
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/generated_virtual.out 2026-05-03 0...
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| tap |
[07:46:54.503](129.454s) not ok 5 - regression tests in old instance |
| tap |
[07:50:27.246](183.735s) not ok 2 - regression tests pass |
| tap |
[07:46:55.676](135.881s) not ok 1 - regression tests pass |
|
Linux - Debian Trixie - Autoconf |
| core |
[07:57:59.999] #0 0x00007fe5a0d12687 in ?? () from /lib/x86_64-linux-gnu/libc.so.6
[07:57:59.999] #1 0x00007fe5a0d126ad in ?? () from /lib/x86_64-linux-gnu/libc.so.6
[07:57:59.999] #2 0x00007fe5a0d7d7c7 in wait4 () from /lib/x86_64-linux-gnu/libc.so.6
[07:57:59.999] #3 0x00005652340f34b8 in ?? ()
[07:57:59.999] #4 0x00005652340f370a in ?? ()
[07:57:59.999] #5 0x00005652340f4e14 in ?? ()
[07:57:59.999] #6 0x00005652340ee24e in ?? ()
[07:57:59.999] #7 0x00005652340ed297 in ?? ()
[07:57:59.999] #8 0x00005652340edceb in ?? ()
[07:57:59.999] #9 0x00005652340eb677 in ?? () |
| core |
[07:58:00.170] #0 0x00007f31a3a1abbc in __open_nocancel () from /lib/x86_64-linux-gnu/libc.so.6
[07:58:00.170] #1 0x00007f31a394c6ee in ?? () from /lib/x86_64-linux-gnu/libc.so.6
[07:58:00.170] #2 0x00007f31a394b802 in ?? () from /lib/x86_64-linux-gnu/libc.so.6
[07:58:00.170] #3 0x00007f31a394dd22 in setlocale () from /lib/x86_64-linux-gnu/libc.so.6
[07:58:00.170] #4 0x000055f2db4e301e in ?? ()
[07:58:00.170] #5 0x00007f31a393fca8 in ?? () from /lib/x86_64-linux-gnu/libc.so.6
[07:58:00.170] #6 0x00007f31a393fd65 in __libc_start_main () from /lib/x86_64-linux-gnu/libc.so.6
[07:58:00.170] #7 0x000055f2db4e3811 in ?? () |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tm...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-05-03 07:40:57.063863157 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/generated_virtual.out 2026-05-03 07:49:48.390548551 +0000
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/src/test/modules/test...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-05-03 07:40:57.063863157 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/generated_virtual.out 2026-05-03 07:52:13.1...
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/src/test/recovery/tmp...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-05-03 07:40:57.063863157 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/generated_virtual.out 2026-05-03 07:51:54.406346782 +0000
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/src/test/regress/resu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-05-03 07:40:57.063863157 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/generated_virtual.out 2026-05-03 07:46:59.157855013 +0000
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| tap |
[07:51:32.570](173.343s) not ok 5 - regression tests in old instance |
| tap |
[07:53:12.015](151.109s) not ok 1 - regression tests pass |
| tap |
[07:53:06.905](177.451s) not ok 2 - regression tests pass |
|
OpenBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/p...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out Sun May 3 07:41:12 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out Sun May 3 07:45:...
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/r...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out Sun May 3 07:41:12 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out Sun May 3 07:4...
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/r...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out Sun May 3 07:41:12 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_virtual.out Sun May 3 07:45:19 2026
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/t...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out Sun May 3 07:41:12 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/generated_virtual.out Sun May...
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| tap |
[07:46:36.587](130.144s) not ok 5 - regression tests in old instance |
| tap |
[07:49:25.793](193.302s) not ok 2 - regression tests pass |
| tap |
[07:46:34.554](137.666s) not ok 1 - regression tests pass |
| test |
[07:53:10.560] 15/397 postgresql:regress / regress/regress ERROR 1...
[07:53:10.560] 39/397 postgresql:test_plan_advice / test_plan_advice/001_replan_regress ERROR 1...
[07:53:10.560] 42/397 postgresql:pg_upgrade / pg_upgrade/002_pg_upgrade ERROR 2...
[07:53:10.560] 195/397 postgresql:recovery / recovery/027_stream_regress ERROR 2... |
|
NetBSD - Meson |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/p...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out 2026-05-03 07:41:21.058498400 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-05-03 07:44:...
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/r...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out 2026-05-03 07:41:21.058498400 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-05-03 07:4...
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/r...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out 2026-05-03 07:41:21.058498400 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/generated_virtual.out 2026-05-03 07:44:23.666184256 +0...
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /home/postgres/postgres/src/test/regress/expected/generated_virtual.out /home/postgres/postgres/build/testrun/t...
--- /home/postgres/postgres/src/test/regress/expected/generated_virtual.out 2026-05-03 07:41:21.058498400 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/generated_virtual.out 2026-05...
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| tap |
[07:45:21.809](98.164s) not ok 5 - regression tests in old instance |
| tap |
[07:46:13.227](108.272s) not ok 2 - regression tests pass |
| tap |
[07:45:29.011](108.683s) not ok 1 - regression tests pass |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/pg_upgr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-05-03 07:40:52.548813000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/generated_virtual.out 2026-05-03 07:44:20....
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/recover...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-05-03 07:40:52.548813000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/generated_virtual.out 2026-05-03 07:45:5...
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-05-03 07:40:52.548813000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/generated_virtual.out 2026-05-03 07:44:31.513586000 +0000
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out /tmp/cirrus-ci-build/build/testrun/test_pl...
--- /tmp/cirrus-ci-build/src/test/regress/expected/generated_virtual.out 2026-05-03 07:40:52.548813000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/generated_virtual.out 2026-05-03...
@@ -1154,9 +1154,10 @@
f2 | bigint | | | | plain | |
f3 | bigint | | | generated always as (f2 * 2) | plain | |
Partition key: RANGE (f3)
-Partitions: gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30'),
- gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50'),
- gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
+Partitions:
+ gtest_part_key1_0 FOR VALUES FROM ('20') TO ('30')
+ gtest_part_key1_1 FOR VALUES FROM ('30') TO ('50')
+ gtest_part_key1_2 FOR VALUES FROM ('50') TO ('100')
INSERT INTO gtest_part_key1(f2) VALUES (9); -- error
ERROR: no partition of relation "gtest_part_key1" found for row |
| tap |
[07:46:47.184](251.212s) not ok 5 - regression tests in old instance |
| tap |
[07:47:57.237](252.759s) not ok 2 - regression tests pass |
| tap |
[07:46:57.668](263.874s) not ok 1 - regression tests pass |
| 59/6422 |
ANALYZE: hash-accelerate MCV tracking for equality-only types |
|
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-05-03 07:09:13.281029504 +0000
+++ /home/postgres/postgres/build/testrun/isolation/isolation/results/timeouts.out 2026-05-03 07:11:49.174492534 +0000
@@ -11,7 +11,7 @@
step sto: SET statement_timeout = '10ms';
step locktbl: LOCK TABLE accounts; <waiting ...>
step locktbl: <... completed>
-ERROR: canceling statement due to statement timeout
+ERROR: canceling statement due to user request
starting permutation: rdtbl lto locktbl
step rdtbl: SELECT * FROM accounts; |