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/5674 |
Add "\gi file" to psql to allow COPY with variable expansion |
 |
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_up...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy.out 2025-05-18 10:37:15.586434000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy.out 2025-05-18 10:38:31.514915000 +00...
@@ -39,314 +39,3 @@
\qecho '\\.'
\qecho line2
\o
--- get the data back in with copy
-truncate copytest2;
-copy copytest2(test) from :'filename' csv;
-select test from copytest2 order by test collate "C";
- test
--------
- \.
- line1
- line2
-(3 rows)
-
--- in text mode, \. must be alone on its line
-truncate copytest2;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy.out 2025-05-18 10:37:15.586434000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/copy.out 2025-05-18 10:39:28.826743000 +...
@@ -39,314 +39,3 @@
\qecho '\\.'
\qecho line2
\o
--- get the data back in with copy
-truncate copytest2;
-copy copytest2(test) from :'filename' csv;
-select test from copytest2 order by test collate "C";
- test
--------
- \.
- line1
- line2
-(3 rows)
-
--- in text mode, \. must be alone on its line
-truncate copytest2;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy.out 2025-05-18 10:37:15.586434000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/copy.out 2025-05-18 10:38:31.930905000 +0000
@@ -39,314 +39,3 @@
\qecho '\\.'
\qecho line2
\o
--- get the data back in with copy
-truncate copytest2;
-copy copytest2(test) from :'filename' csv;
-select test from copytest2 order by test collate "C";
- test
--------
- \.
- line1
- line2
-(3 rows)
-
--- in text mode, \. must be alone on its line
-truncate copytest2;
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy.out 2025-05-18 10:37:14.867617031 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/copy.out 2025-05-18 10:40:48.782722873 +0000
@@ -39,314 +39,21 @@
\qecho '\\.'
\qecho line2
\o
--- get the data back in with copy
-truncate copytest2;
-copy copytest2(test) from :'filename' csv;
-select test from copytest2 order by test collate "C";
- test
--------
- \.
- line1
- line2
-(3 rows)
-
--- in text mode, \. must be alone on its line
-truncate copytest2;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy.out /tmp/cirrus-ci-build/src/test/regress/results/copy.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy.out 2025-05-18 10:37:14.867617031 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/copy.out 2025-05-18 10:38:49.115045336 +0000
@@ -39,314 +39,21 @@
\qecho '\\.'
\qecho line2
\o
--- get the data back in with copy
-truncate copytest2;
-copy copytest2(test) from :'filename' csv;
-select test from copytest2 order by test collate "C";
- test
--------
- \.
- line1
- line2
-(3 rows)
-
--- in text mode, \. must be alone on its line
-truncate copytest2;
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_up...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy.out 2025-05-18 10:37:13.940987614 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy.out 2025-05-18 10:38:51.471590172 +00...
@@ -39,314 +39,15 @@
\qecho '\\.'
\qecho line2
\o
--- get the data back in with copy
-truncate copytest2;
-copy copytest2(test) from :'filename' csv;
-select test from copytest2 order by test collate "C";
- test
--------
- \.
- line1
- line2
-(3 rows)
+==16458==Using libbacktrace symbolizer.
+../src/bin/psql/command.c:2497:19: runtime error: load of null pointer of type 'char'
+ #0 0x55f1a9b8a743 in exec_command_out ../src/bin/psql/command.c:2497
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy.out 2025-05-18 10:37:13.940987614 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/copy.out 2025-05-18 10:40:07.972721508 +...
@@ -39,314 +39,15 @@
\qecho '\\.'
\qecho line2
\o
--- get the data back in with copy
-truncate copytest2;
-copy copytest2(test) from :'filename' csv;
-select test from copytest2 order by test collate "C";
- test
--------
- \.
- line1
- line2
-(3 rows)
+==26396==Using libbacktrace symbolizer.
+../src/bin/psql/command.c:2497:19: runtime error: load of null pointer of type 'char'
+ #0 0x5618d192c743 in exec_command_out ../src/bin/psql/command.c:2497
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy.out 2025-05-18 10:37:13.940987614 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/copy.out 2025-05-18 10:38:49.975585728 +0000
@@ -39,314 +39,15 @@
\qecho '\\.'
\qecho line2
\o
--- get the data back in with copy
-truncate copytest2;
-copy copytest2(test) from :'filename' csv;
-select test from copytest2 order by test collate "C";
- test
--------
- \.
- line1
- line2
-(3 rows)
+==16165==Using libbacktrace symbolizer.
+../src/bin/psql/command.c:2497:19: runtime error: load of null pointer of type 'char'
+ #0 0x55fdd99d6743 in exec_command_out ../src/bin/psql/command.c:2497
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/copy.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrad...
--- /Users/admin/pgsql/src/test/regress/expected/copy.out 2025-05-18 10:36:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy.out 2025-05-18 10:37:38
@@ -39,314 +39,3 @@
\qecho '\\.'
\qecho line2
\o
--- get the data back in with copy
-truncate copytest2;
-copy copytest2(test) from :'filename' csv;
-select test from copytest2 order by test collate "C";
- test
--------
- \.
- line1
- line2
-(3 rows)
-
--- in text mode, \. must be alone on its line
-truncate copytest2;
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/copy.out /Users/admin/pgsql/build/testrun/recovery/027_stream_regr...
--- /Users/admin/pgsql/src/test/regress/expected/copy.out 2025-05-18 10:36:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/copy.out 2025-05-18 10:38:47
@@ -39,314 +39,3 @@
\qecho '\\.'
\qecho line2
\o
--- get the data back in with copy
-truncate copytest2;
-copy copytest2(test) from :'filename' csv;
-select test from copytest2 order by test collate "C";
- test
--------
- \.
- line1
- line2
-(3 rows)
-
--- in text mode, \. must be alone on its line
-truncate copytest2;
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/copy.out /Users/admin/pgsql/build/testrun/regress/regress/results/...
--- /Users/admin/pgsql/src/test/regress/expected/copy.out 2025-05-18 10:36:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/copy.out 2025-05-18 10:37:34
@@ -39,314 +39,3 @@
\qecho '\\.'
\qecho line2
\o
--- get the data back in with copy
-truncate copytest2;
-copy copytest2(test) from :'filename' csv;
-select test from copytest2 order by test collate "C";
- test
--------
- \.
- line1
- line2
-(3 rows)
-
--- in text mode, \. must be alone on its line
-truncate copytest2;
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/copy.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgr...
--- C:/cirrus/src/test/regress/expected/copy.out 2025-05-18 10:37:17.338469100 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy.out 2025-05-18 10:39:24.434448200 +0000
@@ -39,314 +39,3 @@
\qecho '\\.'
\qecho line2
\o
--- get the data back in with copy
-truncate copytest2;
-copy copytest2(test) from :'filename' csv;
-select test from copytest2 order by test collate "C";
- test
--------
- \.
- line1
- line2
-(3 rows)
-
--- in text mode, \. must be alone on its line
-truncate copytest2;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/copy.out C:/cirrus/build/testrun/recovery/027_stream_re...
--- C:/cirrus/src/test/regress/expected/copy.out 2025-05-18 10:37:17.338469100 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/copy.out 2025-05-18 10:41:58.971784400 +0000
@@ -39,314 +39,3 @@
\qecho '\\.'
\qecho line2
\o
--- get the data back in with copy
-truncate copytest2;
-copy copytest2(test) from :'filename' csv;
-select test from copytest2 order by test collate "C";
- test
--------
- \.
- line1
- line2
-(3 rows)
-
--- in text mode, \. must be alone on its line
-truncate copytest2;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/copy.out C:/cirrus/build/testrun/regress/regress/result...
--- C:/cirrus/src/test/regress/expected/copy.out 2025-05-18 10:37:17.338469100 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/copy.out 2025-05-18 10:39:19.829214600 +0000
@@ -39,314 +39,3 @@
\qecho '\\.'
\qecho line2
\o
--- get the data back in with copy
-truncate copytest2;
-copy copytest2(test) from :'filename' csv;
-select test from copytest2 order by test collate "C";
- test
--------
- \.
- line1
- line2
-(3 rows)
-
--- in text mode, \. must be alone on its line
-truncate copytest2;
... |
| 53/5751 |
Disable parallel query by default |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/deadlock-parallel.out /tmp/cirrus-ci-build/build/testrun/isola...
--- /tmp/cirrus-ci-build/src/test/isolation/expected/deadlock-parallel.out 2025-05-17 06:29:57.590233000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/deadlock-parallel.out 2025-05-17 06:31:47.755029000 +...
@@ -46,6 +46,7 @@
1
(1 row)
+step e1c: COMMIT;
step d2a1: <... completed>
sum
-----
@@ -57,7 +58,6 @@
1
(1 row)
-step e1c: COMMIT;
step d2c: COMMIT;
step e2l: <... completed>
lock_excl |
| 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-05-17 06:29:56.245328000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_overexplain/regress/results/pg_overexplain.out 2025-05-17 06:33:05.851344000 +...
@@ -91,26 +91,26 @@
GroupAggregate
Group Key: vegetables.genus
Disabled Nodes: 0
- Parallel Safe: true
+ Parallel Safe: false
Plan Node ID: 0
-> Sort
Sort Key: vegetables.genus, vegetables.name
Disabled Nodes: 0
- Parallel Safe: true
+ Parallel Safe: false
Plan Node ID: 1
-> Append
Disabled Nodes: 0
- Parallel Safe: true
+ Parallel Safe: false
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/build/testrun/pg_upgrad...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2025-05-17 06:29:57.749017000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2025-05-17 06:32:07.85...
@@ -1390,7 +1390,6 @@
select set_role_and_error(0);
ERROR: division by zero
CONTEXT: SQL function "set_role_and_error" statement 1
-parallel worker
reset debug_parallel_query;
drop function set_and_report_role();
drop function set_role_and_error(int);
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out 2025-05-17 06:29:57.736696000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plpgsql.out 2025-05-17 06:32:25.034443000 ...
@@ -4111,15 +4111,11 @@
$$ language plpgsql parallel safe;
set debug_parallel_query to on;
explain (verbose, costs off) select error_trap_test();
- QUERY PLAN
------------------------------------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/build/testrun/recovery/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2025-05-17 06:29:57.749017000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2025-05-17 06:33:15....
@@ -1390,7 +1390,6 @@
select set_role_and_error(0);
ERROR: division by zero
CONTEXT: SQL function "set_role_and_error" statement 1
-parallel worker
reset debug_parallel_query;
drop function set_and_report_role();
drop function set_role_and_error(int);
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out 2025-05-17 06:29:57.736696000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/plpgsql.out 2025-05-17 06:33:36.36486500...
@@ -4111,15 +4111,11 @@
$$ language plpgsql parallel safe;
set debug_parallel_query to on;
explain (verbose, costs off) select error_trap_test();
- QUERY PLAN
------------------------------------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/build/testrun/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2025-05-17 06:29:57.749017000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/select_parallel.out 2025-05-17 06:32:06.767227000 +0000
@@ -1390,7 +1390,6 @@
select set_role_and_error(0);
ERROR: division by zero
CONTEXT: SQL function "set_role_and_error" statement 1
-parallel worker
reset debug_parallel_query;
drop function set_and_report_role();
drop function set_role_and_error(int);
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out /tmp/cirrus-ci-build/build/testrun/regress/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out 2025-05-17 06:29:57.736696000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/plpgsql.out 2025-05-17 06:32:20.198560000 +0000
@@ -4111,15 +4111,11 @@
$$ language plpgsql parallel safe;
set debug_parallel_query to on;
explain (verbose, costs off) select error_trap_test();
- QUERY PLAN
------------------------------------
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_overexplain/expected/pg_overexplain.out /tmp/cirrus-ci-build/contrib/pg_overexp...
--- /tmp/cirrus-ci-build/contrib/pg_overexplain/expected/pg_overexplain.out 2025-05-17 06:29:56.205063613 +0000
+++ /tmp/cirrus-ci-build/contrib/pg_overexplain/results/pg_overexplain.out 2025-05-17 06:36:59.600047279 +0000
@@ -91,26 +91,26 @@
GroupAggregate
Group Key: vegetables.genus
Disabled Nodes: 0
- Parallel Safe: true
+ Parallel Safe: false
Plan Node ID: 0
-> Sort
Sort Key: vegetables.genus, vegetables.name
Disabled Nodes: 0
- Parallel Safe: true
+ Parallel Safe: false
Plan Node ID: 1
-> Append
Disabled Nodes: 0
- Parallel Safe: true
+ Parallel Safe: false
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2025-05-17 06:29:58.205063655 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/select_parallel.out 2025-05-17 06:38:17.879991910 +0000
@@ -1390,7 +1390,6 @@
select set_role_and_error(0);
ERROR: division by zero
CONTEXT: SQL function "set_role_and_error" statement 1
-parallel worker
reset debug_parallel_query;
drop function set_and_report_role();
drop function set_role_and_error(int);
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out 2025-05-17 06:29:58.189063654 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/plpgsql.out 2025-05-17 06:38:32.455978591 +0000
@@ -4111,15 +4111,11 @@
$$ language plpgsql parallel safe;
set debug_parallel_query to on;
explain (verbose, costs off) select error_trap_test();
- QUERY PLAN
------------------------------------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/deadlock-parallel.out /tmp/cirrus-ci-build/src/test/isolation/...
--- /tmp/cirrus-ci-build/src/test/isolation/expected/deadlock-parallel.out 2025-05-17 06:29:57.973063650 +0000
+++ /tmp/cirrus-ci-build/src/test/isolation/output_iso/results/deadlock-parallel.out 2025-05-17 06:34:49.740128047 +0000
@@ -46,6 +46,7 @@
1
(1 row)
+step e1c: COMMIT;
step d2a1: <... completed>
sum
-----
@@ -57,7 +58,6 @@
1
(1 row)
-step e1c: COMMIT;
step d2c: COMMIT;
step e2l: <... completed>
lock_excl |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/src/test/recovery/tmp_c...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2025-05-17 06:29:58.205063655 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/select_parallel.out 2025-05-17 06:39:58.339910859 +0000
@@ -1390,7 +1390,6 @@
select set_role_and_error(0);
ERROR: division by zero
CONTEXT: SQL function "set_role_and_error" statement 1
-parallel worker
reset debug_parallel_query;
drop function set_and_report_role();
drop function set_role_and_error(int);
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out 2025-05-17 06:29:58.189063654 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/plpgsql.out 2025-05-17 06:40:12.635900907 +0000
@@ -4111,15 +4111,11 @@
$$ language plpgsql parallel safe;
set debug_parallel_query to on;
explain (verbose, costs off) select error_trap_test();
- QUERY PLAN
------------------------------------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/src/test/regress/result...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2025-05-17 06:29:58.205063655 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/select_parallel.out 2025-05-17 06:35:40.348091042 +0000
@@ -1390,7 +1390,6 @@
select set_role_and_error(0);
ERROR: division by zero
CONTEXT: SQL function "set_role_and_error" statement 1
-parallel worker
reset debug_parallel_query;
drop function set_and_report_role();
drop function set_role_and_error(int);
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out /tmp/cirrus-ci-build/src/test/regress/results/plpgsq...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out 2025-05-17 06:29:58.189063654 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/plpgsql.out 2025-05-17 06:36:10.604073067 +0000
@@ -4111,15 +4111,11 @@
$$ language plpgsql parallel safe;
set debug_parallel_query to on;
explain (verbose, costs off) select error_trap_test();
- QUERY PLAN
------------------------------------
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/deadlock-parallel.out /tmp/cirrus-ci-build/build/testrun/isola...
--- /tmp/cirrus-ci-build/src/test/isolation/expected/deadlock-parallel.out 2025-05-17 06:29:59.600532582 +0000
+++ /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/deadlock-parallel.out 2025-05-17 06:34:49.988513327 +...
@@ -46,6 +46,7 @@
1
(1 row)
+step e1c: COMMIT;
step d2a1: <... completed>
sum
-----
@@ -57,7 +58,6 @@
1
(1 row)
-step e1c: COMMIT;
step d2c: COMMIT;
step e2l: <... completed>
lock_excl |
| 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-05-17 06:29:57.884750800 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_overexplain/regress/results/pg_overexplain.out 2025-05-17 06:36:54.212161871 +...
@@ -91,26 +91,26 @@
GroupAggregate
Group Key: vegetables.genus
Disabled Nodes: 0
- Parallel Safe: true
+ Parallel Safe: false
Plan Node ID: 0
-> Sort
Sort Key: vegetables.genus, vegetables.name
Disabled Nodes: 0
- Parallel Safe: true
+ Parallel Safe: false
Plan Node ID: 1
-> Append
Disabled Nodes: 0
- Parallel Safe: true
+ Parallel Safe: false
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/build/testrun/pg_upgrad...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2025-05-17 06:29:59.816052948 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2025-05-17 06:35:24.21...
@@ -1390,7 +1390,6 @@
select set_role_and_error(0);
ERROR: division by zero
CONTEXT: SQL function "set_role_and_error" statement 1
-parallel worker
reset debug_parallel_query;
drop function set_and_report_role();
drop function set_role_and_error(int);
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out 2025-05-17 06:29:59.800088477 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plpgsql.out 2025-05-17 06:35:39.788409517 ...
@@ -4111,15 +4111,11 @@
$$ language plpgsql parallel safe;
set debug_parallel_query to on;
explain (verbose, costs off) select error_trap_test();
- QUERY PLAN
------------------------------------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/build/testrun/recovery/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2025-05-17 06:29:59.816052948 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2025-05-17 06:36:35....
@@ -1390,7 +1390,6 @@
select set_role_and_error(0);
ERROR: division by zero
CONTEXT: SQL function "set_role_and_error" statement 1
-parallel worker
reset debug_parallel_query;
drop function set_and_report_role();
drop function set_role_and_error(int);
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out 2025-05-17 06:29:59.800088477 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/plpgsql.out 2025-05-17 06:36:50.94817391...
@@ -4111,15 +4111,11 @@
$$ language plpgsql parallel safe;
set debug_parallel_query to on;
explain (verbose, costs off) select error_trap_test();
- QUERY PLAN
------------------------------------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/build/testrun/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2025-05-17 06:29:59.816052948 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/select_parallel.out 2025-05-17 06:35:18.568463141 +0000
@@ -1390,7 +1390,6 @@
select set_role_and_error(0);
ERROR: division by zero
CONTEXT: SQL function "set_role_and_error" statement 1
-parallel worker
reset debug_parallel_query;
drop function set_and_report_role();
drop function set_role_and_error(int);
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out /tmp/cirrus-ci-build/build/testrun/regress/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/plpgsql.out 2025-05-17 06:29:59.800088477 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/plpgsql.out 2025-05-17 06:35:32.992427891 +0000
@@ -4111,15 +4111,11 @@
$$ language plpgsql parallel safe;
set debug_parallel_query to on;
explain (verbose, costs off) select error_trap_test();
- QUERY PLAN
------------------------------------
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/isolation/expected/deadlock-parallel.out /Users/admin/pgsql/build/testrun/isolation...
--- /Users/admin/pgsql/src/test/isolation/expected/deadlock-parallel.out 2025-05-17 06:29:12
+++ /Users/admin/pgsql/build/testrun/isolation/isolation/results/deadlock-parallel.out 2025-05-17 06:31:27
@@ -46,6 +46,7 @@
1
(1 row)
+step e1c: COMMIT;
step d2a1: <... completed>
sum
-----
@@ -57,7 +58,6 @@
1
(1 row)
-step e1c: COMMIT;
step d2c: COMMIT;
step e2l: <... completed>
lock_excl |
| regress |
diff -U3 /Users/admin/pgsql/contrib/pg_overexplain/expected/pg_overexplain.out /Users/admin/pgsql/build/testrun/pg_overe...
--- /Users/admin/pgsql/contrib/pg_overexplain/expected/pg_overexplain.out 2025-05-17 06:29:10
+++ /Users/admin/pgsql/build/testrun/pg_overexplain/regress/results/pg_overexplain.out 2025-05-17 06:33:05
@@ -91,26 +91,26 @@
GroupAggregate
Group Key: vegetables.genus
Disabled Nodes: 0
- Parallel Safe: true
+ Parallel Safe: false
Plan Node ID: 0
-> Sort
Sort Key: vegetables.genus, vegetables.name
Disabled Nodes: 0
- Parallel Safe: true
+ Parallel Safe: false
Plan Node ID: 1
-> Append
Disabled Nodes: 0
- Parallel Safe: true
+ Parallel Safe: false
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/select_parallel.out /Users/admin/pgsql/build/testrun/pg_upgrade/00...
--- /Users/admin/pgsql/src/test/regress/expected/select_parallel.out 2025-05-17 06:29:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2025-05-17 06:31:42
@@ -1390,7 +1390,6 @@
select set_role_and_error(0);
ERROR: division by zero
CONTEXT: SQL function "set_role_and_error" statement 1
-parallel worker
reset debug_parallel_query;
drop function set_and_report_role();
drop function set_role_and_error(int);
diff -U3 /Users/admin/pgsql/src/test/regress/expected/plpgsql.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upg...
--- /Users/admin/pgsql/src/test/regress/expected/plpgsql.out 2025-05-17 06:29:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plpgsql.out 2025-05-17 06:31:49
@@ -4111,15 +4111,11 @@
$$ language plpgsql parallel safe;
set debug_parallel_query to on;
explain (verbose, costs off) select error_trap_test();
- QUERY PLAN
------------------------------------
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/select_parallel.out /Users/admin/pgsql/build/testrun/recovery/027_...
--- /Users/admin/pgsql/src/test/regress/expected/select_parallel.out 2025-05-17 06:29:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2025-05-17 06:32:57
@@ -1390,7 +1390,6 @@
select set_role_and_error(0);
ERROR: division by zero
CONTEXT: SQL function "set_role_and_error" statement 1
-parallel worker
reset debug_parallel_query;
drop function set_and_report_role();
drop function set_role_and_error(int);
diff -U3 /Users/admin/pgsql/src/test/regress/expected/plpgsql.out /Users/admin/pgsql/build/testrun/recovery/027_stream_r...
--- /Users/admin/pgsql/src/test/regress/expected/plpgsql.out 2025-05-17 06:29:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/plpgsql.out 2025-05-17 06:33:06
@@ -4111,15 +4111,11 @@
$$ language plpgsql parallel safe;
set debug_parallel_query to on;
explain (verbose, costs off) select error_trap_test();
- QUERY PLAN
------------------------------------
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/select_parallel.out /Users/admin/pgsql/build/testrun/regress/regre...
--- /Users/admin/pgsql/src/test/regress/expected/select_parallel.out 2025-05-17 06:29:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/select_parallel.out 2025-05-17 06:31:45
@@ -1390,7 +1390,6 @@
select set_role_and_error(0);
ERROR: division by zero
CONTEXT: SQL function "set_role_and_error" statement 1
-parallel worker
reset debug_parallel_query;
drop function set_and_report_role();
drop function set_role_and_error(int);
diff -U3 /Users/admin/pgsql/src/test/regress/expected/plpgsql.out /Users/admin/pgsql/build/testrun/regress/regress/resul...
--- /Users/admin/pgsql/src/test/regress/expected/plpgsql.out 2025-05-17 06:29:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/plpgsql.out 2025-05-17 06:31:53
@@ -4111,15 +4111,11 @@
$$ language plpgsql parallel safe;
set debug_parallel_query to on;
explain (verbose, costs off) select error_trap_test();
- QUERY PLAN
------------------------------------
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/isolation/expected/deadlock-parallel.out C:/cirrus/build/testrun/isolati...
--- C:/cirrus/src/test/isolation/expected/deadlock-parallel.out 2025-05-17 06:30:02.165570500 +0000
+++ C:/cirrus/build/testrun/isolation/isolation/results/deadlock-parallel.out 2025-05-17 06:32:39.191521900 +0000
@@ -46,6 +46,7 @@
1
(1 row)
+step e1c: COMMIT;
step d2a1: <... completed>
sum
-----
@@ -57,7 +58,6 @@
1
(1 row)
-step e1c: COMMIT;
step d2c: COMMIT;
step e2l: <... completed>
lock_excl |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_overexplain/expected/pg_overexplain.out C:/cirrus/build/testrun/pg_ove...
--- C:/cirrus/contrib/pg_overexplain/expected/pg_overexplain.out 2025-05-17 06:29:58.201765500 +0000
+++ C:/cirrus/build/testrun/pg_overexplain/regress/results/pg_overexplain.out 2025-05-17 06:37:15.347662100 +0000
@@ -91,26 +91,26 @@
GroupAggregate
Group Key: vegetables.genus
Disabled Nodes: 0
- Parallel Safe: true
+ Parallel Safe: false
Plan Node ID: 0
-> Sort
Sort Key: vegetables.genus, vegetables.name
Disabled Nodes: 0
- Parallel Safe: true
+ Parallel Safe: false
Plan Node ID: 1
-> Append
Disabled Nodes: 0
- Parallel Safe: true
+ Parallel Safe: false
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/select_parallel.out C:/cirrus/build/testrun/pg_upgrade/...
--- C:/cirrus/src/test/regress/expected/select_parallel.out 2025-05-17 06:30:02.858539300 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2025-05-17 06:33:23.299894300 +00...
@@ -1390,7 +1390,6 @@
select set_role_and_error(0);
ERROR: division by zero
CONTEXT: SQL function "set_role_and_error" statement 1
-parallel worker
reset debug_parallel_query;
drop function set_and_report_role();
drop function set_role_and_error(int);
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/plpgsql.out C:/cirrus/build/testrun/pg_upgrade/002_pg_u...
--- C:/cirrus/src/test/regress/expected/plpgsql.out 2025-05-17 06:30:02.820478100 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plpgsql.out 2025-05-17 06:33:43.627522000 +0000
@@ -4111,15 +4111,11 @@
$$ language plpgsql parallel safe;
set debug_parallel_query to on;
explain (verbose, costs off) select error_trap_test();
- QUERY PLAN
------------------------------------
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/select_parallel.out C:/cirrus/build/testrun/recovery/02...
--- C:/cirrus/src/test/regress/expected/select_parallel.out 2025-05-17 06:30:02.858539300 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2025-05-17 06:36:07.443918200 +...
@@ -1390,7 +1390,6 @@
select set_role_and_error(0);
ERROR: division by zero
CONTEXT: SQL function "set_role_and_error" statement 1
-parallel worker
reset debug_parallel_query;
drop function set_and_report_role();
drop function set_role_and_error(int);
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/plpgsql.out C:/cirrus/build/testrun/recovery/027_stream...
--- C:/cirrus/src/test/regress/expected/plpgsql.out 2025-05-17 06:30:02.820478100 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/plpgsql.out 2025-05-17 06:36:30.525900600 +0000
@@ -4111,15 +4111,11 @@
$$ language plpgsql parallel safe;
set debug_parallel_query to on;
explain (verbose, costs off) select error_trap_test();
- QUERY PLAN
------------------------------------
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/select_parallel.out C:/cirrus/build/testrun/regress/reg...
--- C:/cirrus/src/test/regress/expected/select_parallel.out 2025-05-17 06:30:02.858539300 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/select_parallel.out 2025-05-17 06:33:21.950788200 +0000
@@ -1390,7 +1390,6 @@
select set_role_and_error(0);
ERROR: division by zero
CONTEXT: SQL function "set_role_and_error" statement 1
-parallel worker
reset debug_parallel_query;
drop function set_and_report_role();
drop function set_role_and_error(int);
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/plpgsql.out C:/cirrus/build/testrun/regress/regress/res...
--- C:/cirrus/src/test/regress/expected/plpgsql.out 2025-05-17 06:30:02.820478100 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/plpgsql.out 2025-05-17 06:33:40.596344000 +0000
@@ -4111,15 +4111,11 @@
$$ language plpgsql parallel safe;
set debug_parallel_query to on;
explain (verbose, costs off) select error_trap_test();
- QUERY PLAN
------------------------------------
... |
| 53/5738 |
Improve hash join's handling of tuples with null join keys |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join_hash.out /tmp/cirrus-ci-build/build/testrun/recovery/027_st...
--- /tmp/cirrus-ci-build/src/test/regress/expected/join_hash.out 2025-05-17 02:46:03.568327000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/join_hash.out 2025-05-17 02:50:07.852996...
@@ -309,7 +309,7 @@
select count(*) from simple r full outer join simple s using (id);
count
-------
- 20002
+ 20001
(1 row)
rollback to settings; |
| 53/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 2025-05-16 18:16:44.593089018 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonb_jsonpath.out 2025-05-16 18:25:41....
@@ -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 2025-05-16 18:16:44.593089018 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/recovery/027_stream_regress/data/results/jsonb_jsonpath.out 2025-05-16 18:27:0...
@@ -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 2025-05-16 18:16:44.593089018 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/jsonb_jsonpath.out 2025-05-16 18:25:41.357082785 +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 |
| 53/5748 |
Improve Valgrind support and remove some memory leaks |
|
FreeBSD - Meson |
| 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-05-16 02:55:03.724737000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/join.out 2025-05-16 02:56:48.654951000 +00...
@@ -8183,1227 +8183,10 @@
select * from int4_tbl i left join
lateral (select coalesce(i) from int2_tbl j where i.f1 = j.f1) k on true;
- f1 | coalesce
--------------+----------
- 0 | (0)
- 123456 |
- -123456 |
- 2147483647 |
- -2147483647 |
-(5 rows)
-
-explain (verbose, costs off)
-select * from int4_tbl a,
- lateral (
- select * from int4_tbl b left join int8_tbl c on (b.f1 = q1 and a.f1 = q2)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out 2025-05-16 02:55:03.693944000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/btree_index.out 2025-05-16 02:57:44.6938...
@@ -557,113 +557,7 @@
INSERT INTO dedup_unique_test_table SELECT 1;
END LOOP;
END$$;
--- Exercise the LP_DEAD-bit-set tuple deletion code with a posting list tuple.
--- The implementation prefers deleting existing items to merging any duplicate
--- tuples into a posting list, so we need an explicit test to make sure we get
--- coverage (note that this test also assumes BLCKSZ is 8192 or less):
-DROP INDEX plain_unique;
-DELETE FROM dedup_unique_test_table WHERE a = 1;
-INSERT INTO dedup_unique_test_table SELECT i FROM generate_series(0,450) i;
---
--- Test B-tree fast path (cache rightmost leaf page) optimization.
---
--- First create a tree that's at least three levels deep (i.e. has one level
--- between the root and leaf levels). The text inserted is long. It won't be
--- TOAST compressed because we use plain storage in the table. Only a few
... |
| 53/5110 |
Add XMLCast (SQL/XML X025) |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/xml.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/xml.out 2025-05-15 00:24:07.383329000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/xml.out 2025-05-15 00:28:42.400266000 +000...
@@ -2214,7 +2214,7 @@
SELECT j, pg_typeof(j) FROM xmlcast('11:11:11.5'::time with time zone at time zone 'Europe/Berlin' AS xml) t(j);
j | pg_typeof
---------------+-----------
- 19:11:11.5+01 | xml
+ 20:11:11.5+02 | xml
(1 row)
-- Convert an XML string to bytea and back to xml
@@ -2377,7 +2377,7 @@
SELECT * FROM view_xmlcast_to_xml;
c1 | c2 | c3 | c4 | c5 | c6 | c7 | c8 | ...
----+-----+----+----+----+----+-----------------------------------+-----------------------------------+----------------...
- | foo | | | | | foo & <"bar"> | foo & <"bar"> | foo & <&...
+ | foo | | | | | foo & <"bar"> | foo & <"bar"> | foo & <&...
(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/xml.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/xml.out 2025-05-15 00:24:07.383329000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/xml.out 2025-05-15 00:29:58.000962000 +0...
@@ -2214,7 +2214,7 @@
SELECT j, pg_typeof(j) FROM xmlcast('11:11:11.5'::time with time zone at time zone 'Europe/Berlin' AS xml) t(j);
j | pg_typeof
---------------+-----------
- 19:11:11.5+01 | xml
+ 20:11:11.5+02 | xml
(1 row)
-- Convert an XML string to bytea and back to xml
@@ -2377,7 +2377,7 @@
SELECT * FROM view_xmlcast_to_xml;
c1 | c2 | c3 | c4 | c5 | c6 | c7 | c8 | ...
----+-----+----+----+----+----+-----------------------------------+-----------------------------------+----------------...
- | foo | | | | | foo & <"bar"> | foo & <"bar"> | foo & <&...
+ | foo | | | | | foo & <"bar"> | foo & <"bar"> | foo & <&...
(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/xml.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/xml.out 2025-05-15 00:24:07.383329000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/xml.out 2025-05-15 00:28:45.966384000 +0000
@@ -2214,7 +2214,7 @@
SELECT j, pg_typeof(j) FROM xmlcast('11:11:11.5'::time with time zone at time zone 'Europe/Berlin' AS xml) t(j);
j | pg_typeof
---------------+-----------
- 19:11:11.5+01 | xml
+ 20:11:11.5+02 | xml
(1 row)
-- Convert an XML string to bytea and back to xml
@@ -2377,7 +2377,7 @@
SELECT * FROM view_xmlcast_to_xml;
c1 | c2 | c3 | c4 | c5 | c6 | c7 | c8 | ...
----+-----+----+----+----+----+-----------------------------------+-----------------------------------+----------------...
- | foo | | | | | foo & <"bar"> | foo & <"bar"> | foo & <&...
+ | foo | | | | | foo & <"bar"> | foo & <"bar"> | foo & <&...
(1 row)
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/xml.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/result...
--- /tmp/cirrus-ci-build/src/test/regress/expected/xml.out 2025-05-15 00:24:08.053485622 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/xml.out 2025-05-15 00:33:11.105723080 +0000
@@ -2214,7 +2214,7 @@
SELECT j, pg_typeof(j) FROM xmlcast('11:11:11.5'::time with time zone at time zone 'Europe/Berlin' AS xml) t(j);
j | pg_typeof
---------------+-----------
- 19:11:11.5+01 | xml
+ 20:11:11.5+02 | xml
(1 row)
-- Convert an XML string to bytea and back to xml
@@ -2377,7 +2377,7 @@
SELECT * FROM view_xmlcast_to_xml;
c1 | c2 | c3 | c4 | c5 | c6 | c7 | c8 | ...
----+-----+----+----+----+----+-----------------------------------+-----------------------------------+----------------...
- | foo | | | | | foo & <"bar"> | foo & <"bar"> | foo & <&...
+ | foo | | | | | foo & <"bar"> | foo & <"bar"> | foo & <&...
(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/xml.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results...
--- /tmp/cirrus-ci-build/src/test/regress/expected/xml.out 2025-05-15 00:24:08.053485622 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/xml.out 2025-05-15 00:34:52.757612725 +0000
@@ -2214,7 +2214,7 @@
SELECT j, pg_typeof(j) FROM xmlcast('11:11:11.5'::time with time zone at time zone 'Europe/Berlin' AS xml) t(j);
j | pg_typeof
---------------+-----------
- 19:11:11.5+01 | xml
+ 20:11:11.5+02 | xml
(1 row)
-- Convert an XML string to bytea and back to xml
@@ -2377,7 +2377,7 @@
SELECT * FROM view_xmlcast_to_xml;
c1 | c2 | c3 | c4 | c5 | c6 | c7 | c8 | ...
----+-----+----+----+----+----+-----------------------------------+-----------------------------------+----------------...
- | foo | | | | | foo & <"bar"> | foo & <"bar"> | foo & <&...
+ | foo | | | | | foo & <"bar"> | foo & <"bar"> | foo & <&...
(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/xml.out /tmp/cirrus-ci-build/src/test/regress/results/xml.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/xml.out 2025-05-15 00:24:08.053485622 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/xml.out 2025-05-15 00:30:33.009822524 +0000
@@ -2214,7 +2214,7 @@
SELECT j, pg_typeof(j) FROM xmlcast('11:11:11.5'::time with time zone at time zone 'Europe/Berlin' AS xml) t(j);
j | pg_typeof
---------------+-----------
- 19:11:11.5+01 | xml
+ 20:11:11.5+02 | xml
(1 row)
-- Convert an XML string to bytea and back to xml
@@ -2377,7 +2377,7 @@
SELECT * FROM view_xmlcast_to_xml;
c1 | c2 | c3 | c4 | c5 | c6 | c7 | c8 | ...
----+-----+----+----+----+----+-----------------------------------+-----------------------------------+----------------...
- | foo | | | | | foo & <"bar"> | foo & <"bar"> | foo & <&...
+ | foo | | | | | foo & <"bar"> | foo & <"bar"> | foo & <&...
(1 row)
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/xml.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/xml.out 2025-05-15 00:24:07.553313496 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/xml.out 2025-05-15 00:30:16.824808454 +000...
@@ -2214,7 +2214,7 @@
SELECT j, pg_typeof(j) FROM xmlcast('11:11:11.5'::time with time zone at time zone 'Europe/Berlin' AS xml) t(j);
j | pg_typeof
---------------+-----------
- 19:11:11.5+01 | xml
+ 20:11:11.5+02 | xml
(1 row)
-- Convert an XML string to bytea and back to xml
@@ -2377,7 +2377,7 @@
SELECT * FROM view_xmlcast_to_xml;
c1 | c2 | c3 | c4 | c5 | c6 | c7 | c8 | ...
----+-----+----+----+----+----+-----------------------------------+-----------------------------------+----------------...
- | foo | | | | | foo & <"bar"> | foo & <"bar"> | foo & <&...
+ | foo | | | | | foo & <"bar"> | foo & <"bar"> | foo & <&...
(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/xml.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/xml.out 2025-05-15 00:24:07.553313496 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/xml.out 2025-05-15 00:31:33.964586413 +0...
@@ -2214,7 +2214,7 @@
SELECT j, pg_typeof(j) FROM xmlcast('11:11:11.5'::time with time zone at time zone 'Europe/Berlin' AS xml) t(j);
j | pg_typeof
---------------+-----------
- 19:11:11.5+01 | xml
+ 20:11:11.5+02 | xml
(1 row)
-- Convert an XML string to bytea and back to xml
@@ -2377,7 +2377,7 @@
SELECT * FROM view_xmlcast_to_xml;
c1 | c2 | c3 | c4 | c5 | c6 | c7 | c8 | ...
----+-----+----+----+----+----+-----------------------------------+-----------------------------------+----------------...
- | foo | | | | | foo & <"bar"> | foo & <"bar"> | foo & <&...
+ | foo | | | | | foo & <"bar"> | foo & <"bar"> | foo & <&...
(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/xml.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/xml.out 2025-05-15 00:24:07.553313496 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/xml.out 2025-05-15 00:30:12.252824940 +0000
@@ -2214,7 +2214,7 @@
SELECT j, pg_typeof(j) FROM xmlcast('11:11:11.5'::time with time zone at time zone 'Europe/Berlin' AS xml) t(j);
j | pg_typeof
---------------+-----------
- 19:11:11.5+01 | xml
+ 20:11:11.5+02 | xml
(1 row)
-- Convert an XML string to bytea and back to xml
@@ -2377,7 +2377,7 @@
SELECT * FROM view_xmlcast_to_xml;
c1 | c2 | c3 | c4 | c5 | c6 | c7 | c8 | ...
----+-----+----+----+----+----+-----------------------------------+-----------------------------------+----------------...
- | foo | | | | | foo & <"bar"> | foo & <"bar"> | foo & <&...
+ | foo | | | | | foo & <"bar"> | foo & <"bar"> | foo & <&...
(1 row)
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/xml.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade...
--- /Users/admin/pgsql/src/test/regress/expected/xml.out 2025-05-15 00:23:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/xml.out 2025-05-15 00:26:15
@@ -2214,7 +2214,7 @@
SELECT j, pg_typeof(j) FROM xmlcast('11:11:11.5'::time with time zone at time zone 'Europe/Berlin' AS xml) t(j);
j | pg_typeof
---------------+-----------
- 19:11:11.5+01 | xml
+ 20:11:11.5+02 | xml
(1 row)
-- Convert an XML string to bytea and back to xml
@@ -2379,7 +2379,7 @@
SELECT * FROM view_xmlcast_to_xml;
c1 | c2 | c3 | c4 | c5 | c6 | c7 | c8 | ...
----+-----+----+----+----+----+-----------------------------------+-----------------------------------+----------------...
- | foo | | | | | foo & <"bar"> | foo & <"bar"> | foo & <&...
+ | foo | | | | | foo & <"bar"> | foo & <"bar"> | foo & <&...
(1 row)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/xml.out /Users/admin/pgsql/build/testrun/recovery/027_stream_regre...
--- /Users/admin/pgsql/src/test/regress/expected/xml.out 2025-05-15 00:23:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/xml.out 2025-05-15 00:27:12
@@ -2214,7 +2214,7 @@
SELECT j, pg_typeof(j) FROM xmlcast('11:11:11.5'::time with time zone at time zone 'Europe/Berlin' AS xml) t(j);
j | pg_typeof
---------------+-----------
- 19:11:11.5+01 | xml
+ 20:11:11.5+02 | xml
(1 row)
-- Convert an XML string to bytea and back to xml
@@ -2379,7 +2379,7 @@
SELECT * FROM view_xmlcast_to_xml;
c1 | c2 | c3 | c4 | c5 | c6 | c7 | c8 | ...
----+-----+----+----+----+----+-----------------------------------+-----------------------------------+----------------...
- | foo | | | | | foo & <"bar"> | foo & <"bar"> | foo & <&...
+ | foo | | | | | foo & <"bar"> | foo & <"bar"> | foo & <&...
(1 row)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/xml.out /Users/admin/pgsql/build/testrun/regress/regress/results/x...
--- /Users/admin/pgsql/src/test/regress/expected/xml.out 2025-05-15 00:23:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/xml.out 2025-05-15 00:26:16
@@ -2214,7 +2214,7 @@
SELECT j, pg_typeof(j) FROM xmlcast('11:11:11.5'::time with time zone at time zone 'Europe/Berlin' AS xml) t(j);
j | pg_typeof
---------------+-----------
- 19:11:11.5+01 | xml
+ 20:11:11.5+02 | xml
(1 row)
-- Convert an XML string to bytea and back to xml
@@ -2379,7 +2379,7 @@
SELECT * FROM view_xmlcast_to_xml;
c1 | c2 | c3 | c4 | c5 | c6 | c7 | c8 | ...
----+-----+----+----+----+----+-----------------------------------+-----------------------------------+----------------...
- | foo | | | | | foo & <"bar"> | foo & <"bar"> | foo & <&...
+ | foo | | | | | foo & <"bar"> | foo & <"bar"> | foo & <&...
(1 row)
... |
| 53/5669 |
Use CLOCK_MONOTONIC_COARSE for instr_time for explain analyze |
|
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-05-13 04:16:26.944419873 +0000
+++ /tmp/cirrus-ci-build/contrib/pg_stat_statements/results/entry_timestamp.out 2025-05-13 04:23:41.513657275 +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-05-13 04:16:24.707226188 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_stat_statements/regress/results/entry_timestamp.out 2025-05-13 04:23:05.246764...
@@ -45,7 +45,7 @@
WHERE query LIKE '%STMTTS%';
total | minmax_plan_zero | minmax_exec_zero | minmax_stats_since_after_ref | stats_since_after_ref
-------+------------------+------------------+------------------------------+-----------------------
- 2 | 0 | 0 | 0 | 0
+ 2 | 0 | 2 | 0 | 0
(1 row)
-- Perform single min/max reset
@@ -71,7 +71,7 @@
WHERE query LIKE '%STMTTS%';
total | minmax_plan_zero | minmax_exec_zero | minmax_stats_since_after_ref | stats_since_after_ref
-------+------------------+------------------+------------------------------+-----------------------
- 2 | 1 | 1 | 1 | 0
+ 2 | 1 | 2 | 1 | 0
(1 row)
... |
| 53/5382 |
Adding compression of temporary files |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join_hash_pglz.out /tmp/cirrus-ci-build/build-32/testrun/pg_upgr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/join_hash_pglz.out 2025-05-11 01:02:03.401015367 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade/002_pg_upgrade/data/results/join_hash_pglz.out 2025-05-11 01:12:29....
@@ -252,21 +252,13 @@
(9 rows)
select count(*) from simple r join simple s using (id);
- count
--------
- 20000
-(1 row)
-
+ERROR: could not read from temporary file: read only 8176 of 1572860 bytes
select original > 1 as initially_multibatch, final > original as increased_batches
from hash_join_batches(
$$
select count(*) from simple r join simple s using (id);
$$);
- initially_multibatch | increased_batches
-----------------------+-------------------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join_hash_pglz.out /tmp/cirrus-ci-build/build-32/testrun/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/join_hash_pglz.out 2025-05-11 01:02:03.401015367 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/join_hash_pglz.out 2025-05-11 01:12:29.146704008 +0000
@@ -252,21 +252,13 @@
(9 rows)
select count(*) from simple r join simple s using (id);
- count
--------
- 20000
-(1 row)
-
+ERROR: could not read from temporary file: read only 8176 of 1572860 bytes
select original > 1 as initially_multibatch, final > original as increased_batches
from hash_join_batches(
$$
select count(*) from simple r join simple s using (id);
$$);
- initially_multibatch | increased_batches
-----------------------+-------------------
... |
| 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-05-10 21:25:30.349713000...
+++ /tmp/cirrus-ci-build/build/testrun/test_dsm_registry-running/regress/results/test_dsm_registry.out 2025-05-10 21:34:...
@@ -17,5 +17,6 @@
name | size
-------------------+------
test_dsm_registry | 20
-(1 row)
+ injection_points | 560
+(2 rows)
|
| 53/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-05-09 23:29:56.989612000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/foreign_key.out 2025-05-09 23:33:44.789449...
@@ -874,2488 +874,7 @@
DROP TABLE PKTABLE;
-- Test for referencing column number smaller than referenced constraint
CREATE TABLE PKTABLE (ptest1 int, ptest2 int, UNIQUE(ptest1, ptest2));
-CREATE TABLE FKTABLE_FAIL1 (ftest1 int REFERENCES pktable(ptest1));
-ERROR: there is no unique constraint matching given keys for referenced table "pktable"
-DROP TABLE FKTABLE_FAIL1;
-ERROR: table "fktable_fail1" does not exist
-DROP TABLE PKTABLE;
---
--- Tests for mismatched types
---
--- Basic one column, two table setup
-CREATE TABLE PKTABLE (ptest1 int PRIMARY KEY);
-INSERT INTO PKTABLE VALUES(42);
--- This next should fail, because int=inet does not exist
-CREATE TABLE FKTABLE (ftest1 inet REFERENCES pktable);
... |
| 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-05-09 23:29:56.989612000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/foreign_key.out 2025-05-09 23:34:37.0622...
@@ -650,2712 +650,10 @@
(4 rows)
SELECT * from FKTABLE;
- ftest1 | ftest2 | ftest3 | ftest4
---------+--------+--------+--------
- 2 | 3 | 4 | 1
- | 2 | 3 | 2
- 2 | | 3 | 3
- | 2 | 7 | 4
- | 3 | 4 | 5
- | | | 1
-(6 rows)
-
--- Try to delete something that should set default
-DELETE FROM PKTABLE where ptest1=2 and ptest2=3 and ptest3=4;
--- Show PKTABLE and FKTABLE
... |
| 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-05-09 23:29:56.989612000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/foreign_key.out 2025-05-09 23:33:41.061431000 +0000
@@ -853,2509 +853,10 @@
(1, 2, NULL, 2);
DELETE FROM PKTABLE WHERE id = 1 OR id = 2;
SELECT * FROM FKTABLE ORDER BY id;
- tid | id | fk_id_del_set_null | fk_id_del_set_default
------+----+--------------------+-----------------------
- 1 | 1 | |
- 1 | 2 | | 0
-(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));
... |
|
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-05-09 23:29:57.462261313 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/foreign_key.out 2025-05-09 23:36:59.394673226 +0000
@@ -1683,1679 +1683,10 @@
CREATE TABLE fk_partitioned_fk_3_1 PARTITION OF fk_partitioned_fk_3 FOR VALUES WITH (MODULUS 5, REMAINDER 1);
ALTER TABLE fk_partitioned_fk ATTACH PARTITION fk_partitioned_fk_3
FOR VALUES FROM (2000,2000) TO (3000,3000);
--- Creating a foreign key with ONLY on a partitioned table referencing
--- a non-partitioned table fails.
-ALTER TABLE ONLY fk_partitioned_fk ADD FOREIGN KEY (a, b)
- REFERENCES fk_notpartitioned_pk;
-ERROR: cannot use ONLY for foreign key on partitioned table "fk_partitioned_fk" referencing relation "fk_notpartitione...
--- these inserts, targeting both the partition directly as well as the
--- partitioned table, should all fail
-INSERT INTO fk_partitioned_fk (a,b) VALUES (500, 501);
-ERROR: insert or update on table "fk_partitioned_fk_1" violates foreign key constraint "fk_partitioned_fk_a_b_fkey"
-DETAIL: Key (a, b)=(500, 501) is not present in table "fk_notpartitioned_pk".
-INSERT INTO fk_partitioned_fk_1 (a,b) VALUES (500, 501);
-ERROR: insert or update on table "fk_partitioned_fk_1" violates foreign key constraint "fk_partitioned_fk_a_b_fkey"
-DETAIL: Key (a, b)=(500, 501) is not present in table "fk_notpartitioned_pk".
... |
| 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-05-09 23:29:57.462261313 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/foreign_key.out 2025-05-09 23:35:29.260992493 +0000
@@ -1705,1657 +1705,10 @@
INSERT INTO fk_partitioned_fk (a,b) VALUES (2500, 2502);
ERROR: insert or update on table "fk_partitioned_fk_3_1" violates foreign key constraint "fk_partitioned_fk_a_b_fkey"
DETAIL: Key (a, b)=(2500, 2502) is not present in table "fk_notpartitioned_pk".
-INSERT INTO fk_partitioned_fk_3 (a,b) VALUES (2500, 2502);
-ERROR: insert or update on table "fk_partitioned_fk_3_1" violates foreign key constraint "fk_partitioned_fk_a_b_fkey"
-DETAIL: Key (a, b)=(2500, 2502) is not present in table "fk_notpartitioned_pk".
-INSERT INTO fk_partitioned_fk (a,b) VALUES (2501, 2503);
-ERROR: insert or update on table "fk_partitioned_fk_3_0" violates foreign key constraint "fk_partitioned_fk_a_b_fkey"
-DETAIL: Key (a, b)=(2501, 2503) is not present in table "fk_notpartitioned_pk".
-INSERT INTO fk_partitioned_fk_3 (a,b) VALUES (2501, 2503);
-ERROR: insert or update on table "fk_partitioned_fk_3_0" violates foreign key constraint "fk_partitioned_fk_a_b_fkey"
-DETAIL: Key (a, b)=(2501, 2503) is not present in table "fk_notpartitioned_pk".
--- but if we insert the values that make them valid, then they work
-INSERT INTO fk_notpartitioned_pk VALUES (500, 501), (1500, 1501),
- (2500, 2502), (2501, 2503);
-INSERT INTO fk_partitioned_fk (a,b) VALUES (500, 501);
... |
|
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-05-09 23:29:57.556916207 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/foreign_key.out 2025-05-09 23:35:23.754715...
@@ -1812,1550 +1812,10 @@
(14 rows)
ALTER TABLE fk_partitioned_fk DROP CONSTRAINT fk_partitioned_fk_a_b_fkey;
--- done.
-DROP TABLE fk_notpartitioned_pk, fk_partitioned_fk;
--- Altering a type referenced by a foreign key needs to drop/recreate the FK.
--- Ensure that works.
-CREATE TABLE fk_notpartitioned_pk (a INT, PRIMARY KEY(a), CHECK (a > 0));
-CREATE TABLE fk_partitioned_fk (a INT REFERENCES fk_notpartitioned_pk(a) PRIMARY KEY) PARTITION BY RANGE(a);
-CREATE TABLE fk_partitioned_fk_1 PARTITION OF fk_partitioned_fk FOR VALUES FROM (MINVALUE) TO (MAXVALUE);
-INSERT INTO fk_notpartitioned_pk VALUES (1);
-INSERT INTO fk_partitioned_fk VALUES (1);
-ALTER TABLE fk_notpartitioned_pk ALTER COLUMN a TYPE bigint;
-DELETE FROM fk_notpartitioned_pk WHERE a = 1;
-ERROR: update or delete on table "fk_notpartitioned_pk" violates foreign key constraint "fk_partitioned_fk_a_fkey" on ...
-DETAIL: Key (a)=(1) is still referenced from table "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-05-09 23:29:57.556916207 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/foreign_key.out 2025-05-09 23:36:34.9187...
@@ -892,2470 +892,10 @@
-- This should also fail for the same reason, but here we
-- give the column name
CREATE TABLE FKTABLE (ftest1 inet REFERENCES pktable(ptest1));
-ERROR: foreign key constraint "fktable_ftest1_fkey" cannot be implemented
-DETAIL: Key columns "ftest1" of the referencing table and "ptest1" of the referenced table are of incompatible types: ...
--- This should succeed, even though they are different types,
--- because int=int8 exists and is a member of the integer opfamily
-CREATE TABLE FKTABLE (ftest1 int8 REFERENCES pktable);
--- Check it actually works
-INSERT INTO FKTABLE VALUES(42); -- should succeed
-INSERT INTO FKTABLE VALUES(43); -- should fail
-ERROR: insert or update on table "fktable" violates foreign key constraint "fktable_ftest1_fkey"
-DETAIL: Key (ftest1)=(43) is not present in table "pktable".
-UPDATE FKTABLE SET ftest1 = ftest1; -- should succeed
-UPDATE FKTABLE SET ftest1 = ftest1 + 1; -- should fail
-ERROR: insert or update on table "fktable" violates foreign key constraint "fktable_ftest1_fkey"
... |
| 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-05-09 23:29:57.556916207 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/foreign_key.out 2025-05-09 23:35:24.786715370 +0000
@@ -1885,1477 +1885,10 @@
-- All constraints are now valid.
SELECT conname, convalidated, conrelid::regclass FROM pg_constraint
WHERE conrelid::regclass::text like 'fk_partitioned_fk%' ORDER BY oid::regclass::text;
- conname | convalidated | conrelid
---------------------------------+--------------+-----------------------
- fk_partitioned_fk_a_b_fkey | t | fk_partitioned_fk
- fk_partitioned_fk_1_a_b_fkey | t | fk_partitioned_fk_1
- fk_partitioned_fk_2_a_b_fkey | t | fk_partitioned_fk_2
- fk_partitioned_fk_3_a_b_fkey | t | fk_partitioned_fk_3
- fk_partitioned_fk_3_1_a_b_fkey | t | fk_partitioned_fk_3_1
-(5 rows)
-
-DROP TABLE fk_partitioned_fk, fk_notpartitioned_pk;
--- NOT VALID foreign key on a non-partitioned table referencing a partitioned table
-CREATE TABLE fk_partitioned_pk (a int, b int, PRIMARY KEY (a, b)) PARTITION BY RANGE (a, b);
-CREATE TABLE fk_partitioned_pk_1 PARTITION OF fk_partitioned_pk FOR VALUES FROM (0,0) TO (1000,1000);
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/foreign_key.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg...
--- /Users/admin/pgsql/src/test/regress/expected/foreign_key.out 2025-05-09 23:29:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/foreign_key.out 2025-05-09 23:32:27
@@ -604,2758 +604,13 @@
DROP TABLE PKTABLE;
-- set null update / set default delete
CREATE TABLE PKTABLE ( ptest1 int, ptest2 int, ptest3 int, ptest4 text, PRIMARY KEY(ptest1, ptest2, ptest3) );
-CREATE TABLE FKTABLE ( ftest1 int DEFAULT 0, ftest2 int, ftest3 int, ftest4 int, CONSTRAINT constrname3
- FOREIGN KEY(ftest1, ftest2, ftest3) REFERENCES PKTABLE
- ON DELETE SET DEFAULT ON UPDATE SET NULL);
--- Insert Primary Key values
-INSERT INTO PKTABLE VALUES (1, 2, 3, 'test1');
-INSERT INTO PKTABLE VALUES (1, 3, 3, 'test2');
-INSERT INTO PKTABLE VALUES (2, 3, 4, 'test3');
-INSERT INTO PKTABLE VALUES (2, 4, 5, 'test4');
--- Insert Foreign Key values
-INSERT INTO FKTABLE VALUES (1, 2, 3, 1);
-INSERT INTO FKTABLE VALUES (2, 3, 4, 1);
-INSERT INTO FKTABLE VALUES (NULL, 2, 3, 2);
-INSERT INTO FKTABLE VALUES (2, NULL, 3, 3);
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/foreign_key.out /Users/admin/pgsql/build/testrun/recovery/027_stre...
--- /Users/admin/pgsql/src/test/regress/expected/foreign_key.out 2025-05-09 23:29:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/foreign_key.out 2025-05-09 23:33:23
@@ -959,2403 +959,10 @@
CREATE TABLE FKTABLE (ftest1 int, ftest2 inet, FOREIGN KEY(ftest1, ftest2) REFERENCES pktable(ptest1, ptest2));
DROP TABLE FKTABLE;
DROP TABLE PKTABLE;
--- Two columns, same table
--- Make sure this still works...
-CREATE TABLE PKTABLE (ptest1 int, ptest2 inet, ptest3 int, ptest4 inet, PRIMARY KEY(ptest1, ptest2), FOREIGN KEY(ptest3...
-ptest4) REFERENCES pktable(ptest1, ptest2));
-DROP TABLE PKTABLE;
--- And this,
-CREATE TABLE PKTABLE (ptest1 int, ptest2 inet, ptest3 int, ptest4 inet, PRIMARY KEY(ptest1, ptest2), FOREIGN KEY(ptest3...
-ptest4) REFERENCES pktable);
-DROP TABLE PKTABLE;
--- This shouldn't (mixed up columns)
-CREATE TABLE PKTABLE (ptest1 int, ptest2 inet, ptest3 int, ptest4 inet, PRIMARY KEY(ptest1, ptest2), FOREIGN KEY(ptest3...
-ptest4) REFERENCES pktable(ptest2, ptest1));
-ERROR: foreign key constraint "pktable_ptest3_ptest4_fkey" cannot be implemented
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/cluster.out /Users/admin/pgsql/build/testrun/regress/regress/resul...
--- /Users/admin/pgsql/src/test/regress/expected/cluster.out 2025-05-09 23:29:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/cluster.out 2025-05-09 23:32:27
@@ -496,180 +496,10 @@
ALTER TABLE clstrpart CLUSTER ON clstrpart_idx;
ERROR: cannot mark index clustered in partitioned table
DROP TABLE clstrpart;
--- Ownership of partitions is checked
-CREATE TABLE ptnowner(i int unique) PARTITION BY LIST (i);
-CREATE INDEX ptnowner_i_idx ON ptnowner(i);
-CREATE TABLE ptnowner1 PARTITION OF ptnowner FOR VALUES IN (1);
-CREATE ROLE regress_ptnowner;
-CREATE TABLE ptnowner2 PARTITION OF ptnowner FOR VALUES IN (2);
-ALTER TABLE ptnowner1 OWNER TO regress_ptnowner;
-SET SESSION AUTHORIZATION regress_ptnowner;
-CLUSTER ptnowner USING ptnowner_i_idx;
-ERROR: permission denied for table ptnowner
-RESET SESSION AUTHORIZATION;
-ALTER TABLE ptnowner OWNER TO regress_ptnowner;
-CREATE TEMP TABLE ptnowner_oldnodes AS
... |
|
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-05-09 23:30:00.335289600 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/foreign_key.out 2025-05-09 23:33:29.724526100 +0000
@@ -3309,53 +3309,10 @@
ALTER TABLE fk_r DETACH PARTITION fk_r_1;
ALTER TABLE fk_r DETACH PARTITION fk_r_2;
\d fk_r_2
- Partitioned table "fkpart12.fk_r_2"
- Column | Type | Collation | Nullable | Default
---------+---------+-----------+----------+---------
- id | integer | | not null |
- p_id | integer | | not null |
- p_jd | integer | | not null |
-Partition key: LIST (id)
-Indexes:
- "fk_r_2_pkey" PRIMARY KEY, btree (id)
-Foreign-key constraints:
- "fk_r_p_id_p_jd_fkey" FOREIGN KEY (p_id, p_jd) REFERENCES fk_p(id, jd)
-Number of partitions: 1 (Use \d+ to list them.)
-
... |
| 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-05-09 23:30:00.335289600 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/foreign_key.out 2025-05-09 23:35:58.606086400 +0000
@@ -2968,394 +2968,10 @@
(2 rows)
DROP TABLE fk;
-TRUNCATE TABLE pk;
-INSERT INTO pk VALUES (20), (30);
-CREATE TABLE fk (a int DEFAULT 50) PARTITION BY RANGE (a);
-CREATE TABLE fk1 PARTITION OF fk FOR VALUES FROM (1) TO (100) PARTITION BY RANGE (a);
-CREATE TABLE fk11 PARTITION OF fk1 FOR VALUES FROM (1) TO (10);
-CREATE TABLE fk12 PARTITION OF fk1 FOR VALUES FROM (10) TO (100);
-ALTER TABLE fk ADD FOREIGN KEY (a) REFERENCES pk ON UPDATE RESTRICT ON DELETE RESTRICT;
-CREATE TABLE fk_d PARTITION OF fk DEFAULT;
-INSERT INTO fk VALUES (20), (30);
-DELETE FROM pk WHERE a = 20;
-ERROR: update or delete on table "pk11" violates RESTRICT setting of foreign key constraint "fk_a_fkey_2" on table "fk...
-DETAIL: Key (a)=(20) is referenced from table "fk".
-UPDATE pk SET a = 90 WHERE a = 30;
... |
| 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-05-09 23:30:00.342535200 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/guc.out 2025-05-09 23:33:24.476187000 +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;
... |
| 53/5714 |
Allow to collect statistics on virtual generated columns |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/stats_ext.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/stats_ext.out 2025-05-09 04:26:45.275140000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/stats_ext.out 2025-05-09 04:29:57.33248300...
@@ -56,7 +56,6 @@
ERROR: unrecognized statistics kind "unrecognized"
-- incorrect expressions
CREATE STATISTICS tst ON (y) FROM ext_stats_test; -- single column reference
-ERROR: extended statistics require at least 2 columns
CREATE STATISTICS tst ON y + z FROM ext_stats_test; -- missing parentheses
ERROR: syntax error at or near "+"
LINE 1: CREATE STATISTICS tst ON y + z FROM ext_stats_test;
@@ -69,25 +68,24 @@
-- statistics on virtual generated column not allowed
CREATE TABLE ext_stats_test1 (x int, y int, z int GENERATED ALWAYS AS (x+y) VIRTUAL, w xid);
CREATE STATISTICS tst on z from ext_stats_test1;
-ERROR: statistics creation on virtual generated columns is not supported
CREATE STATISTICS tst on (z) from ext_stats_test1;
-ERROR: statistics creation on virtual generated columns is not supported
+ERROR: statistics object "tst" already exists
CREATE STATISTICS tst on (z+1) from ext_stats_test1;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/stats_ext.out /tmp/cirrus-ci-build/build/testrun/recovery/027_st...
--- /tmp/cirrus-ci-build/src/test/regress/expected/stats_ext.out 2025-05-09 04:26:45.275140000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/stats_ext.out 2025-05-09 04:31:21.561247...
@@ -56,7 +56,6 @@
ERROR: unrecognized statistics kind "unrecognized"
-- incorrect expressions
CREATE STATISTICS tst ON (y) FROM ext_stats_test; -- single column reference
-ERROR: extended statistics require at least 2 columns
CREATE STATISTICS tst ON y + z FROM ext_stats_test; -- missing parentheses
ERROR: syntax error at or near "+"
LINE 1: CREATE STATISTICS tst ON y + z FROM ext_stats_test;
@@ -69,25 +68,24 @@
-- statistics on virtual generated column not allowed
CREATE TABLE ext_stats_test1 (x int, y int, z int GENERATED ALWAYS AS (x+y) VIRTUAL, w xid);
CREATE STATISTICS tst on z from ext_stats_test1;
-ERROR: statistics creation on virtual generated columns is not supported
CREATE STATISTICS tst on (z) from ext_stats_test1;
-ERROR: statistics creation on virtual generated columns is not supported
+ERROR: statistics object "tst" already exists
CREATE STATISTICS tst on (z+1) from ext_stats_test1;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/stats_ext.out /tmp/cirrus-ci-build/build/testrun/regress/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/stats_ext.out 2025-05-09 04:26:45.275140000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/stats_ext.out 2025-05-09 04:29:59.528046000 +0000
@@ -56,7 +56,6 @@
ERROR: unrecognized statistics kind "unrecognized"
-- incorrect expressions
CREATE STATISTICS tst ON (y) FROM ext_stats_test; -- single column reference
-ERROR: extended statistics require at least 2 columns
CREATE STATISTICS tst ON y + z FROM ext_stats_test; -- missing parentheses
ERROR: syntax error at or near "+"
LINE 1: CREATE STATISTICS tst ON y + z FROM ext_stats_test;
@@ -69,25 +68,24 @@
-- statistics on virtual generated column not allowed
CREATE TABLE ext_stats_test1 (x int, y int, z int GENERATED ALWAYS AS (x+y) VIRTUAL, w xid);
CREATE STATISTICS tst on z from ext_stats_test1;
-ERROR: statistics creation on virtual generated columns is not supported
CREATE STATISTICS tst on (z) from ext_stats_test1;
-ERROR: statistics creation on virtual generated columns is not supported
+ERROR: statistics object "tst" already exists
CREATE STATISTICS tst on (z+1) from ext_stats_test1;
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/stats_ext.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/stats_ext.out 2025-05-09 04:26:38.339638250 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/stats_ext.out 2025-05-09 04:33:37.662820248 +0000
@@ -56,7 +56,6 @@
ERROR: unrecognized statistics kind "unrecognized"
-- incorrect expressions
CREATE STATISTICS tst ON (y) FROM ext_stats_test; -- single column reference
-ERROR: extended statistics require at least 2 columns
CREATE STATISTICS tst ON y + z FROM ext_stats_test; -- missing parentheses
ERROR: syntax error at or near "+"
LINE 1: CREATE STATISTICS tst ON y + z FROM ext_stats_test;
@@ -69,25 +68,24 @@
-- statistics on virtual generated column not allowed
CREATE TABLE ext_stats_test1 (x int, y int, z int GENERATED ALWAYS AS (x+y) VIRTUAL, w xid);
CREATE STATISTICS tst on z from ext_stats_test1;
-ERROR: statistics creation on virtual generated columns is not supported
CREATE STATISTICS tst on (z) from ext_stats_test1;
-ERROR: statistics creation on virtual generated columns is not supported
+ERROR: statistics object "tst" already exists
CREATE STATISTICS tst on (z+1) from ext_stats_test1;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/stats_ext.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/stats_ext.out 2025-05-09 04:26:38.339638250 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/stats_ext.out 2025-05-09 04:34:58.162704434 +0000
@@ -56,7 +56,6 @@
ERROR: unrecognized statistics kind "unrecognized"
-- incorrect expressions
CREATE STATISTICS tst ON (y) FROM ext_stats_test; -- single column reference
-ERROR: extended statistics require at least 2 columns
CREATE STATISTICS tst ON y + z FROM ext_stats_test; -- missing parentheses
ERROR: syntax error at or near "+"
LINE 1: CREATE STATISTICS tst ON y + z FROM ext_stats_test;
@@ -69,25 +68,24 @@
-- statistics on virtual generated column not allowed
CREATE TABLE ext_stats_test1 (x int, y int, z int GENERATED ALWAYS AS (x+y) VIRTUAL, w xid);
CREATE STATISTICS tst on z from ext_stats_test1;
-ERROR: statistics creation on virtual generated columns is not supported
CREATE STATISTICS tst on (z) from ext_stats_test1;
-ERROR: statistics creation on virtual generated columns is not supported
+ERROR: statistics object "tst" already exists
CREATE STATISTICS tst on (z+1) from ext_stats_test1;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/stats_ext.out /tmp/cirrus-ci-build/src/test/regress/results/stat...
--- /tmp/cirrus-ci-build/src/test/regress/expected/stats_ext.out 2025-05-09 04:26:38.339638250 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/stats_ext.out 2025-05-09 04:30:11.194984591 +0000
@@ -56,7 +56,6 @@
ERROR: unrecognized statistics kind "unrecognized"
-- incorrect expressions
CREATE STATISTICS tst ON (y) FROM ext_stats_test; -- single column reference
-ERROR: extended statistics require at least 2 columns
CREATE STATISTICS tst ON y + z FROM ext_stats_test; -- missing parentheses
ERROR: syntax error at or near "+"
LINE 1: CREATE STATISTICS tst ON y + z FROM ext_stats_test;
@@ -69,25 +68,24 @@
-- statistics on virtual generated column not allowed
CREATE TABLE ext_stats_test1 (x int, y int, z int GENERATED ALWAYS AS (x+y) VIRTUAL, w xid);
CREATE STATISTICS tst on z from ext_stats_test1;
-ERROR: statistics creation on virtual generated columns is not supported
CREATE STATISTICS tst on (z) from ext_stats_test1;
-ERROR: statistics creation on virtual generated columns is not supported
+ERROR: statistics object "tst" already exists
CREATE STATISTICS tst on (z+1) from ext_stats_test1;
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/stats_ext.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/stats_ext.out 2025-05-09 04:26:35.293883222 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/stats_ext.out 2025-05-09 04:30:09.36991605...
@@ -56,7 +56,6 @@
ERROR: unrecognized statistics kind "unrecognized"
-- incorrect expressions
CREATE STATISTICS tst ON (y) FROM ext_stats_test; -- single column reference
-ERROR: extended statistics require at least 2 columns
CREATE STATISTICS tst ON y + z FROM ext_stats_test; -- missing parentheses
ERROR: syntax error at or near "+"
LINE 1: CREATE STATISTICS tst ON y + z FROM ext_stats_test;
@@ -69,25 +68,24 @@
-- statistics on virtual generated column not allowed
CREATE TABLE ext_stats_test1 (x int, y int, z int GENERATED ALWAYS AS (x+y) VIRTUAL, w xid);
CREATE STATISTICS tst on z from ext_stats_test1;
-ERROR: statistics creation on virtual generated columns is not supported
CREATE STATISTICS tst on (z) from ext_stats_test1;
-ERROR: statistics creation on virtual generated columns is not supported
+ERROR: statistics object "tst" already exists
CREATE STATISTICS tst on (z+1) from ext_stats_test1;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/stats_ext.out /tmp/cirrus-ci-build/build/testrun/recovery/027_st...
--- /tmp/cirrus-ci-build/src/test/regress/expected/stats_ext.out 2025-05-09 04:26:35.293883222 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/stats_ext.out 2025-05-09 04:31:31.508890...
@@ -56,7 +56,6 @@
ERROR: unrecognized statistics kind "unrecognized"
-- incorrect expressions
CREATE STATISTICS tst ON (y) FROM ext_stats_test; -- single column reference
-ERROR: extended statistics require at least 2 columns
CREATE STATISTICS tst ON y + z FROM ext_stats_test; -- missing parentheses
ERROR: syntax error at or near "+"
LINE 1: CREATE STATISTICS tst ON y + z FROM ext_stats_test;
@@ -69,25 +68,24 @@
-- statistics on virtual generated column not allowed
CREATE TABLE ext_stats_test1 (x int, y int, z int GENERATED ALWAYS AS (x+y) VIRTUAL, w xid);
CREATE STATISTICS tst on z from ext_stats_test1;
-ERROR: statistics creation on virtual generated columns is not supported
CREATE STATISTICS tst on (z) from ext_stats_test1;
-ERROR: statistics creation on virtual generated columns is not supported
+ERROR: statistics object "tst" already exists
CREATE STATISTICS tst on (z+1) from ext_stats_test1;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/stats_ext.out /tmp/cirrus-ci-build/build/testrun/regress/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/stats_ext.out 2025-05-09 04:26:35.293883222 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/stats_ext.out 2025-05-09 04:30:04.126151542 +0000
@@ -56,7 +56,6 @@
ERROR: unrecognized statistics kind "unrecognized"
-- incorrect expressions
CREATE STATISTICS tst ON (y) FROM ext_stats_test; -- single column reference
-ERROR: extended statistics require at least 2 columns
CREATE STATISTICS tst ON y + z FROM ext_stats_test; -- missing parentheses
ERROR: syntax error at or near "+"
LINE 1: CREATE STATISTICS tst ON y + z FROM ext_stats_test;
@@ -69,25 +68,24 @@
-- statistics on virtual generated column not allowed
CREATE TABLE ext_stats_test1 (x int, y int, z int GENERATED ALWAYS AS (x+y) VIRTUAL, w xid);
CREATE STATISTICS tst on z from ext_stats_test1;
-ERROR: statistics creation on virtual generated columns is not supported
CREATE STATISTICS tst on (z) from ext_stats_test1;
-ERROR: statistics creation on virtual generated columns is not supported
+ERROR: statistics object "tst" already exists
CREATE STATISTICS tst on (z+1) from ext_stats_test1;
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/stats_ext.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_u...
--- /Users/admin/pgsql/src/test/regress/expected/stats_ext.out 2025-05-09 04:26:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/stats_ext.out 2025-05-09 04:28:11
@@ -56,7 +56,6 @@
ERROR: unrecognized statistics kind "unrecognized"
-- incorrect expressions
CREATE STATISTICS tst ON (y) FROM ext_stats_test; -- single column reference
-ERROR: extended statistics require at least 2 columns
CREATE STATISTICS tst ON y + z FROM ext_stats_test; -- missing parentheses
ERROR: syntax error at or near "+"
LINE 1: CREATE STATISTICS tst ON y + z FROM ext_stats_test;
@@ -69,25 +68,24 @@
-- statistics on virtual generated column not allowed
CREATE TABLE ext_stats_test1 (x int, y int, z int GENERATED ALWAYS AS (x+y) VIRTUAL, w xid);
CREATE STATISTICS tst on z from ext_stats_test1;
-ERROR: statistics creation on virtual generated columns is not supported
CREATE STATISTICS tst on (z) from ext_stats_test1;
-ERROR: statistics creation on virtual generated columns is not supported
+ERROR: statistics object "tst" already exists
CREATE STATISTICS tst on (z+1) from ext_stats_test1;
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/stats_ext.out /Users/admin/pgsql/build/testrun/recovery/027_stream...
--- /Users/admin/pgsql/src/test/regress/expected/stats_ext.out 2025-05-09 04:26:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/stats_ext.out 2025-05-09 04:29:19
@@ -56,7 +56,6 @@
ERROR: unrecognized statistics kind "unrecognized"
-- incorrect expressions
CREATE STATISTICS tst ON (y) FROM ext_stats_test; -- single column reference
-ERROR: extended statistics require at least 2 columns
CREATE STATISTICS tst ON y + z FROM ext_stats_test; -- missing parentheses
ERROR: syntax error at or near "+"
LINE 1: CREATE STATISTICS tst ON y + z FROM ext_stats_test;
@@ -69,25 +68,24 @@
-- statistics on virtual generated column not allowed
CREATE TABLE ext_stats_test1 (x int, y int, z int GENERATED ALWAYS AS (x+y) VIRTUAL, w xid);
CREATE STATISTICS tst on z from ext_stats_test1;
-ERROR: statistics creation on virtual generated columns is not supported
CREATE STATISTICS tst on (z) from ext_stats_test1;
-ERROR: statistics creation on virtual generated columns is not supported
+ERROR: statistics object "tst" already exists
CREATE STATISTICS tst on (z+1) from ext_stats_test1;
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/stats_ext.out /Users/admin/pgsql/build/testrun/regress/regress/res...
--- /Users/admin/pgsql/src/test/regress/expected/stats_ext.out 2025-05-09 04:26:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/stats_ext.out 2025-05-09 04:28:13
@@ -56,7 +56,6 @@
ERROR: unrecognized statistics kind "unrecognized"
-- incorrect expressions
CREATE STATISTICS tst ON (y) FROM ext_stats_test; -- single column reference
-ERROR: extended statistics require at least 2 columns
CREATE STATISTICS tst ON y + z FROM ext_stats_test; -- missing parentheses
ERROR: syntax error at or near "+"
LINE 1: CREATE STATISTICS tst ON y + z FROM ext_stats_test;
@@ -69,25 +68,24 @@
-- statistics on virtual generated column not allowed
CREATE TABLE ext_stats_test1 (x int, y int, z int GENERATED ALWAYS AS (x+y) VIRTUAL, w xid);
CREATE STATISTICS tst on z from ext_stats_test1;
-ERROR: statistics creation on virtual generated columns is not supported
CREATE STATISTICS tst on (z) from ext_stats_test1;
-ERROR: statistics creation on virtual generated columns is not supported
+ERROR: statistics object "tst" already exists
CREATE STATISTICS tst on (z+1) from ext_stats_test1;
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/stats_ext.out C:/cirrus/build/testrun/pg_upgrade/002_pg...
--- C:/cirrus/src/test/regress/expected/stats_ext.out 2025-05-09 04:27:20.690252600 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/stats_ext.out 2025-05-09 04:30:55.471895100 +0000
@@ -56,7 +56,6 @@
ERROR: unrecognized statistics kind "unrecognized"
-- incorrect expressions
CREATE STATISTICS tst ON (y) FROM ext_stats_test; -- single column reference
-ERROR: extended statistics require at least 2 columns
CREATE STATISTICS tst ON y + z FROM ext_stats_test; -- missing parentheses
ERROR: syntax error at or near "+"
LINE 1: CREATE STATISTICS tst ON y + z FROM ext_stats_test;
@@ -69,25 +68,24 @@
-- statistics on virtual generated column not allowed
CREATE TABLE ext_stats_test1 (x int, y int, z int GENERATED ALWAYS AS (x+y) VIRTUAL, w xid);
CREATE STATISTICS tst on z from ext_stats_test1;
-ERROR: statistics creation on virtual generated columns is not supported
CREATE STATISTICS tst on (z) from ext_stats_test1;
-ERROR: statistics creation on virtual generated columns is not supported
+ERROR: statistics object "tst" already exists
CREATE STATISTICS tst on (z+1) from ext_stats_test1;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/stats_ext.out C:/cirrus/build/testrun/recovery/027_stre...
--- C:/cirrus/src/test/regress/expected/stats_ext.out 2025-05-09 04:27:20.690252600 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/stats_ext.out 2025-05-09 04:33:53.747277700 +0000
@@ -56,7 +56,6 @@
ERROR: unrecognized statistics kind "unrecognized"
-- incorrect expressions
CREATE STATISTICS tst ON (y) FROM ext_stats_test; -- single column reference
-ERROR: extended statistics require at least 2 columns
CREATE STATISTICS tst ON y + z FROM ext_stats_test; -- missing parentheses
ERROR: syntax error at or near "+"
LINE 1: CREATE STATISTICS tst ON y + z FROM ext_stats_test;
@@ -69,25 +68,24 @@
-- statistics on virtual generated column not allowed
CREATE TABLE ext_stats_test1 (x int, y int, z int GENERATED ALWAYS AS (x+y) VIRTUAL, w xid);
CREATE STATISTICS tst on z from ext_stats_test1;
-ERROR: statistics creation on virtual generated columns is not supported
CREATE STATISTICS tst on (z) from ext_stats_test1;
-ERROR: statistics creation on virtual generated columns is not supported
+ERROR: statistics object "tst" already exists
CREATE STATISTICS tst on (z+1) from ext_stats_test1;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/stats_ext.out C:/cirrus/build/testrun/regress/regress/r...
--- C:/cirrus/src/test/regress/expected/stats_ext.out 2025-05-09 04:27:20.690252600 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/stats_ext.out 2025-05-09 04:30:50.949941300 +0000
@@ -56,7 +56,6 @@
ERROR: unrecognized statistics kind "unrecognized"
-- incorrect expressions
CREATE STATISTICS tst ON (y) FROM ext_stats_test; -- single column reference
-ERROR: extended statistics require at least 2 columns
CREATE STATISTICS tst ON y + z FROM ext_stats_test; -- missing parentheses
ERROR: syntax error at or near "+"
LINE 1: CREATE STATISTICS tst ON y + z FROM ext_stats_test;
@@ -69,25 +68,24 @@
-- statistics on virtual generated column not allowed
CREATE TABLE ext_stats_test1 (x int, y int, z int GENERATED ALWAYS AS (x+y) VIRTUAL, w xid);
CREATE STATISTICS tst on z from ext_stats_test1;
-ERROR: statistics creation on virtual generated columns is not supported
CREATE STATISTICS tst on (z) from ext_stats_test1;
-ERROR: statistics creation on virtual generated columns is not supported
+ERROR: statistics object "tst" already exists
CREATE STATISTICS tst on (z+1) from ext_stats_test1;
... |
| 53/5641 |
support fast default for domain with constraints |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/fast_default.out /tmp/cirrus-ci-build/build/testrun/regress-runn...
--- /tmp/cirrus-ci-build/src/test/regress/expected/fast_default.out 2025-04-30 06:30:02.178544000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress-running/regress/results/fast_default.out 2025-04-30 06:39:31.621697000 +0...
@@ -373,6 +373,7 @@
--table rewrite. we are applying domain volatile default expresion
ALTER TABLE t3 ADD COLUMN f domain8;
NOTICE: rewriting table t3 for reason 2
+ERROR: value for domain domain8 violates check constraint "domain8_check"
SELECT attnum, attname, atthasmissing, atthasdef, attmissingval
FROM pg_attribute
WHERE attnum > 0 AND attrelid = 't3'::regclass and not attisdropped
@@ -380,20 +381,16 @@
attnum | attname | atthasmissing | atthasdef | attmissingval
--------+---------+---------------+-----------+---------------
1 | a | f | f |
- 2 | b | f | t |
- 3 | c | f | t |
- 4 | d | f | t |
- 5 | e | f | t |
- 6 | f | f | f |
... |
| 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-04-08 05:52:49.895051000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plperl/regress/results/plperl_setup.out 2025-04-08 05:55:30.722340000 +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-04-08 05:52:46.976426862 +0000
+++ /tmp/cirrus-ci-build/src/pl/plperl/results/plperl_setup.out 2025-04-08 05:56:27.370216753 +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-04-08 05:52:49.092847353 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plperl/regress/results/plperl_setup.out 2025-04-08 05:58:59.307821334 +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-04-08 05:52:09
+++ /Users/admin/pgsql/build/testrun/plperl/regress/results/plperl_setup.out 2025-04-08 05:55:24
@@ -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-04-08 05:52:52.129960500 +0000
+++ C:/cirrus/build/testrun/plperl/regress/results/plperl_setup.out 2025-04-08 05:59:01.945179700 +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/5597 |
Warn, and disallow, clear text passwords via SQL |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subselect.out C:/cirrus/build/testrun/recovery/027_stre...
--- C:/cirrus/src/test/regress/expected/subselect.out 2025-04-04 13:43:52.629221600 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/subselect.out 2025-04-04 13:49:17.277677700 +0000
@@ -2769,15 +2769,16 @@
EXPLAIN (COSTS OFF)
SELECT c.oid,c.relname FROM pg_class c JOIN pg_am a USING (oid)
WHERE c.oid IN (VALUES (1), (2));
- QUERY PLAN
----------------------------------------------------------------
- Hash Join
- Hash Cond: (a.oid = c.oid)
- -> Seq Scan on pg_am a
- -> Hash
- -> Index Scan using pg_class_oid_index on pg_class c
- Index Cond: (oid = ANY ('{1,2}'::oid[]))
-(6 rows)
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (c.oid = a.oid)
... |
| 52/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}
... |
| 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
... |
| 53/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)
... |
| 53/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/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 |