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/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-15 23:52:00.296565000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy.out 2025-05-15 23:53:37.659518000 +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-15 23:52:00.296565000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/copy.out 2025-05-15 23:54:30.535693000 +...
@@ -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-15 23:52:00.296565000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/copy.out 2025-05-15 23:53:36.160763000 +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-15 23:52:00.090204179 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/copy.out 2025-05-15 23:57:56.123399266 +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-15 23:52:00.090204179 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/copy.out 2025-05-15 23:55:50.675410391 +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-15 23:51:59.576555556 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy.out 2025-05-15 23:55:08.509104760 +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)
+==22124==Using libbacktrace symbolizer.
+../src/bin/psql/command.c:2497:19: runtime error: load of null pointer of type 'char'
+ #0 0x5578332ee743 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-15 23:51:59.576555556 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/copy.out 2025-05-15 23:56:24.448642216 +...
@@ -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)
+==32108==Using libbacktrace symbolizer.
+../src/bin/psql/command.c:2497:19: runtime error: load of null pointer of type 'char'
+ #0 0x55e631bb2743 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-15 23:51:59.576555556 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/copy.out 2025-05-15 23:55:06.945074510 +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)
+==21795==Using libbacktrace symbolizer.
+../src/bin/psql/command.c:2497:19: runtime error: load of null pointer of type 'char'
+ #0 0x55fe48949743 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-15 23:51:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy.out 2025-05-15 23:53:06
@@ -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-15 23:51:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/copy.out 2025-05-15 23:54:26
@@ -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-15 23:51:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/copy.out 2025-05-15 23:53:03
@@ -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-15 23:52:08.191307300 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy.out 2025-05-15 23:54:30.003008000 +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-15 23:52:08.191307300 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/copy.out 2025-05-15 23:57:13.213623800 +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-15 23:52:08.191307300 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/copy.out 2025-05-15 23:54:24.255914500 +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-15 22:51:06.967981000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/deadlock-parallel.out 2025-05-15 22:52:08.266487000 +...
@@ -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-15 22:51:05.661442000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_overexplain/regress/results/pg_overexplain.out 2025-05-15 22:53:23.491874000 +...
@@ -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-15 22:51:07.125166000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2025-05-15 22:52:25.64...
@@ -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-15 22:51:07.112390000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plpgsql.out 2025-05-15 22:52:38.616394000 ...
@@ -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-15 22:51:07.125166000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2025-05-15 22:53:26....
@@ -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-15 22:51:07.112390000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/plpgsql.out 2025-05-15 22:53:48.11868700...
@@ -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-15 22:51:07.125166000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/select_parallel.out 2025-05-15 22:52:25.953004000 +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-15 22:51:07.112390000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/plpgsql.out 2025-05-15 22:52:40.256125000 +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-15 22:51:06.460349372 +0000
+++ /tmp/cirrus-ci-build/contrib/pg_overexplain/results/pg_overexplain.out 2025-05-15 22:54:59.933110458 +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-15 22:51:08.348098594 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/select_parallel.out 2025-05-15 22:56:57.381403065 +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-15 22:51:08.332041932 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/plpgsql.out 2025-05-15 22:57:13.317682433 +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-15 22:51:08.123305319 +0000
+++ /tmp/cirrus-ci-build/src/test/isolation/output_iso/results/deadlock-parallel.out 2025-05-15 22:53:11.079833117 +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-15 22:51:08.348098594 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/select_parallel.out 2025-05-15 22:58:14.634934002 +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-15 22:51:08.332041932 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/plpgsql.out 2025-05-15 22:58:28.375238348 +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-15 22:51:08.348098594 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/select_parallel.out 2025-05-15 22:54:00.296792896 +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-15 22:51:08.332041932 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/plpgsql.out 2025-05-15 22:54:28.525611888 +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-15 22:51:09.132162449 +0000
+++ /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/deadlock-parallel.out 2025-05-15 22:52:52.826536439 +...
@@ -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-15 22:51:07.510084831 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_overexplain/regress/results/pg_overexplain.out 2025-05-15 22:54:54.362204522 +...
@@ -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-15 22:51:09.351921985 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2025-05-15 22:53:27.48...
@@ -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-15 22:51:09.335939473 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plpgsql.out 2025-05-15 22:53:43.510209861 ...
@@ -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-15 22:51:09.351921985 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2025-05-15 22:54:38....
@@ -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-15 22:51:09.335939473 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/plpgsql.out 2025-05-15 22:54:52.46220374...
@@ -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-15 22:51:09.351921985 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/select_parallel.out 2025-05-15 22:53:22.794319415 +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-15 22:51:09.335939473 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/plpgsql.out 2025-05-15 22:53:36.038247066 +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-15 22:50:12
+++ /Users/admin/pgsql/build/testrun/isolation/isolation/results/deadlock-parallel.out 2025-05-15 22:51:44
@@ -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-15 22:50:11
+++ /Users/admin/pgsql/build/testrun/pg_overexplain/regress/results/pg_overexplain.out 2025-05-15 22:53:14
@@ -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-15 22:50:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2025-05-15 22:51:59
@@ -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-15 22:50:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plpgsql.out 2025-05-15 22:52: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/recovery/027_...
--- /Users/admin/pgsql/src/test/regress/expected/select_parallel.out 2025-05-15 22:50:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2025-05-15 22:53:06
@@ -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-15 22:50:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/plpgsql.out 2025-05-15 22:53:17
@@ -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-15 22:50:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/select_parallel.out 2025-05-15 22:52:02
@@ -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-15 22:50:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/plpgsql.out 2025-05-15 22:52:10
@@ -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-15 22:51:11.560501400 +0000
+++ C:/cirrus/build/testrun/isolation/isolation/results/deadlock-parallel.out 2025-05-15 22:53:37.038706800 +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-15 22:51:07.909132600 +0000
+++ C:/cirrus/build/testrun/pg_overexplain/regress/results/pg_overexplain.out 2025-05-15 22:57:53.167007600 +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-15 22:51:12.213338200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2025-05-15 22:54:30.025943100 +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-15 22:51:12.182979000 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plpgsql.out 2025-05-15 22:54:45.944871700 +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-15 22:51:12.213338200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2025-05-15 22:56:57.287146900 +...
@@ -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-15 22:51:12.182979000 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/plpgsql.out 2025-05-15 22:57:17.062989100 +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-15 22:51:12.213338200 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/select_parallel.out 2025-05-15 22:54:21.110416800 +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-15 22:51:12.182979000 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/plpgsql.out 2025-05-15 22:54:40.950256000 +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/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-15 16:30:14.255905549 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonb_jsonpath.out 2025-05-15 16:38:36....
@@ -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-15 16:30:14.255905549 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/recovery/027_stream_regress/data/results/jsonb_jsonpath.out 2025-05-15 16:39:5...
@@ -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-15 16:30:14.255905549 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/jsonb_jsonpath.out 2025-05-15 16:38:36.697012805 +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/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/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-14 22:22:54.665613000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/deadlock-parallel.out 2025-05-14 22:24:32.660758000 +...
@@ -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-14 22:22:53.248559000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_overexplain/regress/results/pg_overexplain.out 2025-05-14 22:25:58.166571000 +...
@@ -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-14 22:22:54.833426000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2025-05-14 22:24:55.18...
@@ -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-14 22:22:54.820163000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plpgsql.out 2025-05-14 22:25:12.496405000 ...
@@ -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-14 22:22:54.833426000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2025-05-14 22:26:07....
@@ -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-14 22:22:54.820163000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/plpgsql.out 2025-05-14 22:26:30.43485600...
@@ -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-14 22:22:54.833426000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/select_parallel.out 2025-05-14 22:24:54.130823000 +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-14 22:22:54.820163000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/plpgsql.out 2025-05-14 22:25:12.202985000 +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-14 22:22:52.803728961 +0000
+++ /tmp/cirrus-ci-build/contrib/pg_overexplain/results/pg_overexplain.out 2025-05-14 22:28:00.358301417 +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-14 22:22:54.781849735 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/select_parallel.out 2025-05-14 22:30:19.480820190 +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-14 22:22:54.765745422 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/plpgsql.out 2025-05-14 22:30:32.477577596 +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-14 22:22:54.544311128 +0000
+++ /tmp/cirrus-ci-build/src/test/isolation/output_iso/results/deadlock-parallel.out 2025-05-14 22:27:12.170017448 +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/regress/result...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2025-05-14 22:22:54.781849735 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/select_parallel.out 2025-05-14 22:28:05.714441091 +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-14 22:22:54.765745422 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/plpgsql.out 2025-05-14 22:28:33.003369714 +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-14 22:22:55.071984004 +0000
+++ /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/deadlock-parallel.out 2025-05-14 22:27:20.455529428 +...
@@ -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-14 22:22:53.379983968 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_overexplain/regress/results/pg_overexplain.out 2025-05-14 22:29:17.515461068 +...
@@ -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-14 22:22:55.299984009 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2025-05-14 22:27:48.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 /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-14 22:22:55.283984008 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plpgsql.out 2025-05-14 22:28:01.823500722 ...
@@ -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-14 22:22:55.299984009 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2025-05-14 22:29:01....
@@ -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-14 22:22:55.283984008 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/plpgsql.out 2025-05-14 22:29:14.86346230...
@@ -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-14 22:22:55.299984009 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/select_parallel.out 2025-05-14 22:27:47.527509795 +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-14 22:22:55.283984008 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/plpgsql.out 2025-05-14 22:28:02.335500411 +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-14 22:22:12
+++ /Users/admin/pgsql/build/testrun/isolation/isolation/results/deadlock-parallel.out 2025-05-14 22:24:17
@@ -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-14 22:22:11
+++ /Users/admin/pgsql/build/testrun/pg_overexplain/regress/results/pg_overexplain.out 2025-05-14 22:25:45
@@ -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-14 22:22:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2025-05-14 22:24:33
@@ -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-14 22:22:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plpgsql.out 2025-05-14 22:24:40
@@ -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-14 22:22:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2025-05-14 22:25:39
@@ -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-14 22:22:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/plpgsql.out 2025-05-14 22:25:48
@@ -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-14 22:22:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/select_parallel.out 2025-05-14 22:24:36
@@ -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-14 22:22:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/plpgsql.out 2025-05-14 22:24:46
@@ -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-14 22:22:57.508062000 +0000
+++ C:/cirrus/build/testrun/isolation/isolation/results/deadlock-parallel.out 2025-05-14 22:25:42.840810200 +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-14 22:22:53.821124400 +0000
+++ C:/cirrus/build/testrun/pg_overexplain/regress/results/pg_overexplain.out 2025-05-14 22:30:27.421468700 +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-14 22:22:58.192107400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2025-05-14 22:26:34.315880000 +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-14 22:22:58.163248200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plpgsql.out 2025-05-14 22:26:57.821735000 +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-14 22:22:58.192107400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2025-05-14 22:29:32.330454000 +...
@@ -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-14 22:22:58.163248200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/plpgsql.out 2025-05-14 22:29:52.807010500 +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-14 22:22:58.192107400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/select_parallel.out 2025-05-14 22:26:30.810510000 +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-14 22:22:58.163248200 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/plpgsql.out 2025-05-14 22:26:51.201618100 +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/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-14 18:34:14.590438000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy.out 2025-05-14 18:35:25.420603000 +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-14 18:34:14.590438000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/copy.out 2025-05-14 18:36:20.410989000 +...
@@ -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-14 18:34:14.590438000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/copy.out 2025-05-14 18:35:24.391666000 +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-14 18:34:15.059409104 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/copy.out 2025-05-14 18:37:24.030281608 +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-14 18:34:15.059409104 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/copy.out 2025-05-14 18:36:03.334318427 +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-14 18:34:15.295774042 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy.out 2025-05-14 18:36:00.467323588 +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)
+==16866==Using libbacktrace symbolizer.
+../src/bin/psql/command.c:2497:19: runtime error: load of null pointer of type 'char'
+ #0 0x55dcdd7d2743 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-14 18:34:15.295774042 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/copy.out 2025-05-14 18:37:19.011346990 +...
@@ -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)
+==26989==Using libbacktrace symbolizer.
+../src/bin/psql/command.c:2497:19: runtime error: load of null pointer of type 'char'
+ #0 0x562d5de0c743 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-14 18:34:15.295774042 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/copy.out 2025-05-14 18:35:58.491322313 +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)
+==16477==Using libbacktrace symbolizer.
+../src/bin/psql/command.c:2497:19: runtime error: load of null pointer of type 'char'
+ #0 0x556384906743 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-14 18:34:10
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy.out 2025-05-14 18:35:35
@@ -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-14 18:34:10
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/copy.out 2025-05-14 18:36:43
@@ -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-14 18:34:10
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/copy.out 2025-05-14 18:35:30
@@ -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-14 18:34:21.724610000 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy.out 2025-05-14 18:36:41.916279100 +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-14 18:34:21.724610000 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/copy.out 2025-05-14 18:39:17.283560300 +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-14 18:34:21.724610000 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/copy.out 2025-05-14 18:36:35.950404500 +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/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-14 16:10:16.720879060 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonb_jsonpath.out 2025-05-14 16:18:53....
@@ -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-14 16:10:16.720879060 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/recovery/027_stream_regress/data/results/jsonb_jsonpath.out 2025-05-14 16:20:1...
@@ -3082,7 +3082,7 @@
select jsonb_path_query('"abc~@~def~@~ghi"', '$.split_part("~@~", 2)');
jsonb_path_query
------------------
- "def"
+ ""
(1 row)
-- Test string methods play nicely together |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb_jsonpath.out /tmp/cirrus-ci-build/build-32/testrun/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb_jsonpath.out 2025-05-14 16:10:16.720879060 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/jsonb_jsonpath.out 2025-05-14 16:18:48.695075272 +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/arrays.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/arrays.out 2025-05-14 15:52:23.008596000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/arrays.out 2025-05-14 15:54:14.168375000 +...
@@ -2377,628 +2377,10 @@
(1 row)
select array_remove(array[1,2,2,3], 5);
- array_remove
---------------
- {1,2,2,3}
-(1 row)
-
-select array_remove(array[1,NULL,NULL,3], NULL);
- array_remove
---------------
- {1,3}
-(1 row)
-
-select array_remove(array['A','CC','D','C','RR'], 'RR');
- array_remove
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out 2025-05-14 15:52:23.010428000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/btree_index.out 2025-05-14 15:54:21.758072000 +0000
@@ -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/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/pg_upgrade/002_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/join_hash.out 2025-05-14 10:04:56.436113000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/join_hash.out 2025-05-14 10:07:42.89768400...
@@ -309,7 +309,7 @@
select count(*) from simple r full outer join simple s using (id);
count
-------
- 20002
+ 20001
(1 row)
rollback to settings; |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join_hash.out /tmp/cirrus-ci-build/build-32/testrun/recovery/027...
--- /tmp/cirrus-ci-build/src/test/regress/expected/join_hash.out 2025-05-14 10:04:53.470260668 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/recovery/027_stream_regress/data/results/join_hash.out 2025-05-14 10:16:53.537...
@@ -309,7 +309,7 @@
select count(*) from simple r full outer join simple s using (id);
count
-------
- 20002
+ 20001
(1 row)
rollback to settings; |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/join_hash.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_u...
--- /Users/admin/pgsql/src/test/regress/expected/join_hash.out 2025-05-14 10:04:10
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/join_hash.out 2025-05-14 10:08:25
@@ -835,7 +835,7 @@
select count(*) from simple r full outer join simple s using (id);
count
-------
- 20002
+ 20001
(1 row)
rollback to settings; |
| 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-13 20:46:17.883900000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/deadlock-parallel.out 2025-05-13 20:47:56.537481000 +...
@@ -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-13 20:46:16.472727000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_overexplain/regress/results/pg_overexplain.out 2025-05-13 20:49:20.029699000 +...
@@ -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-13 20:46:18.051327000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2025-05-13 20:48:18.56...
@@ -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-13 20:46:18.037930000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plpgsql.out 2025-05-13 20:48:37.058171000 ...
@@ -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-13 20:46:18.051327000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2025-05-13 20:49:29....
@@ -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-13 20:46:18.037930000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/plpgsql.out 2025-05-13 20:49:51.78444200...
@@ -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-13 20:46:18.051327000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/select_parallel.out 2025-05-13 20:48:18.200547000 +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-13 20:46:18.037930000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/plpgsql.out 2025-05-13 20:48:36.992892000 +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-13 20:46:14.976234933 +0000
+++ /tmp/cirrus-ci-build/contrib/pg_overexplain/results/pg_overexplain.out 2025-05-13 20:51:49.779871819 +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-13 20:46:16.840737954 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/select_parallel.out 2025-05-13 20:53:02.817672496 +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-13 20:46:16.824670145 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/plpgsql.out 2025-05-13 20:53:16.178053188 +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-13 20:46:16.623822541 +0000
+++ /tmp/cirrus-ci-build/src/test/isolation/output_iso/results/deadlock-parallel.out 2025-05-13 20:50:21.755420724 +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/regress/result...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2025-05-13 20:46:16.840737954 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/select_parallel.out 2025-05-13 20:51:08.795274791 +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-13 20:46:16.824670145 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/plpgsql.out 2025-05-13 20:51:32.399563569 +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-13 20:46:17.477875772 +0000
+++ /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/deadlock-parallel.out 2025-05-13 20:50:36.634992999 +...
@@ -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-13 20:46:15.831854575 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_overexplain/regress/results/pg_overexplain.out 2025-05-13 20:52:27.614979524 +...
@@ -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-13 20:46:17.690108799 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2025-05-13 20:51:03.29...
@@ -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-13 20:46:17.674091212 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plpgsql.out 2025-05-13 20:51:15.766878334 ...
@@ -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-13 20:46:17.690108799 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2025-05-13 20:52:12....
@@ -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-13 20:46:17.674091212 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/plpgsql.out 2025-05-13 20:52:26.07497503...
@@ -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-13 20:46:17.690108799 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/select_parallel.out 2025-05-13 20:51:02.074898247 +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-13 20:46:17.674091212 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/plpgsql.out 2025-05-13 20:51:15.046878936 +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-13 20:46:12
+++ /Users/admin/pgsql/build/testrun/isolation/isolation/results/deadlock-parallel.out 2025-05-13 20:48:19
@@ -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-13 20:46:10
+++ /Users/admin/pgsql/build/testrun/pg_overexplain/regress/results/pg_overexplain.out 2025-05-13 20:49:46
@@ -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-13 20:46:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2025-05-13 20:48:41
@@ -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-13 20:46:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plpgsql.out 2025-05-13 20:48:50
@@ -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-13 20:46:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2025-05-13 20:49:39
@@ -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-13 20:46:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/plpgsql.out 2025-05-13 20:49:48
@@ -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-13 20:46:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/select_parallel.out 2025-05-13 20:48: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/regress/regress/resul...
--- /Users/admin/pgsql/src/test/regress/expected/plpgsql.out 2025-05-13 20:46:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/plpgsql.out 2025-05-13 20:48:51
@@ -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-13 20:46:20.219340000 +0000
+++ C:/cirrus/build/testrun/isolation/isolation/results/deadlock-parallel.out 2025-05-13 20:48:41.889390000 +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-13 20:46:16.722770000 +0000
+++ C:/cirrus/build/testrun/pg_overexplain/regress/results/pg_overexplain.out 2025-05-13 20:52:52.419578800 +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-13 20:46:20.834381100 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2025-05-13 20:49:22.716546200 +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-13 20:46:20.809626000 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plpgsql.out 2025-05-13 20:49:39.702390700 +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-13 20:46:20.834381100 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2025-05-13 20:51:53.340825300 +...
@@ -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-13 20:46:20.809626000 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/plpgsql.out 2025-05-13 20:52:12.549977400 +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-13 20:46:20.834381100 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/select_parallel.out 2025-05-13 20:49:19.497327300 +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-13 20:46:20.809626000 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/plpgsql.out 2025-05-13 20:49:37.491443000 +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/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-13 16:17:19.346683000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy.out 2025-05-13 16:18:25.828343000 +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-13 16:17:19.346683000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/copy.out 2025-05-13 16:19:19.758269000 +...
@@ -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-13 16:17:19.346683000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/copy.out 2025-05-13 16:18:25.599799000 +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-13 16:17:19.087852582 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/copy.out 2025-05-13 16:22:34.181511180 +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/recovery/tmp_check/result...
--- /tmp/cirrus-ci-build/src/test/regress/expected/copy.out 2025-05-13 16:17:19.087852582 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/copy.out 2025-05-13 16:23:48.937399784 +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-13 16:17:19.087852582 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/copy.out 2025-05-13 16:19:02.273666570 +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-13 16:17:19.094187951 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy.out 2025-05-13 16:20:27.069581134 +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)
+==21759==Using libbacktrace symbolizer.
+../src/bin/psql/command.c:2497:19: runtime error: load of null pointer of type 'char'
+ #0 0x5590fe363743 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-13 16:17:19.094187951 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/copy.out 2025-05-13 16:21:40.721564660 +...
@@ -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)
+==31935==Using libbacktrace symbolizer.
+../src/bin/psql/command.c:2497:19: runtime error: load of null pointer of type 'char'
+ #0 0x56037784b743 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-13 16:17:19.094187951 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/copy.out 2025-05-13 16:20:24.277581329 +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)
+==21128==Using libbacktrace symbolizer.
+../src/bin/psql/command.c:2497:19: runtime error: load of null pointer of type 'char'
+ #0 0x558ed1a52743 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-13 16:17:16
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy.out 2025-05-13 16:19: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;
... |
| 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-13 16:17:16
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/copy.out 2025-05-13 16:21: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-13 16:17:16
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/copy.out 2025-05-13 16:19:26
@@ -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-13 16:17:21.943565300 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy.out 2025-05-13 16:19:39.586345400 +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-13 16:17:21.943565300 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/copy.out 2025-05-13 16:22:24.599942400 +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-13 16:17:21.943565300 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/copy.out 2025-05-13 16:19:35.232833700 +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/5636 |
Memoize ANTI and SEMI JOIN inner |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade/002...
--- /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out 2025-05-13 14:03:52.077869604 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade/002_pg_upgrade/data/results/memoize.out 2025-05-13 14:12:25.1878334...
@@ -525,7 +525,7 @@
-> Unique (actual rows=2.67 loops=N)
-> Sort (actual rows=67.33 loops=N)
Sort Key: t2_1.a
- Sort Method: quicksort Memory: 27kB
+ Sort Method: quicksort Memory: 18kB
-> Seq Scan on tab_anti t2_1 (actual rows=100.00 loops=N)
(15 rows)
|
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out /tmp/cirrus-ci-build/build-32/testrun/recovery/027_s...
--- /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out 2025-05-13 14:03:52.077869604 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/recovery/027_stream_regress/data/results/memoize.out 2025-05-13 14:13:41.35575...
@@ -525,7 +525,7 @@
-> Unique (actual rows=2.67 loops=N)
-> Sort (actual rows=67.33 loops=N)
Sort Key: t2_1.a
- Sort Method: quicksort Memory: 27kB
+ Sort Method: quicksort Memory: 18kB
-> Seq Scan on tab_anti t2_1 (actual rows=100.00 loops=N)
(15 rows)
|
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out /tmp/cirrus-ci-build/build-32/testrun/regress/regres...
--- /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out 2025-05-13 14:03:52.077869604 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/memoize.out 2025-05-13 14:12:21.771834003 +0000
@@ -525,7 +525,7 @@
-> Unique (actual rows=2.67 loops=N)
-> Sort (actual rows=67.33 loops=N)
Sort Key: t2_1.a
- Sort Method: quicksort Memory: 27kB
+ Sort Method: quicksort Memory: 18kB
-> Seq Scan on tab_anti t2_1 (actual rows=100.00 loops=N)
(15 rows)
|
| 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/5748 |
Improve Valgrind support and remove some memory leaks |
|
FreeBSD - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/aggregates.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002...
--- /tmp/cirrus-ci-build/src/test/regress/expected/aggregates.out 2025-05-11 19:30:18.926430000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/aggregates.out 2025-05-11 19:32:41.9479920...
@@ -2513,1071 +2513,10 @@
-- check collation propagates up in suitable cases:
select pg_collation_for(percentile_disc(1) within group (order by x collate "POSIX"))
from (values ('fred'),('jim')) v(x);
- pg_collation_for
-------------------
- "POSIX"
-(1 row)
-
--- ordered-set aggs created with CREATE AGGREGATE
-select test_rank(3) within group (order by x)
-from (values (1),(1),(2),(2),(3),(3),(4)) v(x);
- test_rank
------------
- 5
-(1 row)
-
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/arrays.out /tmp/cirrus-ci-build/build/testrun/regress/regress/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/arrays.out 2025-05-11 19:30:18.929678000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/arrays.out 2025-05-11 19:32:35.434958000 +0000
@@ -2148,857 +2148,10 @@
(1 row)
select array_to_string(string_to_array('1|2|3', '|'), '|');
- array_to_string
------------------
- 1|2|3
-(1 row)
-
-select array_length(array[1,2,3], 1);
- array_length
---------------
- 3
-(1 row)
-
-select array_length(array[[1,2,3], [4,5,6]], 0);
- array_length
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/plancache.out /Users/admin/pgsql/build/testrun/regress/regress/res...
--- /Users/admin/pgsql/src/test/regress/expected/plancache.out 2025-05-11 19:29:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/plancache.out 2025-05-11 19:32:04
@@ -150,251 +150,7 @@
create or replace temp view v1 as
select 2+2+4 as f1;
select cache_test_2();
- cache_test_2
---------------
- 8
-(1 row)
-
-create or replace temp view v1 as
- select 2+2+4+(select max(unique1) from tenk1) as f1;
-select cache_test_2();
- cache_test_2
---------------
- 10007
-(1 row)
-
... |