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.
| 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)
... |
| 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/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/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/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/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/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/4735 |
Support a wildcard in backtrace_functions |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_overexplain/expected/pg_overexplain.out /tmp/cirrus-ci-build/build/testrun/pg_o...
--- /tmp/cirrus-ci-build/contrib/pg_overexplain/expected/pg_overexplain.out 2025-03-26 18:14:03.523615000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_overexplain/regress/results/pg_overexplain.out 2025-03-26 18:17:43.269052000 +...
@@ -387,25 +387,25 @@
Nested Loop (actual rows=8.00 loops=1)
Disabled Nodes: 0
Parallel Safe: true
- Plan Node ID: 0
+ Plan Node ID: 1
-> Append (actual rows=8.00 loops=1)
Disabled Nodes: 0
Parallel Safe: true
- Plan Node ID: 1
+ Plan Node ID: 2
-> Index Scan using brassica_id_idx on brassica v1_1 (actual rows=7.00 loops=1)
Index Searches: 1
Disabled Nodes: 0
Parallel Safe: true
- Plan Node ID: 2
+ Plan Node ID: 3
... |
| 52/5487 |
Exists pull-up application with JoinExpr |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-03-20 06:04:53.285663000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2025-03-20 06:06:57.29160100...
@@ -822,16 +822,17 @@
FROM tb
JOIN tc
ON ta.id = tb.id);
- QUERY PLAN
--------------------------------------------------------------------------
- Nested Loop Semi Join (actual rows=2 loops=1)
- -> Seq Scan on ta (actual rows=2 loops=1)
- -> Nested Loop (actual rows=1 loops=2)
- -> Index Only Scan using tb_pkey on tb (actual rows=1 loops=2)
+ QUERY PLAN
+----------------------------------------------------------------------------
+ Nested Loop Semi Join (actual rows=2.00 loops=1)
+ -> Seq Scan on ta (actual rows=2.00 loops=1)
+ -> Nested Loop (actual rows=1.00 loops=2)
+ -> Index Only Scan using tb_pkey on tb (actual rows=1.00 loops=2)
Index Cond: (id = ta.id)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-03-20 06:04:51.808332000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2025-03-20 06:08:15.937699000 +0000
@@ -4838,13 +4838,15 @@
EXISTS (SELECT 1 FROM ft4 WHERE ft4.c2 = ft2.c2))
AND ft2.c1 > 900
ORDER BY ft2.c1 LIMIT 10;
- ...
------------------------------------------------------------------------------------------------------------------------...
- Foreign Scan
+ ...
+-----------------------------------------------------------------------------------------------------------------------...
+ Limit
Output: ft2.c1, ft2.c2, ft2.c3, ft2.c4, ft2.c5, ft2.c6, ft2.c7, ft2.c8
- Relations: (public.ft2) SEMI JOIN ((public.ft2 ft2_1) SEMI JOIN (public.ft4))
- Remote SQL: SELECT r1."C 1", r1.c2, r1.c3, r1.c4, r1.c5, r1.c6, r1.c7, r1.c8 FROM "S 1"."T 1" r1 WHERE ((r1."C 1" > ...
-(4 rows)
+ -> Foreign Scan
+ Output: ft2.c1, ft2.c2, ft2.c3, ft2.c4, ft2.c5, ft2.c6, ft2.c7, ft2.c8
+ Relations: (public.ft2) SEMI JOIN ((public.ft2 ft2_1) SEMI JOIN (public.ft4))
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/recovery/027_st...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-03-20 06:04:53.285663000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2025-03-20 06:07:51.555645...
@@ -822,16 +822,17 @@
FROM tb
JOIN tc
ON ta.id = tb.id);
- QUERY PLAN
--------------------------------------------------------------------------
- Nested Loop Semi Join (actual rows=2 loops=1)
- -> Seq Scan on ta (actual rows=2 loops=1)
- -> Nested Loop (actual rows=1 loops=2)
- -> Index Only Scan using tb_pkey on tb (actual rows=1 loops=2)
+ QUERY PLAN
+----------------------------------------------------------------------------
+ Nested Loop Semi Join (actual rows=2.00 loops=1)
+ -> Seq Scan on ta (actual rows=2.00 loops=1)
+ -> Nested Loop (actual rows=1.00 loops=2)
+ -> Index Only Scan using tb_pkey on tb (actual rows=1.00 loops=2)
Index Cond: (id = ta.id)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/regress/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-03-20 06:04:53.285663000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/subselect.out 2025-03-20 06:06:53.110382000 +0000
@@ -822,16 +822,17 @@
FROM tb
JOIN tc
ON ta.id = tb.id);
- QUERY PLAN
--------------------------------------------------------------------------
- Nested Loop Semi Join (actual rows=2 loops=1)
- -> Seq Scan on ta (actual rows=2 loops=1)
- -> Nested Loop (actual rows=1 loops=2)
- -> Index Only Scan using tb_pkey on tb (actual rows=1 loops=2)
+ QUERY PLAN
+----------------------------------------------------------------------------
+ Nested Loop Semi Join (actual rows=2.00 loops=1)
+ -> Seq Scan on ta (actual rows=2.00 loops=1)
+ -> Nested Loop (actual rows=1.00 loops=2)
+ -> Index Only Scan using tb_pkey on tb (actual rows=1.00 loops=2)
Index Cond: (id = ta.id)
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/contrib/postgres_fdw/r...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-03-20 06:04:48.738306190 +0000
+++ /tmp/cirrus-ci-build/contrib/postgres_fdw/results/postgres_fdw.out 2025-03-20 06:11:23.534303642 +0000
@@ -4838,13 +4838,15 @@
EXISTS (SELECT 1 FROM ft4 WHERE ft4.c2 = ft2.c2))
AND ft2.c1 > 900
ORDER BY ft2.c1 LIMIT 10;
- ...
------------------------------------------------------------------------------------------------------------------------...
- Foreign Scan
+ ...
+-----------------------------------------------------------------------------------------------------------------------...
+ Limit
Output: ft2.c1, ft2.c2, ft2.c3, ft2.c4, ft2.c5, ft2.c6, ft2.c7, ft2.c8
- Relations: (public.ft2) SEMI JOIN ((public.ft2 ft2_1) SEMI JOIN (public.ft4))
- Remote SQL: SELECT r1."C 1", r1.c2, r1.c3, r1.c4, r1.c5, r1.c6, r1.c7, r1.c8 FROM "S 1"."T 1" r1 WHERE ((r1."C 1" > ...
-(4 rows)
+ -> Foreign Scan
+ Output: ft2.c1, ft2.c2, ft2.c3, ft2.c4, ft2.c5, ft2.c6, ft2.c7, ft2.c8
+ Relations: (public.ft2) SEMI JOIN ((public.ft2 ft2_1) SEMI JOIN (public.ft4))
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-03-20 06:04:50.568927793 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/subselect.out 2025-03-20 06:11:19.682262404 +0000
@@ -822,16 +822,17 @@
FROM tb
JOIN tc
ON ta.id = tb.id);
- QUERY PLAN
--------------------------------------------------------------------------
- Nested Loop Semi Join (actual rows=2 loops=1)
- -> Seq Scan on ta (actual rows=2 loops=1)
- -> Nested Loop (actual rows=1 loops=2)
- -> Index Only Scan using tb_pkey on tb (actual rows=1 loops=2)
+ QUERY PLAN
+----------------------------------------------------------------------------
+ Nested Loop Semi Join (actual rows=2.00 loops=1)
+ -> Seq Scan on ta (actual rows=2.00 loops=1)
+ -> Nested Loop (actual rows=1.00 loops=2)
+ -> Index Only Scan using tb_pkey on tb (actual rows=1.00 loops=2)
Index Cond: (id = ta.id)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/src/test/regress/results/subs...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-03-20 06:04:50.568927793 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/subselect.out 2025-03-20 06:08:53.485662780 +0000
@@ -822,16 +822,17 @@
FROM tb
JOIN tc
ON ta.id = tb.id);
- QUERY PLAN
--------------------------------------------------------------------------
- Nested Loop Semi Join (actual rows=2 loops=1)
- -> Seq Scan on ta (actual rows=2 loops=1)
- -> Nested Loop (actual rows=1 loops=2)
- -> Index Only Scan using tb_pkey on tb (actual rows=1 loops=2)
+ QUERY PLAN
+----------------------------------------------------------------------------
+ Nested Loop Semi Join (actual rows=2.00 loops=1)
+ -> Seq Scan on ta (actual rows=2.00 loops=1)
+ -> Nested Loop (actual rows=1.00 loops=2)
+ -> Index Only Scan using tb_pkey on tb (actual rows=1.00 loops=2)
Index Cond: (id = ta.id)
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-03-20 06:04:51.191265988 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2025-03-20 06:09:06.69361857...
@@ -822,16 +822,17 @@
FROM tb
JOIN tc
ON ta.id = tb.id);
- QUERY PLAN
--------------------------------------------------------------------------
- Nested Loop Semi Join (actual rows=2 loops=1)
- -> Seq Scan on ta (actual rows=2 loops=1)
- -> Nested Loop (actual rows=1 loops=2)
- -> Index Only Scan using tb_pkey on tb (actual rows=1 loops=2)
+ QUERY PLAN
+----------------------------------------------------------------------------
+ Nested Loop Semi Join (actual rows=2.00 loops=1)
+ -> Seq Scan on ta (actual rows=2.00 loops=1)
+ -> Nested Loop (actual rows=1.00 loops=2)
+ -> Index Only Scan using tb_pkey on tb (actual rows=1.00 loops=2)
Index Cond: (id = ta.id)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-03-20 06:04:49.330769931 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2025-03-20 06:10:29.837768430 +0000
@@ -4838,13 +4838,15 @@
EXISTS (SELECT 1 FROM ft4 WHERE ft4.c2 = ft2.c2))
AND ft2.c1 > 900
ORDER BY ft2.c1 LIMIT 10;
- ...
------------------------------------------------------------------------------------------------------------------------...
- Foreign Scan
+ ...
+-----------------------------------------------------------------------------------------------------------------------...
+ Limit
Output: ft2.c1, ft2.c2, ft2.c3, ft2.c4, ft2.c5, ft2.c6, ft2.c7, ft2.c8
- Relations: (public.ft2) SEMI JOIN ((public.ft2 ft2_1) SEMI JOIN (public.ft4))
- Remote SQL: SELECT r1."C 1", r1.c2, r1.c3, r1.c4, r1.c5, r1.c6, r1.c7, r1.c8 FROM "S 1"."T 1" r1 WHERE ((r1."C 1" > ...
-(4 rows)
+ -> Foreign Scan
+ Output: ft2.c1, ft2.c2, ft2.c3, ft2.c4, ft2.c5, ft2.c6, ft2.c7, ft2.c8
+ Relations: (public.ft2) SEMI JOIN ((public.ft2 ft2_1) SEMI JOIN (public.ft4))
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/recovery/027_st...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-03-20 06:04:51.191265988 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2025-03-20 06:09:49.741624...
@@ -822,16 +822,17 @@
FROM tb
JOIN tc
ON ta.id = tb.id);
- QUERY PLAN
--------------------------------------------------------------------------
- Nested Loop Semi Join (actual rows=2 loops=1)
- -> Seq Scan on ta (actual rows=2 loops=1)
- -> Nested Loop (actual rows=1 loops=2)
- -> Index Only Scan using tb_pkey on tb (actual rows=1 loops=2)
+ QUERY PLAN
+----------------------------------------------------------------------------
+ Nested Loop Semi Join (actual rows=2.00 loops=1)
+ -> Seq Scan on ta (actual rows=2.00 loops=1)
+ -> Nested Loop (actual rows=1.00 loops=2)
+ -> Index Only Scan using tb_pkey on tb (actual rows=1.00 loops=2)
Index Cond: (id = ta.id)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/regress/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2025-03-20 06:04:51.191265988 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/subselect.out 2025-03-20 06:09:01.541633955 +0000
@@ -822,16 +822,17 @@
FROM tb
JOIN tc
ON ta.id = tb.id);
- QUERY PLAN
--------------------------------------------------------------------------
- Nested Loop Semi Join (actual rows=2 loops=1)
- -> Seq Scan on ta (actual rows=2 loops=1)
- -> Nested Loop (actual rows=1 loops=2)
- -> Index Only Scan using tb_pkey on tb (actual rows=1 loops=2)
+ QUERY PLAN
+----------------------------------------------------------------------------
+ Nested Loop Semi Join (actual rows=2.00 loops=1)
+ -> Seq Scan on ta (actual rows=2.00 loops=1)
+ -> Nested Loop (actual rows=1.00 loops=2)
+ -> Index Only Scan using tb_pkey on tb (actual rows=1.00 loops=2)
Index Cond: (id = ta.id)
... |
|
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-03-20 06:04:13
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2025-03-20 06:06:17
@@ -822,16 +822,17 @@
FROM tb
JOIN tc
ON ta.id = tb.id);
- QUERY PLAN
--------------------------------------------------------------------------
- Nested Loop Semi Join (actual rows=2 loops=1)
- -> Seq Scan on ta (actual rows=2 loops=1)
- -> Nested Loop (actual rows=1 loops=2)
- -> Index Only Scan using tb_pkey on tb (actual rows=1 loops=2)
+ QUERY PLAN
+----------------------------------------------------------------------------
+ Nested Loop Semi Join (actual rows=2.00 loops=1)
+ -> Seq Scan on ta (actual rows=2.00 loops=1)
+ -> Nested Loop (actual rows=1.00 loops=2)
+ -> Index Only Scan using tb_pkey on tb (actual rows=1.00 loops=2)
Index Cond: (id = ta.id)
... |
| regress |
diff -U3 /Users/admin/pgsql/contrib/postgres_fdw/expected/postgres_fdw.out /Users/admin/pgsql/build/testrun/postgres_fdw...
--- /Users/admin/pgsql/contrib/postgres_fdw/expected/postgres_fdw.out 2025-03-20 06:04:11
+++ /Users/admin/pgsql/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2025-03-20 06:07:45
@@ -4838,13 +4838,15 @@
EXISTS (SELECT 1 FROM ft4 WHERE ft4.c2 = ft2.c2))
AND ft2.c1 > 900
ORDER BY ft2.c1 LIMIT 10;
- ...
------------------------------------------------------------------------------------------------------------------------...
- Foreign Scan
+ ...
+-----------------------------------------------------------------------------------------------------------------------...
+ Limit
Output: ft2.c1, ft2.c2, ft2.c3, ft2.c4, ft2.c5, ft2.c6, ft2.c7, ft2.c8
- Relations: (public.ft2) SEMI JOIN ((public.ft2 ft2_1) SEMI JOIN (public.ft4))
- Remote SQL: SELECT r1."C 1", r1.c2, r1.c3, r1.c4, r1.c5, r1.c6, r1.c7, r1.c8 FROM "S 1"."T 1" r1 WHERE ((r1."C 1" > ...
-(4 rows)
+ -> Foreign Scan
+ Output: ft2.c1, ft2.c2, ft2.c3, ft2.c4, ft2.c5, ft2.c6, ft2.c7, ft2.c8
+ Relations: (public.ft2) SEMI JOIN ((public.ft2 ft2_1) SEMI JOIN (public.ft4))
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/subselect.out /Users/admin/pgsql/build/testrun/recovery/027_stream...
--- /Users/admin/pgsql/src/test/regress/expected/subselect.out 2025-03-20 06:04:13
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2025-03-20 06:07:10
@@ -822,16 +822,17 @@
FROM tb
JOIN tc
ON ta.id = tb.id);
- QUERY PLAN
--------------------------------------------------------------------------
- Nested Loop Semi Join (actual rows=2 loops=1)
- -> Seq Scan on ta (actual rows=2 loops=1)
- -> Nested Loop (actual rows=1 loops=2)
- -> Index Only Scan using tb_pkey on tb (actual rows=1 loops=2)
+ QUERY PLAN
+----------------------------------------------------------------------------
+ Nested Loop Semi Join (actual rows=2.00 loops=1)
+ -> Seq Scan on ta (actual rows=2.00 loops=1)
+ -> Nested Loop (actual rows=1.00 loops=2)
+ -> Index Only Scan using tb_pkey on tb (actual rows=1.00 loops=2)
Index Cond: (id = ta.id)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/subselect.out /Users/admin/pgsql/build/testrun/regress/regress/res...
--- /Users/admin/pgsql/src/test/regress/expected/subselect.out 2025-03-20 06:04:13
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/subselect.out 2025-03-20 06:06:16
@@ -822,16 +822,17 @@
FROM tb
JOIN tc
ON ta.id = tb.id);
- QUERY PLAN
--------------------------------------------------------------------------
- Nested Loop Semi Join (actual rows=2 loops=1)
- -> Seq Scan on ta (actual rows=2 loops=1)
- -> Nested Loop (actual rows=1 loops=2)
- -> Index Only Scan using tb_pkey on tb (actual rows=1 loops=2)
+ QUERY PLAN
+----------------------------------------------------------------------------
+ Nested Loop Semi Join (actual rows=2.00 loops=1)
+ -> Seq Scan on ta (actual rows=2.00 loops=1)
+ -> Nested Loop (actual rows=1.00 loops=2)
+ -> Index Only Scan using tb_pkey on tb (actual rows=1.00 loops=2)
Index Cond: (id = ta.id)
... |
|
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-03-20 06:04:54.387946900 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2025-03-20 06:07:34.393290200 +0000
@@ -822,16 +822,17 @@
FROM tb
JOIN tc
ON ta.id = tb.id);
- QUERY PLAN
--------------------------------------------------------------------------
- Nested Loop Semi Join (actual rows=2 loops=1)
- -> Seq Scan on ta (actual rows=2 loops=1)
- -> Nested Loop (actual rows=1 loops=2)
- -> Index Only Scan using tb_pkey on tb (actual rows=1 loops=2)
+ QUERY PLAN
+----------------------------------------------------------------------------
+ Nested Loop Semi Join (actual rows=2.00 loops=1)
+ -> Seq Scan on ta (actual rows=2.00 loops=1)
+ -> Nested Loop (actual rows=1.00 loops=2)
+ -> Index Only Scan using tb_pkey on tb (actual rows=1.00 loops=2)
Index Cond: (id = ta.id)
... |
| 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-20 06:04:50.205707000 +0000
+++ C:/cirrus/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2025-03-20 06:12:02.062233200 +0000
@@ -4838,13 +4838,15 @@
EXISTS (SELECT 1 FROM ft4 WHERE ft4.c2 = ft2.c2))
AND ft2.c1 > 900
ORDER BY ft2.c1 LIMIT 10;
- ...
------------------------------------------------------------------------------------------------------------------------...
- Foreign Scan
+ ...
+-----------------------------------------------------------------------------------------------------------------------...
+ Limit
Output: ft2.c1, ft2.c2, ft2.c3, ft2.c4, ft2.c5, ft2.c6, ft2.c7, ft2.c8
- Relations: (public.ft2) SEMI JOIN ((public.ft2 ft2_1) SEMI JOIN (public.ft4))
- Remote SQL: SELECT r1."C 1", r1.c2, r1.c3, r1.c4, r1.c5, r1.c6, r1.c7, r1.c8 FROM "S 1"."T 1" r1 WHERE ((r1."C 1" > ...
-(4 rows)
+ -> Foreign Scan
+ Output: ft2.c1, ft2.c2, ft2.c3, ft2.c4, ft2.c5, ft2.c6, ft2.c7, ft2.c8
+ Relations: (public.ft2) SEMI JOIN ((public.ft2 ft2_1) SEMI JOIN (public.ft4))
... |
| 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-20 06:04:54.387946900 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2025-03-20 06:09:59.611498100 +0000
@@ -822,16 +822,17 @@
FROM tb
JOIN tc
ON ta.id = tb.id);
- QUERY PLAN
--------------------------------------------------------------------------
- Nested Loop Semi Join (actual rows=2 loops=1)
- -> Seq Scan on ta (actual rows=2 loops=1)
- -> Nested Loop (actual rows=1 loops=2)
- -> Index Only Scan using tb_pkey on tb (actual rows=1 loops=2)
+ QUERY PLAN
+----------------------------------------------------------------------------
+ Nested Loop Semi Join (actual rows=2.00 loops=1)
+ -> Seq Scan on ta (actual rows=2.00 loops=1)
+ -> Nested Loop (actual rows=1.00 loops=2)
+ -> Index Only Scan using tb_pkey on tb (actual rows=1.00 loops=2)
Index Cond: (id = ta.id)
... |
| 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-20 06:04:54.387946900 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/subselect.out 2025-03-20 06:07:25.300077000 +0000
@@ -822,16 +822,17 @@
FROM tb
JOIN tc
ON ta.id = tb.id);
- QUERY PLAN
--------------------------------------------------------------------------
- Nested Loop Semi Join (actual rows=2 loops=1)
- -> Seq Scan on ta (actual rows=2 loops=1)
- -> Nested Loop (actual rows=1 loops=2)
- -> Index Only Scan using tb_pkey on tb (actual rows=1 loops=2)
+ QUERY PLAN
+----------------------------------------------------------------------------
+ Nested Loop Semi Join (actual rows=2.00 loops=1)
+ -> Seq Scan on ta (actual rows=2.00 loops=1)
+ -> Nested Loop (actual rows=1.00 loops=2)
+ -> Index Only Scan using tb_pkey on tb (actual rows=1.00 loops=2)
Index Cond: (id = ta.id)
... |
| 52/4904 |
SQL Property Graph Queries (SQL/PGQ) |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/privileges.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002...
--- /tmp/cirrus-ci-build/src/test/regress/expected/privileges.out 2025-03-18 01:20:00.532849000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/privileges.out 2025-03-18 01:22:43.7534400...
@@ -3046,368 +3046,7 @@
create view atpgv1 as select * from graph_table (ptg1 match ( : atest1) COLUMNS (1 as value)) limit 0;
grant select on atpgv1 to regress_priv_user3;
select * from atpgv1; -- ok
- value
--------
-(0 rows)
-
-set session role regress_priv_user3;
-select * from atpgv1; -- ok
- value
--------
-(0 rows)
-
-set session role regress_priv_user4;
-create view atpgv2 as select * from graph_table (ptg1 match (v : ltv) COLUMNS (v.ltvk)) limit 0;
--- though the session user is the owner of the view and also has access to the
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/privileges.out /tmp/cirrus-ci-build/build/testrun/recovery/027_s...
--- /tmp/cirrus-ci-build/src/test/regress/expected/privileges.out 2025-03-18 01:20:00.532849000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/privileges.out 2025-03-18 01:23:30.18193...
@@ -3046,368 +3046,7 @@
create view atpgv1 as select * from graph_table (ptg1 match ( : atest1) COLUMNS (1 as value)) limit 0;
grant select on atpgv1 to regress_priv_user3;
select * from atpgv1; -- ok
- value
--------
-(0 rows)
-
-set session role regress_priv_user3;
-select * from atpgv1; -- ok
- value
--------
-(0 rows)
-
-set session role regress_priv_user4;
-create view atpgv2 as select * from graph_table (ptg1 match (v : ltv) COLUMNS (v.ltvk)) limit 0;
--- though the session user is the owner of the view and also has access to the
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/privileges.out /tmp/cirrus-ci-build/build/testrun/regress/regres...
--- /tmp/cirrus-ci-build/src/test/regress/expected/privileges.out 2025-03-18 01:20:00.532849000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/privileges.out 2025-03-18 01:22:45.518519000 +0000
@@ -3046,368 +3046,7 @@
create view atpgv1 as select * from graph_table (ptg1 match ( : atest1) COLUMNS (1 as value)) limit 0;
grant select on atpgv1 to regress_priv_user3;
select * from atpgv1; -- ok
- value
--------
-(0 rows)
-
-set session role regress_priv_user3;
-select * from atpgv1; -- ok
- value
--------
-(0 rows)
-
-set session role regress_priv_user4;
-create view atpgv2 as select * from graph_table (ptg1 match (v : ltv) COLUMNS (v.ltvk)) limit 0;
--- though the session user is the owner of the view and also has access to the
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/privileges.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check...
--- /tmp/cirrus-ci-build/src/test/regress/expected/privileges.out 2025-03-18 01:20:00.955172408 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/privileges.out 2025-03-18 01:27:12.028787332 +0000
@@ -3046,368 +3046,7 @@
create view atpgv1 as select * from graph_table (ptg1 match ( : atest1) COLUMNS (1 as value)) limit 0;
grant select on atpgv1 to regress_priv_user3;
select * from atpgv1; -- ok
- value
--------
-(0 rows)
-
-set session role regress_priv_user3;
-select * from atpgv1; -- ok
- value
--------
-(0 rows)
-
-set session role regress_priv_user4;
-create view atpgv2 as select * from graph_table (ptg1 match (v : ltv) COLUMNS (v.ltvk)) limit 0;
--- though the session user is the owner of the view and also has access to the
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/privileges.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/privileges.out 2025-03-18 01:20:00.955172408 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/privileges.out 2025-03-18 01:28:34.952493179 +0000
@@ -3046,368 +3046,7 @@
create view atpgv1 as select * from graph_table (ptg1 match ( : atest1) COLUMNS (1 as value)) limit 0;
grant select on atpgv1 to regress_priv_user3;
select * from atpgv1; -- ok
- value
--------
-(0 rows)
-
-set session role regress_priv_user3;
-select * from atpgv1; -- ok
- value
--------
-(0 rows)
-
-set session role regress_priv_user4;
-create view atpgv2 as select * from graph_table (ptg1 match (v : ltv) COLUMNS (v.ltvk)) limit 0;
--- though the session user is the owner of the view and also has access to the
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/privileges.out /tmp/cirrus-ci-build/src/test/regress/results/pri...
--- /tmp/cirrus-ci-build/src/test/regress/expected/privileges.out 2025-03-18 01:20:00.955172408 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/privileges.out 2025-03-18 01:24:47.071673945 +0000
@@ -3046,368 +3046,7 @@
create view atpgv1 as select * from graph_table (ptg1 match ( : atest1) COLUMNS (1 as value)) limit 0;
grant select on atpgv1 to regress_priv_user3;
select * from atpgv1; -- ok
- value
--------
-(0 rows)
-
-set session role regress_priv_user3;
-select * from atpgv1; -- ok
- value
--------
-(0 rows)
-
-set session role regress_priv_user4;
-create view atpgv2 as select * from graph_table (ptg1 match (v : ltv) COLUMNS (v.ltvk)) limit 0;
--- though the session user is the owner of the view and also has access to the
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/privileges.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002...
--- /tmp/cirrus-ci-build/src/test/regress/expected/privileges.out 2025-03-18 01:20:02.230204189 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/privileges.out 2025-03-18 01:25:04.5118183...
@@ -3046,368 +3046,7 @@
create view atpgv1 as select * from graph_table (ptg1 match ( : atest1) COLUMNS (1 as value)) limit 0;
grant select on atpgv1 to regress_priv_user3;
select * from atpgv1; -- ok
- value
--------
-(0 rows)
-
-set session role regress_priv_user3;
-select * from atpgv1; -- ok
- value
--------
-(0 rows)
-
-set session role regress_priv_user4;
-create view atpgv2 as select * from graph_table (ptg1 match (v : ltv) COLUMNS (v.ltvk)) limit 0;
--- though the session user is the owner of the view and also has access to the
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/privileges.out /tmp/cirrus-ci-build/build/testrun/recovery/027_s...
--- /tmp/cirrus-ci-build/src/test/regress/expected/privileges.out 2025-03-18 01:20:02.230204189 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/privileges.out 2025-03-18 01:25:40.64392...
@@ -3046,368 +3046,7 @@
create view atpgv1 as select * from graph_table (ptg1 match ( : atest1) COLUMNS (1 as value)) limit 0;
grant select on atpgv1 to regress_priv_user3;
select * from atpgv1; -- ok
- value
--------
-(0 rows)
-
-set session role regress_priv_user3;
-select * from atpgv1; -- ok
- value
--------
-(0 rows)
-
-set session role regress_priv_user4;
-create view atpgv2 as select * from graph_table (ptg1 match (v : ltv) COLUMNS (v.ltvk)) limit 0;
--- though the session user is the owner of the view and also has access to the
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/privileges.out /tmp/cirrus-ci-build/build/testrun/regress/regres...
--- /tmp/cirrus-ci-build/src/test/regress/expected/privileges.out 2025-03-18 01:20:02.230204189 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/privileges.out 2025-03-18 01:25:01.491812189 +0000
@@ -3046,368 +3046,7 @@
create view atpgv1 as select * from graph_table (ptg1 match ( : atest1) COLUMNS (1 as value)) limit 0;
grant select on atpgv1 to regress_priv_user3;
select * from atpgv1; -- ok
- value
--------
-(0 rows)
-
-set session role regress_priv_user3;
-select * from atpgv1; -- ok
- value
--------
-(0 rows)
-
-set session role regress_priv_user4;
-create view atpgv2 as select * from graph_table (ptg1 match (v : ltv) COLUMNS (v.ltvk)) limit 0;
--- though the session user is the owner of the view and also has access to the
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/privileges.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_...
--- /Users/admin/pgsql/src/test/regress/expected/privileges.out 2025-03-18 01:20:15
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/privileges.out 2025-03-18 01:24:19
@@ -3046,368 +3046,7 @@
create view atpgv1 as select * from graph_table (ptg1 match ( : atest1) COLUMNS (1 as value)) limit 0;
grant select on atpgv1 to regress_priv_user3;
select * from atpgv1; -- ok
- value
--------
-(0 rows)
-
-set session role regress_priv_user3;
-select * from atpgv1; -- ok
- value
--------
-(0 rows)
-
-set session role regress_priv_user4;
-create view atpgv2 as select * from graph_table (ptg1 match (v : ltv) COLUMNS (v.ltvk)) limit 0;
--- though the session user is the owner of the view and also has access to the
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/privileges.out /Users/admin/pgsql/build/testrun/recovery/027_strea...
--- /Users/admin/pgsql/src/test/regress/expected/privileges.out 2025-03-18 01:20:15
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/privileges.out 2025-03-18 01:25:06
@@ -3046,368 +3046,7 @@
create view atpgv1 as select * from graph_table (ptg1 match ( : atest1) COLUMNS (1 as value)) limit 0;
grant select on atpgv1 to regress_priv_user3;
select * from atpgv1; -- ok
- value
--------
-(0 rows)
-
-set session role regress_priv_user3;
-select * from atpgv1; -- ok
- value
--------
-(0 rows)
-
-set session role regress_priv_user4;
-create view atpgv2 as select * from graph_table (ptg1 match (v : ltv) COLUMNS (v.ltvk)) limit 0;
--- though the session user is the owner of the view and also has access to the
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/privileges.out /Users/admin/pgsql/build/testrun/regress/regress/re...
--- /Users/admin/pgsql/src/test/regress/expected/privileges.out 2025-03-18 01:20:15
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/privileges.out 2025-03-18 01:24:19
@@ -3046,368 +3046,7 @@
create view atpgv1 as select * from graph_table (ptg1 match ( : atest1) COLUMNS (1 as value)) limit 0;
grant select on atpgv1 to regress_priv_user3;
select * from atpgv1; -- ok
- value
--------
-(0 rows)
-
-set session role regress_priv_user3;
-select * from atpgv1; -- ok
- value
--------
-(0 rows)
-
-set session role regress_priv_user4;
-create view atpgv2 as select * from graph_table (ptg1 match (v : ltv) COLUMNS (v.ltvk)) limit 0;
--- though the session user is the owner of the view and also has access to the
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/privileges.out C:/cirrus/build/testrun/pg_upgrade/002_p...
--- C:/cirrus/src/test/regress/expected/privileges.out 2025-03-18 01:20:07.126854400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/privileges.out 2025-03-18 01:22:47.561328900 +0000
@@ -3046,368 +3046,7 @@
create view atpgv1 as select * from graph_table (ptg1 match ( : atest1) COLUMNS (1 as value)) limit 0;
grant select on atpgv1 to regress_priv_user3;
select * from atpgv1; -- ok
- value
--------
-(0 rows)
-
-set session role regress_priv_user3;
-select * from atpgv1; -- ok
- value
--------
-(0 rows)
-
-set session role regress_priv_user4;
-create view atpgv2 as select * from graph_table (ptg1 match (v : ltv) COLUMNS (v.ltvk)) limit 0;
--- though the session user is the owner of the view and also has access to the
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/privileges.out C:/cirrus/build/testrun/recovery/027_str...
--- C:/cirrus/src/test/regress/expected/privileges.out 2025-03-18 01:20:07.126854400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/privileges.out 2025-03-18 01:24:39.498542800 +0000
@@ -3046,368 +3046,7 @@
create view atpgv1 as select * from graph_table (ptg1 match ( : atest1) COLUMNS (1 as value)) limit 0;
grant select on atpgv1 to regress_priv_user3;
select * from atpgv1; -- ok
- value
--------
-(0 rows)
-
-set session role regress_priv_user3;
-select * from atpgv1; -- ok
- value
--------
-(0 rows)
-
-set session role regress_priv_user4;
-create view atpgv2 as select * from graph_table (ptg1 match (v : ltv) COLUMNS (v.ltvk)) limit 0;
--- though the session user is the owner of the view and also has access to the
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/privileges.out C:/cirrus/build/testrun/regress/regress/...
--- C:/cirrus/src/test/regress/expected/privileges.out 2025-03-18 01:20:07.126854400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/privileges.out 2025-03-18 01:22:42.154589400 +0000
@@ -3046,368 +3046,7 @@
create view atpgv1 as select * from graph_table (ptg1 match ( : atest1) COLUMNS (1 as value)) limit 0;
grant select on atpgv1 to regress_priv_user3;
select * from atpgv1; -- ok
- value
--------
-(0 rows)
-
-set session role regress_priv_user3;
-select * from atpgv1; -- ok
- value
--------
-(0 rows)
-
-set session role regress_priv_user4;
-create view atpgv2 as select * from graph_table (ptg1 match (v : ltv) COLUMNS (v.ltvk)) limit 0;
--- though the session user is the owner of the view and also has access to the
... |
| 53/5004 |
CREATE INDEX CONCURRENTLY for partitioned tables |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2025-03-17 21:54:59.242036000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2025-03-17 22:00:11.341502000...
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2025-03-17 21:54:59.242036000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2025-03-17 22:01:04.5978230...
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2025-03-17 21:54:59.242036000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/indexing.out 2025-03-17 22:00:19.215216000 +0000
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2025-03-17 21:54:59.597411435 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/indexing.out 2025-03-17 22:03:52.353099440 +0000
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/partitioned-cic.out /tmp/cirrus-ci-build/src/test/isolation/ou...
--- /tmp/cirrus-ci-build/src/test/isolation/expected/partitioned-cic.out 2025-03-17 21:54:59.434078221 +0000
+++ /tmp/cirrus-ci-build/src/test/isolation/output_iso/results/partitioned-cic.out 2025-03-17 22:25:25.101890453 +0000
@@ -3,10 +3,14 @@
starting permutation: lock_p1 cic insert drop2 commit chk_content
step lock_p1: lock cictab_part_1 in row exclusive mode;
step cic: CREATE INDEX CONCURRENTLY ON cictab(i); <waiting ...>
-step insert: insert into cictab values (1, 1), (11, 1);
-step drop2: DROP TABLE cictab_part_2;
+step insert: insert into cictab values (1, 1), (11, 1); <waiting ...>
+isolationtester: canceling step insert after 360 seconds
+step insert: <... completed>
+ERROR: canceling statement due to user request
+step drop2: DROP TABLE cictab_part_2; <waiting ...>
step commit: COMMIT;
step cic: <... completed>
+step drop2: <... completed>
step chk_content:
set enable_seqscan to off;
explain (costs off) select * from cictab where i > 0;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/test/regress/results/index...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2025-03-17 21:54:59.597411435 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/indexing.out 2025-03-17 22:01:44.437236280 +0000
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2025-03-17 21:54:57.429403469 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2025-03-17 22:00:47.359528498...
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2025-03-17 21:54:57.429403469 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2025-03-17 22:01:22.6113715...
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2025-03-17 21:54:57.429403469 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/indexing.out 2025-03-17 22:00:41.803551506 +0000
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2025-03-17 21:58:14
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2025-03-17 22:02:22
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2025-03-17 21:58:14
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2025-03-17 22:03:37
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/regress/regress/resu...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2025-03-17 21:58:14
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/indexing.out 2025-03-17 22:02:34
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/indexing.out 2025-03-17 21:55:03.364247600 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2025-03-17 21:59:32.651587400 +0000
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/indexing.out 2025-03-17 21:55:03.364247600 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2025-03-17 22:02:10.909871500 +0000
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/indexing.out 2025-03-17 21:55:03.364247600 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/indexing.out 2025-03-17 21:59:24.936240200 +0000
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
| 52/4881 |
Eager aggregation, take 3 |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-03-17 21:50:06.961459000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2025-03-17 21:53:05.736702000...
@@ -173,7 +173,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(24 rows)
+(25 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-03-17 21:50:06.961459000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2025-03-17 21:53:56.6971580...
@@ -173,7 +173,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(24 rows)
+(25 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-03-17 21:50:06.961459000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/sysviews.out 2025-03-17 21:53:11.403698000 +0000
@@ -173,7 +173,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(24 rows)
+(25 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-03-17 21:50:04.655299140 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/sysviews.out 2025-03-17 21:57:09.975577407 +0000
@@ -173,7 +173,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(24 rows)
+(25 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/src/test/regress/results/sysvi...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-03-17 21:50:04.655299140 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/sysviews.out 2025-03-17 21:55:16.888433831 +0000
@@ -173,7 +173,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(24 rows)
+(25 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-03-17 21:50:05.196023737 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2025-03-17 21:55:34.483506182...
@@ -173,7 +173,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(24 rows)
+(25 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-03-17 21:50:05.196023737 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2025-03-17 21:56:22.8834794...
@@ -173,7 +173,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(24 rows)
+(25 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-03-17 21:50:05.196023737 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/sysviews.out 2025-03-17 21:55:30.607508611 +0000
@@ -173,7 +173,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(24 rows)
+(25 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/sysviews.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/sysviews.out 2025-03-17 21:50:09
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2025-03-17 21:54:56
@@ -173,7 +173,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(24 rows)
+(25 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/sysviews.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/sysviews.out 2025-03-17 21:50:09
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2025-03-17 21:56:04
@@ -173,7 +173,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(24 rows)
+(25 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/sysviews.out /Users/admin/pgsql/build/testrun/regress/regress/resu...
--- /Users/admin/pgsql/src/test/regress/expected/sysviews.out 2025-03-17 21:50:09
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/sysviews.out 2025-03-17 21:54:53
@@ -173,7 +173,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(24 rows)
+(25 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/sysviews.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/sysviews.out 2025-03-17 21:50:09.980700700 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2025-03-17 21:53:09.631651100 +0000
@@ -173,7 +173,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(24 rows)
+(25 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/sysviews.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/sysviews.out 2025-03-17 21:50:09.980700700 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2025-03-17 21:55:29.772963400 +0000
@@ -173,7 +173,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(24 rows)
+(25 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/sysviews.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/sysviews.out 2025-03-17 21:50:09.980700700 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/sysviews.out 2025-03-17 21:53:05.348424300 +0000
@@ -173,7 +173,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(24 rows)
+(25 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| 52/5595 |
Track and display estimated "work_mem" as well as limit, via EXPLAIN (work_mem on); add hook to override work_mem limits; add extension to override using "workmem.query_work_mem" GUC |
|
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-16 11:18:10.400187000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/foreign_key.out 2025-03-16 11:22:05.426737...
@@ -2882,279 +2882,10 @@
DETAIL: Key (f1)=(-2) is still referenced from table "tbl4".
BEGIN;
UPDATE fkpart10.tbl3 SET f1 = f1 * -1;
-UPDATE fkpart10.tbl1 SET f1 = 3 WHERE f1 = 0;
-INSERT INTO fkpart10.tbl1 VALUES (0);
-INSERT INTO fkpart10.tbl3 VALUES (-2), (-1);
-COMMIT;
--- test where the updated table now has both an IMMEDIATE and a DEFERRED
--- constraint pointing into it
-CREATE TABLE fkpart10.tbl5(f1 int REFERENCES fkpart10.tbl3);
-INSERT INTO fkpart10.tbl5 VALUES (-2), (-1);
-BEGIN;
-UPDATE fkpart10.tbl3 SET f1 = f1 * -3;
-ERROR: update or delete on table "tbl3" violates foreign key constraint "tbl5_f1_fkey" on table "tbl5"
-DETAIL: Key (f1)=(-2) is still referenced from table "tbl5".
-COMMIT;
... |
| 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-16 11:18:10.400187000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/foreign_key.out 2025-03-16 11:22:58.4645...
@@ -1997,1164 +1997,10 @@
-- this one has an FK with mismatched properties
\d fk_partitioned_fk_4_2
- Table "public.fk_partitioned_fk_4_2"
- Column | Type | Collation | Nullable | Default
---------+---------+-----------+----------+---------
- a | integer | | |
- b | integer | | |
-Partition of: fk_partitioned_fk_4 FOR VALUES FROM (100, 100) TO (1000, 1000)
-Foreign-key constraints:
- "fk_partitioned_fk_4_2_a_b_fkey" FOREIGN KEY (a, b) REFERENCES fk_notpartitioned_pk(a, b) ON UPDATE SET NULL
- TABLE "fk_partitioned_fk" CONSTRAINT "fk_partitioned_fk_a_b_fkey" FOREIGN KEY (a, b) REFERENCES fk_notpartitioned_p...
-
-CREATE TABLE fk_partitioned_fk_5 (a int, b int,
- FOREIGN KEY (a, b) REFERENCES fk_notpartitioned_pk(a, b) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE,
- FOREIGN KEY (a, b) REFERENCES fk_notpartitioned_pk(a, b) MATCH FULL ON UPDATE CASCADE ON DELETE CASCADE)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/tsearch.out /tmp/cirrus-ci-build/build/testrun/regress/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/tsearch.out 2025-03-16 11:18:10.468490000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/tsearch.out 2025-03-16 11:22:20.226998000 +0000
@@ -1292,1723 +1292,10 @@
-- ts_debug
SELECT * from ts_debug('english', '<myns:foo-bar_baz.blurfl>abc&nm1;def©ghiõjkl</myns:foo-bar_baz.blurfl>');
- alias | description | token | dictionaries | dictionary | lexemes
------------+-----------------+----------------------------+----------------+--------------+---------
- tag | XML tag | <myns:foo-bar_baz.blurfl> | {} | |
- asciiword | Word, all ASCII | abc | {english_stem} | english_stem | {abc}
- entity | XML entity | &nm1; | {} | |
- asciiword | Word, all ASCII | def | {english_stem} | english_stem | {def}
- entity | XML entity | © | {} | |
- asciiword | Word, all ASCII | ghi | {english_stem} | english_stem | {ghi}
- entity | XML entity | õ | {} | |
- asciiword | Word, all ASCII | jkl | {english_stem} | english_stem | {jkl}
- tag | XML tag | </myns:foo-bar_baz.blurfl> | {} | |
-(9 rows)
-
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/workmem/expected/workmem.out /tmp/cirrus-ci-build/contrib/workmem/results/workmem....
--- /tmp/cirrus-ci-build/contrib/workmem/expected/workmem.out 2025-03-16 11:18:06.941606890 +0000
+++ /tmp/cirrus-ci-build/contrib/workmem/results/workmem.out 2025-03-16 11:24:27.285959208 +0000
@@ -30,9 +30,10 @@
from (values (1, 1), (2, 2)) as t (a, b) where a = b
group by grouping sets((a, b), (a));
');
- workmem_filter
-----------------------------------------------------------------------
+ workmem_filter
+--------------------------------------------------------------------------------------------
WindowAgg (work_mem=N kB limit=25600 kB)
+ Window: w1 AS (ORDER BY "*VALUES*".column1, "*VALUES*".column2 ROWS UNBOUNDED PRECEDING)
-> Sort (work_mem=N kB limit=25600 kB)
Sort Key: "*VALUES*".column1, "*VALUES*".column2 NULLS FIRST
-> HashAggregate (work_mem=N kB limit=51200 kB)
@@ -42,7 +43,7 @@
Filter: (column1 = column2)
Total Working Memory: N kB
Total Working Memory Limit: 102400 kB
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/workmem.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/workmem.out 2025-03-16 11:18:08.750696852 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/workmem.out 2025-03-16 11:25:39.979299380 +0000
@@ -207,9 +207,10 @@
from (values (1, 1), (2, 2)) as t (a, b) where a = b
group by grouping sets((a, b), (a));
');
- workmem_filter
-----------------------------------------------------------------------
+ workmem_filter
+--------------------------------------------------------------------------------------------
WindowAgg (work_mem=N kB limit=4096 kB)
+ Window: w1 AS (ORDER BY "*VALUES*".column1, "*VALUES*".column2 ROWS UNBOUNDED PRECEDING)
-> Sort (work_mem=N kB limit=4096 kB)
Sort Key: "*VALUES*".column1, "*VALUES*".column2 NULLS FIRST
-> HashAggregate (work_mem=N kB limit=8192 kB)
@@ -219,7 +220,7 @@
Filter: (column1 = column2)
Total Working Memory: N kB
Total Working Memory Limit: 16384 kB
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/workmem.out /tmp/cirrus-ci-build/src/test/regress/results/workme...
--- /tmp/cirrus-ci-build/src/test/regress/expected/workmem.out 2025-03-16 11:18:08.750696852 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/workmem.out 2025-03-16 11:23:54.557455409 +0000
@@ -207,9 +207,10 @@
from (values (1, 1), (2, 2)) as t (a, b) where a = b
group by grouping sets((a, b), (a));
');
- workmem_filter
-----------------------------------------------------------------------
+ workmem_filter
+--------------------------------------------------------------------------------------------
WindowAgg (work_mem=N kB limit=4096 kB)
+ Window: w1 AS (ORDER BY "*VALUES*".column1, "*VALUES*".column2 ROWS UNBOUNDED PRECEDING)
-> Sort (work_mem=N kB limit=4096 kB)
Sort Key: "*VALUES*".column1, "*VALUES*".column2 NULLS FIRST
-> HashAggregate (work_mem=N kB limit=8192 kB)
@@ -219,7 +220,7 @@
Filter: (column1 = column2)
Total Working Memory: N kB
Total Working Memory Limit: 16384 kB
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/workmem.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/workmem.out 2025-03-16 11:18:08.353234581 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/workmem.out 2025-03-16 11:24:02.384806845 ...
@@ -207,9 +207,10 @@
from (values (1, 1), (2, 2)) as t (a, b) where a = b
group by grouping sets((a, b), (a));
');
- workmem_filter
-----------------------------------------------------------------------
+ workmem_filter
+--------------------------------------------------------------------------------------------
WindowAgg (work_mem=N kB limit=4096 kB)
+ Window: w1 AS (ORDER BY "*VALUES*".column1, "*VALUES*".column2 ROWS UNBOUNDED PRECEDING)
-> Sort (work_mem=N kB limit=4096 kB)
Sort Key: "*VALUES*".column1, "*VALUES*".column2 NULLS FIRST
-> HashAggregate (work_mem=N kB limit=8192 kB)
@@ -219,7 +220,7 @@
Filter: (column1 = column2)
Total Working Memory: N kB
Total Working Memory Limit: 16384 kB
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/workmem.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/workmem.out 2025-03-16 11:18:08.353234581 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/workmem.out 2025-03-16 11:24:38.84077715...
@@ -207,9 +207,10 @@
from (values (1, 1), (2, 2)) as t (a, b) where a = b
group by grouping sets((a, b), (a));
');
- workmem_filter
-----------------------------------------------------------------------
+ workmem_filter
+--------------------------------------------------------------------------------------------
WindowAgg (work_mem=N kB limit=4096 kB)
+ Window: w1 AS (ORDER BY "*VALUES*".column1, "*VALUES*".column2 ROWS UNBOUNDED PRECEDING)
-> Sort (work_mem=N kB limit=4096 kB)
Sort Key: "*VALUES*".column1, "*VALUES*".column2 NULLS FIRST
-> HashAggregate (work_mem=N kB limit=8192 kB)
@@ -219,7 +220,7 @@
Filter: (column1 = column2)
Total Working Memory: N kB
Total Working Memory Limit: 16384 kB
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/workmem.out /tmp/cirrus-ci-build/build/testrun/regress/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/workmem.out 2025-03-16 11:18:08.353234581 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/workmem.out 2025-03-16 11:23:55.444814941 +0000
@@ -207,9 +207,10 @@
from (values (1, 1), (2, 2)) as t (a, b) where a = b
group by grouping sets((a, b), (a));
');
- workmem_filter
-----------------------------------------------------------------------
+ workmem_filter
+--------------------------------------------------------------------------------------------
WindowAgg (work_mem=N kB limit=4096 kB)
+ Window: w1 AS (ORDER BY "*VALUES*".column1, "*VALUES*".column2 ROWS UNBOUNDED PRECEDING)
-> Sort (work_mem=N kB limit=4096 kB)
Sort Key: "*VALUES*".column1, "*VALUES*".column2 NULLS FIRST
-> HashAggregate (work_mem=N kB limit=8192 kB)
@@ -219,7 +220,7 @@
Filter: (column1 = column2)
Total Working Memory: N kB
Total Working Memory Limit: 16384 kB
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/workmem.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upg...
--- /Users/admin/pgsql/src/test/regress/expected/workmem.out 2025-03-16 11:18:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/workmem.out 2025-03-16 11:21:05
@@ -207,9 +207,10 @@
from (values (1, 1), (2, 2)) as t (a, b) where a = b
group by grouping sets((a, b), (a));
');
- workmem_filter
-----------------------------------------------------------------------
+ workmem_filter
+--------------------------------------------------------------------------------------------
WindowAgg (work_mem=N kB limit=4096 kB)
+ Window: w1 AS (ORDER BY "*VALUES*".column1, "*VALUES*".column2 ROWS UNBOUNDED PRECEDING)
-> Sort (work_mem=N kB limit=4096 kB)
Sort Key: "*VALUES*".column1, "*VALUES*".column2 NULLS FIRST
-> HashAggregate (work_mem=N kB limit=8192 kB)
@@ -219,7 +220,7 @@
Filter: (column1 = column2)
Total Working Memory: N kB
Total Working Memory Limit: 16384 kB
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/workmem.out /Users/admin/pgsql/build/testrun/recovery/027_stream_r...
--- /Users/admin/pgsql/src/test/regress/expected/workmem.out 2025-03-16 11:18:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/workmem.out 2025-03-16 11:21:48
@@ -207,9 +207,10 @@
from (values (1, 1), (2, 2)) as t (a, b) where a = b
group by grouping sets((a, b), (a));
');
- workmem_filter
-----------------------------------------------------------------------
+ workmem_filter
+--------------------------------------------------------------------------------------------
WindowAgg (work_mem=N kB limit=4096 kB)
+ Window: w1 AS (ORDER BY "*VALUES*".column1, "*VALUES*".column2 ROWS UNBOUNDED PRECEDING)
-> Sort (work_mem=N kB limit=4096 kB)
Sort Key: "*VALUES*".column1, "*VALUES*".column2 NULLS FIRST
-> HashAggregate (work_mem=N kB limit=8192 kB)
@@ -219,7 +220,7 @@
Filter: (column1 = column2)
Total Working Memory: N kB
Total Working Memory Limit: 16384 kB
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/workmem.out /Users/admin/pgsql/build/testrun/regress/regress/resul...
--- /Users/admin/pgsql/src/test/regress/expected/workmem.out 2025-03-16 11:18:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/workmem.out 2025-03-16 11:21:05
@@ -207,9 +207,10 @@
from (values (1, 1), (2, 2)) as t (a, b) where a = b
group by grouping sets((a, b), (a));
');
- workmem_filter
-----------------------------------------------------------------------
+ workmem_filter
+--------------------------------------------------------------------------------------------
WindowAgg (work_mem=N kB limit=4096 kB)
+ Window: w1 AS (ORDER BY "*VALUES*".column1, "*VALUES*".column2 ROWS UNBOUNDED PRECEDING)
-> Sort (work_mem=N kB limit=4096 kB)
Sort Key: "*VALUES*".column1, "*VALUES*".column2 NULLS FIRST
-> HashAggregate (work_mem=N kB limit=8192 kB)
@@ -219,7 +220,7 @@
Filter: (column1 = column2)
Total Working Memory: N kB
Total Working Memory Limit: 16384 kB
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/workmem.out C:/cirrus/build/testrun/pg_upgrade/002_pg_u...
--- C:/cirrus/src/test/regress/expected/workmem.out 2025-03-16 11:18:13.944986300 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/workmem.out 2025-03-16 11:21:44.325758300 +0000
@@ -207,9 +207,10 @@
from (values (1, 1), (2, 2)) as t (a, b) where a = b
group by grouping sets((a, b), (a));
');
- workmem_filter
-----------------------------------------------------------------------
+ workmem_filter
+--------------------------------------------------------------------------------------------
WindowAgg (work_mem=N kB limit=4096 kB)
+ Window: w1 AS (ORDER BY "*VALUES*".column1, "*VALUES*".column2 ROWS UNBOUNDED PRECEDING)
-> Sort (work_mem=N kB limit=4096 kB)
Sort Key: "*VALUES*".column1, "*VALUES*".column2 NULLS FIRST
-> HashAggregate (work_mem=N kB limit=8192 kB)
@@ -219,7 +220,7 @@
Filter: (column1 = column2)
Total Working Memory: N kB
Total Working Memory Limit: 16384 kB
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/workmem.out C:/cirrus/build/testrun/recovery/027_stream...
--- C:/cirrus/src/test/regress/expected/workmem.out 2025-03-16 11:18:13.944986300 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/workmem.out 2025-03-16 11:23:55.806713400 +0000
@@ -207,9 +207,10 @@
from (values (1, 1), (2, 2)) as t (a, b) where a = b
group by grouping sets((a, b), (a));
');
- workmem_filter
-----------------------------------------------------------------------
+ workmem_filter
+--------------------------------------------------------------------------------------------
WindowAgg (work_mem=N kB limit=4096 kB)
+ Window: w1 AS (ORDER BY "*VALUES*".column1, "*VALUES*".column2 ROWS UNBOUNDED PRECEDING)
-> Sort (work_mem=N kB limit=4096 kB)
Sort Key: "*VALUES*".column1, "*VALUES*".column2 NULLS FIRST
-> HashAggregate (work_mem=N kB limit=8192 kB)
@@ -219,7 +220,7 @@
Filter: (column1 = column2)
Total Working Memory: N kB
Total Working Memory Limit: 16384 kB
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/workmem.out C:/cirrus/build/testrun/regress/regress/res...
--- C:/cirrus/src/test/regress/expected/workmem.out 2025-03-16 11:18:13.944986300 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/workmem.out 2025-03-16 11:21:39.294519000 +0000
@@ -207,9 +207,10 @@
from (values (1, 1), (2, 2)) as t (a, b) where a = b
group by grouping sets((a, b), (a));
');
- workmem_filter
-----------------------------------------------------------------------
+ workmem_filter
+--------------------------------------------------------------------------------------------
WindowAgg (work_mem=N kB limit=4096 kB)
+ Window: w1 AS (ORDER BY "*VALUES*".column1, "*VALUES*".column2 ROWS UNBOUNDED PRECEDING)
-> Sort (work_mem=N kB limit=4096 kB)
Sort Key: "*VALUES*".column1, "*VALUES*".column2 NULLS FIRST
-> HashAggregate (work_mem=N kB limit=8192 kB)
@@ -219,7 +220,7 @@
Filter: (column1 = column2)
Total Working Memory: N kB
Total Working Memory Limit: 16384 kB
... |
| 52/5614 |
Metadata and record block access stats for indexes |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/inplace.out /tmp/cirrus-ci-build/build/testrun/...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/inplace.out 2025-03-15 11:59:57.447415198 +0000
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/inplace.out 2025-03-15 12:05:38.943494138 +000...
@@ -47,294 +47,6 @@
starting permutation: begin2 grant2 vac1 c2 vac3 mkrels3 read1
-mkrels
-------
-
-(1 row)
-
-injection_points_attach
------------------------
-
-(1 row)
-
-step begin2: BEGIN;
-step grant2: GRANT SELECT ON TABLE vactest.orig50 TO PUBLIC;
-step vac1: VACUUM vactest.orig50; -- wait during inplace update <waiting ...>
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_up...
--- /tmp/cirrus-ci-build/src/test/regress/expected/join.out 2025-03-15 11:59:57.576041004 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/join.out 2025-03-15 12:04:57.350621971 +00...
@@ -8729,635 +8729,7 @@
join fkest f2 on (f1.x = f2.x and f1.x10 = f2.x10b and f1.x100 = f2.x100)
join fkest f3 on f1.x = f3.x
where f1.x100 = 2;
- QUERY PLAN
------------------------------------------------------------
- Nested Loop
- -> Hash Join
- Hash Cond: ((f2.x = f1.x) AND (f2.x10b = f1.x10))
- -> Seq Scan on fkest f2
- Filter: (x100 = 2)
- -> Hash
- -> Seq Scan on fkest f1
- Filter: (x100 = 2)
- -> Index Scan using fkest_x_x10_x100_idx on fkest f3
- Index Cond: (x = f1.x)
-(10 rows)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/test_setup.out /tmp/cirrus-ci-build/build/testrun/recovery/027_s...
--- /tmp/cirrus-ci-build/src/test/regress/expected/test_setup.out 2025-03-15 11:59:57.632314794 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/test_setup.out 2025-03-15 12:05:08.70680...
@@ -176,66 +176,7 @@
COPY road FROM :'filename';
VACUUM ANALYZE road;
CREATE TABLE ihighway () INHERITS (road);
-INSERT INTO ihighway
- SELECT *
- FROM ONLY road
- WHERE name ~ 'I- .*';
-VACUUM ANALYZE ihighway;
-CREATE TABLE shighway (
- surface text
-) INHERITS (road);
-INSERT INTO shighway
- SELECT *, 'asphalt'
- FROM ONLY road
- WHERE name ~ 'State Hwy.*';
-VACUUM ANALYZE shighway;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/interval.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/interval.out 2025-03-15 11:59:57.572021447 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/interval.out 2025-03-15 12:04:38.134440516 +0000
@@ -381,1948 +381,7 @@
(1 row)
SELECT f1 FROM INTERVAL_TBL_OF r1 ORDER BY f1;
- f1
--------------------------------------------
- -178956970 years -8 mons -2147483648 days
- -178956970 years -8 mons +2147483647 days
- 1 year
- 178956970 years 7 mons -2147483648 days
- 178956970 years 7 mons 2147483647 days
-(5 rows)
-
-RESET enable_seqscan;
--- subtracting about-to-overflow values should result in 0
-SELECT f1 - f1 FROM INTERVAL_TBL_OF;
- ?column?
... |
| 52/5525 |
explain plans for foreign servers |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/explain.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/explain.out 2025-02-26 20:18:51.484936000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/explain.out 2025-02-26 20:21:31.102750000 ...
@@ -400,29 +400,9 @@
"Actual Total Time": N.N, +
"Actual Rows": N, +
"Actual Loops": N, +
- "Disabled": false, +
- "Shared Hit Blocks": N, +
- "Shared Read Blocks": N, +
- "Shared Dirtied Blocks": N, +
- "Shared Written Blocks": N, +
- "Local Hit Blocks": N, +
- "Local Read Blocks": N, +
- "Local Dirtied Blocks": N, +
- "Local Written Blocks": N, +
- "Temp Read Blocks": N, +
- "Temp Written Blocks": N +
+ "Disabled": false +
}, +
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-02-26 20:18:49.994196000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2025-02-26 20:22:11.365595000 +0000
@@ -2,7 +2,14 @@
-- create FDW objects
-- ===================================================================
CREATE EXTENSION postgres_fdw;
+ERROR: could not load library "/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/lib/postgres_fdw.so": /tmp/cirru...
+CONTEXT: SQL statement "CREATE FUNCTION postgres_fdw_handler()
+RETURNS fdw_handler
+AS '$libdir/postgres_fdw'
+LANGUAGE C STRICT"
+extension script file "postgres_fdw--1.0.sql", near line 6
CREATE SERVER testserver1 FOREIGN DATA WRAPPER postgres_fdw;
+ERROR: foreign-data wrapper "postgres_fdw" does not exist
DO $d$
BEGIN
EXECUTE $$CREATE SERVER loopback FOREIGN DATA WRAPPER postgres_fdw
@@ -19,11 +26,21 @@
)$$;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/explain.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/explain.out 2025-02-26 20:18:51.484936000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/explain.out 2025-02-26 20:22:18.44812200...
@@ -400,29 +400,9 @@
"Actual Total Time": N.N, +
"Actual Rows": N, +
"Actual Loops": N, +
- "Disabled": false, +
- "Shared Hit Blocks": N, +
- "Shared Read Blocks": N, +
- "Shared Dirtied Blocks": N, +
- "Shared Written Blocks": N, +
- "Local Hit Blocks": N, +
- "Local Read Blocks": N, +
- "Local Dirtied Blocks": N, +
- "Local Written Blocks": N, +
- "Temp Read Blocks": N, +
- "Temp Written Blocks": N +
+ "Disabled": false +
}, +
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/explain.out /tmp/cirrus-ci-build/build/testrun/regress/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/explain.out 2025-02-26 20:18:51.484936000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/explain.out 2025-02-26 20:21:28.496857000 +0000
@@ -400,29 +400,9 @@
"Actual Total Time": N.N, +
"Actual Rows": N, +
"Actual Loops": N, +
- "Disabled": false, +
- "Shared Hit Blocks": N, +
- "Shared Read Blocks": N, +
- "Shared Dirtied Blocks": N, +
- "Shared Written Blocks": N, +
- "Local Hit Blocks": N, +
- "Local Read Blocks": N, +
- "Local Dirtied Blocks": N, +
- "Local Written Blocks": N, +
- "Temp Read Blocks": N, +
- "Temp Written Blocks": N +
+ "Disabled": false +
}, +
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/explain.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/explain.out 2025-02-26 20:18:50.386126207 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/explain.out 2025-02-26 20:24:06.764659668 ...
@@ -400,29 +400,9 @@
"Actual Total Time": N.N, +
"Actual Rows": N, +
"Actual Loops": N, +
- "Disabled": false, +
- "Shared Hit Blocks": N, +
- "Shared Read Blocks": N, +
- "Shared Dirtied Blocks": N, +
- "Shared Written Blocks": N, +
- "Local Hit Blocks": N, +
- "Local Read Blocks": N, +
- "Local Dirtied Blocks": N, +
- "Local Written Blocks": N, +
- "Temp Read Blocks": N, +
- "Temp Written Blocks": N +
+ "Disabled": false +
}, +
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres...
--- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-02-26 20:18:48.575308071 +0000
+++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2025-02-26 20:24:29.325355865 +0000
@@ -2,7 +2,14 @@
-- create FDW objects
-- ===================================================================
CREATE EXTENSION postgres_fdw;
+ERROR: could not load library "/tmp/cirrus-ci-build/build/tmp_install/usr/local/pgsql/lib/x86_64-linux-gnu/postgres_fd...
+CONTEXT: SQL statement "CREATE FUNCTION postgres_fdw_handler()
+RETURNS fdw_handler
+AS '$libdir/postgres_fdw'
+LANGUAGE C STRICT"
+extension script file "postgres_fdw--1.0.sql", near line 6
CREATE SERVER testserver1 FOREIGN DATA WRAPPER postgres_fdw;
+ERROR: foreign-data wrapper "postgres_fdw" does not exist
DO $d$
BEGIN
EXECUTE $$CREATE SERVER loopback FOREIGN DATA WRAPPER postgres_fdw
@@ -19,11 +26,21 @@
)$$;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/explain.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/explain.out 2025-02-26 20:18:50.386126207 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/explain.out 2025-02-26 20:24:44.00589676...
@@ -400,29 +400,9 @@
"Actual Total Time": N.N, +
"Actual Rows": N, +
"Actual Loops": N, +
- "Disabled": false, +
- "Shared Hit Blocks": N, +
- "Shared Read Blocks": N, +
- "Shared Dirtied Blocks": N, +
- "Shared Written Blocks": N, +
- "Local Hit Blocks": N, +
- "Local Read Blocks": N, +
- "Local Dirtied Blocks": N, +
- "Local Written Blocks": N, +
- "Temp Read Blocks": N, +
- "Temp Written Blocks": N +
+ "Disabled": false +
}, +
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/explain.out /tmp/cirrus-ci-build/build/testrun/regress/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/explain.out 2025-02-26 20:18:50.386126207 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/explain.out 2025-02-26 20:24:02.568552566 +0000
@@ -400,29 +400,9 @@
"Actual Total Time": N.N, +
"Actual Rows": N, +
"Actual Loops": N, +
- "Disabled": false, +
- "Shared Hit Blocks": N, +
- "Shared Read Blocks": N, +
- "Shared Dirtied Blocks": N, +
- "Shared Written Blocks": N, +
- "Local Hit Blocks": N, +
- "Local Read Blocks": N, +
- "Local Dirtied Blocks": N, +
- "Local Written Blocks": N, +
- "Temp Read Blocks": N, +
- "Temp Written Blocks": N +
+ "Disabled": false +
}, +
... |
| 53/5319 |
Changing shared_buffers without restart |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/numeric.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/numeric.out 2025-02-21 04:08:17.478976424 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/numeric.out 2025-02-21 04:25:01.485739224 +0000
@@ -3753,24 +3753,20 @@
ROLLBACK;
-- case where sum of squares would overflow but variance does not
DELETE FROM num_variance;
+ERROR: index "pg_statistic_ext_relid_index" contains corrupted page at block 4294967295
+HINT: Please REINDEX it.
INSERT INTO num_variance SELECT 9e131071 + x FROM generate_series(1, 5) x;
SELECT variance(a) FROM num_variance;
- variance
---------------------
- 2.5000000000000000
-(1 row)
-
+ERROR: index "pg_statistic_ext_relid_index" contains corrupted page at block 4294967295
+HINT: Please REINDEX it.
-- check that parallel execution produces the same result
BEGIN;
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/numeric.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/numeric.out 2025-02-21 04:08:19.388526714 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/numeric.out 2025-02-21 04:13:41.92260614...
@@ -3754,132 +3754,7 @@
-- case where sum of squares would overflow but variance does not
DELETE FROM num_variance;
INSERT INTO num_variance SELECT 9e131071 + x FROM generate_series(1, 5) x;
-SELECT variance(a) FROM num_variance;
- variance
---------------------
- 2.5000000000000000
-(1 row)
-
--- check that parallel execution produces the same result
-BEGIN;
-ALTER TABLE num_variance SET (parallel_workers = 4);
-SET LOCAL parallel_setup_cost = 0;
-SET LOCAL max_parallel_workers_per_gather = 4;
-SELECT variance(a) FROM num_variance;
- variance
... |
| 51/5231 |
Consider the number of columns in the sort cost model |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/level_tracking.out /tmp/cirrus-ci-build/build/testrun/...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/level_tracking.out 2025-02-01 02:38:28.566114000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_stat_statements/regress/results/level_tracking.out 2025-02-01 02:41:07.0340200...
@@ -383,26 +383,24 @@
(1 row)
EXPLAIN (COSTS OFF) SELECT 1, 2 UNION SELECT 3, 4\; EXPLAIN (COSTS OFF) (SELECT 1, 2, 3) UNION SELECT 3, 4, 5;
+ QUERY PLAN
+-----------------------
+ HashAggregate
+ Group Key: (1), (2)
+ -> Append
+ -> Result
+ -> Result
+(5 rows)
+
QUERY PLAN
----------------------------
- Unique
- -> Sort
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/level_tracking.out /tmp/cirrus-ci-build/contrib/pg_sta...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/level_tracking.out 2025-02-01 02:38:28.410197114 +0000
+++ /tmp/cirrus-ci-build/contrib/pg_stat_statements/results/level_tracking.out 2025-02-01 02:43:52.556550480 +0000
@@ -383,25 +383,23 @@
(1 row)
EXPLAIN (COSTS OFF) SELECT 1, 2 UNION SELECT 3, 4\; EXPLAIN (COSTS OFF) (SELECT 1, 2, 3) UNION SELECT 3, 4, 5;
+ QUERY PLAN
+-----------------------
+ HashAggregate
+ Group Key: (1), (2)
+ -> Append
+ -> Result
+ -> Result
+(5 rows)
+
QUERY PLAN
----------------------------
- Unique
- -> Sort
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/level_tracking.out /tmp/cirrus-ci-build/build/testrun/...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/level_tracking.out 2025-02-01 02:38:29.263760882 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_stat_statements/regress/results/level_tracking.out 2025-02-01 02:43:31.7688094...
@@ -383,25 +383,23 @@
(1 row)
EXPLAIN (COSTS OFF) SELECT 1, 2 UNION SELECT 3, 4\; EXPLAIN (COSTS OFF) (SELECT 1, 2, 3) UNION SELECT 3, 4, 5;
+ QUERY PLAN
+-----------------------
+ HashAggregate
+ Group Key: (1), (2)
+ -> Append
+ -> Result
+ -> Result
+(5 rows)
+
QUERY PLAN
----------------------------
- Unique
- -> Sort
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/contrib/pg_stat_statements/expected/level_tracking.out /Users/admin/pgsql/build/testrun/pg_s...
--- /Users/admin/pgsql/contrib/pg_stat_statements/expected/level_tracking.out 2025-02-01 02:45:11
+++ /Users/admin/pgsql/build/testrun/pg_stat_statements/regress/results/level_tracking.out 2025-02-01 02:50:53
@@ -383,25 +383,23 @@
(1 row)
EXPLAIN (COSTS OFF) SELECT 1, 2 UNION SELECT 3, 4\; EXPLAIN (COSTS OFF) (SELECT 1, 2, 3) UNION SELECT 3, 4, 5;
+ QUERY PLAN
+-----------------------
+ HashAggregate
+ Group Key: (1), (2)
+ -> Append
+ -> Result
+ -> Result
+(5 rows)
+
QUERY PLAN
----------------------------
- Unique
- -> Sort
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_stat_statements/expected/level_tracking.out C:/cirrus/build/testrun/pg...
--- C:/cirrus/contrib/pg_stat_statements/expected/level_tracking.out 2025-02-01 02:38:29.023790600 +0000
+++ C:/cirrus/build/testrun/pg_stat_statements/regress/results/level_tracking.out 2025-02-01 02:45:10.947490000 +0000
@@ -383,25 +383,23 @@
(1 row)
EXPLAIN (COSTS OFF) SELECT 1, 2 UNION SELECT 3, 4\; EXPLAIN (COSTS OFF) (SELECT 1, 2, 3) UNION SELECT 3, 4, 5;
+ QUERY PLAN
+-----------------------
+ HashAggregate
+ Group Key: (1), (2)
+ -> Append
+ -> Result
+ -> Result
+(5 rows)
+
QUERY PLAN
----------------------------
- Unique
- -> Sort
... |
| 51/5426 |
Add a warning message when using unencrypted passwords |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/connect-test5.stderr /tmp/cirrus-ci-build/build/testrun/...
--- /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/connect-test5.stderr 2025-02-01 01:49:23.500703000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/ecpg/ecpg/results/connect-test5.stderr 2025-02-01 01:52:15.611475000 +0000
@@ -4,16 +4,24 @@
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ecpg_execute on line 24: query: alter user regress_ecpg_user2 encrypted password 'insecure'; with 0 parameter...
[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_execute on line 24: using PQexec
+[NO_PID]: ECPGnoticeReceiver: using a plaintext password in a query
[NO_PID]: sqlca: code: 0, state: 00000
+[NO_PID]: raising sqlcode 0
+[NO_PID]: sqlca: code: 0, state: 01000
+[NO_PID]: ecpg_execute on line 24: using PQexec
+[NO_PID]: sqlca: code: 0, state: 01000
[NO_PID]: ecpg_process_output on line 24: OK: ALTER ROLE
-[NO_PID]: sqlca: code: 0, state: 00000
+[NO_PID]: sqlca: code: 0, state: 01000
[NO_PID]: ecpg_execute on line 25: query: alter user regress_ecpg_user1 encrypted password 'connectpw'; with 0 paramete...
[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_execute on line 25: using PQexec
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/connect-test5.stderr /tmp/cirrus-ci-build/src/interfaces...
--- /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/connect-test5.stderr 2025-02-01 01:49:20.015261848 +0000
+++ /tmp/cirrus-ci-build/src/interfaces/ecpg/test/results/connect-test5.stderr 2025-02-01 01:51:24.157005816 +0000
@@ -4,16 +4,24 @@
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ecpg_execute on line 24: query: alter user regress_ecpg_user2 encrypted password 'insecure'; with 0 parameter...
[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_execute on line 24: using PQexec
+[NO_PID]: ECPGnoticeReceiver: using a plaintext password in a query
[NO_PID]: sqlca: code: 0, state: 00000
+[NO_PID]: raising sqlcode 0
+[NO_PID]: sqlca: code: 0, state: 01000
+[NO_PID]: ecpg_execute on line 24: using PQexec
+[NO_PID]: sqlca: code: 0, state: 01000
[NO_PID]: ecpg_process_output on line 24: OK: ALTER ROLE
-[NO_PID]: sqlca: code: 0, state: 00000
+[NO_PID]: sqlca: code: 0, state: 01000
[NO_PID]: ecpg_execute on line 25: query: alter user regress_ecpg_user1 encrypted password 'connectpw'; with 0 paramete...
[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_execute on line 25: using PQexec
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/connect-test5.stderr /tmp/cirrus-ci-build/build/testrun/...
--- /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/connect-test5.stderr 2025-02-01 01:49:18.536829002 +0000
+++ /tmp/cirrus-ci-build/build/testrun/ecpg/ecpg/results/connect-test5.stderr 2025-02-01 01:52:49.741836860 +0000
@@ -4,16 +4,24 @@
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ecpg_execute on line 24: query: alter user regress_ecpg_user2 encrypted password 'insecure'; with 0 parameter...
[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_execute on line 24: using PQexec
+[NO_PID]: ECPGnoticeReceiver: using a plaintext password in a query
[NO_PID]: sqlca: code: 0, state: 00000
+[NO_PID]: raising sqlcode 0
+[NO_PID]: sqlca: code: 0, state: 01000
+[NO_PID]: ecpg_execute on line 24: using PQexec
+[NO_PID]: sqlca: code: 0, state: 01000
[NO_PID]: ecpg_process_output on line 24: OK: ALTER ROLE
-[NO_PID]: sqlca: code: 0, state: 00000
+[NO_PID]: sqlca: code: 0, state: 01000
[NO_PID]: ecpg_execute on line 25: query: alter user regress_ecpg_user1 encrypted password 'connectpw'; with 0 paramete...
[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_execute on line 25: using PQexec
... |
| 51/5421 |
Use streaming read API in pgstattuple. |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pgstattuple/expected/pgstattuple.out /tmp/cirrus-ci-build/build-32/testrun/pgstatt...
--- /tmp/cirrus-ci-build/contrib/pgstattuple/expected/pgstattuple.out 2025-02-01 00:26:18.955607478 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/pgstattuple/regress/results/pgstattuple.out 2025-02-01 00:34:33.819519131 +000...
@@ -134,7 +134,7 @@
select * from pgstathashindex('test_hashidx');
version | bucket_pages | overflow_pages | bitmap_pages | unused_pages | live_items | dead_items | free_percent
---------+--------------+----------------+--------------+--------------+------------+------------+--------------
- 4 | 4 | 0 | 1 | 0 | 0 | 0 | 100
+ 4 | 2 | 0 | 1 | 0 | 0 | 0 | 100
(1 row)
create index test_gistidx ON test USING gist(c);
@@ -166,7 +166,7 @@
select pgstattuple('test_hashidx');
pgstattuple
---------------------------------
- (49152,0,0,0,0,0,0,32608,66.34)
+ (32768,0,0,0,0,0,0,16304,49.76)
(1 row)
... |
| 51/5446 |
Improving default column names/aliases of subscript text expressions |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/hstore/expected/hstore.out /tmp/cirrus-ci-build/build/testrun/hstore/regress/resul...
--- /tmp/cirrus-ci-build/contrib/hstore/expected/hstore.out 2025-01-31 22:47:15.913050000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/hstore/regress/results/hstore.out 2025-01-31 22:49:29.533569000 +0000
@@ -1597,7 +1597,7 @@
-- Test subscripting
insert into test_json_agg default values;
select f2['d'], f2['x'] is null as x_isnull from test_json_agg;
- f2 | x_isnull
+ d | x_isnull
--------+----------
12345 | t
-12345 | t |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2025-01-31 22:47:17.453576000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonb.out 2025-01-31 22:48:50.480975000 +0...
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2025-01-31 22:47:17.453576000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/jsonb.out 2025-01-31 22:49:38.224223000 ...
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/build/testrun/regress/regress/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2025-01-31 22:47:17.453576000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/jsonb.out 2025-01-31 22:48:52.261387000 +0000
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/hstore/expected/hstore.out /tmp/cirrus-ci-build/contrib/hstore/results/hstore.out
--- /tmp/cirrus-ci-build/contrib/hstore/expected/hstore.out 2025-01-31 22:47:13.594812974 +0000
+++ /tmp/cirrus-ci-build/contrib/hstore/results/hstore.out 2025-01-31 22:49:55.072732913 +0000
@@ -1597,7 +1597,7 @@
-- Test subscripting
insert into test_json_agg default values;
select f2['d'], f2['x'] is null as x_isnull from test_json_agg;
- f2 | x_isnull
+ d | x_isnull
--------+----------
12345 | t
-12345 | t |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/resu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2025-01-31 22:47:15.487227431 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/jsonb.out 2025-01-31 22:52:00.069083270 +0000
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/src/test/regress/results/jsonb.ou...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2025-01-31 22:47:15.487227431 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/jsonb.out 2025-01-31 22:50:16.421560904 +0000
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/hstore/expected/hstore.out /tmp/cirrus-ci-build/build/testrun/hstore/regress/resul...
--- /tmp/cirrus-ci-build/contrib/hstore/expected/hstore.out 2025-01-31 22:47:13.669986652 +0000
+++ /tmp/cirrus-ci-build/build/testrun/hstore/regress/results/hstore.out 2025-01-31 22:50:03.333232574 +0000
@@ -1597,7 +1597,7 @@
-- Test subscripting
insert into test_json_agg default values;
select f2['d'], f2['x'] is null as x_isnull from test_json_agg;
- f2 | x_isnull
+ d | x_isnull
--------+----------
12345 | t
-12345 | t |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2025-01-31 22:47:15.510288965 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonb.out 2025-01-31 22:49:37.797238657 +0...
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2025-01-31 22:47:15.510288965 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/jsonb.out 2025-01-31 22:50:15.785219578 ...
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/build/testrun/regress/regress/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2025-01-31 22:47:15.510288965 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/jsonb.out 2025-01-31 22:49:31.593233529 +0000
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/contrib/hstore/expected/hstore.out /Users/admin/pgsql/build/testrun/hstore/regress/results/h...
--- /Users/admin/pgsql/contrib/hstore/expected/hstore.out 2025-01-31 22:58:12
+++ /Users/admin/pgsql/build/testrun/hstore/regress/results/hstore.out 2025-01-31 23:02:56
@@ -1597,7 +1597,7 @@
-- Test subscripting
insert into test_json_agg default values;
select f2['d'], f2['x'] is null as x_isnull from test_json_agg;
- f2 | x_isnull
+ d | x_isnull
--------+----------
12345 | t
-12345 | t |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/jsonb.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgra...
--- /Users/admin/pgsql/src/test/regress/expected/jsonb.out 2025-01-31 22:58:15
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonb.out 2025-01-31 23:01:25
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/jsonb.out /Users/admin/pgsql/build/testrun/recovery/027_stream_reg...
--- /Users/admin/pgsql/src/test/regress/expected/jsonb.out 2025-01-31 22:58:15
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/jsonb.out 2025-01-31 23:03:03
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/jsonb.out /Users/admin/pgsql/build/testrun/regress/regress/results...
--- /Users/admin/pgsql/src/test/regress/expected/jsonb.out 2025-01-31 22:58:15
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/jsonb.out 2025-01-31 23:01:25
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/hstore/expected/hstore.out C:/cirrus/build/testrun/hstore/regress/results...
--- C:/cirrus/contrib/hstore/expected/hstore.out 2025-01-31 22:47:14.429352200 +0000
+++ C:/cirrus/build/testrun/hstore/regress/results/hstore.out 2025-01-31 22:53:24.056520800 +0000
@@ -1597,7 +1597,7 @@
-- Test subscripting
insert into test_json_agg default values;
select f2['d'], f2['x'] is null as x_isnull from test_json_agg;
- f2 | x_isnull
+ d | x_isnull
--------+----------
12345 | t
-12345 | t |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/jsonb.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upg...
--- C:/cirrus/src/test/regress/expected/jsonb.out 2025-01-31 22:47:18.744331700 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonb.out 2025-01-31 22:50:57.101447400 +0000
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/jsonb.out C:/cirrus/build/testrun/recovery/027_stream_r...
--- C:/cirrus/src/test/regress/expected/jsonb.out 2025-01-31 22:47:18.744331700 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/jsonb.out 2025-01-31 22:53:25.986635700 +0000
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/jsonb.out C:/cirrus/build/testrun/regress/regress/resul...
--- C:/cirrus/src/test/regress/expected/jsonb.out 2025-01-31 22:47:18.744331700 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/jsonb.out 2025-01-31 22:50:40.910527100 +0000
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| 52/5129 |
Asynchronous MergeAppend Execution |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-01-29 17:55:01.116276000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2025-01-29 17:57:07.971658000...
@@ -172,7 +172,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(23 rows)
+(24 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-01-29 17:55:01.116276000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2025-01-29 17:57:53.7440780...
@@ -172,7 +172,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(23 rows)
+(24 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-01-29 17:55:01.116276000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/sysviews.out 2025-01-29 17:57:04.155082000 +0000
@@ -172,7 +172,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(23 rows)
+(24 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-01-29 17:54:57.373774839 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/sysviews.out 2025-01-29 18:02:32.894877293 +0000
@@ -172,7 +172,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(23 rows)
+(24 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-01-29 17:54:57.373774839 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/sysviews.out 2025-01-29 18:04:07.311500397 +0000
@@ -172,7 +172,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(23 rows)
+(24 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/src/test/regress/results/sysvi...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-01-29 17:54:57.373774839 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/sysviews.out 2025-01-29 17:59:28.715208055 +0000
@@ -172,7 +172,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(23 rows)
+(24 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-01-29 17:55:03.577484649 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2025-01-29 17:59:46.678253735...
@@ -172,7 +172,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(23 rows)
+(24 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-01-29 17:55:03.577484649 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2025-01-29 18:00:31.0985385...
@@ -172,7 +172,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(23 rows)
+(24 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2025-01-29 17:55:03.577484649 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/sysviews.out 2025-01-29 17:59:43.190248262 +0000
@@ -172,7 +172,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(23 rows)
+(24 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/sysviews.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/sysviews.out 2025-01-29 17:54:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2025-01-29 17:56:37
@@ -172,7 +172,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(23 rows)
+(24 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/sysviews.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/sysviews.out 2025-01-29 17:54:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2025-01-29 17:57:26
@@ -172,7 +172,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(23 rows)
+(24 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/sysviews.out /Users/admin/pgsql/build/testrun/regress/regress/resu...
--- /Users/admin/pgsql/src/test/regress/expected/sysviews.out 2025-01-29 17:54:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/sysviews.out 2025-01-29 17:56:35
@@ -172,7 +172,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(23 rows)
+(24 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/sysviews.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/sysviews.out 2025-01-29 17:55:06.702610200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2025-01-29 17:58:02.780137300 +0000
@@ -172,7 +172,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(23 rows)
+(24 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/sysviews.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/sysviews.out 2025-01-29 17:55:06.702610200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2025-01-29 18:00:16.798021400 +0000
@@ -172,7 +172,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(23 rows)
+(24 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/sysviews.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/sysviews.out 2025-01-29 17:55:06.702610200 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/sysviews.out 2025-01-29 17:57:58.185310500 +0000
@@ -172,7 +172,7 @@
enable_seqscan | on
enable_sort | on
enable_tidscan | on
-(23 rows)
+(24 rows)
-- There are always wait event descriptions for various types. InjectionPoint
-- may be present or absent, depending on history since last postmaster start. |
| 51/5284 |
database-specific role memberships |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/privs_in_db.out /tmp/cirrus-ci-build/build/testrun/regress-runni...
--- /tmp/cirrus-ci-build/src/test/regress/expected/privs_in_db.out 2025-01-06 03:21:59.302064000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress-running/regress/results/privs_in_db.out 2025-01-06 03:27:58.458701000 +00...
@@ -756,9 +756,10 @@
DROP DATABASE regression_db_0;
DROP ROLE regress_role_admin;
SELECT datname FROM pg_database WHERE datname LIKE 'regression_db_%';
- datname
----------
-(0 rows)
+ datname
+-------------------
+ regression_dblink
+(1 row)
SELECT rolname FROM pg_roles WHERE rolname LIKE 'regress_role_%';
rolname |
| 50/5270 |
jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb_jsonpath.out /tmp/cirrus-ci-build/build-32/testrun/pg_upgr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb_jsonpath.out 2024-11-29 14:31:16.474625998 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonb_jsonpath.out 2024-11-29 14:37:31....
@@ -3082,7 +3082,7 @@
select jsonb_path_query('"abc~@~def~@~ghi"', '$.split_part("~@~", 2)');
jsonb_path_query
------------------
- "def"
+ ""
(1 row)
-- Test string methods play nicely together |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb_jsonpath.out /tmp/cirrus-ci-build/build-32/testrun/recover...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb_jsonpath.out 2024-11-29 14:31:16.474625998 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/recovery/027_stream_regress/data/results/jsonb_jsonpath.out 2024-11-29 14:38:1...
@@ -3082,7 +3082,7 @@
select jsonb_path_query('"abc~@~def~@~ghi"', '$.split_part("~@~", 2)');
jsonb_path_query
------------------
- "def"
+ ""
(1 row)
-- Test string methods play nicely together |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb_jsonpath.out /tmp/cirrus-ci-build/build-32/testrun/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb_jsonpath.out 2024-11-29 14:31:16.474625998 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/jsonb_jsonpath.out 2024-11-29 14:37:28.656595197 +0000
@@ -3082,7 +3082,7 @@
select jsonb_path_query('"abc~@~def~@~ghi"', '$.split_part("~@~", 2)');
jsonb_path_query
------------------
- "def"
+ ""
(1 row)
-- Test string methods play nicely together |
| 50/5317 |
type cache cleanup improvements |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/regress-running/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-10-22 18:23:14.676052000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress-running/regress/results/triggers.out 2024-10-22 18:28:03.168650000 +0000
@@ -2145,14 +2145,9 @@
create table trigpart3 (like trigpart);
create trigger trg1 after insert on trigpart3 for each row execute procedure trigger_nothing();
\d trigpart3
- Table "public.trigpart3"
- Column | Type | Collation | Nullable | Default
---------+---------+-----------+----------+---------
- a | integer | | |
- b | integer | | |
-Triggers:
- trg1 AFTER INSERT ON trigpart3 FOR EACH ROW EXECUTE FUNCTION trigger_nothing()
-
+ERROR: error triggered for injection point typecache-before-rel-type-cache-insert
+LINE 2: ....pg_roles where oid = any (pol.polroles) order by 1),',') EN...
+ ^
alter table trigpart attach partition trigpart3 FOR VALUES FROM (2000) to (3000); -- fail
ERROR: trigger "trg1" for relation "trigpart3" already exists
... |