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.
| 52/4285 |
Revise get_cheapest_parallel_safe_total_inner |
 |
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/regress-runn...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-04-02 21:21:15.783200000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress-running/regress/results/create_index.out 2025-04-02 21:28:16.023016000 +0...
@@ -2012,7 +2012,7 @@
QUERY PLAN
----------------------------------------------------------------------------
Aggregate
- -> Index Only Scan using tenk1_thous_tenthous on tenk1 t1
+ -> Seq Scan on tenk1 t1
Filter: ((thousand = 42) OR (thousand = (SubPlan 1)))
SubPlan 1
-> Limit
@@ -2211,7 +2211,7 @@
Aggregate
-> Nested Loop Left Join
Join Filter: (tenk1.hundred = 42)
- -> Index Only Scan using tenk1_hundred on tenk1
+ -> Seq Scan on tenk1
-> Memoize
Cache Key: tenk1.hundred
... |
| 53/5669 |
Use CLOCK_MONOTONIC_COARSE for instr_time for explain analyze |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/entry_timestamp.out /tmp/cirrus-ci-build/build/testrun...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/entry_timestamp.out 2025-04-02 01:12:53.974257000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_stat_statements/regress/results/entry_timestamp.out 2025-04-02 01:16:32.155105...
@@ -147,7 +147,7 @@
WHERE query LIKE '%STMTTS%';
total | minmax_exec_zero | minmax_ts_after_ref | stats_since_after_ref
-------+------------------+---------------------+-----------------------
- 2 | 1 | 2 | 0
+ 2 | 2 | 2 | 0
(1 row)
-- Cleanup |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/entry_timestamp.out /tmp/cirrus-ci-build/contrib/pg_st...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/entry_timestamp.out 2025-04-02 01:12:53.009140981 +0000
+++ /tmp/cirrus-ci-build/contrib/pg_stat_statements/results/entry_timestamp.out 2025-04-02 01:19:52.811595451 +0000
@@ -45,7 +45,7 @@
WHERE query LIKE '%STMTTS%';
total | minmax_plan_zero | minmax_exec_zero | minmax_stats_since_after_ref | stats_since_after_ref
-------+------------------+------------------+------------------------------+-----------------------
- 2 | 0 | 0 | 0 | 0
+ 2 | 0 | 2 | 0 | 0
(1 row)
-- Perform single min/max reset
@@ -71,7 +71,7 @@
WHERE query LIKE '%STMTTS%';
total | minmax_plan_zero | minmax_exec_zero | minmax_stats_since_after_ref | stats_since_after_ref
-------+------------------+------------------+------------------------------+-----------------------
- 2 | 1 | 1 | 1 | 0
+ 2 | 1 | 2 | 1 | 0
(1 row)
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/entry_timestamp.out /tmp/cirrus-ci-build/build/testrun...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/entry_timestamp.out 2025-04-02 01:12:53.692621424 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_stat_statements/regress/results/entry_timestamp.out 2025-04-02 01:19:32.527670...
@@ -45,7 +45,7 @@
WHERE query LIKE '%STMTTS%';
total | minmax_plan_zero | minmax_exec_zero | minmax_stats_since_after_ref | stats_since_after_ref
-------+------------------+------------------+------------------------------+-----------------------
- 2 | 0 | 0 | 0 | 0
+ 2 | 0 | 2 | 0 | 0
(1 row)
-- Perform single min/max reset
@@ -71,7 +71,7 @@
WHERE query LIKE '%STMTTS%';
total | minmax_plan_zero | minmax_exec_zero | minmax_stats_since_after_ref | stats_since_after_ref
-------+------------------+------------------+------------------------------+-----------------------
- 2 | 1 | 1 | 1 | 0
+ 2 | 1 | 2 | 1 | 0
(1 row)
... |
| 52/5607 |
SIMD optimization for list_sort |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/list_sort_simd.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade...
--- /tmp/cirrus-ci-build/src/test/regress/expected/list_sort_simd.out 2025-04-01 16:35:00.638454000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/list_sort_simd.out 2025-04-01 16:38:43.495...
@@ -26,62 +26,62 @@
(1 row)
SELECT test_list_sort_simd_float_random(100, 20, 2, true);
- test_list_sort_simd_float_random
-------------------------------------------------------------------------------------------------------------------
- {0.024923936,0.03346995,0.08167228,0.08531265,0.10674526,0.114986524,0.11994517,0.1355998,0.13572839,0.16894749}
+ test_list_sort_simd_float_random ...
+-----------------------------------------------------------------------------------------------------------------------...
+ {0.003372915,0.0034219418,0.013631644,0.019021165,0.030820394,0.031393025,0.057282537,0.0827536,0.090136975,0.09039178...
(1 row)
SELECT test_list_sort_simd_float_random(2, 20, 2, true);
test_list_sort_simd_float_random
----------------------------------
- {0.03346995,0.32996422}
+ {0.34728608,2}
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/list_sort_simd.out /tmp/cirrus-ci-build/build/testrun/recovery/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/list_sort_simd.out 2025-04-01 16:35:00.638454000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/list_sort_simd.out 2025-04-01 16:39:55.8...
@@ -26,62 +26,62 @@
(1 row)
SELECT test_list_sort_simd_float_random(100, 20, 2, true);
- test_list_sort_simd_float_random
-------------------------------------------------------------------------------------------------------------------
- {0.024923936,0.03346995,0.08167228,0.08531265,0.10674526,0.114986524,0.11994517,0.1355998,0.13572839,0.16894749}
+ test_list_sort_simd_float_random ...
+-----------------------------------------------------------------------------------------------------------------------...
+ {0.003372915,0.0034219418,0.013631644,0.019021165,0.030820394,0.031393025,0.057282537,0.0827536,0.090136975,0.09039178...
(1 row)
SELECT test_list_sort_simd_float_random(2, 20, 2, true);
test_list_sort_simd_float_random
----------------------------------
- {0.03346995,0.32996422}
+ {0.34728608,2}
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/list_sort_simd.out /tmp/cirrus-ci-build/build/testrun/regress/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/list_sort_simd.out 2025-04-01 16:35:00.638454000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/list_sort_simd.out 2025-04-01 16:38:52.282775000 +0000
@@ -26,62 +26,62 @@
(1 row)
SELECT test_list_sort_simd_float_random(100, 20, 2, true);
- test_list_sort_simd_float_random
-------------------------------------------------------------------------------------------------------------------
- {0.024923936,0.03346995,0.08167228,0.08531265,0.10674526,0.114986524,0.11994517,0.1355998,0.13572839,0.16894749}
+ test_list_sort_simd_float_random ...
+-----------------------------------------------------------------------------------------------------------------------...
+ {0.003372915,0.0034219418,0.013631644,0.019021165,0.030820394,0.031393025,0.057282537,0.0827536,0.090136975,0.09039178...
(1 row)
SELECT test_list_sort_simd_float_random(2, 20, 2, true);
test_list_sort_simd_float_random
----------------------------------
- {0.03346995,0.32996422}
+ {0.34728608,2}
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/list_sort_simd.out /Users/admin/pgsql/build/testrun/pg_upgrade/002...
--- /Users/admin/pgsql/src/test/regress/expected/list_sort_simd.out 2025-04-01 16:34:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/list_sort_simd.out 2025-04-01 16:37:11
@@ -26,62 +26,62 @@
(1 row)
SELECT test_list_sort_simd_float_random(100, 20, 2, true);
- test_list_sort_simd_float_random
-------------------------------------------------------------------------------------------------------------------
- {0.024923936,0.03346995,0.08167228,0.08531265,0.10674526,0.114986524,0.11994517,0.1355998,0.13572839,0.16894749}
+ test_list_sort_simd_float_random
+-----------------------------------------------------------------------------------------------------------------------
+ {0.0003287075,0.012317667,0.023025734,0.02969798,0.052807085,0.06473413,0.08912913,0.09746116,0.10345733,0.103527315}
(1 row)
SELECT test_list_sort_simd_float_random(2, 20, 2, true);
test_list_sort_simd_float_random
----------------------------------
- {0.03346995,0.32996422}
+ {0.0003287075,0.5245871}
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/list_sort_simd.out /Users/admin/pgsql/build/testrun/recovery/027_s...
--- /Users/admin/pgsql/src/test/regress/expected/list_sort_simd.out 2025-04-01 16:34:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/list_sort_simd.out 2025-04-01 16:38:10
@@ -26,62 +26,62 @@
(1 row)
SELECT test_list_sort_simd_float_random(100, 20, 2, true);
- test_list_sort_simd_float_random
-------------------------------------------------------------------------------------------------------------------
- {0.024923936,0.03346995,0.08167228,0.08531265,0.10674526,0.114986524,0.11994517,0.1355998,0.13572839,0.16894749}
+ test_list_sort_simd_float_random
+-----------------------------------------------------------------------------------------------------------------------
+ {0.0003287075,0.012317667,0.023025734,0.02969798,0.052807085,0.06473413,0.08912913,0.09746116,0.10345733,0.103527315}
(1 row)
SELECT test_list_sort_simd_float_random(2, 20, 2, true);
test_list_sort_simd_float_random
----------------------------------
- {0.03346995,0.32996422}
+ {0.0003287075,0.5245871}
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/list_sort_simd.out /Users/admin/pgsql/build/testrun/regress/regres...
--- /Users/admin/pgsql/src/test/regress/expected/list_sort_simd.out 2025-04-01 16:34:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/list_sort_simd.out 2025-04-01 16:37:13
@@ -26,62 +26,62 @@
(1 row)
SELECT test_list_sort_simd_float_random(100, 20, 2, true);
- test_list_sort_simd_float_random
-------------------------------------------------------------------------------------------------------------------
- {0.024923936,0.03346995,0.08167228,0.08531265,0.10674526,0.114986524,0.11994517,0.1355998,0.13572839,0.16894749}
+ test_list_sort_simd_float_random
+-----------------------------------------------------------------------------------------------------------------------
+ {0.0003287075,0.012317667,0.023025734,0.02969798,0.052807085,0.06473413,0.08912913,0.09746116,0.10345733,0.103527315}
(1 row)
SELECT test_list_sort_simd_float_random(2, 20, 2, true);
test_list_sort_simd_float_random
----------------------------------
- {0.03346995,0.32996422}
+ {0.0003287075,0.5245871}
... |
| 52/5117 |
VACUUM FULL / CLUSTER CONCURRENTLY |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out C:/cirr...
--- C:/cirrus/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out 2025-04-01 14:48:14.284573100 +0...
+++ C:/cirrus/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-04-01 14:54:13.313953...
@@ -1,51 +1,6 @@
Parsed test spec with 2 sessions
starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check
-step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass);
-itemoffset|blknum|attnum|allnulls|hasnulls|placeholder|empty|value
-----------+------+------+--------+--------+-----------+-----+--------
- 1| 0| 1|f |t |f |f |{1 .. 1}
-(1 row)
-
-step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ;
-step s2b: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1;
-?column?
---------
- 1
-(1 row)
-
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/dblink/expected/dblink.out C:/cirrus/build/testrun/dblink/regress/results...
--- C:/cirrus/contrib/dblink/expected/dblink.out 2025-04-01 14:48:10.336153400 +0000
+++ C:/cirrus/build/testrun/dblink/regress/results/dblink.out 2025-04-01 14:53:37.875932500 +0000
@@ -799,423 +799,7 @@
UNION
(SELECT * from dblink_get_result('dtest3') as t3(f1 int, f2 text, f3 text[]))
ORDER by f1;
--- dblink_get_connections returns an array with elements in a machine-dependent
--- ordering, so we must resort to unnesting and sorting for a stable result
-create function unnest(anyarray) returns setof anyelement
-language sql strict immutable as $$
-select $1[i] from generate_series(array_lower($1,1), array_upper($1,1)) as i
-$$;
-SELECT * FROM unnest(dblink_get_connections()) ORDER BY 1;
- unnest
---------
- dtest1
- dtest2
- dtest3
-(3 rows)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/delay_execution/expected/partition-addition.out C:/cirrus/build/...
--- C:/cirrus/src/test/modules/delay_execution/expected/partition-addition.out 2025-04-01 14:48:14.292460100 +0000
+++ C:/cirrus/build/testrun/delay_execution/isolation/results/partition-addition.out 2025-04-01 14:54:18.018384600 +0000
@@ -1,27 +1,6 @@
Parsed test spec with 2 sessions
starting permutation: s2lock s1exec s2addp s2unlock
-step s2lock: SELECT pg_advisory_lock(12345);
-pg_advisory_lock
-----------------
-
-(1 row)
-
-step s1exec: LOAD 'delay_execution';
- SET delay_execution.post_planning_lock_id = 12345;
- SELECT * FROM foo WHERE a <> 1 AND a <> (SELECT 3); <waiting ...>
-step s2addp: CREATE TABLE foo2 (LIKE foo);
- ALTER TABLE foo ATTACH PARTITION foo2 FOR VALUES IN (2);
- INSERT INTO foo VALUES (2, 'ADD2');
-step s2unlock: SELECT pg_advisory_unlock(12345);
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/interfaces/ecpg/test/expected/compat_informix-sqlda.stderr C:/cirrus/build/te...
--- C:/cirrus/src/interfaces/ecpg/test/expected/compat_informix-sqlda.stderr 2025-04-01 14:48:13.715917000 +0000
+++ C:/cirrus/build/testrun/ecpg/ecpg/results/compat_informix-sqlda.stderr 2025-04-01 14:54:46.480543300 +0000
@@ -332,9 +332,9 @@
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ecpg_execute on line 241: using PQexec
[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_process_output on line 241: OK: DROP TABLE
-[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ECPGtrans on line 244: action "commit"; connection "regress1"
-[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_finish: connection regress1 closed
+[NO_PID]: ecpg_check_PQresult on line 241: bad response - server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
[NO_PID]: sqlca: code: 0, state: 00000
+[NO_PID]: raising sqlstate 57P02 (sqlcode -400): the connection to the server was lost on line 241
+[NO_PID]: sqlca: code: -400, state: 57P02
diff --strip-trailing-cr -U3 C:/cirrus/src/interfaces/ecpg/test/expected/compat_informix-describe.stdout C:/cirrus/build...
--- C:/cirrus/src/interfaces/ecpg/test/expected/compat_informix-describe.stdout 2025-04-01 14:48:13.715917000 +0000
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/injection_points/expected/basic.out C:/cirrus/build/testrun/inje...
--- C:/cirrus/src/test/modules/injection_points/expected/basic.out 2025-04-01 14:48:14.310113500 +0000
+++ C:/cirrus/build/testrun/injection_points/isolation/results/basic.out 2025-04-01 14:54:23.040616500 +0000
@@ -1,75 +1,6 @@
Parsed test spec with 2 sessions
starting permutation: wait1 wakeup2 noop1 detach2
-injection_points_attach
------------------------
-
-(1 row)
-
-step wait1: SELECT injection_points_run('injection-points-wait'); <waiting ...>
-step wakeup2: SELECT injection_points_wakeup('injection-points-wait');
-injection_points_wakeup
------------------------
-
-(1 row)
-
-step wait1: <... completed>
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/isolation/expected/read-only-anomaly.out C:/cirrus/build/testrun/isolati...
--- C:/cirrus/src/test/isolation/expected/read-only-anomaly.out 2025-04-01 14:48:14.163489000 +0000
+++ C:/cirrus/build/testrun/isolation/isolation/results/read-only-anomaly.out 2025-04-01 14:50:11.396247400 +0000
@@ -1,33 +1,6 @@
Parsed test spec with 3 sessions
starting permutation: s2rx s2ry s1ry s1wy s1c s3r s2wx s2c s3c
-step s2rx: SELECT balance FROM bank_account WHERE id = 'X';
-balance
--------
- 0
-(1 row)
-
-step s2ry: SELECT balance FROM bank_account WHERE id = 'Y';
-balance
--------
- 0
-(1 row)
-
-step s1ry: SELECT balance FROM bank_account WHERE id = 'Y';
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pageinspect/expected/brin.out C:/cirrus/build/testrun/pageinspect/regress...
--- C:/cirrus/contrib/pageinspect/expected/brin.out 2025-04-01 14:48:10.510840900 +0000
+++ C:/cirrus/build/testrun/pageinspect/regress/results/brin.out 2025-04-01 14:53:49.486829000 +0000
@@ -146,65 +146,7 @@
USING brin (a int4_minmax_ops, a int4_bloom_ops, b, c int8_minmax_multi_ops)
WITH (pages_per_range=7)
WHERE NOT (a BETWEEN 1000 and 1500);
-SELECT relname, relpages
- FROM pg_class
- WHERE relname IN ('brin_test_serial_idx', 'brin_test_parallel_idx')
- ORDER BY relname;
- relname | relpages
-------------------------+----------
- brin_test_parallel_idx | 4
- brin_test_serial_idx | 4
-(2 rows)
-
--- Check that (A except B) and (B except A) is empty, which means the indexes
--- are the same.
-SELECT * FROM brin_page_items(get_raw_page('brin_test_parallel_idx', 2), 'brin_test_parallel_idx')
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_logicalinspect/expected/logical_inspect.out C:/cirrus/build/testrun/pg...
--- C:/cirrus/contrib/pg_logicalinspect/expected/logical_inspect.out 2025-04-01 14:48:10.559823500 +0000
+++ C:/cirrus/build/testrun/pg_logicalinspect/isolation/results/logical_inspect.out 2025-04-01 14:53:53.179207000 +0000
@@ -1,32 +1,6 @@
Parsed test spec with 2 sessions
starting permutation: s0_init s0_begin s0_savepoint s0_truncate s1_create_table s1_checkpoint s1_get_changes s1_check_s...
-step s0_init: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding');
-?column?
---------
-init
-(1 row)
-
-step s0_begin: BEGIN;
-step s0_savepoint: SAVEPOINT sp1;
-step s0_truncate: TRUNCATE tbl1;
-step s1_create_table: CREATE TABLE tbl2 (val1 integer, val2 integer);
-step s1_checkpoint: CHECKPOINT;
-step s1_get_changes: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'skip-empty-xacts', '1'...
-data
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_stat_statements/expected/parallel.out C:/cirrus/build/testrun/pg_stat_...
--- C:/cirrus/contrib/pg_stat_statements/expected/parallel.out 2025-04-01 14:48:10.582248600 +0000
+++ C:/cirrus/build/testrun/pg_stat_statements/regress/results/parallel.out 2025-04-01 14:53:58.170475500 +0000
@@ -26,9 +26,7 @@
FROM pg_stat_statements
WHERE query ~ 'SELECT count'
ORDER BY query COLLATE "C";
- query | has_workers_to_launch | has_workers_launched
-----------------------------------------+-----------------------+----------------------
- SELECT count(*) FROM pgss_parallel_tab | t | t
-(1 row)
-
-DROP TABLE pgss_parallel_tab;
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_stat_statements/expected/cleanup.out C:/cirrus/build/testrun/pg_stat_s...
--- C:/cirrus/contrib/pg_stat_statements/expected/cleanup.out 2025-04-01 14:48:10.576837000 +0000
+++ C:/cirrus/build/testrun/pg_stat_statements/regress/results/cleanup.out 2025-04-01 14:53:58.330680500 +0000
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/boolean.out C:/cirrus/build/testrun/pg_upgrade/002_pg_u...
--- C:/cirrus/src/test/regress/expected/boolean.out 2025-04-01 14:48:14.587565900 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/boolean.out 2025-04-01 14:50:12.336433400 +0000
@@ -241,357 +241,7 @@
SELECT ''::text::boolean AS invalid; -- error
ERROR: invalid input syntax for type boolean: ""
CREATE TABLE BOOLTBL1 (f1 bool);
-INSERT INTO BOOLTBL1 (f1) VALUES (bool 't');
-INSERT INTO BOOLTBL1 (f1) VALUES (bool 'True');
-INSERT INTO BOOLTBL1 (f1) VALUES (bool 'true');
--- BOOLTBL1 should be full of true's at this point
-SELECT BOOLTBL1.* FROM BOOLTBL1;
- f1
-----
- t
- t
- t
-(3 rows)
-
-SELECT BOOLTBL1.*
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pgrowlocks/expected/pgrowlocks.out C:/cirrus/build/testrun/pgrowlocks/iso...
--- C:/cirrus/contrib/pgrowlocks/expected/pgrowlocks.out 2025-04-01 14:48:10.701397400 +0000
+++ C:/cirrus/build/testrun/pgrowlocks/isolation/results/pgrowlocks.out 2025-04-01 14:53:56.479987900 +0000
@@ -1,233 +1,6 @@
Parsed test spec with 2 sessions
starting permutation: s1_begin s1_tuplock1 s2_rowlocks s1_commit
-step s1_begin: BEGIN;
-step s1_tuplock1: SELECT * FROM multixact_conflict FOR KEY SHARE;
-a|b
--+-
-1|2
-3|4
-(2 rows)
-
-step s2_rowlocks: SELECT locked_row, multi, modes FROM pgrowlocks('multixact_conflict');
-locked_row|multi|modes
-----------+-----+-----------------
-(0,1) |f |{"For Key Share"}
-(0,2) |f |{"For Key Share"}
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/postgres_fdw/expected/postgres_fdw.out C:/cirrus/build/testrun/postgres_f...
--- C:/cirrus/contrib/postgres_fdw/expected/postgres_fdw.out 2025-04-01 14:48:10.727760600 +0000
+++ C:/cirrus/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2025-04-01 14:54:03.400068200 +0000
@@ -254,12264 +254,7 @@
-- To exercise multiple code paths, we use local stats on ft1
-- and remote-estimate mode on ft2.
ANALYZE ft1;
-ALTER FOREIGN TABLE ft2 OPTIONS (use_remote_estimate 'true');
--- ===================================================================
--- test error case for create publication on foreign table
--- ===================================================================
-CREATE PUBLICATION testpub_ftbl FOR TABLE ft1; -- should fail
-ERROR: cannot add relation "ft1" to publication
-DETAIL: This operation is not supported for foreign tables.
--- ===================================================================
--- simple queries
--- ===================================================================
--- single table without alias
-EXPLAIN (COSTS OFF) SELECT * FROM ft1 ORDER BY c3, c1 OFFSET 100 LIMIT 10;
- QUERY PLAN
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/boolean.out C:/cirrus/build/testrun/recovery/027_stream...
--- C:/cirrus/src/test/regress/expected/boolean.out 2025-04-01 14:48:14.587565900 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/boolean.out 2025-04-01 14:52:14.044326500 +0000
@@ -1,597 +1,3 @@
---
--- BOOLEAN
---
---
--- sanity check - if this fails go insane!
---
-SELECT 1 AS one;
- one
------
- 1
-(1 row)
-
--- ******************testing built-in type bool********************
--- check bool input syntax
-SELECT true AS true;
- true
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/char.out C:/cirrus/build/testrun/regress/regress/result...
--- C:/cirrus/src/test/regress/expected/char.out 2025-04-01 14:48:14.594275000 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/char.out 2025-04-01 14:50:07.920035500 +0000
@@ -14,186 +14,7 @@
-- (This temporarily hides the table created in test_setup.sql)
--
CREATE TEMP TABLE CHAR_TBL(f1 char);
-INSERT INTO CHAR_TBL (f1) VALUES ('a');
-INSERT INTO CHAR_TBL (f1) VALUES ('A');
--- any of the following three input formats are acceptable
-INSERT INTO CHAR_TBL (f1) VALUES ('1');
-INSERT INTO CHAR_TBL (f1) VALUES (2);
-INSERT INTO CHAR_TBL (f1) VALUES ('3');
--- zero-length char
-INSERT INTO CHAR_TBL (f1) VALUES ('');
--- try char's of greater than 1 length
-INSERT INTO CHAR_TBL (f1) VALUES ('cd');
-ERROR: value too long for type character(1)
-INSERT INTO CHAR_TBL (f1) VALUES ('c ');
-SELECT * FROM CHAR_TBL;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/tcn/expected/tcn.out C:/cirrus/build/testrun/tcn/isolation/results/tcn.ou...
--- C:/cirrus/contrib/tcn/expected/tcn.out 2025-04-01 14:48:10.816673100 +0000
+++ C:/cirrus/build/testrun/tcn/isolation/results/tcn.out 2025-04-01 14:54:05.548876700 +0000
@@ -1,13 +1,6 @@
Parsed test spec with 1 sessions
starting permutation: listen insert insert2 update delete
-step listen: LISTEN mychannel;
-step insert: INSERT INTO mytable VALUES(1, 'one');
-s1: NOTIFY "mychannel" with payload ""mytable",I,"key"='1'" from s1
-step insert2: INSERT INTO mytable VALUES(2, 'two');
-s1: NOTIFY "mychannel" with payload ""mytable",I,"key"='2'" from s1
-step update: UPDATE mytable SET value = 'foo' WHERE key = 2;
-s1: NOTIFY "mychannel" with payload ""mytable",U,"key"='2'" from s1
-step delete: DELETE FROM mytable;
-s1: NOTIFY "mychannel" with payload ""mytable",D,"key"='1'" from s1
-s1: NOTIFY "mychannel" with payload ""mytable",D,"key"='2'" from s1
+setup failed: server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request. |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/test_decoding/expected/mxact.out C:/cirrus/build/testrun/test_decoding/is...
--- C:/cirrus/contrib/test_decoding/expected/mxact.out 2025-04-01 14:48:10.825908200 +0000
+++ C:/cirrus/build/testrun/test_decoding/isolation/results/mxact.out 2025-04-01 14:54:06.555163500 +0000
@@ -1,90 +1,6 @@
Parsed test spec with 3 sessions
starting permutation: s0init s0start s1begin s1sharepgclass s2begin s2sharepgclass s0w s0start s2commit s1commit
-step s0init: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding');
-?column?
---------
-init
-(1 row)
-
-step s0start: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false');
-data
-----
-(0 rows)
-
-step s1begin: BEGIN;
-step s1sharepgclass: SELECT count(*) > 1 FROM (SELECT * FROM pg_class FOR SHARE) s;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/test_extensions/expected/test_extensions.out C:/cirrus/build/tes...
--- C:/cirrus/src/test/modules/test_extensions/expected/test_extensions.out 2025-04-01 14:48:14.396692000 +0000
+++ C:/cirrus/build/testrun/test_extensions/regress/results/test_extensions.out 2025-04-01 14:54:31.313045400 +0000
@@ -144,527 +144,10 @@
') > 0 loop c := c + 1; perform pg_stat_clear_snapshot(); end loop;
raise log ''test_extensions looped % times'', c;
end';
--- extension should now contain no temp objects
-\dx+ test_ext8
-Objects in extension "test_ext8"
- Object description
-----------------------------
- function ext8_even(posint)
- table ext8_table1
- type ext8_table1
- type ext8_table1[]
- type posint
- type posint[]
-(6 rows)
-
... |
| 52/5283 |
Replace IN VALUES with ANY in WHERE clauses during optimization |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-04-01 12:34:30.693623529 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2025-04-01 12:43:05.74503...
@@ -3056,7 +3056,7 @@
SELECT ten FROM onek t WHERE 1 IN ((VALUES (1), (3)));
QUERY PLAN
----------------------------------------------------------
- Seq Scan on onek t (cost=0.00..45.00 rows=1000 width=4)
+ Seq Scan on onek t (cost=0.00..44.00 rows=1000 width=4)
(1 row)
EXPLAIN (COSTS OFF) |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build-32/testrun/recovery/027...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-04-01 12:34:30.693623529 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/recovery/027_stream_regress/data/results/subselect.out 2025-04-01 12:44:23.809...
@@ -3056,7 +3056,7 @@
SELECT ten FROM onek t WHERE 1 IN ((VALUES (1), (3)));
QUERY PLAN
----------------------------------------------------------
- Seq Scan on onek t (cost=0.00..45.00 rows=1000 width=4)
+ Seq Scan on onek t (cost=0.00..44.00 rows=1000 width=4)
(1 row)
EXPLAIN (COSTS OFF) |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build-32/testrun/regress/regr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-04-01 12:34:30.693623529 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/subselect.out 2025-04-01 12:43:01.885034512 +0000
@@ -3056,7 +3056,7 @@
SELECT ten FROM onek t WHERE 1 IN ((VALUES (1), (3)));
QUERY PLAN
----------------------------------------------------------
- Seq Scan on onek t (cost=0.00..45.00 rows=1000 width=4)
+ Seq Scan on onek t (cost=0.00..44.00 rows=1000 width=4)
(1 row)
EXPLAIN (COSTS OFF) |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/subselect.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_u...
--- /Users/admin/pgsql/src/test/regress/expected/subselect.out 2025-04-01 12:34:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2025-04-01 12:35:58
@@ -2833,15 +2833,16 @@
EXPLAIN (COSTS OFF)
SELECT c.oid,c.relname FROM pg_class c JOIN pg_am a USING (oid)
WHERE c.oid IN (VALUES (1), (2));
- QUERY PLAN
----------------------------------------------------------------
- Hash Join
- Hash Cond: (a.oid = c.oid)
- -> Seq Scan on pg_am a
- -> Hash
- -> Index Scan using pg_class_oid_index on pg_class c
- Index Cond: (oid = ANY ('{1,2}'::oid[]))
-(6 rows)
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (c.oid = a.oid)
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subselect.out C:/cirrus/build/testrun/pg_upgrade/002_pg...
--- C:/cirrus/src/test/regress/expected/subselect.out 2025-04-01 12:34:33.548221700 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2025-04-01 12:36:55.563436900 +0000
@@ -2833,15 +2833,16 @@
EXPLAIN (COSTS OFF)
SELECT c.oid,c.relname FROM pg_class c JOIN pg_am a USING (oid)
WHERE c.oid IN (VALUES (1), (2));
- QUERY PLAN
----------------------------------------------------------------
- Hash Join
- Hash Cond: (a.oid = c.oid)
- -> Seq Scan on pg_am a
- -> Hash
- -> Index Scan using pg_class_oid_index on pg_class c
- Index Cond: (oid = ANY ('{1,2}'::oid[]))
-(6 rows)
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (c.oid = a.oid)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subselect.out C:/cirrus/build/testrun/regress/regress/r...
--- C:/cirrus/src/test/regress/expected/subselect.out 2025-04-01 12:34:33.548221700 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/subselect.out 2025-04-01 12:36:51.794892700 +0000
@@ -2833,15 +2833,16 @@
EXPLAIN (COSTS OFF)
SELECT c.oid,c.relname FROM pg_class c JOIN pg_am a USING (oid)
WHERE c.oid IN (VALUES (1), (2));
- QUERY PLAN
----------------------------------------------------------------
- Hash Join
- Hash Cond: (a.oid = c.oid)
- -> Seq Scan on pg_am a
- -> Hash
- -> Index Scan using pg_class_oid_index on pg_class c
- Index Cond: (oid = ANY ('{1,2}'::oid[]))
-(6 rows)
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (c.oid = a.oid)
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-04-01 03:55:26.312546848 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2025-04-01 04:04:11.15349...
@@ -3043,7 +3043,7 @@
SELECT ten FROM onek t WHERE 1 IN ((VALUES (1), (3)));
QUERY PLAN
----------------------------------------------------------
- Seq Scan on onek t (cost=0.00..45.00 rows=1000 width=4)
+ Seq Scan on onek t (cost=0.00..44.00 rows=1000 width=4)
(1 row)
EXPLAIN (COSTS OFF) |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build-32/testrun/recovery/027...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-04-01 03:55:26.312546848 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/recovery/027_stream_regress/data/results/subselect.out 2025-04-01 04:05:32.192...
@@ -3043,7 +3043,7 @@
SELECT ten FROM onek t WHERE 1 IN ((VALUES (1), (3)));
QUERY PLAN
----------------------------------------------------------
- Seq Scan on onek t (cost=0.00..45.00 rows=1000 width=4)
+ Seq Scan on onek t (cost=0.00..44.00 rows=1000 width=4)
(1 row)
EXPLAIN (COSTS OFF) |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build-32/testrun/regress/regr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-04-01 03:55:26.312546848 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/subselect.out 2025-04-01 04:04:12.245457233 +0000
@@ -3043,7 +3043,7 @@
SELECT ten FROM onek t WHERE 1 IN ((VALUES (1), (3)));
QUERY PLAN
----------------------------------------------------------
- Seq Scan on onek t (cost=0.00..45.00 rows=1000 width=4)
+ Seq Scan on onek t (cost=0.00..44.00 rows=1000 width=4)
(1 row)
EXPLAIN (COSTS OFF) |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subselect.out C:/cirrus/build/testrun/pg_upgrade/002_pg...
--- C:/cirrus/src/test/regress/expected/subselect.out 2025-04-01 03:55:29.413211300 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2025-04-01 03:58:07.517725700 +0000
@@ -2833,15 +2833,16 @@
EXPLAIN (COSTS OFF)
SELECT c.oid,c.relname FROM pg_class c JOIN pg_am a USING (oid)
WHERE c.oid IN (VALUES (1), (2));
- QUERY PLAN
----------------------------------------------------------------
- Hash Join
- Hash Cond: (a.oid = c.oid)
- -> Seq Scan on pg_am a
- -> Hash
- -> Index Scan using pg_class_oid_index on pg_class c
- Index Cond: (oid = ANY ('{1,2}'::oid[]))
-(6 rows)
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (c.oid = a.oid)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subselect.out C:/cirrus/build/testrun/recovery/027_stre...
--- C:/cirrus/src/test/regress/expected/subselect.out 2025-04-01 03:55:29.413211300 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2025-04-01 04:00:51.138811800 +0000
@@ -2833,15 +2833,16 @@
EXPLAIN (COSTS OFF)
SELECT c.oid,c.relname FROM pg_class c JOIN pg_am a USING (oid)
WHERE c.oid IN (VALUES (1), (2));
- QUERY PLAN
----------------------------------------------------------------
- Hash Join
- Hash Cond: (a.oid = c.oid)
- -> Seq Scan on pg_am a
- -> Hash
- -> Index Scan using pg_class_oid_index on pg_class c
- Index Cond: (oid = ANY ('{1,2}'::oid[]))
-(6 rows)
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (c.oid = a.oid)
... |
| 53/5087 |
Doc: Move and modify standalone hot backups section |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/regress-runn...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-03-31 21:31:57.590656000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress-running/regress/results/create_index.out 2025-03-31 21:39:18.103892000 +0...
@@ -2012,7 +2012,7 @@
QUERY PLAN
----------------------------------------------------------------------------
Aggregate
- -> Index Only Scan using tenk1_thous_tenthous on tenk1 t1
+ -> Seq Scan on tenk1 t1
Filter: ((thousand = 42) OR (thousand = (SubPlan 1)))
SubPlan 1
-> Limit
@@ -2181,9 +2181,11 @@
Filter: ((thousand = 42) OR (thousand = 41) OR (tenthous = 2))
-> Bitmap Index Scan on tenk2_hundred
Index Cond: (hundred = 42)
- -> Index Only Scan using tenk1_hundred on tenk1
- Index Cond: (hundred = 42)
-(9 rows)
+ -> Bitmap Heap Scan on tenk1
... |
| 53/5652 |
pg_dsm_registry system view |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_dsm_registry/expected/test_dsm_registry.out /tmp/cirrus-ci-build/bui...
--- /tmp/cirrus-ci-build/src/test/modules/test_dsm_registry/expected/test_dsm_registry.out 2025-03-31 17:02:50.257414000...
+++ /tmp/cirrus-ci-build/build/testrun/test_dsm_registry-running/regress/results/test_dsm_registry.out 2025-03-31 17:09:...
@@ -17,5 +17,6 @@
name | size
-------------------+------
test_dsm_registry | 20
-(1 row)
+ injection_points | 560
+(2 rows)
|
| 52/5117 |
VACUUM FULL / CLUSTER CONCURRENTLY |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/repack.out /tmp/cirrus-ci-build/build/testrun/i...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/repack.out 2025-03-31 15:02:23.110404000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/repack.out 2025-03-31 15:06:35.923266000 +0000
@@ -8,7 +8,8 @@
step wait_before_lock:
REPACK CONCURRENTLY repack_test USING INDEX repack_test_pkey;
- <waiting ...>
+
+ERROR: could not open relation with OID 2139062143
step change_existing:
UPDATE repack_test SET i=10 where i=1;
UPDATE repack_test SET j=20 where i=2;
@@ -63,12 +64,7 @@
step wakeup_before_lock:
SELECT injection_points_wakeup('repack-concurrently-before-lock');
-injection_points_wakeup
------------------------
-
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out C:/cirr...
--- C:/cirrus/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out 2025-03-31 15:02:25.957887400 +0...
+++ C:/cirrus/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-03-31 15:08:32.218628...
@@ -1,51 +1,6 @@
Parsed test spec with 2 sessions
starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check
-step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass);
-itemoffset|blknum|attnum|allnulls|hasnulls|placeholder|empty|value
-----------+------+------+--------+--------+-----------+-----+--------
- 1| 0| 1|f |t |f |f |{1 .. 1}
-(1 row)
-
-step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ;
-step s2b: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1;
-?column?
---------
- 1
-(1 row)
-
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/dblink/expected/dblink.out C:/cirrus/build/testrun/dblink/regress/results...
--- C:/cirrus/contrib/dblink/expected/dblink.out 2025-03-31 15:02:21.678012200 +0000
+++ C:/cirrus/build/testrun/dblink/regress/results/dblink.out 2025-03-31 15:07:53.535460600 +0000
@@ -799,423 +799,7 @@
UNION
(SELECT * from dblink_get_result('dtest3') as t3(f1 int, f2 text, f3 text[]))
ORDER by f1;
--- dblink_get_connections returns an array with elements in a machine-dependent
--- ordering, so we must resort to unnesting and sorting for a stable result
-create function unnest(anyarray) returns setof anyelement
-language sql strict immutable as $$
-select $1[i] from generate_series(array_lower($1,1), array_upper($1,1)) as i
-$$;
-SELECT * FROM unnest(dblink_get_connections()) ORDER BY 1;
- unnest
---------
- dtest1
- dtest2
- dtest3
-(3 rows)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/delay_execution/expected/partition-addition.out C:/cirrus/build/...
--- C:/cirrus/src/test/modules/delay_execution/expected/partition-addition.out 2025-03-31 15:02:25.968292900 +0000
+++ C:/cirrus/build/testrun/delay_execution/isolation/results/partition-addition.out 2025-03-31 15:08:37.156066300 +0000
@@ -1,27 +1,6 @@
Parsed test spec with 2 sessions
starting permutation: s2lock s1exec s2addp s2unlock
-step s2lock: SELECT pg_advisory_lock(12345);
-pg_advisory_lock
-----------------
-
-(1 row)
-
-step s1exec: LOAD 'delay_execution';
- SET delay_execution.post_planning_lock_id = 12345;
- SELECT * FROM foo WHERE a <> 1 AND a <> (SELECT 3); <waiting ...>
-step s2addp: CREATE TABLE foo2 (LIKE foo);
- ALTER TABLE foo ATTACH PARTITION foo2 FOR VALUES IN (2);
- INSERT INTO foo VALUES (2, 'ADD2');
-step s2unlock: SELECT pg_advisory_unlock(12345);
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/interfaces/ecpg/test/expected/compat_informix-sqlda.stderr C:/cirrus/build/te...
--- C:/cirrus/src/interfaces/ecpg/test/expected/compat_informix-sqlda.stderr 2025-03-31 15:02:25.261831800 +0000
+++ C:/cirrus/build/testrun/ecpg/ecpg/results/compat_informix-sqlda.stderr 2025-03-31 15:09:07.656633600 +0000
@@ -332,9 +332,9 @@
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ecpg_execute on line 241: using PQexec
[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_process_output on line 241: OK: DROP TABLE
-[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ECPGtrans on line 244: action "commit"; connection "regress1"
-[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_finish: connection regress1 closed
+[NO_PID]: ecpg_check_PQresult on line 241: bad response - server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
[NO_PID]: sqlca: code: 0, state: 00000
+[NO_PID]: raising sqlstate 57P02 (sqlcode -400): the connection to the server was lost on line 241
+[NO_PID]: sqlca: code: -400, state: 57P02
diff --strip-trailing-cr -U3 C:/cirrus/src/interfaces/ecpg/test/expected/compat_informix-describe.stdout C:/cirrus/build...
--- C:/cirrus/src/interfaces/ecpg/test/expected/compat_informix-describe.stdout 2025-03-31 15:02:25.249450300 +0000
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/injection_points/expected/basic.out C:/cirrus/build/testrun/inje...
--- C:/cirrus/src/test/modules/injection_points/expected/basic.out 2025-03-31 15:02:25.993579900 +0000
+++ C:/cirrus/build/testrun/injection_points/isolation/results/basic.out 2025-03-31 15:08:42.134578900 +0000
@@ -1,75 +1,6 @@
Parsed test spec with 2 sessions
starting permutation: wait1 wakeup2 noop1 detach2
-injection_points_attach
------------------------
-
-(1 row)
-
-step wait1: SELECT injection_points_run('injection-points-wait'); <waiting ...>
-step wakeup2: SELECT injection_points_wakeup('injection-points-wait');
-injection_points_wakeup
------------------------
-
-(1 row)
-
-step wait1: <... completed>
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/isolation/expected/read-only-anomaly.out C:/cirrus/build/testrun/isolati...
--- C:/cirrus/src/test/isolation/expected/read-only-anomaly.out 2025-03-31 15:02:25.808068700 +0000
+++ C:/cirrus/build/testrun/isolation/isolation/results/read-only-anomaly.out 2025-03-31 15:04:26.536497700 +0000
@@ -1,33 +1,6 @@
Parsed test spec with 3 sessions
starting permutation: s2rx s2ry s1ry s1wy s1c s3r s2wx s2c s3c
-step s2rx: SELECT balance FROM bank_account WHERE id = 'X';
-balance
--------
- 0
-(1 row)
-
-step s2ry: SELECT balance FROM bank_account WHERE id = 'Y';
-balance
--------
- 0
-(1 row)
-
-step s1ry: SELECT balance FROM bank_account WHERE id = 'Y';
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pageinspect/expected/brin.out C:/cirrus/build/testrun/pageinspect/regress...
--- C:/cirrus/contrib/pageinspect/expected/brin.out 2025-03-31 15:02:21.868965000 +0000
+++ C:/cirrus/build/testrun/pageinspect/regress/results/brin.out 2025-03-31 15:08:07.465142700 +0000
@@ -146,65 +146,10 @@
USING brin (a int4_minmax_ops, a int4_bloom_ops, b, c int8_minmax_multi_ops)
WITH (pages_per_range=7)
WHERE NOT (a BETWEEN 1000 and 1500);
-SELECT relname, relpages
- FROM pg_class
- WHERE relname IN ('brin_test_serial_idx', 'brin_test_parallel_idx')
- ORDER BY relname;
- relname | relpages
-------------------------+----------
- brin_test_parallel_idx | 4
- brin_test_serial_idx | 4
-(2 rows)
-
--- Check that (A except B) and (B except A) is empty, which means the indexes
--- are the same.
-SELECT * FROM brin_page_items(get_raw_page('brin_test_parallel_idx', 2), 'brin_test_parallel_idx')
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_logicalinspect/expected/logical_inspect.out C:/cirrus/build/testrun/pg...
--- C:/cirrus/contrib/pg_logicalinspect/expected/logical_inspect.out 2025-03-31 15:02:21.919270800 +0000
+++ C:/cirrus/build/testrun/pg_logicalinspect/isolation/results/logical_inspect.out 2025-03-31 15:08:10.968183700 +0000
@@ -1,32 +1,6 @@
Parsed test spec with 2 sessions
starting permutation: s0_init s0_begin s0_savepoint s0_truncate s1_create_table s1_checkpoint s1_get_changes s1_check_s...
-step s0_init: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding');
-?column?
---------
-init
-(1 row)
-
-step s0_begin: BEGIN;
-step s0_savepoint: SAVEPOINT sp1;
-step s0_truncate: TRUNCATE tbl1;
-step s1_create_table: CREATE TABLE tbl2 (val1 integer, val2 integer);
-step s1_checkpoint: CHECKPOINT;
-step s1_get_changes: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'skip-empty-xacts', '1'...
-data
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_stat_statements/expected/parallel.out C:/cirrus/build/testrun/pg_stat_...
--- C:/cirrus/contrib/pg_stat_statements/expected/parallel.out 2025-03-31 15:02:21.941724600 +0000
+++ C:/cirrus/build/testrun/pg_stat_statements/regress/results/parallel.out 2025-03-31 15:08:16.045214400 +0000
@@ -15,20 +15,10 @@
(1 row)
SELECT count(*) FROM pgss_parallel_tab;
- count
--------
- 0
-(1 row)
-
-SELECT query,
- parallel_workers_to_launch > 0 AS has_workers_to_launch,
- parallel_workers_launched > 0 AS has_workers_launched
- FROM pg_stat_statements
- WHERE query ~ 'SELECT count'
- ORDER BY query COLLATE "C";
- query | has_workers_to_launch | has_workers_launched
-----------------------------------------+-----------------------+----------------------
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/boolean.out C:/cirrus/build/testrun/pg_upgrade/002_pg_u...
--- C:/cirrus/src/test/regress/expected/boolean.out 2025-03-31 15:02:26.324743200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/boolean.out 2025-03-31 15:04:30.048255400 +0000
@@ -241,357 +241,7 @@
SELECT ''::text::boolean AS invalid; -- error
ERROR: invalid input syntax for type boolean: ""
CREATE TABLE BOOLTBL1 (f1 bool);
-INSERT INTO BOOLTBL1 (f1) VALUES (bool 't');
-INSERT INTO BOOLTBL1 (f1) VALUES (bool 'True');
-INSERT INTO BOOLTBL1 (f1) VALUES (bool 'true');
--- BOOLTBL1 should be full of true's at this point
-SELECT BOOLTBL1.* FROM BOOLTBL1;
- f1
-----
- t
- t
- t
-(3 rows)
-
-SELECT BOOLTBL1.*
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pgrowlocks/expected/pgrowlocks.out C:/cirrus/build/testrun/pgrowlocks/iso...
--- C:/cirrus/contrib/pgrowlocks/expected/pgrowlocks.out 2025-03-31 15:02:22.065824200 +0000
+++ C:/cirrus/build/testrun/pgrowlocks/isolation/results/pgrowlocks.out 2025-03-31 15:08:14.194654000 +0000
@@ -1,233 +1,6 @@
Parsed test spec with 2 sessions
starting permutation: s1_begin s1_tuplock1 s2_rowlocks s1_commit
-step s1_begin: BEGIN;
-step s1_tuplock1: SELECT * FROM multixact_conflict FOR KEY SHARE;
-a|b
--+-
-1|2
-3|4
-(2 rows)
-
-step s2_rowlocks: SELECT locked_row, multi, modes FROM pgrowlocks('multixact_conflict');
-locked_row|multi|modes
-----------+-----+-----------------
-(0,1) |f |{"For Key Share"}
-(0,2) |f |{"For Key Share"}
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/postgres_fdw/expected/postgres_fdw.out C:/cirrus/build/testrun/postgres_f...
--- C:/cirrus/contrib/postgres_fdw/expected/postgres_fdw.out 2025-03-31 15:02:22.092553700 +0000
+++ C:/cirrus/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2025-03-31 15:08:20.172701700 +0000
@@ -254,12264 +254,7 @@
-- To exercise multiple code paths, we use local stats on ft1
-- and remote-estimate mode on ft2.
ANALYZE ft1;
-ALTER FOREIGN TABLE ft2 OPTIONS (use_remote_estimate 'true');
--- ===================================================================
--- test error case for create publication on foreign table
--- ===================================================================
-CREATE PUBLICATION testpub_ftbl FOR TABLE ft1; -- should fail
-ERROR: cannot add relation "ft1" to publication
-DETAIL: This operation is not supported for foreign tables.
--- ===================================================================
--- simple queries
--- ===================================================================
--- single table without alias
-EXPLAIN (COSTS OFF) SELECT * FROM ft1 ORDER BY c3, c1 OFFSET 100 LIMIT 10;
- QUERY PLAN
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/boolean.out C:/cirrus/build/testrun/recovery/027_stream...
--- C:/cirrus/src/test/regress/expected/boolean.out 2025-03-31 15:02:26.324743200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/boolean.out 2025-03-31 15:06:32.851870400 +0000
@@ -241,357 +241,7 @@
SELECT ''::text::boolean AS invalid; -- error
ERROR: invalid input syntax for type boolean: ""
CREATE TABLE BOOLTBL1 (f1 bool);
-INSERT INTO BOOLTBL1 (f1) VALUES (bool 't');
-INSERT INTO BOOLTBL1 (f1) VALUES (bool 'True');
-INSERT INTO BOOLTBL1 (f1) VALUES (bool 'true');
--- BOOLTBL1 should be full of true's at this point
-SELECT BOOLTBL1.* FROM BOOLTBL1;
- f1
-----
- t
- t
- t
-(3 rows)
-
-SELECT BOOLTBL1.*
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/varchar_1.out C:/cirrus/build/testrun/regress/regress/r...
--- C:/cirrus/src/test/regress/expected/varchar_1.out 2025-03-31 15:02:26.539931300 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/varchar.out 2025-03-31 15:04:26.468136900 +0000
@@ -94,39 +94,7 @@
(3 rows)
DROP TABLE VARCHAR_TBL;
---
--- Now test longer arrays of char
---
--- This varchar_tbl was already created and filled in test_setup.sql.
--- Here we just try to insert bad values.
---
-INSERT INTO VARCHAR_TBL (f1) VALUES ('abcde');
-ERROR: value too long for type character varying(4)
-SELECT * FROM VARCHAR_TBL;
- f1
-------
- a
- ab
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/tcn/expected/tcn.out C:/cirrus/build/testrun/tcn/isolation/results/tcn.ou...
--- C:/cirrus/contrib/tcn/expected/tcn.out 2025-03-31 15:02:22.183059900 +0000
+++ C:/cirrus/build/testrun/tcn/isolation/results/tcn.out 2025-03-31 15:08:23.814734900 +0000
@@ -1,13 +1,6 @@
Parsed test spec with 1 sessions
starting permutation: listen insert insert2 update delete
-step listen: LISTEN mychannel;
-step insert: INSERT INTO mytable VALUES(1, 'one');
-s1: NOTIFY "mychannel" with payload ""mytable",I,"key"='1'" from s1
-step insert2: INSERT INTO mytable VALUES(2, 'two');
-s1: NOTIFY "mychannel" with payload ""mytable",I,"key"='2'" from s1
-step update: UPDATE mytable SET value = 'foo' WHERE key = 2;
-s1: NOTIFY "mychannel" with payload ""mytable",U,"key"='2'" from s1
-step delete: DELETE FROM mytable;
-s1: NOTIFY "mychannel" with payload ""mytable",D,"key"='1'" from s1
-s1: NOTIFY "mychannel" with payload ""mytable",D,"key"='2'" from s1
+setup failed: server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request. |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/test_decoding/expected/mxact.out C:/cirrus/build/testrun/test_decoding/is...
--- C:/cirrus/contrib/test_decoding/expected/mxact.out 2025-03-31 15:02:22.196089000 +0000
+++ C:/cirrus/build/testrun/test_decoding/isolation/results/mxact.out 2025-03-31 15:08:24.114640400 +0000
@@ -1,90 +1,6 @@
Parsed test spec with 3 sessions
starting permutation: s0init s0start s1begin s1sharepgclass s2begin s2sharepgclass s0w s0start s2commit s1commit
-step s0init: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding');
-?column?
---------
-init
-(1 row)
-
-step s0start: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false');
-data
-----
-(0 rows)
-
-step s1begin: BEGIN;
-step s1sharepgclass: SELECT count(*) > 1 FROM (SELECT * FROM pg_class FOR SHARE) s;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/test_extensions/expected/test_extensions.out C:/cirrus/build/tes...
--- C:/cirrus/src/test/modules/test_extensions/expected/test_extensions.out 2025-03-31 15:02:26.093958400 +0000
+++ C:/cirrus/build/testrun/test_extensions/regress/results/test_extensions.out 2025-03-31 15:08:50.836255100 +0000
@@ -144,527 +144,10 @@
') > 0 loop c := c + 1; perform pg_stat_clear_snapshot(); end loop;
raise log ''test_extensions looped % times'', c;
end';
--- extension should now contain no temp objects
-\dx+ test_ext8
-Objects in extension "test_ext8"
- Object description
-----------------------------
- function ext8_even(posint)
- table ext8_table1
- type ext8_table1
- type ext8_table1[]
- type posint
- type posint[]
-(6 rows)
-
... |
| 52/5447 |
log_min_messages per backend type |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out 2025-03-31 13:01:51.580056000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/foreign_key.out 2025-03-31 13:05:16.781059...
@@ -1655,1504 +1655,10 @@
DETAIL: Key (a, b)=(2500, 2502) is still referenced from table "fk_partitioned_fk".
-- check psql behavior
\d fk_notpartitioned_pk
- Table "public.fk_notpartitioned_pk"
- Column | Type | Collation | Nullable | Default
---------+---------+-----------+----------+---------
- a | integer | | not null |
- b | integer | | not null |
-Indexes:
- "fk_notpartitioned_pk_pkey" PRIMARY KEY, btree (a, b)
-Referenced by:
- TABLE "fk_partitioned_fk" CONSTRAINT "fk_partitioned_fk_a_b_fkey" FOREIGN KEY (a, b) REFERENCES fk_notpartitioned_p...
-
-ALTER TABLE fk_partitioned_fk DROP CONSTRAINT fk_partitioned_fk_a_b_fkey;
--- done.
-DROP TABLE fk_notpartitioned_pk, fk_partitioned_fk;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out 2025-03-31 13:01:51.580056000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/foreign_key.out 2025-03-31 13:06:24.5534...
@@ -463,2696 +463,10 @@
DETAIL: Key (ftest1, ftest2, ftest3)=(1, 2, 7) is not present in table "pktable".
-- Show FKTABLE
SELECT * from FKTABLE;
- ftest1 | ftest2 | ftest3 | ftest4
---------+--------+--------+--------
- 1 | 2 | 3 | 1
- | 2 | 3 | 2
- 2 | | 3 | 3
- | 2 | 7 | 4
- | 3 | 4 | 5
-(5 rows)
-
--- Try to update something that will cascade
-UPDATE PKTABLE set ptest2=5 where ptest2=2;
--- Try to update something that should not cascade
-UPDATE PKTABLE set ptest1=1 WHERE ptest2=3;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out 2025-03-31 13:01:51.580056000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/foreign_key.out 2025-03-31 13:05:17.957558000 +0000
@@ -1862,1297 +1862,10 @@
INSERT INTO fk_notpartitioned_pk VALUES (2501, 142857);
UPDATE fk_notpartitioned_pk SET a = 1500 WHERE a = 2502;
SELECT * FROM fk_partitioned_fk WHERE b = 142857;
- a | b
-------+--------
- 2501 | 142857
-(1 row)
-
--- ON DELETE SET NULL column_list
-ALTER TABLE fk_partitioned_fk DROP CONSTRAINT fk_partitioned_fk_a_b_fkey;
-ALTER TABLE fk_partitioned_fk ADD FOREIGN KEY (a, b)
- REFERENCES fk_notpartitioned_pk
- ON DELETE SET NULL (a);
-BEGIN;
-DELETE FROM fk_notpartitioned_pk WHERE b = 142857;
-SELECT * FROM fk_partitioned_fk WHERE a IS NOT NULL OR b IS NOT NULL ORDER BY a NULLS LAST;
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_chec...
--- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out 2025-03-31 13:01:52.712197600 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/foreign_key.out 2025-03-31 13:09:14.065617248 +0000
@@ -1932,1227 +1932,10 @@
-- partitions.
CREATE TABLE fk_partitioned_fk_2 PARTITION OF fk_partitioned_fk FOR VALUES IN (1500,1502);
ALTER TABLE fk_partitioned_fk DETACH PARTITION fk_partitioned_fk_2;
-BEGIN;
-DROP TABLE fk_partitioned_fk;
--- constraint should still be there
-\d fk_partitioned_fk_2;
- Table "public.fk_partitioned_fk_2"
- Column | Type | Collation | Nullable | Default
---------+---------+-----------+----------+---------
- a | integer | | | 2501
- b | integer | | | 142857
-Foreign-key constraints:
- "fk_partitioned_fk_a_b_fkey" FOREIGN KEY (a, b) REFERENCES fk_notpartitioned_pk(a, b) ON UPDATE CASCADE ON DELETE C...
-
-ROLLBACK;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check...
--- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out 2025-03-31 13:01:52.712197600 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/foreign_key.out 2025-03-31 13:10:37.897105657 +0000
@@ -794,2365 +794,10 @@
(2 rows)
DROP TABLE FKTABLE;
-DROP TABLE PKTABLE;
--- Test some invalid FK definitions
-CREATE TABLE PKTABLE (ptest1 int PRIMARY KEY, someoid oid);
-CREATE TABLE FKTABLE_FAIL1 ( ftest1 int, CONSTRAINT fkfail1 FOREIGN KEY (ftest2) REFERENCES PKTABLE);
-ERROR: column "ftest2" referenced in foreign key constraint does not exist
-CREATE TABLE FKTABLE_FAIL2 ( ftest1 int, CONSTRAINT fkfail1 FOREIGN KEY (ftest1) REFERENCES PKTABLE(ptest2));
-ERROR: column "ptest2" referenced in foreign key constraint does not exist
-CREATE TABLE FKTABLE_FAIL3 ( ftest1 int, CONSTRAINT fkfail1 FOREIGN KEY (tableoid) REFERENCES PKTABLE(someoid));
-ERROR: system columns cannot be used in foreign keys
-CREATE TABLE FKTABLE_FAIL4 ( ftest1 oid, CONSTRAINT fkfail1 FOREIGN KEY (ftest1) REFERENCES PKTABLE(tableoid));
-ERROR: system columns cannot be used in foreign keys
-DROP TABLE PKTABLE;
--- Test for referencing column number smaller than referenced constraint
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/src/test/regress/results/fo...
--- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out 2025-03-31 13:01:52.712197600 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/foreign_key.out 2025-03-31 13:07:00.464249992 +0000
@@ -2461,698 +2461,10 @@
CREATE TABLE ffk1 PARTITION OF ffk FOR VALUES IN (1);
ALTER TABLE ffk1 ADD FOREIGN KEY (a) REFERENCES pk;
ALTER TABLE ffk DETACH PARTITION ffk1;
-DROP TABLE ffk, ffk1;
-CREATE SCHEMA fkpart4;
-SET search_path TO fkpart4;
--- dropping/detaching PARTITIONs is prevented if that would break
--- a foreign key's existing data
-CREATE TABLE droppk (a int PRIMARY KEY) PARTITION BY RANGE (a);
-CREATE TABLE droppk1 PARTITION OF droppk FOR VALUES FROM (0) TO (1000);
-CREATE TABLE droppk_d PARTITION OF droppk DEFAULT;
-CREATE TABLE droppk2 PARTITION OF droppk FOR VALUES FROM (1000) TO (2000)
- PARTITION BY RANGE (a);
-CREATE TABLE droppk21 PARTITION OF droppk2 FOR VALUES FROM (1000) TO (1400);
-CREATE TABLE droppk2_d PARTITION OF droppk2 DEFAULT;
-INSERT into droppk VALUES (1), (1000), (1500), (2000);
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out 2025-03-31 13:01:52.049227998 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/foreign_key.out 2025-03-31 13:07:18.306039...
@@ -1894,1265 +1894,10 @@
INSERT INTO fk_partitioned_fk VALUES (500, 100000);
DELETE FROM fk_notpartitioned_pk WHERE a = 500;
SELECT * FROM fk_partitioned_fk ORDER BY a;
- a | b
-------+--------
- 2501 | 100000
-(1 row)
-
-ROLLBACK;
--- ON UPDATE/DELETE CASCADE
-ALTER TABLE fk_partitioned_fk DROP CONSTRAINT fk_partitioned_fk_a_b_fkey;
-ALTER TABLE fk_partitioned_fk ADD FOREIGN KEY (a, b)
- REFERENCES fk_notpartitioned_pk
- ON DELETE CASCADE ON UPDATE CASCADE;
-UPDATE fk_notpartitioned_pk SET a = 2502 WHERE a = 2501;
-SELECT * FROM fk_partitioned_fk WHERE b = 142857;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out 2025-03-31 13:01:52.049227998 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/foreign_key.out 2025-03-31 13:08:24.0303...
@@ -933,2226 +933,10 @@
-- let's make a valid row for that
insert into pktable(base1) values (3);
insert into fktable(ftest1) values (3);
--- let's try removing a row that should fail from pktable
-delete from pktable where base1>2;
-ERROR: update or delete on table "pktable" violates foreign key constraint "fktable_ftest1_fkey" on table "fktable"
-DETAIL: Key (base1)=(3) is still referenced from table "fktable".
--- okay, let's try updating all of the base1 values to *4
--- which should fail.
-update pktable set base1=base1*4;
-ERROR: update or delete on table "pktable" violates foreign key constraint "fktable_ftest1_fkey" on table "fktable"
-DETAIL: Key (base1)=(3) is still referenced from table "fktable".
--- okay, let's try an update that should work.
-update pktable set base1=base1*4 where base1<3;
--- and a delete that should work
-delete from pktable where base1>3;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out 2025-03-31 13:01:52.049227998 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/foreign_key.out 2025-03-31 13:07:12.810021589 +0000
@@ -2272,887 +2272,10 @@
create table fkpart0.fk_part_56_5 partition of fkpart0.fk_part_56
for values in (5);
\d fkpart0.fk_part_56
- Partitioned table "fkpart0.fk_part_56"
- Column | Type | Collation | Nullable | Default
---------+---------+-----------+----------+---------
- a | integer | | |
-Partition of: fkpart0.fk_part FOR VALUES IN (5, 6)
-Partition key: LIST (a)
-Foreign-key constraints:
- TABLE "fkpart0.fk_part" CONSTRAINT "fk_part_a_fkey" FOREIGN KEY (a) REFERENCES fkpart0.pkey(a)
-Number of partitions: 1 (Use \d+ to list them.)
-
-alter table fkpart0.fk_part_56 drop constraint fk_part_a_fkey;
-ERROR: cannot drop inherited constraint "fk_part_a_fkey" of relation "fk_part_56"
-alter table fkpart0.fk_part_56_5 drop constraint fk_part_a_fkey;
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/cluster.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upg...
--- /Users/admin/pgsql/src/test/regress/expected/cluster.out 2025-03-31 13:01:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/cluster.out 2025-03-31 13:04:22
@@ -355,321 +355,7 @@
SET SESSION AUTHORIZATION regress_clstr_user;
SET client_min_messages = ERROR; -- order of "skipping" warnings may vary
CLUSTER;
-RESET client_min_messages;
-SELECT * FROM clstr_1 UNION ALL
- SELECT * FROM clstr_2 UNION ALL
- SELECT * FROM clstr_3;
- a
----
- 1
- 2
- 2
- 1
- 2
- 1
-(6 rows)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/guc.out /Users/admin/pgsql/build/testrun/recovery/027_stream_regre...
--- /Users/admin/pgsql/src/test/regress/expected/guc.out 2025-03-31 13:01:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/guc.out 2025-03-31 13:05:29
@@ -929,35 +929,7 @@
(1 row)
SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1'; --fail
-ERROR: invalid value for parameter "log_min_messages": "checkpointer:debug2, autovacuum:debug1"
-DETAIL: Generic log level was not defined.
-SET log_min_messages TO 'debug1, backend:error, fatal'; -- fail
-ERROR: invalid value for parameter "log_min_messages": "debug1, backend:error, fatal"
-DETAIL: Generic log level was already assigned.
-SET log_min_messages TO 'backend:error, foo:fatal, archiver:debug1'; -- fail
-ERROR: invalid value for parameter "log_min_messages": "backend:error, foo:fatal, archiver:debug1"
-DETAIL: Unrecognized backend type: "foo".
-SET log_min_messages TO 'backend:error, checkpointer:bar, archiver:debug1'; -- fail
-ERROR: invalid value for parameter "log_min_messages": "backend:error, checkpointer:bar, archiver:debug1"
-DETAIL: Unrecognized log level: "bar".
-SET log_min_messages TO 'backend:error, checkpointer:debug3, fatal, archiver:debug2, autovacuum:debug1, walsender:debug...
-SHOW log_min_messages;
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/foreign_key.out /Users/admin/pgsql/build/testrun/regress/regress/r...
--- /Users/admin/pgsql/src/test/regress/expected/foreign_key.out 2025-03-31 13:01:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/foreign_key.out 2025-03-31 13:04:22
@@ -151,3008 +151,10 @@
UPDATE FKTABLE SET ftest1 = 1 WHERE ftest1 = 1;
-- Try altering the column type where foreign keys are involved
ALTER TABLE PKTABLE ALTER COLUMN ptest1 TYPE bigint;
-ALTER TABLE FKTABLE ALTER COLUMN ftest1 TYPE bigint;
-SELECT * FROM PKTABLE;
- ptest1 | ptest2 | ptest3
---------+--------+---------
- 1 | 3 | Test1-2
- 3 | 6 | Test3
- 4 | 8 | Test4
- 1 | 4 | Test2
-(4 rows)
-
-SELECT * FROM FKTABLE;
- ftest1 | ftest2 | ftest3
---------+--------+--------
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| 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 2025-03-31 13:01:56.837852200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/foreign_key.out 2025-03-31 13:05:27.212517600 +0000
@@ -3154,5 +3154,7 @@
ERROR: cannot drop inherited constraint "fk_r_p_id_p_jd_fkey" of relation "fk_r_2"
SET client_min_messages TO warning;
DROP SCHEMA fkpart12 CASCADE;
-RESET client_min_messages;
-RESET search_path;
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/guc.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgra...
--- C:/cirrus/src/test/regress/expected/guc.out 2025-03-31 13:01:56.837852200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/guc.out 2025-03-31 13:05:27.132945100 +0000
@@ -929,35 +929,7 @@
(1 row)
SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1'; --fail
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/foreign_key.out C:/cirrus/build/testrun/recovery/027_st...
--- C:/cirrus/src/test/regress/expected/foreign_key.out 2025-03-31 13:01:56.837852200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/foreign_key.out 2025-03-31 13:07:56.159795800 +0000
@@ -2981,178 +2981,7 @@
ALTER TABLE fkpart11.fk DROP CONSTRAINT fkey;
DELETE FROM fkpart11.fk WHERE a = 4;
ALTER TABLE fkpart11.fk ADD CONSTRAINT fkey FOREIGN KEY (a) REFERENCES fkpart11.pk1 (a) ON UPDATE CASCADE ON DELETE CAS...
-UPDATE fkpart11.pk SET a = a - 1;
-ERROR: cannot move tuple across partitions when a non-root ancestor of the source partition is directly referenced in ...
-DETAIL: A foreign key points to ancestor "pk1" but not the root ancestor "pk".
-HINT: Consider defining the foreign key on table "pk".
--- it's okay though if the non-leaf partition is updated directly
-UPDATE fkpart11.pk1 SET a = a - 1;
-SELECT tableoid::pg_catalog.regclass, * FROM fkpart11.pk;
- tableoid | a | b
----------------+---+-----
- fkpart11.pk11 | 1 | xxx
- fkpart11.pk3 | 4 | yyy
-(2 rows)
-
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/guc.out C:/cirrus/build/testrun/regress/regress/results...
--- C:/cirrus/src/test/regress/expected/guc.out 2025-03-31 13:01:56.837852200 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/guc.out 2025-03-31 13:05:21.675420100 +0000
@@ -929,35 +929,7 @@
(1 row)
SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1'; --fail
-ERROR: invalid value for parameter "log_min_messages": "checkpointer:debug2, autovacuum:debug1"
-DETAIL: Generic log level was not defined.
-SET log_min_messages TO 'debug1, backend:error, fatal'; -- fail
-ERROR: invalid value for parameter "log_min_messages": "debug1, backend:error, fatal"
-DETAIL: Generic log level was already assigned.
-SET log_min_messages TO 'backend:error, foo:fatal, archiver:debug1'; -- fail
-ERROR: invalid value for parameter "log_min_messages": "backend:error, foo:fatal, archiver:debug1"
-DETAIL: Unrecognized backend type: "foo".
-SET log_min_messages TO 'backend:error, checkpointer:bar, archiver:debug1'; -- fail
-ERROR: invalid value for parameter "log_min_messages": "backend:error, checkpointer:bar, archiver:debug1"
-DETAIL: Unrecognized log level: "bar".
-SET log_min_messages TO 'backend:error, checkpointer:debug3, fatal, archiver:debug2, autovacuum:debug1, walsender:debug...
-SHOW log_min_messages;
... |
| 52/5081 |
nbtree skip scan |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-03-31 08:06:07.072030000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_index.out 2025-03-31 08:08:18.29778...
@@ -1681,1889 +1681,10 @@
(1 row)
SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;
- unique1 | unique2
----------+---------
- 500 |
-(1 row)
-
-DROP INDEX onek_nulltest;
-CREATE UNIQUE INDEX onek_nulltest ON onek_with_null (unique2 desc,unique1);
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL;
- count
--------
- 3
-(1 row)
-
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/recovery/027...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-03-31 08:06:07.072030000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/create_index.out 2025-03-31 08:09:02.921...
@@ -1681,1889 +1681,10 @@
(1 row)
SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;
- unique1 | unique2
----------+---------
- 500 |
-(1 row)
-
-DROP INDEX onek_nulltest;
-CREATE UNIQUE INDEX onek_nulltest ON onek_with_null (unique2 desc,unique1);
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL;
- count
--------
- 3
-(1 row)
-
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/regress/regr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-03-31 08:06:07.072030000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/create_index.out 2025-03-31 08:08:13.636727000 +0000
@@ -1681,1889 +1681,10 @@
(1 row)
SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;
- unique1 | unique2
----------+---------
- 500 |
-(1 row)
-
-DROP INDEX onek_nulltest;
-CREATE UNIQUE INDEX onek_nulltest ON onek_with_null (unique2 desc,unique1);
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL;
- count
--------
- 3
-(1 row)
-
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_che...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-03-31 08:06:06.106684538 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/create_index.out 2025-03-31 08:12:14.249662190 +0000
@@ -1681,1889 +1681,7 @@
(1 row)
SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;
- unique1 | unique2
----------+---------
- 500 |
-(1 row)
-
-DROP INDEX onek_nulltest;
-CREATE UNIQUE INDEX onek_nulltest ON onek_with_null (unique2 desc,unique1);
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL;
- count
--------
- 3
-(1 row)
-
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/src/test/regress/results/c...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-03-31 08:06:06.106684538 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/create_index.out 2025-03-31 08:10:23.405811108 +0000
@@ -1681,1889 +1681,7 @@
(1 row)
SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;
- unique1 | unique2
----------+---------
- 500 |
-(1 row)
-
-DROP INDEX onek_nulltest;
-CREATE UNIQUE INDEX onek_nulltest ON onek_with_null (unique2 desc,unique1);
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL;
- count
--------
- 3
-(1 row)
-
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-03-31 08:06:06.842979226 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_index.out 2025-03-31 08:10:51.69429...
@@ -1681,1889 +1681,7 @@
(1 row)
SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;
- unique1 | unique2
----------+---------
- 500 |
-(1 row)
-
-DROP INDEX onek_nulltest;
-CREATE UNIQUE INDEX onek_nulltest ON onek_with_null (unique2 desc,unique1);
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL;
- count
--------
- 3
-(1 row)
-
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/recovery/027...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-03-31 08:06:06.842979226 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/create_index.out 2025-03-31 08:11:46.650...
@@ -1681,1889 +1681,7 @@
(1 row)
SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;
- unique1 | unique2
----------+---------
- 500 |
-(1 row)
-
-DROP INDEX onek_nulltest;
-CREATE UNIQUE INDEX onek_nulltest ON onek_with_null (unique2 desc,unique1);
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL;
- count
--------
- 3
-(1 row)
-
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/regress/regr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-03-31 08:06:06.842979226 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/create_index.out 2025-03-31 08:10:50.766295460 +0000
@@ -1681,1889 +1681,7 @@
(1 row)
SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;
- unique1 | unique2
----------+---------
- 500 |
-(1 row)
-
-DROP INDEX onek_nulltest;
-CREATE UNIQUE INDEX onek_nulltest ON onek_with_null (unique2 desc,unique1);
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL;
- count
--------
- 3
-(1 row)
-
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/create_index.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_p...
--- /Users/admin/pgsql/src/test/regress/expected/create_index.out 2025-03-31 08:05:11
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_index.out 2025-03-31 08:07:49
@@ -1644,144 +1644,6 @@
SET enable_seqscan = OFF;
SET enable_indexscan = ON;
SET enable_bitmapscan = ON;
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL;
- count
--------
- 3
-(1 row)
-
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL AND unique2 IS NULL;
- count
--------
- 1
-(1 row)
-
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NOT NULL;
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/create_index.out /Users/admin/pgsql/build/testrun/recovery/027_str...
--- /Users/admin/pgsql/src/test/regress/expected/create_index.out 2025-03-31 08:05:11
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/create_index.out 2025-03-31 08:08:49
@@ -1644,144 +1644,6 @@
SET enable_seqscan = OFF;
SET enable_indexscan = ON;
SET enable_bitmapscan = ON;
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL;
- count
--------
- 3
-(1 row)
-
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL AND unique2 IS NULL;
- count
--------
- 1
-(1 row)
-
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NOT NULL;
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/create_index.out /Users/admin/pgsql/build/testrun/regress/regress/...
--- /Users/admin/pgsql/src/test/regress/expected/create_index.out 2025-03-31 08:05:11
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/create_index.out 2025-03-31 08:07:49
@@ -1644,144 +1644,6 @@
SET enable_seqscan = OFF;
SET enable_indexscan = ON;
SET enable_bitmapscan = ON;
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL;
- count
--------
- 3
-(1 row)
-
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL AND unique2 IS NULL;
- count
--------
- 1
-(1 row)
-
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NOT NULL;
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_index.out C:/cirrus/build/testrun/pg_upgrade/002...
--- C:/cirrus/src/test/regress/expected/create_index.out 2025-03-31 08:06:12.238553600 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_index.out 2025-03-31 08:08:35.539321200 +0000
@@ -1681,1889 +1681,7 @@
(1 row)
SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;
- unique1 | unique2
----------+---------
- 500 |
-(1 row)
-
-DROP INDEX onek_nulltest;
-CREATE UNIQUE INDEX onek_nulltest ON onek_with_null (unique2 desc,unique1);
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL;
- count
--------
- 3
-(1 row)
-
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_index.out C:/cirrus/build/testrun/recovery/027_s...
--- C:/cirrus/src/test/regress/expected/create_index.out 2025-03-31 08:06:12.238553600 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/create_index.out 2025-03-31 08:10:43.324055300 +000...
@@ -1681,1889 +1681,7 @@
(1 row)
SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;
- unique1 | unique2
----------+---------
- 500 |
-(1 row)
-
-DROP INDEX onek_nulltest;
-CREATE UNIQUE INDEX onek_nulltest ON onek_with_null (unique2 desc,unique1);
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL;
- count
--------
- 3
-(1 row)
-
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_index.out C:/cirrus/build/testrun/regress/regres...
--- C:/cirrus/src/test/regress/expected/create_index.out 2025-03-31 08:06:12.238553600 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/create_index.out 2025-03-31 08:08:32.108653000 +0000
@@ -1681,1889 +1681,7 @@
(1 row)
SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;
- unique1 | unique2
----------+---------
- 500 |
-(1 row)
-
-DROP INDEX onek_nulltest;
-CREATE UNIQUE INDEX onek_nulltest ON onek_with_null (unique2 desc,unique1);
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL;
- count
--------
- 3
-(1 row)
-
... |
| 52/4971 |
[CREATE|RE] INDEX CONCURRENTLY with single heap scan and short-term resetting shapshots |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tablespace.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tablespace.out 2025-03-31 05:00:01.081666000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/tablespace.out 2025-03-31 05:05:21.3214020...
@@ -128,846 +128,7 @@
(0 rows)
REINDEX (TABLESPACE regress_tblspace, CONCURRENTLY) TABLE regress_tblspace_test_tbl;
-SELECT c.relname FROM pg_class c, pg_tablespace s
- WHERE c.reltablespace = s.oid AND s.spcname = 'regress_tblspace'
- ORDER BY c.relname;
- relname
--------------------------------
- regress_tblspace_test_tbl_idx
-(1 row)
-
-SELECT relfilenode = :main_filenode AS main_same FROM pg_class
- WHERE relname = 'regress_tblspace_test_tbl_idx';
- main_same
------------
- f
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tablespace.out /tmp/cirrus-ci-build/build/testrun/recovery/027_s...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tablespace.out 2025-03-31 05:00:01.081666000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/tablespace.out 2025-03-31 05:07:00.23175...
@@ -128,846 +128,7 @@
(0 rows)
REINDEX (TABLESPACE regress_tblspace, CONCURRENTLY) TABLE regress_tblspace_test_tbl;
-SELECT c.relname FROM pg_class c, pg_tablespace s
- WHERE c.reltablespace = s.oid AND s.spcname = 'regress_tblspace'
- ORDER BY c.relname;
- relname
--------------------------------
- regress_tblspace_test_tbl_idx
-(1 row)
-
-SELECT relfilenode = :main_filenode AS main_same FROM pg_class
- WHERE relname = 'regress_tblspace_test_tbl_idx';
- main_same
------------
- f
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tablespace.out /tmp/cirrus-ci-build/build/testrun/regress/regres...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tablespace.out 2025-03-31 05:00:01.081666000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/tablespace.out 2025-03-31 05:05:25.600185000 +0000
@@ -128,846 +128,7 @@
(0 rows)
REINDEX (TABLESPACE regress_tblspace, CONCURRENTLY) TABLE regress_tblspace_test_tbl;
-SELECT c.relname FROM pg_class c, pg_tablespace s
- WHERE c.reltablespace = s.oid AND s.spcname = 'regress_tblspace'
- ORDER BY c.relname;
- relname
--------------------------------
- regress_tblspace_test_tbl_idx
-(1 row)
-
-SELECT relfilenode = :main_filenode AS main_same FROM pg_class
- WHERE relname = 'regress_tblspace_test_tbl_idx';
- main_same
------------
- f
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tablespace.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tablespace.out 2025-03-31 04:59:59.698256200 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/tablespace.out 2025-03-31 05:10:36.954066358 +0000
@@ -128,846 +128,7 @@
(0 rows)
REINDEX (TABLESPACE regress_tblspace, CONCURRENTLY) TABLE regress_tblspace_test_tbl;
-SELECT c.relname FROM pg_class c, pg_tablespace s
- WHERE c.reltablespace = s.oid AND s.spcname = 'regress_tblspace'
- ORDER BY c.relname;
- relname
--------------------------------
- regress_tblspace_test_tbl_idx
-(1 row)
-
-SELECT relfilenode = :main_filenode AS main_same FROM pg_class
- WHERE relname = 'regress_tblspace_test_tbl_idx';
- main_same
------------
- f
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tablespace.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tablespace.out 2025-03-31 04:59:59.698256200 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/tablespace.out 2025-03-31 05:11:50.002443246 +0000
@@ -128,846 +128,7 @@
(0 rows)
REINDEX (TABLESPACE regress_tblspace, CONCURRENTLY) TABLE regress_tblspace_test_tbl;
-SELECT c.relname FROM pg_class c, pg_tablespace s
- WHERE c.reltablespace = s.oid AND s.spcname = 'regress_tblspace'
- ORDER BY c.relname;
- relname
--------------------------------
- regress_tblspace_test_tbl_idx
-(1 row)
-
-SELECT relfilenode = :main_filenode AS main_same FROM pg_class
- WHERE relname = 'regress_tblspace_test_tbl_idx';
- main_same
------------
- f
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tablespace.out /tmp/cirrus-ci-build/src/test/regress/results/tab...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tablespace.out 2025-03-31 04:59:59.698256200 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/tablespace.out 2025-03-31 05:07:27.567317610 +0000
@@ -128,846 +128,7 @@
(0 rows)
REINDEX (TABLESPACE regress_tblspace, CONCURRENTLY) TABLE regress_tblspace_test_tbl;
-SELECT c.relname FROM pg_class c, pg_tablespace s
- WHERE c.reltablespace = s.oid AND s.spcname = 'regress_tblspace'
- ORDER BY c.relname;
- relname
--------------------------------
- regress_tblspace_test_tbl_idx
-(1 row)
-
-SELECT relfilenode = :main_filenode AS main_same FROM pg_class
- WHERE relname = 'regress_tblspace_test_tbl_idx';
- main_same
------------
- f
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tablespace.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tablespace.out 2025-03-31 04:59:58.087691585 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/tablespace.out 2025-03-31 05:05:56.4248528...
@@ -128,846 +128,7 @@
(0 rows)
REINDEX (TABLESPACE regress_tblspace, CONCURRENTLY) TABLE regress_tblspace_test_tbl;
-SELECT c.relname FROM pg_class c, pg_tablespace s
- WHERE c.reltablespace = s.oid AND s.spcname = 'regress_tblspace'
- ORDER BY c.relname;
- relname
--------------------------------
- regress_tblspace_test_tbl_idx
-(1 row)
-
-SELECT relfilenode = :main_filenode AS main_same FROM pg_class
- WHERE relname = 'regress_tblspace_test_tbl_idx';
- main_same
------------
- f
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tablespace.out /tmp/cirrus-ci-build/build/testrun/recovery/027_s...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tablespace.out 2025-03-31 04:59:58.087691585 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/tablespace.out 2025-03-31 05:07:10.30370...
@@ -128,846 +128,7 @@
(0 rows)
REINDEX (TABLESPACE regress_tblspace, CONCURRENTLY) TABLE regress_tblspace_test_tbl;
-SELECT c.relname FROM pg_class c, pg_tablespace s
- WHERE c.reltablespace = s.oid AND s.spcname = 'regress_tblspace'
- ORDER BY c.relname;
- relname
--------------------------------
- regress_tblspace_test_tbl_idx
-(1 row)
-
-SELECT relfilenode = :main_filenode AS main_same FROM pg_class
- WHERE relname = 'regress_tblspace_test_tbl_idx';
- main_same
------------
- f
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tablespace.out /tmp/cirrus-ci-build/build/testrun/regress/regres...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tablespace.out 2025-03-31 04:59:58.087691585 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/tablespace.out 2025-03-31 05:05:54.848799310 +0000
@@ -128,846 +128,7 @@
(0 rows)
REINDEX (TABLESPACE regress_tblspace, CONCURRENTLY) TABLE regress_tblspace_test_tbl;
-SELECT c.relname FROM pg_class c, pg_tablespace s
- WHERE c.reltablespace = s.oid AND s.spcname = 'regress_tblspace'
- ORDER BY c.relname;
- relname
--------------------------------
- regress_tblspace_test_tbl_idx
-(1 row)
-
-SELECT relfilenode = :main_filenode AS main_same FROM pg_class
- WHERE relname = 'regress_tblspace_test_tbl_idx';
- main_same
------------
- f
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/tablespace.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_...
--- /Users/admin/pgsql/src/test/regress/expected/tablespace.out 2025-03-31 04:59:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/tablespace.out 2025-03-31 05:02:47
@@ -128,846 +128,7 @@
(0 rows)
REINDEX (TABLESPACE regress_tblspace, CONCURRENTLY) TABLE regress_tblspace_test_tbl;
-SELECT c.relname FROM pg_class c, pg_tablespace s
- WHERE c.reltablespace = s.oid AND s.spcname = 'regress_tblspace'
- ORDER BY c.relname;
- relname
--------------------------------
- regress_tblspace_test_tbl_idx
-(1 row)
-
-SELECT relfilenode = :main_filenode AS main_same FROM pg_class
- WHERE relname = 'regress_tblspace_test_tbl_idx';
- main_same
------------
- f
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/tablespace.out /Users/admin/pgsql/build/testrun/recovery/027_strea...
--- /Users/admin/pgsql/src/test/regress/expected/tablespace.out 2025-03-31 04:59:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/tablespace.out 2025-03-31 05:03:42
@@ -128,846 +128,7 @@
(0 rows)
REINDEX (TABLESPACE regress_tblspace, CONCURRENTLY) TABLE regress_tblspace_test_tbl;
-SELECT c.relname FROM pg_class c, pg_tablespace s
- WHERE c.reltablespace = s.oid AND s.spcname = 'regress_tblspace'
- ORDER BY c.relname;
- relname
--------------------------------
- regress_tblspace_test_tbl_idx
-(1 row)
-
-SELECT relfilenode = :main_filenode AS main_same FROM pg_class
- WHERE relname = 'regress_tblspace_test_tbl_idx';
- main_same
------------
- f
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/tablespace.out /Users/admin/pgsql/build/testrun/regress/regress/re...
--- /Users/admin/pgsql/src/test/regress/expected/tablespace.out 2025-03-31 04:59:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/tablespace.out 2025-03-31 05:02:47
@@ -128,846 +128,7 @@
(0 rows)
REINDEX (TABLESPACE regress_tblspace, CONCURRENTLY) TABLE regress_tblspace_test_tbl;
-SELECT c.relname FROM pg_class c, pg_tablespace s
- WHERE c.reltablespace = s.oid AND s.spcname = 'regress_tblspace'
- ORDER BY c.relname;
- relname
--------------------------------
- regress_tblspace_test_tbl_idx
-(1 row)
-
-SELECT relfilenode = :main_filenode AS main_same FROM pg_class
- WHERE relname = 'regress_tblspace_test_tbl_idx';
- main_same
------------
- f
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/tablespace.out C:/cirrus/build/testrun/pg_upgrade/002_p...
--- C:/cirrus/src/test/regress/expected/tablespace.out 2025-03-31 05:00:05.796979300 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/tablespace.out 2025-03-31 05:04:11.415315000 +0000
@@ -128,846 +128,7 @@
(0 rows)
REINDEX (TABLESPACE regress_tblspace, CONCURRENTLY) TABLE regress_tblspace_test_tbl;
-SELECT c.relname FROM pg_class c, pg_tablespace s
- WHERE c.reltablespace = s.oid AND s.spcname = 'regress_tblspace'
- ORDER BY c.relname;
- relname
--------------------------------
- regress_tblspace_test_tbl_idx
-(1 row)
-
-SELECT relfilenode = :main_filenode AS main_same FROM pg_class
- WHERE relname = 'regress_tblspace_test_tbl_idx';
- main_same
------------
- f
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/tablespace.out C:/cirrus/build/testrun/recovery/027_str...
--- C:/cirrus/src/test/regress/expected/tablespace.out 2025-03-31 05:00:05.796979300 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/tablespace.out 2025-03-31 05:06:49.243179600 +0000
@@ -128,846 +128,7 @@
(0 rows)
REINDEX (TABLESPACE regress_tblspace, CONCURRENTLY) TABLE regress_tblspace_test_tbl;
-SELECT c.relname FROM pg_class c, pg_tablespace s
- WHERE c.reltablespace = s.oid AND s.spcname = 'regress_tblspace'
- ORDER BY c.relname;
- relname
--------------------------------
- regress_tblspace_test_tbl_idx
-(1 row)
-
-SELECT relfilenode = :main_filenode AS main_same FROM pg_class
- WHERE relname = 'regress_tblspace_test_tbl_idx';
- main_same
------------
- f
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/tablespace.out C:/cirrus/build/testrun/regress/regress/...
--- C:/cirrus/src/test/regress/expected/tablespace.out 2025-03-31 05:00:05.796979300 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/tablespace.out 2025-03-31 05:04:10.373052600 +0000
@@ -128,846 +128,7 @@
(0 rows)
REINDEX (TABLESPACE regress_tblspace, CONCURRENTLY) TABLE regress_tblspace_test_tbl;
-SELECT c.relname FROM pg_class c, pg_tablespace s
- WHERE c.reltablespace = s.oid AND s.spcname = 'regress_tblspace'
- ORDER BY c.relname;
- relname
--------------------------------
- regress_tblspace_test_tbl_idx
-(1 row)
-
-SELECT relfilenode = :main_filenode AS main_same FROM pg_class
- WHERE relname = 'regress_tblspace_test_tbl_idx';
- main_same
------------
- f
... |
| 53/5012 |
Vacuum statistics |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_index_statistics.out /tmp/cirrus-ci-build/build-32/testru...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_index_statistics.out 2025-03-30 16:26:08.407327263 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade/002_pg_upgrade/data/results/vacuum_index_statistics.out 2025-03-30 ...
@@ -60,7 +60,7 @@
WHERE vt.relname = 'vestat_pkey' AND vt.relid = c.oid;
relname | relpages | pages_deleted | tuples_deleted
-------------+----------+---------------+----------------
- vestat_pkey | 30 | 0 | 0
+ vestat_pkey | 24 | 0 | 0
(1 row)
SELECT relpages AS irp
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_tables_and_db_statistics.out /tmp/cirrus-ci-build/build-3...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_tables_and_db_statistics.out 2025-03-30 16:26:08.407327263 +00...
+++ /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade/002_pg_upgrade/data/results/vacuum_tables_and_db_statistics.out 202...
@@ -65,7 +65,7 @@
WHERE vt.relname = 'vestat' AND vt.relid = c.oid;
relname | vm_new_frozen_pages | tuples_deleted | relpages | pages_scanned | pages_removed
---------+---------------------+----------------+----------+---------------+---------------
- vestat | 0 | 0 | 455 | 0 | 0
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_index_statistics.out /tmp/cirrus-ci-build/build-32/testru...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_index_statistics.out 2025-03-30 16:26:08.407327263 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/recovery/027_stream_regress/data/results/vacuum_index_statistics.out 2025-03-3...
@@ -60,7 +60,7 @@
WHERE vt.relname = 'vestat_pkey' AND vt.relid = c.oid;
relname | relpages | pages_deleted | tuples_deleted
-------------+----------+---------------+----------------
- vestat_pkey | 30 | 0 | 0
+ vestat_pkey | 24 | 0 | 0
(1 row)
SELECT relpages AS irp
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_tables_and_db_statistics.out /tmp/cirrus-ci-build/build-3...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_tables_and_db_statistics.out 2025-03-30 16:26:08.407327263 +00...
+++ /tmp/cirrus-ci-build/build-32/testrun/recovery/027_stream_regress/data/results/vacuum_tables_and_db_statistics.out 2...
@@ -65,7 +65,7 @@
WHERE vt.relname = 'vestat' AND vt.relid = c.oid;
relname | vm_new_frozen_pages | tuples_deleted | relpages | pages_scanned | pages_removed
---------+---------------------+----------------+----------+---------------+---------------
- vestat | 0 | 0 | 455 | 0 | 0
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_index_statistics.out /tmp/cirrus-ci-build/build-32/testru...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_index_statistics.out 2025-03-30 16:26:08.407327263 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/vacuum_index_statistics.out 2025-03-30 16:37:47.370803...
@@ -60,7 +60,7 @@
WHERE vt.relname = 'vestat_pkey' AND vt.relid = c.oid;
relname | relpages | pages_deleted | tuples_deleted
-------------+----------+---------------+----------------
- vestat_pkey | 30 | 0 | 0
+ vestat_pkey | 24 | 0 | 0
(1 row)
SELECT relpages AS irp
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_tables_and_db_statistics.out /tmp/cirrus-ci-build/build-3...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_tables_and_db_statistics.out 2025-03-30 16:26:08.407327263 +00...
+++ /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/vacuum_tables_and_db_statistics.out 2025-03-30 16:37:4...
@@ -65,7 +65,7 @@
WHERE vt.relname = 'vestat' AND vt.relid = c.oid;
relname | vm_new_frozen_pages | tuples_deleted | relpages | pages_scanned | pages_removed
---------+---------------------+----------------+----------+---------------+---------------
- vestat | 0 | 0 | 455 | 0 | 0
... |
| 52/5117 |
VACUUM FULL / CLUSTER CONCURRENTLY |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out C:/cirr...
--- C:/cirrus/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out 2025-03-30 15:32:11.708031900 +0...
+++ C:/cirrus/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-03-30 15:38:06.643749...
@@ -1,51 +1,6 @@
Parsed test spec with 2 sessions
starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check
-step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass);
-itemoffset|blknum|attnum|allnulls|hasnulls|placeholder|empty|value
-----------+------+------+--------+--------+-----------+-----+--------
- 1| 0| 1|f |t |f |f |{1 .. 1}
-(1 row)
-
-step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ;
-step s2b: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1;
-?column?
---------
- 1
-(1 row)
-
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/dblink/expected/dblink.out C:/cirrus/build/testrun/dblink/regress/results...
--- C:/cirrus/contrib/dblink/expected/dblink.out 2025-03-30 15:32:07.657432800 +0000
+++ C:/cirrus/build/testrun/dblink/regress/results/dblink.out 2025-03-30 15:37:32.244342200 +0000
@@ -799,423 +799,7 @@
UNION
(SELECT * from dblink_get_result('dtest3') as t3(f1 int, f2 text, f3 text[]))
ORDER by f1;
--- dblink_get_connections returns an array with elements in a machine-dependent
--- ordering, so we must resort to unnesting and sorting for a stable result
-create function unnest(anyarray) returns setof anyelement
-language sql strict immutable as $$
-select $1[i] from generate_series(array_lower($1,1), array_upper($1,1)) as i
-$$;
-SELECT * FROM unnest(dblink_get_connections()) ORDER BY 1;
- unnest
---------
- dtest1
- dtest2
- dtest3
-(3 rows)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/delay_execution/expected/partition-addition.out C:/cirrus/build/...
--- C:/cirrus/src/test/modules/delay_execution/expected/partition-addition.out 2025-03-30 15:32:11.719690400 +0000
+++ C:/cirrus/build/testrun/delay_execution/isolation/results/partition-addition.out 2025-03-30 15:38:08.842482200 +0000
@@ -1,27 +1,6 @@
Parsed test spec with 2 sessions
starting permutation: s2lock s1exec s2addp s2unlock
-step s2lock: SELECT pg_advisory_lock(12345);
-pg_advisory_lock
-----------------
-
-(1 row)
-
-step s1exec: LOAD 'delay_execution';
- SET delay_execution.post_planning_lock_id = 12345;
- SELECT * FROM foo WHERE a <> 1 AND a <> (SELECT 3); <waiting ...>
-step s2addp: CREATE TABLE foo2 (LIKE foo);
- ALTER TABLE foo ATTACH PARTITION foo2 FOR VALUES IN (2);
- INSERT INTO foo VALUES (2, 'ADD2');
-step s2unlock: SELECT pg_advisory_unlock(12345);
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/interfaces/ecpg/test/expected/compat_informix-sqlda.stderr C:/cirrus/build/te...
--- C:/cirrus/src/interfaces/ecpg/test/expected/compat_informix-sqlda.stderr 2025-03-30 15:32:11.124459400 +0000
+++ C:/cirrus/build/testrun/ecpg/ecpg/results/compat_informix-sqlda.stderr 2025-03-30 15:38:39.397672800 +0000
@@ -332,9 +332,9 @@
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ecpg_execute on line 241: using PQexec
[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_process_output on line 241: OK: DROP TABLE
-[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ECPGtrans on line 244: action "commit"; connection "regress1"
-[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_finish: connection regress1 closed
+[NO_PID]: ecpg_check_PQresult on line 241: bad response - server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
[NO_PID]: sqlca: code: 0, state: 00000
+[NO_PID]: raising sqlstate 57P02 (sqlcode -400): the connection to the server was lost on line 241
+[NO_PID]: sqlca: code: -400, state: 57P02
diff --strip-trailing-cr -U3 C:/cirrus/src/interfaces/ecpg/test/expected/compat_informix-describe.stdout C:/cirrus/build...
--- C:/cirrus/src/interfaces/ecpg/test/expected/compat_informix-describe.stdout 2025-03-30 15:32:11.118243400 +0000
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/injection_points/expected/basic.out C:/cirrus/build/testrun/inje...
--- C:/cirrus/src/test/modules/injection_points/expected/basic.out 2025-03-30 15:32:11.735217900 +0000
+++ C:/cirrus/build/testrun/injection_points/isolation/results/basic.out 2025-03-30 15:38:15.610796900 +0000
@@ -1,75 +1,6 @@
Parsed test spec with 2 sessions
starting permutation: wait1 wakeup2 noop1 detach2
-injection_points_attach
------------------------
-
-(1 row)
-
-step wait1: SELECT injection_points_run('injection-points-wait'); <waiting ...>
-step wakeup2: SELECT injection_points_wakeup('injection-points-wait');
-injection_points_wakeup
------------------------
-
-(1 row)
-
-step wait1: <... completed>
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/isolation/expected/read-only-anomaly.out C:/cirrus/build/testrun/isolati...
--- C:/cirrus/src/test/isolation/expected/read-only-anomaly.out 2025-03-30 15:32:11.582893600 +0000
+++ C:/cirrus/build/testrun/isolation/isolation/results/read-only-anomaly.out 2025-03-30 15:34:10.500077100 +0000
@@ -1,33 +1,6 @@
Parsed test spec with 3 sessions
starting permutation: s2rx s2ry s1ry s1wy s1c s3r s2wx s2c s3c
-step s2rx: SELECT balance FROM bank_account WHERE id = 'X';
-balance
--------
- 0
-(1 row)
-
-step s2ry: SELECT balance FROM bank_account WHERE id = 'Y';
-balance
--------
- 0
-(1 row)
-
-step s1ry: SELECT balance FROM bank_account WHERE id = 'Y';
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pageinspect/expected/brin.out C:/cirrus/build/testrun/pageinspect/regress...
--- C:/cirrus/contrib/pageinspect/expected/brin.out 2025-03-30 15:32:07.832709600 +0000
+++ C:/cirrus/build/testrun/pageinspect/regress/results/brin.out 2025-03-30 15:37:44.502151000 +0000
@@ -146,65 +146,7 @@
USING brin (a int4_minmax_ops, a int4_bloom_ops, b, c int8_minmax_multi_ops)
WITH (pages_per_range=7)
WHERE NOT (a BETWEEN 1000 and 1500);
-SELECT relname, relpages
- FROM pg_class
- WHERE relname IN ('brin_test_serial_idx', 'brin_test_parallel_idx')
- ORDER BY relname;
- relname | relpages
-------------------------+----------
- brin_test_parallel_idx | 4
- brin_test_serial_idx | 4
-(2 rows)
-
--- Check that (A except B) and (B except A) is empty, which means the indexes
--- are the same.
-SELECT * FROM brin_page_items(get_raw_page('brin_test_parallel_idx', 2), 'brin_test_parallel_idx')
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_logicalinspect/expected/logical_inspect.out C:/cirrus/build/testrun/pg...
--- C:/cirrus/contrib/pg_logicalinspect/expected/logical_inspect.out 2025-03-30 15:32:07.880016000 +0000
+++ C:/cirrus/build/testrun/pg_logicalinspect/isolation/results/logical_inspect.out 2025-03-30 15:37:48.664218000 +0000
@@ -1,32 +1,6 @@
Parsed test spec with 2 sessions
starting permutation: s0_init s0_begin s0_savepoint s0_truncate s1_create_table s1_checkpoint s1_get_changes s1_check_s...
-step s0_init: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding');
-?column?
---------
-init
-(1 row)
-
-step s0_begin: BEGIN;
-step s0_savepoint: SAVEPOINT sp1;
-step s0_truncate: TRUNCATE tbl1;
-step s1_create_table: CREATE TABLE tbl2 (val1 integer, val2 integer);
-step s1_checkpoint: CHECKPOINT;
-step s1_get_changes: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'skip-empty-xacts', '1'...
-data
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_stat_statements/expected/parallel.out C:/cirrus/build/testrun/pg_stat_...
--- C:/cirrus/contrib/pg_stat_statements/expected/parallel.out 2025-03-30 15:32:07.900080400 +0000
+++ C:/cirrus/build/testrun/pg_stat_statements/regress/results/parallel.out 2025-03-30 15:37:54.433755300 +0000
@@ -26,9 +26,7 @@
FROM pg_stat_statements
WHERE query ~ 'SELECT count'
ORDER BY query COLLATE "C";
- query | has_workers_to_launch | has_workers_launched
-----------------------------------------+-----------------------+----------------------
- SELECT count(*) FROM pgss_parallel_tab | t | t
-(1 row)
-
-DROP TABLE pgss_parallel_tab;
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_stat_statements/expected/squashing.out C:/cirrus/build/testrun/pg_stat...
--- C:/cirrus/contrib/pg_stat_statements/expected/squashing.out 2025-03-30 15:32:07.906487300 +0000
+++ C:/cirrus/build/testrun/pg_stat_statements/regress/results/squashing.out 2025-03-30 15:37:56.878049700 +0000
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/int4.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgr...
--- C:/cirrus/src/test/regress/expected/int4.out 2025-03-30 15:32:12.091207400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/int4.out 2025-03-30 15:34:14.130663000 +0000
@@ -1,594 +1,3 @@
---
--- INT4
---
--- int4_tbl was already created and filled in test_setup.sql.
--- Here we just try to insert bad values.
-INSERT INTO INT4_TBL(f1) VALUES ('34.5');
-ERROR: invalid input syntax for type integer: "34.5"
-LINE 1: INSERT INTO INT4_TBL(f1) VALUES ('34.5');
- ^
-INSERT INTO INT4_TBL(f1) VALUES ('1000000000000');
-ERROR: value "1000000000000" is out of range for type integer
-LINE 1: INSERT INTO INT4_TBL(f1) VALUES ('1000000000000');
- ^
-INSERT INTO INT4_TBL(f1) VALUES ('asdf');
-ERROR: invalid input syntax for type integer: "asdf"
-LINE 1: INSERT INTO INT4_TBL(f1) VALUES ('asdf');
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pgrowlocks/expected/pgrowlocks.out C:/cirrus/build/testrun/pgrowlocks/iso...
--- C:/cirrus/contrib/pgrowlocks/expected/pgrowlocks.out 2025-03-30 15:32:08.026544600 +0000
+++ C:/cirrus/build/testrun/pgrowlocks/isolation/results/pgrowlocks.out 2025-03-30 15:37:50.092924000 +0000
@@ -1,233 +1,6 @@
Parsed test spec with 2 sessions
starting permutation: s1_begin s1_tuplock1 s2_rowlocks s1_commit
-step s1_begin: BEGIN;
-step s1_tuplock1: SELECT * FROM multixact_conflict FOR KEY SHARE;
-a|b
--+-
-1|2
-3|4
-(2 rows)
-
-step s2_rowlocks: SELECT locked_row, multi, modes FROM pgrowlocks('multixact_conflict');
-locked_row|multi|modes
-----------+-----+-----------------
-(0,1) |f |{"For Key Share"}
-(0,2) |f |{"For Key Share"}
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/postgres_fdw/expected/postgres_fdw.out C:/cirrus/build/testrun/postgres_f...
--- C:/cirrus/contrib/postgres_fdw/expected/postgres_fdw.out 2025-03-30 15:32:08.052867600 +0000
+++ C:/cirrus/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2025-03-30 15:37:57.673004900 +0000
@@ -254,12264 +254,7 @@
-- To exercise multiple code paths, we use local stats on ft1
-- and remote-estimate mode on ft2.
ANALYZE ft1;
-ALTER FOREIGN TABLE ft2 OPTIONS (use_remote_estimate 'true');
--- ===================================================================
--- test error case for create publication on foreign table
--- ===================================================================
-CREATE PUBLICATION testpub_ftbl FOR TABLE ft1; -- should fail
-ERROR: cannot add relation "ft1" to publication
-DETAIL: This operation is not supported for foreign tables.
--- ===================================================================
--- simple queries
--- ===================================================================
--- single table without alias
-EXPLAIN (COSTS OFF) SELECT * FROM ft1 ORDER BY c3, c1 OFFSET 100 LIMIT 10;
- QUERY PLAN
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/boolean.out C:/cirrus/build/testrun/recovery/027_stream...
--- C:/cirrus/src/test/regress/expected/boolean.out 2025-03-30 15:32:12.023599900 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/boolean.out 2025-03-30 15:36:06.403304800 +0000
@@ -242,356 +242,7 @@
ERROR: invalid input syntax for type boolean: ""
CREATE TABLE BOOLTBL1 (f1 bool);
INSERT INTO BOOLTBL1 (f1) VALUES (bool 't');
-INSERT INTO BOOLTBL1 (f1) VALUES (bool 'True');
-INSERT INTO BOOLTBL1 (f1) VALUES (bool 'true');
--- BOOLTBL1 should be full of true's at this point
-SELECT BOOLTBL1.* FROM BOOLTBL1;
- f1
-----
- t
- t
- t
-(3 rows)
-
-SELECT BOOLTBL1.*
- FROM BOOLTBL1
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/boolean.out C:/cirrus/build/testrun/regress/regress/res...
--- C:/cirrus/src/test/regress/expected/boolean.out 2025-03-30 15:32:12.023599900 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/boolean.out 2025-03-30 15:34:08.408545500 +0000
@@ -241,357 +241,7 @@
SELECT ''::text::boolean AS invalid; -- error
ERROR: invalid input syntax for type boolean: ""
CREATE TABLE BOOLTBL1 (f1 bool);
-INSERT INTO BOOLTBL1 (f1) VALUES (bool 't');
-INSERT INTO BOOLTBL1 (f1) VALUES (bool 'True');
-INSERT INTO BOOLTBL1 (f1) VALUES (bool 'true');
--- BOOLTBL1 should be full of true's at this point
-SELECT BOOLTBL1.* FROM BOOLTBL1;
- f1
-----
- t
- t
- t
-(3 rows)
-
-SELECT BOOLTBL1.*
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/tcn/expected/tcn.out C:/cirrus/build/testrun/tcn/isolation/results/tcn.ou...
--- C:/cirrus/contrib/tcn/expected/tcn.out 2025-03-30 15:32:08.136615900 +0000
+++ C:/cirrus/build/testrun/tcn/isolation/results/tcn.out 2025-03-30 15:38:00.721449900 +0000
@@ -1,13 +1,6 @@
Parsed test spec with 1 sessions
starting permutation: listen insert insert2 update delete
-step listen: LISTEN mychannel;
-step insert: INSERT INTO mytable VALUES(1, 'one');
-s1: NOTIFY "mychannel" with payload ""mytable",I,"key"='1'" from s1
-step insert2: INSERT INTO mytable VALUES(2, 'two');
-s1: NOTIFY "mychannel" with payload ""mytable",I,"key"='2'" from s1
-step update: UPDATE mytable SET value = 'foo' WHERE key = 2;
-s1: NOTIFY "mychannel" with payload ""mytable",U,"key"='2'" from s1
-step delete: DELETE FROM mytable;
-s1: NOTIFY "mychannel" with payload ""mytable",D,"key"='1'" from s1
-s1: NOTIFY "mychannel" with payload ""mytable",D,"key"='2'" from s1
+setup failed: server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request. |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/test_decoding/expected/mxact.out C:/cirrus/build/testrun/test_decoding/is...
--- C:/cirrus/contrib/test_decoding/expected/mxact.out 2025-03-30 15:32:08.149138000 +0000
+++ C:/cirrus/build/testrun/test_decoding/isolation/results/mxact.out 2025-03-30 15:38:02.040678600 +0000
@@ -1,90 +1,6 @@
Parsed test spec with 3 sessions
starting permutation: s0init s0start s1begin s1sharepgclass s2begin s2sharepgclass s0w s0start s2commit s1commit
-step s0init: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding');
-?column?
---------
-init
-(1 row)
-
-step s0start: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false');
-data
-----
-(0 rows)
-
-step s1begin: BEGIN;
-step s1sharepgclass: SELECT count(*) > 1 FROM (SELECT * FROM pg_class FOR SHARE) s;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/test_extensions/expected/test_extensions.out C:/cirrus/build/tes...
--- C:/cirrus/src/test/modules/test_extensions/expected/test_extensions.out 2025-03-30 15:32:11.823450000 +0000
+++ C:/cirrus/build/testrun/test_extensions/regress/results/test_extensions.out 2025-03-30 15:38:25.037534600 +0000
@@ -144,527 +144,10 @@
') > 0 loop c := c + 1; perform pg_stat_clear_snapshot(); end loop;
raise log ''test_extensions looped % times'', c;
end';
--- extension should now contain no temp objects
-\dx+ test_ext8
-Objects in extension "test_ext8"
- Object description
-----------------------------
- function ext8_even(posint)
- table ext8_table1
- type ext8_table1
- type ext8_table1[]
- type posint
- type posint[]
-(6 rows)
-
... |
| 52/5556 |
Expanding HOT updates for expression and partial indexes |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/heap_hot_updates.out /tmp/cirrus-ci-build/build/testrun/pg_upgra...
--- /tmp/cirrus-ci-build/src/test/regress/expected/heap_hot_updates.out 2025-03-30 15:09:59.085881000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/heap_hot_updates.out 2025-03-30 15:12:52.4...
@@ -209,7 +209,7 @@
SELECT pg_stat_get_xact_tuples_hot_updated('ex'::regclass); -- expect: 1 no new HOT updates
pg_stat_get_xact_tuples_hot_updated
-------------------------------------
- 1
+ 0
(1 row)
-- Let's make sure we're recording HOT updates for our 'ex' relation properly in the system |
| 53/5669 |
Use CLOCK_MONOTONIC_COARSE for instr_time for explain analyze |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/entry_timestamp.out /tmp/cirrus-ci-build/build/testrun...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/entry_timestamp.out 2025-03-30 06:26:55.778728000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_stat_statements/regress/results/entry_timestamp.out 2025-03-30 06:30:27.516665...
@@ -45,7 +45,7 @@
WHERE query LIKE '%STMTTS%';
total | minmax_plan_zero | minmax_exec_zero | minmax_stats_since_after_ref | stats_since_after_ref
-------+------------------+------------------+------------------------------+-----------------------
- 2 | 0 | 0 | 0 | 0
+ 2 | 0 | 1 | 0 | 0
(1 row)
-- Perform single min/max reset
@@ -147,7 +147,7 @@
WHERE query LIKE '%STMTTS%';
total | minmax_exec_zero | minmax_ts_after_ref | stats_since_after_ref
-------+------------------+---------------------+-----------------------
- 2 | 1 | 2 | 0
+ 2 | 2 | 2 | 0
(1 row)
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/entry_timestamp.out /tmp/cirrus-ci-build/contrib/pg_st...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/entry_timestamp.out 2025-03-30 06:26:55.969514888 +0000
+++ /tmp/cirrus-ci-build/contrib/pg_stat_statements/results/entry_timestamp.out 2025-03-30 06:32:05.126359660 +0000
@@ -45,7 +45,7 @@
WHERE query LIKE '%STMTTS%';
total | minmax_plan_zero | minmax_exec_zero | minmax_stats_since_after_ref | stats_since_after_ref
-------+------------------+------------------+------------------------------+-----------------------
- 2 | 0 | 0 | 0 | 0
+ 2 | 0 | 2 | 0 | 0
(1 row)
-- Perform single min/max reset
@@ -71,7 +71,7 @@
WHERE query LIKE '%STMTTS%';
total | minmax_plan_zero | minmax_exec_zero | minmax_stats_since_after_ref | stats_since_after_ref
-------+------------------+------------------+------------------------------+-----------------------
- 2 | 1 | 1 | 1 | 0
+ 2 | 1 | 2 | 1 | 0
(1 row)
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/entry_timestamp.out /tmp/cirrus-ci-build/build/testrun...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/entry_timestamp.out 2025-03-30 06:26:55.809428371 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_stat_statements/regress/results/entry_timestamp.out 2025-03-30 06:33:11.344626...
@@ -45,7 +45,7 @@
WHERE query LIKE '%STMTTS%';
total | minmax_plan_zero | minmax_exec_zero | minmax_stats_since_after_ref | stats_since_after_ref
-------+------------------+------------------+------------------------------+-----------------------
- 2 | 0 | 0 | 0 | 0
+ 2 | 0 | 2 | 0 | 0
(1 row)
-- Perform single min/max reset
@@ -71,7 +71,7 @@
WHERE query LIKE '%STMTTS%';
total | minmax_plan_zero | minmax_exec_zero | minmax_stats_since_after_ref | stats_since_after_ref
-------+------------------+------------------+------------------------------+-----------------------
- 2 | 1 | 1 | 1 | 0
+ 2 | 1 | 2 | 1 | 0
(1 row)
... |
| 53/5318 |
System views for versions reporting |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-03-29 19:52:26.329748026 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2025-03-29 20:03:08.956984...
@@ -235,15 +235,7 @@
-- At least 4 core versions should be present, architecture, ICU, core and
-- compiler
select count(*) >= 4 as ok FROM pg_system_versions;
- ok
-----
- t
-(1 row)
-
--- There is always some number of shared objects
-select count(*) > 0 as ok FROM pg_system_libraries;
- ok
-----
- t
-(1 row)
-
+server closed the connection unexpectedly
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_table_like.out /tmp/cirrus-ci-build/build-32/testrun/reco...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_table_like.out 2025-03-29 19:52:26.249748024 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/recovery/027_stream_regress/data/results/create_table_like.out 2025-03-29 20:0...
@@ -320,352 +320,10 @@
-- including storage and comments
CREATE TABLE ctlt1 (a text CHECK (length(a) > 2) ENFORCED PRIMARY KEY,
b text CHECK (length(b) > 100) NOT ENFORCED);
-CREATE INDEX ctlt1_b_key ON ctlt1 (b);
-CREATE INDEX ctlt1_fnidx ON ctlt1 ((a || b));
-CREATE STATISTICS ctlt1_a_b_stat ON a,b FROM ctlt1;
-CREATE STATISTICS ctlt1_expr_stat ON (a || b) FROM ctlt1;
-COMMENT ON STATISTICS ctlt1_a_b_stat IS 'ab stats';
-COMMENT ON STATISTICS ctlt1_expr_stat IS 'ab expr stats';
-COMMENT ON COLUMN ctlt1.a IS 'A';
-COMMENT ON COLUMN ctlt1.b IS 'B';
-COMMENT ON CONSTRAINT ctlt1_a_check ON ctlt1 IS 't1_a_check';
-COMMENT ON INDEX ctlt1_pkey IS 'index pkey';
-COMMENT ON INDEX ctlt1_b_key IS 'index b_key';
-ALTER TABLE ctlt1 ALTER COLUMN a SET STORAGE MAIN;
-CREATE TABLE ctlt2 (c text);
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build-32/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-03-29 19:52:26.329748026 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/sysviews.out 2025-03-29 20:03:07.568985214 +0000
@@ -235,15 +235,7 @@
-- At least 4 core versions should be present, architecture, ICU, core and
-- compiler
select count(*) >= 4 as ok FROM pg_system_versions;
- ok
-----
- t
-(1 row)
-
--- There is always some number of shared objects
-select count(*) > 0 as ok FROM pg_system_libraries;
- ok
-----
- t
-(1 row)
-
+server closed the connection unexpectedly
... |
| 52/5283 |
Replace IN VALUES with ANY in WHERE clauses during optimization |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-03-29 18:51:01.682817885 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2025-03-29 19:01:42.97158...
@@ -3043,7 +3043,7 @@
SELECT ten FROM onek t WHERE 1 IN ((VALUES (1), (3)));
QUERY PLAN
----------------------------------------------------------
- Seq Scan on onek t (cost=0.00..45.00 rows=1000 width=4)
+ Seq Scan on onek t (cost=0.00..44.00 rows=1000 width=4)
(1 row)
EXPLAIN (COSTS OFF) |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build-32/testrun/recovery/027...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-03-29 18:51:01.682817885 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/recovery/027_stream_regress/data/results/subselect.out 2025-03-29 19:02:59.767...
@@ -3043,7 +3043,7 @@
SELECT ten FROM onek t WHERE 1 IN ((VALUES (1), (3)));
QUERY PLAN
----------------------------------------------------------
- Seq Scan on onek t (cost=0.00..45.00 rows=1000 width=4)
+ Seq Scan on onek t (cost=0.00..44.00 rows=1000 width=4)
(1 row)
EXPLAIN (COSTS OFF) |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build-32/testrun/regress/regr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-03-29 18:51:01.682817885 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/subselect.out 2025-03-29 19:01:40.963585229 +0000
@@ -3043,7 +3043,7 @@
SELECT ten FROM onek t WHERE 1 IN ((VALUES (1), (3)));
QUERY PLAN
----------------------------------------------------------
- Seq Scan on onek t (cost=0.00..45.00 rows=1000 width=4)
+ Seq Scan on onek t (cost=0.00..44.00 rows=1000 width=4)
(1 row)
EXPLAIN (COSTS OFF) |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subselect.out C:/cirrus/build/testrun/recovery/027_stre...
--- C:/cirrus/src/test/regress/expected/subselect.out 2025-03-29 18:51:09.699958900 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2025-03-29 18:56:22.936924000 +0000
@@ -2833,15 +2833,16 @@
EXPLAIN (COSTS OFF)
SELECT c.oid,c.relname FROM pg_class c JOIN pg_am a USING (oid)
WHERE c.oid IN (VALUES (1), (2));
- QUERY PLAN
----------------------------------------------------------------
- Hash Join
- Hash Cond: (a.oid = c.oid)
- -> Seq Scan on pg_am a
- -> Hash
- -> Index Scan using pg_class_oid_index on pg_class c
- Index Cond: (oid = ANY ('{1,2}'::oid[]))
-(6 rows)
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (c.oid = a.oid)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subselect.out C:/cirrus/build/testrun/regress/regress/r...
--- C:/cirrus/src/test/regress/expected/subselect.out 2025-03-29 18:51:09.699958900 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/subselect.out 2025-03-29 18:53:37.037092500 +0000
@@ -2833,15 +2833,16 @@
EXPLAIN (COSTS OFF)
SELECT c.oid,c.relname FROM pg_class c JOIN pg_am a USING (oid)
WHERE c.oid IN (VALUES (1), (2));
- QUERY PLAN
----------------------------------------------------------------
- Hash Join
- Hash Cond: (a.oid = c.oid)
- -> Seq Scan on pg_am a
- -> Hash
- -> Index Scan using pg_class_oid_index on pg_class c
- Index Cond: (oid = ANY ('{1,2}'::oid[]))
-(6 rows)
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (c.oid = a.oid)
... |
| 52/5081 |
nbtree skip scan |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-03-28 22:24:03.793605000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_index.out 2025-03-28 22:26:19.24437...
@@ -1681,1889 +1681,10 @@
(1 row)
SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;
- unique1 | unique2
----------+---------
- 500 |
-(1 row)
-
-DROP INDEX onek_nulltest;
-CREATE UNIQUE INDEX onek_nulltest ON onek_with_null (unique2 desc,unique1);
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL;
- count
--------
- 3
-(1 row)
-
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/recovery/027...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-03-28 22:24:03.793605000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/create_index.out 2025-03-28 22:27:09.553...
@@ -1681,1889 +1681,10 @@
(1 row)
SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;
- unique1 | unique2
----------+---------
- 500 |
-(1 row)
-
-DROP INDEX onek_nulltest;
-CREATE UNIQUE INDEX onek_nulltest ON onek_with_null (unique2 desc,unique1);
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL;
- count
--------
- 3
-(1 row)
-
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/regress/regr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-03-28 22:24:03.793605000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/create_index.out 2025-03-28 22:26:21.558877000 +0000
@@ -1681,1889 +1681,10 @@
(1 row)
SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;
- unique1 | unique2
----------+---------
- 500 |
-(1 row)
-
-DROP INDEX onek_nulltest;
-CREATE UNIQUE INDEX onek_nulltest ON onek_with_null (unique2 desc,unique1);
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL;
- count
--------
- 3
-(1 row)
-
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_che...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-03-28 22:24:04.239021948 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/create_index.out 2025-03-28 22:30:00.765496429 +0000
@@ -1681,1889 +1681,7 @@
(1 row)
SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;
- unique1 | unique2
----------+---------
- 500 |
-(1 row)
-
-DROP INDEX onek_nulltest;
-CREATE UNIQUE INDEX onek_nulltest ON onek_with_null (unique2 desc,unique1);
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL;
- count
--------
- 3
-(1 row)
-
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/src/test/regress/results/c...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-03-28 22:24:04.239021948 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/create_index.out 2025-03-28 22:28:15.901412478 +0000
@@ -1681,1889 +1681,7 @@
(1 row)
SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;
- unique1 | unique2
----------+---------
- 500 |
-(1 row)
-
-DROP INDEX onek_nulltest;
-CREATE UNIQUE INDEX onek_nulltest ON onek_with_null (unique2 desc,unique1);
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL;
- count
--------
- 3
-(1 row)
-
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-03-28 22:24:04.031965262 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_index.out 2025-03-28 22:28:35.89550...
@@ -1681,1889 +1681,7 @@
(1 row)
SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;
- unique1 | unique2
----------+---------
- 500 |
-(1 row)
-
-DROP INDEX onek_nulltest;
-CREATE UNIQUE INDEX onek_nulltest ON onek_with_null (unique2 desc,unique1);
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL;
- count
--------
- 3
-(1 row)
-
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/recovery/027...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-03-28 22:24:04.031965262 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/create_index.out 2025-03-28 22:29:27.067...
@@ -1681,1889 +1681,7 @@
(1 row)
SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;
- unique1 | unique2
----------+---------
- 500 |
-(1 row)
-
-DROP INDEX onek_nulltest;
-CREATE UNIQUE INDEX onek_nulltest ON onek_with_null (unique2 desc,unique1);
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL;
- count
--------
- 3
-(1 row)
-
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/regress/regr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-03-28 22:24:04.031965262 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/create_index.out 2025-03-28 22:28:34.011508290 +0000
@@ -1681,1889 +1681,7 @@
(1 row)
SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;
- unique1 | unique2
----------+---------
- 500 |
-(1 row)
-
-DROP INDEX onek_nulltest;
-CREATE UNIQUE INDEX onek_nulltest ON onek_with_null (unique2 desc,unique1);
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL;
- count
--------
- 3
-(1 row)
-
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/create_index.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_p...
--- /Users/admin/pgsql/src/test/regress/expected/create_index.out 2025-03-28 22:23:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_index.out 2025-03-28 22:26:00
@@ -1644,144 +1644,6 @@
SET enable_seqscan = OFF;
SET enable_indexscan = ON;
SET enable_bitmapscan = ON;
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL;
- count
--------
- 3
-(1 row)
-
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL AND unique2 IS NULL;
- count
--------
- 1
-(1 row)
-
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NOT NULL;
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/create_index.out /Users/admin/pgsql/build/testrun/recovery/027_str...
--- /Users/admin/pgsql/src/test/regress/expected/create_index.out 2025-03-28 22:23:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/create_index.out 2025-03-28 22:26:58
@@ -1644,144 +1644,6 @@
SET enable_seqscan = OFF;
SET enable_indexscan = ON;
SET enable_bitmapscan = ON;
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL;
- count
--------
- 3
-(1 row)
-
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL AND unique2 IS NULL;
- count
--------
- 1
-(1 row)
-
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NOT NULL;
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/create_index.out /Users/admin/pgsql/build/testrun/regress/regress/...
--- /Users/admin/pgsql/src/test/regress/expected/create_index.out 2025-03-28 22:23:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/create_index.out 2025-03-28 22:26:00
@@ -1644,144 +1644,6 @@
SET enable_seqscan = OFF;
SET enable_indexscan = ON;
SET enable_bitmapscan = ON;
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL;
- count
--------
- 3
-(1 row)
-
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL AND unique2 IS NULL;
- count
--------
- 1
-(1 row)
-
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NOT NULL;
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_index.out C:/cirrus/build/testrun/pg_upgrade/002...
--- C:/cirrus/src/test/regress/expected/create_index.out 2025-03-28 22:24:11.421560700 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_index.out 2025-03-28 22:26:26.624856500 +0000
@@ -1681,1889 +1681,7 @@
(1 row)
SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;
- unique1 | unique2
----------+---------
- 500 |
-(1 row)
-
-DROP INDEX onek_nulltest;
-CREATE UNIQUE INDEX onek_nulltest ON onek_with_null (unique2 desc,unique1);
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL;
- count
--------
- 3
-(1 row)
-
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_index.out C:/cirrus/build/testrun/recovery/027_s...
--- C:/cirrus/src/test/regress/expected/create_index.out 2025-03-28 22:24:11.421560700 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/create_index.out 2025-03-28 22:28:30.457041000 +000...
@@ -1681,1889 +1681,7 @@
(1 row)
SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;
- unique1 | unique2
----------+---------
- 500 |
-(1 row)
-
-DROP INDEX onek_nulltest;
-CREATE UNIQUE INDEX onek_nulltest ON onek_with_null (unique2 desc,unique1);
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL;
- count
--------
- 3
-(1 row)
-
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/create_index.out C:/cirrus/build/testrun/regress/regres...
--- C:/cirrus/src/test/regress/expected/create_index.out 2025-03-28 22:24:11.421560700 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/create_index.out 2025-03-28 22:26:24.197296700 +0000
@@ -1681,1889 +1681,7 @@
(1 row)
SELECT unique1, unique2 FROM onek_with_null WHERE unique1 = 500 ORDER BY unique2 DESC, unique1 DESC LIMIT 1;
- unique1 | unique2
----------+---------
- 500 |
-(1 row)
-
-DROP INDEX onek_nulltest;
-CREATE UNIQUE INDEX onek_nulltest ON onek_with_null (unique2 desc,unique1);
-SELECT count(*) FROM onek_with_null WHERE unique1 IS NULL;
- count
--------
- 3
-(1 row)
-
... |
| 52/5357 |
New predefined role pg_manage_extensions |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/pl/plperl/expected/plperl_setup.out /tmp/cirrus-ci-build/build/testrun/plperl/regress/...
--- /tmp/cirrus-ci-build/src/pl/plperl/expected/plperl_setup.out 2025-03-28 08:26:52.717399000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plperl/regress/results/plperl_setup.out 2025-03-28 08:29:08.166396000 +0000
@@ -12,7 +12,7 @@
HINT: Must have CREATE privilege on current database to create this extension.
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
RESET ROLE;
DO $$
begin
@@ -24,7 +24,7 @@
CREATE EXTENSION plperl;
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
CREATE SCHEMA plperl_setup_scratch;
SET search_path = plperl_setup_scratch;
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/pl/plperl/expected/plperl_setup.out /tmp/cirrus-ci-build/src/pl/plperl/results/plperl_...
--- /tmp/cirrus-ci-build/src/pl/plperl/expected/plperl_setup.out 2025-03-28 08:26:56.911789379 +0000
+++ /tmp/cirrus-ci-build/src/pl/plperl/results/plperl_setup.out 2025-03-28 08:29:29.515010348 +0000
@@ -12,7 +12,7 @@
HINT: Must have CREATE privilege on current database to create this extension.
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
RESET ROLE;
DO $$
begin
@@ -24,7 +24,7 @@
CREATE EXTENSION plperl;
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
CREATE SCHEMA plperl_setup_scratch;
SET search_path = plperl_setup_scratch;
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/pl/plperl/expected/plperl_setup.out /tmp/cirrus-ci-build/build/testrun/plperl/regress/...
--- /tmp/cirrus-ci-build/src/pl/plperl/expected/plperl_setup.out 2025-03-28 08:26:53.099339331 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plperl/regress/results/plperl_setup.out 2025-03-28 08:31:43.651324076 +0000
@@ -12,7 +12,7 @@
HINT: Must have CREATE privilege on current database to create this extension.
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
RESET ROLE;
DO $$
begin
@@ -24,7 +24,7 @@
CREATE EXTENSION plperl;
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
CREATE SCHEMA plperl_setup_scratch;
SET search_path = plperl_setup_scratch;
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/pl/plperl/expected/plperl_setup.out /Users/admin/pgsql/build/testrun/plperl/regress/resu...
--- /Users/admin/pgsql/src/pl/plperl/expected/plperl_setup.out 2025-03-28 08:26:13
+++ /Users/admin/pgsql/build/testrun/plperl/regress/results/plperl_setup.out 2025-03-28 08:29:09
@@ -12,7 +12,7 @@
HINT: Must have CREATE privilege on current database to create this extension.
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
RESET ROLE;
DO $$
begin
@@ -24,7 +24,7 @@
CREATE EXTENSION plperl;
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
CREATE SCHEMA plperl_setup_scratch;
SET search_path = plperl_setup_scratch;
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/pl/plperl/expected/plperl_setup.out C:/cirrus/build/testrun/plperl/regress/re...
--- C:/cirrus/src/pl/plperl/expected/plperl_setup.out 2025-03-28 08:27:00.800990000 +0000
+++ C:/cirrus/build/testrun/plperl/regress/results/plperl_setup.out 2025-03-28 08:33:03.338154500 +0000
@@ -12,7 +12,7 @@
HINT: Must have CREATE privilege on current database to create this extension.
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
RESET ROLE;
DO $$
begin
@@ -24,7 +24,7 @@
CREATE EXTENSION plperl;
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Must be superuser or member of pg_manage_extensions to create this extension.
CREATE SCHEMA plperl_setup_scratch;
SET search_path = plperl_setup_scratch;
... |
| 52/5117 |
VACUUM FULL / CLUSTER CONCURRENTLY |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out C:/cirr...
--- C:/cirrus/src/test/modules/brin/expected/summarization-and-inprogress-insertion.out 2025-03-28 05:47:23.201448100 +0...
+++ C:/cirrus/build/testrun/brin/isolation/results/summarization-and-inprogress-insertion.out 2025-03-28 05:53:53.246639...
@@ -1,51 +1,6 @@
Parsed test spec with 2 sessions
starting permutation: s2check s1b s2b s1i s2summ s1c s2c s2check
-step s2check: SELECT * FROM brin_page_items(get_raw_page('brinidx', 2), 'brinidx'::regclass);
-itemoffset|blknum|attnum|allnulls|hasnulls|placeholder|empty|value
-----------+------+------+--------+--------+-----------+-----+--------
- 1| 0| 1|f |t |f |f |{1 .. 1}
-(1 row)
-
-step s1b: BEGIN ISOLATION LEVEL REPEATABLE READ;
-step s2b: BEGIN ISOLATION LEVEL REPEATABLE READ; SELECT 1;
-?column?
---------
- 1
-(1 row)
-
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/dblink/expected/dblink.out C:/cirrus/build/testrun/dblink/regress/results...
--- C:/cirrus/contrib/dblink/expected/dblink.out 2025-03-28 05:47:19.017556000 +0000
+++ C:/cirrus/build/testrun/dblink/regress/results/dblink.out 2025-03-28 05:53:13.845716800 +0000
@@ -799,423 +799,7 @@
UNION
(SELECT * from dblink_get_result('dtest3') as t3(f1 int, f2 text, f3 text[]))
ORDER by f1;
--- dblink_get_connections returns an array with elements in a machine-dependent
--- ordering, so we must resort to unnesting and sorting for a stable result
-create function unnest(anyarray) returns setof anyelement
-language sql strict immutable as $$
-select $1[i] from generate_series(array_lower($1,1), array_upper($1,1)) as i
-$$;
-SELECT * FROM unnest(dblink_get_connections()) ORDER BY 1;
- unnest
---------
- dtest1
- dtest2
- dtest3
-(3 rows)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/delay_execution/expected/partition-addition.out C:/cirrus/build/...
--- C:/cirrus/src/test/modules/delay_execution/expected/partition-addition.out 2025-03-28 05:47:23.215810500 +0000
+++ C:/cirrus/build/testrun/delay_execution/isolation/results/partition-addition.out 2025-03-28 05:53:58.207074300 +0000
@@ -1,27 +1,6 @@
Parsed test spec with 2 sessions
starting permutation: s2lock s1exec s2addp s2unlock
-step s2lock: SELECT pg_advisory_lock(12345);
-pg_advisory_lock
-----------------
-
-(1 row)
-
-step s1exec: LOAD 'delay_execution';
- SET delay_execution.post_planning_lock_id = 12345;
- SELECT * FROM foo WHERE a <> 1 AND a <> (SELECT 3); <waiting ...>
-step s2addp: CREATE TABLE foo2 (LIKE foo);
- ALTER TABLE foo ATTACH PARTITION foo2 FOR VALUES IN (2);
- INSERT INTO foo VALUES (2, 'ADD2');
-step s2unlock: SELECT pg_advisory_unlock(12345);
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/interfaces/ecpg/test/expected/compat_informix-sqlda.stderr C:/cirrus/build/te...
--- C:/cirrus/src/interfaces/ecpg/test/expected/compat_informix-sqlda.stderr 2025-03-28 05:47:22.629837100 +0000
+++ C:/cirrus/build/testrun/ecpg/ecpg/results/compat_informix-sqlda.stderr 2025-03-28 05:54:29.076224600 +0000
@@ -332,9 +332,9 @@
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ecpg_execute on line 241: using PQexec
[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_process_output on line 241: OK: DROP TABLE
-[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ECPGtrans on line 244: action "commit"; connection "regress1"
-[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_finish: connection regress1 closed
+[NO_PID]: ecpg_check_PQresult on line 241: bad response - server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
[NO_PID]: sqlca: code: 0, state: 00000
+[NO_PID]: raising sqlstate 57P02 (sqlcode -400): the connection to the server was lost on line 241
+[NO_PID]: sqlca: code: -400, state: 57P02
diff --strip-trailing-cr -U3 C:/cirrus/src/interfaces/ecpg/test/expected/compat_informix-describe.stdout C:/cirrus/build...
--- C:/cirrus/src/interfaces/ecpg/test/expected/compat_informix-describe.stdout 2025-03-28 05:47:22.620760500 +0000
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/injection_points/expected/basic.out C:/cirrus/build/testrun/inje...
--- C:/cirrus/src/test/modules/injection_points/expected/basic.out 2025-03-28 05:47:23.228070900 +0000
+++ C:/cirrus/build/testrun/injection_points/isolation/results/basic.out 2025-03-28 05:54:02.846704500 +0000
@@ -1,75 +1,6 @@
Parsed test spec with 2 sessions
starting permutation: wait1 wakeup2 noop1 detach2
-injection_points_attach
------------------------
-
-(1 row)
-
-step wait1: SELECT injection_points_run('injection-points-wait'); <waiting ...>
-step wakeup2: SELECT injection_points_wakeup('injection-points-wait');
-injection_points_wakeup
------------------------
-
-(1 row)
-
-step wait1: <... completed>
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/isolation/expected/read-only-anomaly.out C:/cirrus/build/testrun/isolati...
--- C:/cirrus/src/test/isolation/expected/read-only-anomaly.out 2025-03-28 05:47:23.061196800 +0000
+++ C:/cirrus/build/testrun/isolation/isolation/results/read-only-anomaly.out 2025-03-28 05:49:23.758727900 +0000
@@ -1,33 +1,6 @@
Parsed test spec with 3 sessions
starting permutation: s2rx s2ry s1ry s1wy s1c s3r s2wx s2c s3c
-step s2rx: SELECT balance FROM bank_account WHERE id = 'X';
-balance
--------
- 0
-(1 row)
-
-step s2ry: SELECT balance FROM bank_account WHERE id = 'Y';
-balance
--------
- 0
-(1 row)
-
-step s1ry: SELECT balance FROM bank_account WHERE id = 'Y';
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pageinspect/expected/brin.out C:/cirrus/build/testrun/pageinspect/regress...
--- C:/cirrus/contrib/pageinspect/expected/brin.out 2025-03-28 05:47:19.240242500 +0000
+++ C:/cirrus/build/testrun/pageinspect/regress/results/brin.out 2025-03-28 05:53:28.324192100 +0000
@@ -146,65 +146,10 @@
USING brin (a int4_minmax_ops, a int4_bloom_ops, b, c int8_minmax_multi_ops)
WITH (pages_per_range=7)
WHERE NOT (a BETWEEN 1000 and 1500);
-SELECT relname, relpages
- FROM pg_class
- WHERE relname IN ('brin_test_serial_idx', 'brin_test_parallel_idx')
- ORDER BY relname;
- relname | relpages
-------------------------+----------
- brin_test_parallel_idx | 4
- brin_test_serial_idx | 4
-(2 rows)
-
--- Check that (A except B) and (B except A) is empty, which means the indexes
--- are the same.
-SELECT * FROM brin_page_items(get_raw_page('brin_test_parallel_idx', 2), 'brin_test_parallel_idx')
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_logicalinspect/expected/logical_inspect.out C:/cirrus/build/testrun/pg...
--- C:/cirrus/contrib/pg_logicalinspect/expected/logical_inspect.out 2025-03-28 05:47:19.294468100 +0000
+++ C:/cirrus/build/testrun/pg_logicalinspect/isolation/results/logical_inspect.out 2025-03-28 05:53:32.166534400 +0000
@@ -1,32 +1,6 @@
Parsed test spec with 2 sessions
starting permutation: s0_init s0_begin s0_savepoint s0_truncate s1_create_table s1_checkpoint s1_get_changes s1_check_s...
-step s0_init: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding');
-?column?
---------
-init
-(1 row)
-
-step s0_begin: BEGIN;
-step s0_savepoint: SAVEPOINT sp1;
-step s0_truncate: TRUNCATE tbl1;
-step s1_create_table: CREATE TABLE tbl2 (val1 integer, val2 integer);
-step s1_checkpoint: CHECKPOINT;
-step s1_get_changes: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'skip-empty-xacts', '1'...
-data
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_stat_statements/expected/parallel.out C:/cirrus/build/testrun/pg_stat_...
--- C:/cirrus/contrib/pg_stat_statements/expected/parallel.out 2025-03-28 05:47:19.330261800 +0000
+++ C:/cirrus/build/testrun/pg_stat_statements/regress/results/parallel.out 2025-03-28 05:53:37.312531100 +0000
@@ -15,20 +15,10 @@
(1 row)
SELECT count(*) FROM pgss_parallel_tab;
- count
--------
- 0
-(1 row)
-
-SELECT query,
- parallel_workers_to_launch > 0 AS has_workers_to_launch,
- parallel_workers_launched > 0 AS has_workers_launched
- FROM pg_stat_statements
- WHERE query ~ 'SELECT count'
- ORDER BY query COLLATE "C";
- query | has_workers_to_launch | has_workers_launched
-----------------------------------------+-----------------------+----------------------
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/boolean.out C:/cirrus/build/testrun/pg_upgrade/002_pg_u...
--- C:/cirrus/src/test/regress/expected/boolean.out 2025-03-28 05:47:23.522829100 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/boolean.out 2025-03-28 05:49:28.264191700 +0000
@@ -241,357 +241,7 @@
SELECT ''::text::boolean AS invalid; -- error
ERROR: invalid input syntax for type boolean: ""
CREATE TABLE BOOLTBL1 (f1 bool);
-INSERT INTO BOOLTBL1 (f1) VALUES (bool 't');
-INSERT INTO BOOLTBL1 (f1) VALUES (bool 'True');
-INSERT INTO BOOLTBL1 (f1) VALUES (bool 'true');
--- BOOLTBL1 should be full of true's at this point
-SELECT BOOLTBL1.* FROM BOOLTBL1;
- f1
-----
- t
- t
- t
-(3 rows)
-
-SELECT BOOLTBL1.*
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pgrowlocks/expected/pgrowlocks.out C:/cirrus/build/testrun/pgrowlocks/iso...
--- C:/cirrus/contrib/pgrowlocks/expected/pgrowlocks.out 2025-03-28 05:47:19.464377800 +0000
+++ C:/cirrus/build/testrun/pgrowlocks/isolation/results/pgrowlocks.out 2025-03-28 05:53:35.326715200 +0000
@@ -1,233 +1,6 @@
Parsed test spec with 2 sessions
starting permutation: s1_begin s1_tuplock1 s2_rowlocks s1_commit
-step s1_begin: BEGIN;
-step s1_tuplock1: SELECT * FROM multixact_conflict FOR KEY SHARE;
-a|b
--+-
-1|2
-3|4
-(2 rows)
-
-step s2_rowlocks: SELECT locked_row, multi, modes FROM pgrowlocks('multixact_conflict');
-locked_row|multi|modes
-----------+-----+-----------------
-(0,1) |f |{"For Key Share"}
-(0,2) |f |{"For Key Share"}
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/postgres_fdw/expected/postgres_fdw.out C:/cirrus/build/testrun/postgres_f...
--- C:/cirrus/contrib/postgres_fdw/expected/postgres_fdw.out 2025-03-28 05:47:19.485337900 +0000
+++ C:/cirrus/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2025-03-28 05:53:41.476597300 +0000
@@ -254,12264 +254,7 @@
-- To exercise multiple code paths, we use local stats on ft1
-- and remote-estimate mode on ft2.
ANALYZE ft1;
-ALTER FOREIGN TABLE ft2 OPTIONS (use_remote_estimate 'true');
--- ===================================================================
--- test error case for create publication on foreign table
--- ===================================================================
-CREATE PUBLICATION testpub_ftbl FOR TABLE ft1; -- should fail
-ERROR: cannot add relation "ft1" to publication
-DETAIL: This operation is not supported for foreign tables.
--- ===================================================================
--- simple queries
--- ===================================================================
--- single table without alias
-EXPLAIN (COSTS OFF) SELECT * FROM ft1 ORDER BY c3, c1 OFFSET 100 LIMIT 10;
- QUERY PLAN
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/boolean.out C:/cirrus/build/testrun/recovery/027_stream...
--- C:/cirrus/src/test/regress/expected/boolean.out 2025-03-28 05:47:23.522829100 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/boolean.out 2025-03-28 05:51:59.753849000 +0000
@@ -1,597 +1,3 @@
---
--- BOOLEAN
---
---
--- sanity check - if this fails go insane!
---
-SELECT 1 AS one;
- one
------
- 1
-(1 row)
-
--- ******************testing built-in type bool********************
--- check bool input syntax
-SELECT true AS true;
- true
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/boolean.out C:/cirrus/build/testrun/regress/regress/res...
--- C:/cirrus/src/test/regress/expected/boolean.out 2025-03-28 05:47:23.522829100 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/boolean.out 2025-03-28 05:49:23.821366200 +0000
@@ -241,357 +241,7 @@
SELECT ''::text::boolean AS invalid; -- error
ERROR: invalid input syntax for type boolean: ""
CREATE TABLE BOOLTBL1 (f1 bool);
-INSERT INTO BOOLTBL1 (f1) VALUES (bool 't');
-INSERT INTO BOOLTBL1 (f1) VALUES (bool 'True');
-INSERT INTO BOOLTBL1 (f1) VALUES (bool 'true');
--- BOOLTBL1 should be full of true's at this point
-SELECT BOOLTBL1.* FROM BOOLTBL1;
- f1
-----
- t
- t
- t
-(3 rows)
-
-SELECT BOOLTBL1.*
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/tcn/expected/tcn.out C:/cirrus/build/testrun/tcn/isolation/results/tcn.ou...
--- C:/cirrus/contrib/tcn/expected/tcn.out 2025-03-28 05:47:19.588886800 +0000
+++ C:/cirrus/build/testrun/tcn/isolation/results/tcn.out 2025-03-28 05:53:45.024877900 +0000
@@ -1,13 +1,6 @@
Parsed test spec with 1 sessions
starting permutation: listen insert insert2 update delete
-step listen: LISTEN mychannel;
-step insert: INSERT INTO mytable VALUES(1, 'one');
-s1: NOTIFY "mychannel" with payload ""mytable",I,"key"='1'" from s1
-step insert2: INSERT INTO mytable VALUES(2, 'two');
-s1: NOTIFY "mychannel" with payload ""mytable",I,"key"='2'" from s1
-step update: UPDATE mytable SET value = 'foo' WHERE key = 2;
-s1: NOTIFY "mychannel" with payload ""mytable",U,"key"='2'" from s1
-step delete: DELETE FROM mytable;
-s1: NOTIFY "mychannel" with payload ""mytable",D,"key"='1'" from s1
-s1: NOTIFY "mychannel" with payload ""mytable",D,"key"='2'" from s1
+setup failed: server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request. |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/test_decoding/expected/mxact.out C:/cirrus/build/testrun/test_decoding/is...
--- C:/cirrus/contrib/test_decoding/expected/mxact.out 2025-03-28 05:47:19.604469800 +0000
+++ C:/cirrus/build/testrun/test_decoding/isolation/results/mxact.out 2025-03-28 05:53:45.337481600 +0000
@@ -1,90 +1,6 @@
Parsed test spec with 3 sessions
starting permutation: s0init s0start s1begin s1sharepgclass s2begin s2sharepgclass s0w s0start s2commit s1commit
-step s0init: SELECT 'init' FROM pg_create_logical_replication_slot('isolation_slot', 'test_decoding');
-?column?
---------
-init
-(1 row)
-
-step s0start: SELECT data FROM pg_logical_slot_get_changes('isolation_slot', NULL, NULL, 'include-xids', 'false');
-data
-----
-(0 rows)
-
-step s1begin: BEGIN;
-step s1sharepgclass: SELECT count(*) > 1 FROM (SELECT * FROM pg_class FOR SHARE) s;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/test_extensions/expected/test_extensions.out C:/cirrus/build/tes...
--- C:/cirrus/src/test/modules/test_extensions/expected/test_extensions.out 2025-03-28 05:47:23.318992300 +0000
+++ C:/cirrus/build/testrun/test_extensions/regress/results/test_extensions.out 2025-03-28 05:54:12.972650800 +0000
@@ -144,527 +144,10 @@
') > 0 loop c := c + 1; perform pg_stat_clear_snapshot(); end loop;
raise log ''test_extensions looped % times'', c;
end';
--- extension should now contain no temp objects
-\dx+ test_ext8
-Objects in extension "test_ext8"
- Object description
-----------------------------
- function ext8_even(posint)
- table ext8_table1
- type ext8_table1
- type ext8_table1[]
- type posint
- type posint[]
-(6 rows)
-
... |
| 53/5012 |
Vacuum statistics |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_index_statistics.out /tmp/cirrus-ci-build/build-32/testru...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_index_statistics.out 2025-03-27 22:48:56.687435440 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade/002_pg_upgrade/data/results/vacuum_index_statistics.out 2025-03-27 ...
@@ -60,7 +60,7 @@
WHERE vt.relname = 'vestat_pkey' AND vt.relid = c.oid;
relname | relpages | pages_deleted | tuples_deleted
-------------+----------+---------------+----------------
- vestat_pkey | 30 | 0 | 0
+ vestat_pkey | 24 | 0 | 0
(1 row)
SELECT relpages AS irp
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_tables_and_db_statistics.out /tmp/cirrus-ci-build/build-3...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_tables_and_db_statistics.out 2025-03-27 22:48:56.687435440 +00...
+++ /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade/002_pg_upgrade/data/results/vacuum_tables_and_db_statistics.out 202...
@@ -65,7 +65,7 @@
WHERE vt.relname = 'vestat' AND vt.relid = c.oid;
relname | vm_new_frozen_pages | tuples_deleted | relpages | pages_scanned | pages_removed
---------+---------------------+----------------+----------+---------------+---------------
- vestat | 0 | 0 | 455 | 0 | 0
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_index_statistics.out /tmp/cirrus-ci-build/build-32/testru...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_index_statistics.out 2025-03-27 22:48:56.687435440 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/recovery/027_stream_regress/data/results/vacuum_index_statistics.out 2025-03-2...
@@ -60,7 +60,7 @@
WHERE vt.relname = 'vestat_pkey' AND vt.relid = c.oid;
relname | relpages | pages_deleted | tuples_deleted
-------------+----------+---------------+----------------
- vestat_pkey | 30 | 0 | 0
+ vestat_pkey | 24 | 0 | 0
(1 row)
SELECT relpages AS irp
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_tables_and_db_statistics.out /tmp/cirrus-ci-build/build-3...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_tables_and_db_statistics.out 2025-03-27 22:48:56.687435440 +00...
+++ /tmp/cirrus-ci-build/build-32/testrun/recovery/027_stream_regress/data/results/vacuum_tables_and_db_statistics.out 2...
@@ -65,7 +65,7 @@
WHERE vt.relname = 'vestat' AND vt.relid = c.oid;
relname | vm_new_frozen_pages | tuples_deleted | relpages | pages_scanned | pages_removed
---------+---------------------+----------------+----------+---------------+---------------
- vestat | 0 | 0 | 455 | 0 | 0
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_index_statistics.out /tmp/cirrus-ci-build/build-32/testru...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_index_statistics.out 2025-03-27 22:48:56.687435440 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/vacuum_index_statistics.out 2025-03-27 23:00:37.490644...
@@ -60,7 +60,7 @@
WHERE vt.relname = 'vestat_pkey' AND vt.relid = c.oid;
relname | relpages | pages_deleted | tuples_deleted
-------------+----------+---------------+----------------
- vestat_pkey | 30 | 0 | 0
+ vestat_pkey | 24 | 0 | 0
(1 row)
SELECT relpages AS irp
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_tables_and_db_statistics.out /tmp/cirrus-ci-build/build-3...
--- /tmp/cirrus-ci-build/src/test/regress/expected/vacuum_tables_and_db_statistics.out 2025-03-27 22:48:56.687435440 +00...
+++ /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/vacuum_tables_and_db_statistics.out 2025-03-27 23:00:3...
@@ -65,7 +65,7 @@
WHERE vt.relname = 'vestat' AND vt.relid = c.oid;
relname | vm_new_frozen_pages | tuples_deleted | relpages | pages_scanned | pages_removed
---------+---------------------+----------------+----------+---------------+---------------
- vestat | 0 | 0 | 455 | 0 | 0
... |
| 52/5326 |
Parallel heap vacuum |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out 2025-03-27 18:18:59.166482000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/constraints.out 2025-03-27 18:21:03.431342000 +0000
@@ -931,464 +931,10 @@
create table notnull_tbl4 (a int not null constraint foo not null);
\d+ notnull_tbl4
- Table "public.notnull_tbl4"
- Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
---------+---------+-----------+----------+---------+---------+--------------+-------------
- a | integer | | not null | | plain | |
-Not-null constraints:
- "foo" NOT NULL "a"
-
-create table notnull_tbl5 (a int constraint foo not null constraint foo not null);
-\d+ notnull_tbl5
- Table "public.notnull_tbl5"
- Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
---------+---------+-----------+----------+---------+---------+--------------+-------------
- a | integer | | not null | | plain | |
... |
| 53/5669 |
Use CLOCK_MONOTONIC_COARSE for instr_time for explain analyze |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/entry_timestamp.out /tmp/cirrus-ci-build/build/testrun...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/entry_timestamp.out 2025-03-27 16:48:19.344281000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_stat_statements/regress/results/entry_timestamp.out 2025-03-27 16:51:55.715379...
@@ -45,7 +45,7 @@
WHERE query LIKE '%STMTTS%';
total | minmax_plan_zero | minmax_exec_zero | minmax_stats_since_after_ref | stats_since_after_ref
-------+------------------+------------------+------------------------------+-----------------------
- 2 | 0 | 0 | 0 | 0
+ 2 | 0 | 1 | 0 | 0
(1 row)
-- Perform single min/max reset
@@ -71,7 +71,7 @@
WHERE query LIKE '%STMTTS%';
total | minmax_plan_zero | minmax_exec_zero | minmax_stats_since_after_ref | stats_since_after_ref
-------+------------------+------------------+------------------------------+-----------------------
- 2 | 1 | 1 | 1 | 0
+ 2 | 1 | 2 | 1 | 0
(1 row)
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/entry_timestamp.out /tmp/cirrus-ci-build/contrib/pg_st...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/entry_timestamp.out 2025-03-27 16:48:19.832831557 +0000
+++ /tmp/cirrus-ci-build/contrib/pg_stat_statements/results/entry_timestamp.out 2025-03-27 16:54:21.118834794 +0000
@@ -45,7 +45,7 @@
WHERE query LIKE '%STMTTS%';
total | minmax_plan_zero | minmax_exec_zero | minmax_stats_since_after_ref | stats_since_after_ref
-------+------------------+------------------+------------------------------+-----------------------
- 2 | 0 | 0 | 0 | 0
+ 2 | 0 | 2 | 0 | 0
(1 row)
-- Perform single min/max reset
@@ -71,7 +71,7 @@
WHERE query LIKE '%STMTTS%';
total | minmax_plan_zero | minmax_exec_zero | minmax_stats_since_after_ref | stats_since_after_ref
-------+------------------+------------------+------------------------------+-----------------------
- 2 | 1 | 1 | 1 | 0
+ 2 | 1 | 2 | 1 | 0
(1 row)
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/entry_timestamp.out /tmp/cirrus-ci-build/build/testrun...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/entry_timestamp.out 2025-03-27 16:48:16.911619139 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_stat_statements/regress/results/entry_timestamp.out 2025-03-27 16:54:57.678706...
@@ -45,7 +45,7 @@
WHERE query LIKE '%STMTTS%';
total | minmax_plan_zero | minmax_exec_zero | minmax_stats_since_after_ref | stats_since_after_ref
-------+------------------+------------------+------------------------------+-----------------------
- 2 | 0 | 0 | 0 | 0
+ 2 | 0 | 2 | 0 | 0
(1 row)
-- Perform single min/max reset
@@ -71,7 +71,7 @@
WHERE query LIKE '%STMTTS%';
total | minmax_plan_zero | minmax_exec_zero | minmax_stats_since_after_ref | stats_since_after_ref
-------+------------------+------------------+------------------------------+-----------------------
- 2 | 1 | 1 | 1 | 0
+ 2 | 1 | 2 | 1 | 0
(1 row)
... |