Current commitfest | Next commitfest | FAQ | Statistics | Highlights
Highlight type: all assertion compiler core linker panic regress sanitizer tap test
Time range: current 7-day 30-day 90-day
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/5708 | don't generate fake alias names, only fake eref names |
macOS - Sonoma - Meson | |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/memoize.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upg... --- /Users/admin/pgsql/src/test/regress/expected/memoize.out 2025-07-06 17:54:12 +++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/memoize.out 2025-07-06 17:56:09 @@ -545,15 +545,15 @@ SELECT * FROM tab_anti t1 WHERE t1.a IN (SELECT a FROM tab_anti t2 WHERE t2.b IN (SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0)); - QUERY PLAN -------------------------------------------------- + QUERY PLAN +--------------------------------------------------- Nested Loop Semi Join -> Seq Scan on tab_anti t1 -> Nested Loop Semi Join Join Filter: (t1.a = t2.a) -> Seq Scan on tab_anti t2 - -> Subquery Scan on "ANY_subquery" - Filter: (t2.b = "ANY_subquery".b) + -> Subquery Scan on unnamed_subquery + Filter: (t2.b = unnamed_subquery.b) ... |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/memoize.out /Users/admin/pgsql/build/testrun/recovery/027_stream_r... --- /Users/admin/pgsql/src/test/regress/expected/memoize.out 2025-07-06 17:54:12 +++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/memoize.out 2025-07-06 17:57:25 @@ -545,15 +545,15 @@ SELECT * FROM tab_anti t1 WHERE t1.a IN (SELECT a FROM tab_anti t2 WHERE t2.b IN (SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0)); - QUERY PLAN -------------------------------------------------- + QUERY PLAN +--------------------------------------------------- Nested Loop Semi Join -> Seq Scan on tab_anti t1 -> Nested Loop Semi Join Join Filter: (t1.a = t2.a) -> Seq Scan on tab_anti t2 - -> Subquery Scan on "ANY_subquery" - Filter: (t2.b = "ANY_subquery".b) + -> Subquery Scan on unnamed_subquery + Filter: (t2.b = unnamed_subquery.b) ... |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/memoize.out /Users/admin/pgsql/build/testrun/regress/regress/resul... --- /Users/admin/pgsql/src/test/regress/expected/memoize.out 2025-07-06 17:54:12 +++ /Users/admin/pgsql/build/testrun/regress/regress/results/memoize.out 2025-07-06 17:56:14 @@ -545,15 +545,15 @@ SELECT * FROM tab_anti t1 WHERE t1.a IN (SELECT a FROM tab_anti t2 WHERE t2.b IN (SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0)); - QUERY PLAN -------------------------------------------------- + QUERY PLAN +--------------------------------------------------- Nested Loop Semi Join -> Seq Scan on tab_anti t1 -> Nested Loop Semi Join Join Filter: (t1.a = t2.a) -> Seq Scan on tab_anti t2 - -> Subquery Scan on "ANY_subquery" - Filter: (t2.b = "ANY_subquery".b) + -> Subquery Scan on unnamed_subquery + Filter: (t2.b = unnamed_subquery.b) ... |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/memoize.out C:/cirrus/build/testrun/pg_upgrade/002_pg_u... --- C:/cirrus/src/test/regress/expected/memoize.out 2025-07-06 17:54:21.093575500 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/memoize.out 2025-07-06 17:58:57.836167100 +0000 @@ -545,15 +545,15 @@ SELECT * FROM tab_anti t1 WHERE t1.a IN (SELECT a FROM tab_anti t2 WHERE t2.b IN (SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0)); - QUERY PLAN -------------------------------------------------- + QUERY PLAN +--------------------------------------------------- Nested Loop Semi Join -> Seq Scan on tab_anti t1 -> Nested Loop Semi Join Join Filter: (t1.a = t2.a) -> Seq Scan on tab_anti t2 - -> Subquery Scan on "ANY_subquery" - Filter: (t2.b = "ANY_subquery".b) + -> Subquery Scan on unnamed_subquery + Filter: (t2.b = unnamed_subquery.b) ... |
regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/memoize.out C:/cirrus/build/testrun/recovery/027_stream... --- C:/cirrus/src/test/regress/expected/memoize.out 2025-07-06 17:54:21.093575500 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/memoize.out 2025-07-06 18:01:46.883034900 +0000 @@ -545,15 +545,15 @@ SELECT * FROM tab_anti t1 WHERE t1.a IN (SELECT a FROM tab_anti t2 WHERE t2.b IN (SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0)); - QUERY PLAN -------------------------------------------------- + QUERY PLAN +--------------------------------------------------- Nested Loop Semi Join -> Seq Scan on tab_anti t1 -> Nested Loop Semi Join Join Filter: (t1.a = t2.a) -> Seq Scan on tab_anti t2 - -> Subquery Scan on "ANY_subquery" - Filter: (t2.b = "ANY_subquery".b) + -> Subquery Scan on unnamed_subquery + Filter: (t2.b = unnamed_subquery.b) ... |
regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/memoize.out C:/cirrus/build/testrun/regress/regress/res... --- C:/cirrus/src/test/regress/expected/memoize.out 2025-07-06 17:54:21.093575500 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/memoize.out 2025-07-06 17:58:51.254134200 +0000 @@ -545,15 +545,15 @@ SELECT * FROM tab_anti t1 WHERE t1.a IN (SELECT a FROM tab_anti t2 WHERE t2.b IN (SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0)); - QUERY PLAN -------------------------------------------------- + QUERY PLAN +--------------------------------------------------- Nested Loop Semi Join -> Seq Scan on tab_anti t1 -> Nested Loop Semi Join Join Filter: (t1.a = t2.a) -> Seq Scan on tab_anti t2 - -> Subquery Scan on "ANY_subquery" - Filter: (t2.b = "ANY_subquery".b) + -> Subquery Scan on unnamed_subquery + Filter: (t2.b = unnamed_subquery.b) ... |
Linux - Debian Bookworm - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg... --- /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out 2025-07-06 17:54:17.644328052 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/memoize.out 2025-07-06 17:57:11.662078495 ... @@ -545,15 +545,15 @@ SELECT * FROM tab_anti t1 WHERE t1.a IN (SELECT a FROM tab_anti t2 WHERE t2.b IN (SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0)); - QUERY PLAN -------------------------------------------------- + QUERY PLAN +--------------------------------------------------- Nested Loop Semi Join -> Seq Scan on tab_anti t1 -> Nested Loop Semi Join Join Filter: (t1.a = t2.a) -> Seq Scan on tab_anti t2 - -> Subquery Scan on "ANY_subquery" - Filter: (t2.b = "ANY_subquery".b) + -> Subquery Scan on unnamed_subquery + Filter: (t2.b = unnamed_subquery.b) ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stre... --- /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out 2025-07-06 17:54:17.644328052 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/memoize.out 2025-07-06 17:58:31.58602935... @@ -545,15 +545,15 @@ SELECT * FROM tab_anti t1 WHERE t1.a IN (SELECT a FROM tab_anti t2 WHERE t2.b IN (SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0)); - QUERY PLAN -------------------------------------------------- + QUERY PLAN +--------------------------------------------------- Nested Loop Semi Join -> Seq Scan on tab_anti t1 -> Nested Loop Semi Join Join Filter: (t1.a = t2.a) -> Seq Scan on tab_anti t2 - -> Subquery Scan on "ANY_subquery" - Filter: (t2.b = "ANY_subquery".b) + -> Subquery Scan on unnamed_subquery + Filter: (t2.b = unnamed_subquery.b) ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out /tmp/cirrus-ci-build/build/testrun/regress/regress/r... --- /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out 2025-07-06 17:54:17.644328052 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/memoize.out 2025-07-06 17:57:08.638084262 +0000 @@ -545,15 +545,15 @@ SELECT * FROM tab_anti t1 WHERE t1.a IN (SELECT a FROM tab_anti t2 WHERE t2.b IN (SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0)); - QUERY PLAN -------------------------------------------------- + QUERY PLAN +--------------------------------------------------- Nested Loop Semi Join -> Seq Scan on tab_anti t1 -> Nested Loop Semi Join Join Filter: (t1.a = t2.a) -> Seq Scan on tab_anti t2 - -> Subquery Scan on "ANY_subquery" - Filter: (t2.b = "ANY_subquery".b) + -> Subquery Scan on unnamed_subquery + Filter: (t2.b = unnamed_subquery.b) ... |
Linux - Debian Bookworm - Autoconf | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/re... --- /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out 2025-07-06 17:54:17.260049932 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/memoize.out 2025-07-06 18:00:52.729226676 +0000 @@ -545,15 +545,15 @@ SELECT * FROM tab_anti t1 WHERE t1.a IN (SELECT a FROM tab_anti t2 WHERE t2.b IN (SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0)); - QUERY PLAN -------------------------------------------------- + QUERY PLAN +--------------------------------------------------- Nested Loop Semi Join -> Seq Scan on tab_anti t1 -> Nested Loop Semi Join Join Filter: (t1.a = t2.a) -> Seq Scan on tab_anti t2 - -> Subquery Scan on "ANY_subquery" - Filter: (t2.b = "ANY_subquery".b) + -> Subquery Scan on unnamed_subquery + Filter: (t2.b = unnamed_subquery.b) ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/res... --- /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out 2025-07-06 17:54:17.260049932 +0000 +++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/memoize.out 2025-07-06 18:02:22.433157086 +0000 @@ -545,15 +545,15 @@ SELECT * FROM tab_anti t1 WHERE t1.a IN (SELECT a FROM tab_anti t2 WHERE t2.b IN (SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0)); - QUERY PLAN -------------------------------------------------- + QUERY PLAN +--------------------------------------------------- Nested Loop Semi Join -> Seq Scan on tab_anti t1 -> Nested Loop Semi Join Join Filter: (t1.a = t2.a) -> Seq Scan on tab_anti t2 - -> Subquery Scan on "ANY_subquery" - Filter: (t2.b = "ANY_subquery".b) + -> Subquery Scan on unnamed_subquery + Filter: (t2.b = unnamed_subquery.b) ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out /tmp/cirrus-ci-build/src/test/regress/results/memoiz... --- /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out 2025-07-06 17:54:17.260049932 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/memoize.out 2025-07-06 17:58:02.237423047 +0000 @@ -545,15 +545,15 @@ SELECT * FROM tab_anti t1 WHERE t1.a IN (SELECT a FROM tab_anti t2 WHERE t2.b IN (SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0)); - QUERY PLAN -------------------------------------------------- + QUERY PLAN +--------------------------------------------------- Nested Loop Semi Join -> Seq Scan on tab_anti t1 -> Nested Loop Semi Join Join Filter: (t1.a = t2.a) -> Seq Scan on tab_anti t2 - -> Subquery Scan on "ANY_subquery" - Filter: (t2.b = "ANY_subquery".b) + -> Subquery Scan on unnamed_subquery + Filter: (t2.b = unnamed_subquery.b) ... |
FreeBSD - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg... --- /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out 2025-07-06 17:54:17.501396000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/memoize.out 2025-07-06 17:58:20.555380000 ... @@ -545,15 +545,15 @@ SELECT * FROM tab_anti t1 WHERE t1.a IN (SELECT a FROM tab_anti t2 WHERE t2.b IN (SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0)); - QUERY PLAN -------------------------------------------------- + QUERY PLAN +--------------------------------------------------- Nested Loop Semi Join -> Seq Scan on tab_anti t1 -> Nested Loop Semi Join Join Filter: (t1.a = t2.a) -> Seq Scan on tab_anti t2 - -> Subquery Scan on "ANY_subquery" - Filter: (t2.b = "ANY_subquery".b) + -> Subquery Scan on unnamed_subquery + Filter: (t2.b = unnamed_subquery.b) ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stre... --- /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out 2025-07-06 17:54:17.501396000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/memoize.out 2025-07-06 17:59:46.67994200... @@ -545,15 +545,15 @@ SELECT * FROM tab_anti t1 WHERE t1.a IN (SELECT a FROM tab_anti t2 WHERE t2.b IN (SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0)); - QUERY PLAN -------------------------------------------------- + QUERY PLAN +--------------------------------------------------- Nested Loop Semi Join -> Seq Scan on tab_anti t1 -> Nested Loop Semi Join Join Filter: (t1.a = t2.a) -> Seq Scan on tab_anti t2 - -> Subquery Scan on "ANY_subquery" - Filter: (t2.b = "ANY_subquery".b) + -> Subquery Scan on unnamed_subquery + Filter: (t2.b = unnamed_subquery.b) ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out /tmp/cirrus-ci-build/build/testrun/regress/regress/r... --- /tmp/cirrus-ci-build/src/test/regress/expected/memoize.out 2025-07-06 17:54:17.501396000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/memoize.out 2025-07-06 17:58:23.611417000 +0000 @@ -545,15 +545,15 @@ SELECT * FROM tab_anti t1 WHERE t1.a IN (SELECT a FROM tab_anti t2 WHERE t2.b IN (SELECT t1.b FROM tab_anti t3 WHERE t2.a > 1 OFFSET 0)); - QUERY PLAN -------------------------------------------------- + QUERY PLAN +--------------------------------------------------- Nested Loop Semi Join -> Seq Scan on tab_anti t1 -> Nested Loop Semi Join Join Filter: (t1.a = t2.a) -> Seq Scan on tab_anti t2 - -> Subquery Scan on "ANY_subquery" - Filter: (t2.b = "ANY_subquery".b) + -> Subquery Scan on unnamed_subquery + Filter: (t2.b = unnamed_subquery.b) ... |
53/4904 | SQL Property Graph Queries (SQL/PGQ) |
FreeBSD - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/graph_table.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00... --- /tmp/cirrus-ci-build/src/test/regress/expected/graph_table.out 2025-07-06 16:39:11.166496000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/graph_table.out 2025-07-06 16:42:25.486032... @@ -536,8 +536,8 @@ SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo... self | loop_name ------+----------- - v33 | e331 v33 | E331 + v33 | e331 (2 rows) SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo... @@ -613,8 +613,8 @@ SELECT * FROM GRAPH_TABLE (g2 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.elname AS self, b.elname COLLATE pg_catalog."defau... self | loop_name --------+----------- - g2.v33 | g2.e331 g2.v33 | g2.E331 + g2.v33 | g2.e331 ... |
Linux - Debian Bookworm - Autoconf | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/graph_table.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_chec... --- /tmp/cirrus-ci-build/src/test/regress/expected/graph_table.out 2025-07-06 16:39:12.790303668 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/graph_table.out 2025-07-06 16:48:02.965631334 +0000 @@ -536,8 +536,8 @@ SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo... self | loop_name ------+----------- - v33 | e331 v33 | E331 + v33 | e331 (2 rows) SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo... @@ -613,8 +613,8 @@ SELECT * FROM GRAPH_TABLE (g2 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.elname AS self, b.elname COLLATE pg_catalog."defau... self | loop_name --------+----------- - g2.v33 | g2.e331 g2.v33 | g2.E331 + g2.v33 | g2.e331 ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/graph_table.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check... --- /tmp/cirrus-ci-build/src/test/regress/expected/graph_table.out 2025-07-06 16:39:12.790303668 +0000 +++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/graph_table.out 2025-07-06 16:49:44.577542520 +0000 @@ -536,8 +536,8 @@ SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo... self | loop_name ------+----------- - v33 | e331 v33 | E331 + v33 | e331 (2 rows) SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo... @@ -613,8 +613,8 @@ SELECT * FROM GRAPH_TABLE (g2 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.elname AS self, b.elname COLLATE pg_catalog."defau... self | loop_name --------+----------- - g2.v33 | g2.e331 g2.v33 | g2.E331 + g2.v33 | g2.e331 ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/graph_table.out /tmp/cirrus-ci-build/src/test/regress/results/gr... --- /tmp/cirrus-ci-build/src/test/regress/expected/graph_table.out 2025-07-06 16:39:12.790303668 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/graph_table.out 2025-07-06 16:44:44.681769869 +0000 @@ -536,8 +536,8 @@ SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo... self | loop_name ------+----------- - v33 | e331 v33 | E331 + v33 | e331 (2 rows) SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo... @@ -613,8 +613,8 @@ SELECT * FROM GRAPH_TABLE (g2 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.elname AS self, b.elname COLLATE pg_catalog."defau... self | loop_name --------+----------- - g2.v33 | g2.e331 g2.v33 | g2.E331 + g2.v33 | g2.e331 ... |
Linux - Debian Bookworm - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/graph_table.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00... --- /tmp/cirrus-ci-build/src/test/regress/expected/graph_table.out 2025-07-06 16:39:09.624542165 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/graph_table.out 2025-07-06 16:44:48.494098... @@ -536,8 +536,8 @@ SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo... self | loop_name ------+----------- - v33 | e331 v33 | E331 + v33 | e331 (2 rows) SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo... @@ -613,8 +613,8 @@ SELECT * FROM GRAPH_TABLE (g2 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.elname AS self, b.elname COLLATE pg_catalog."defau... self | loop_name --------+----------- - g2.v33 | g2.e331 g2.v33 | g2.E331 + g2.v33 | g2.e331 ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/graph_table.out /tmp/cirrus-ci-build/build/testrun/recovery/027_... --- /tmp/cirrus-ci-build/src/test/regress/expected/graph_table.out 2025-07-06 16:39:09.624542165 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/graph_table.out 2025-07-06 16:46:06.1663... @@ -536,8 +536,8 @@ SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo... self | loop_name ------+----------- - v33 | e331 v33 | E331 + v33 | e331 (2 rows) SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo... @@ -613,8 +613,8 @@ SELECT * FROM GRAPH_TABLE (g2 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.elname AS self, b.elname COLLATE pg_catalog."defau... self | loop_name --------+----------- - g2.v33 | g2.e331 g2.v33 | g2.E331 + g2.v33 | g2.e331 ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/graph_table.out /tmp/cirrus-ci-build/build/testrun/regress/regre... --- /tmp/cirrus-ci-build/src/test/regress/expected/graph_table.out 2025-07-06 16:39:09.624542165 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/graph_table.out 2025-07-06 16:44:46.314093913 +0000 @@ -536,8 +536,8 @@ SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo... self | loop_name ------+----------- - v33 | e331 v33 | E331 + v33 | e331 (2 rows) SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo... @@ -613,8 +613,8 @@ SELECT * FROM GRAPH_TABLE (g2 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.elname AS self, b.elname COLLATE pg_catalog."defau... self | loop_name --------+----------- - g2.v33 | g2.e331 g2.v33 | g2.E331 + g2.v33 | g2.e331 ... |
macOS - Sonoma - Meson | |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/graph_table.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg... --- /Users/admin/pgsql/src/test/regress/expected/graph_table.out 2025-07-06 16:38:12 +++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/graph_table.out 2025-07-06 16:41:04 @@ -536,8 +536,8 @@ SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo... self | loop_name ------+----------- - v33 | e331 v33 | E331 + v33 | e331 (2 rows) SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo... @@ -613,8 +613,8 @@ SELECT * FROM GRAPH_TABLE (g2 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.elname AS self, b.elname COLLATE pg_catalog."defau... self | loop_name --------+----------- - g2.v33 | g2.e331 g2.v33 | g2.E331 + g2.v33 | g2.e331 ... |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/graph_table.out /Users/admin/pgsql/build/testrun/recovery/027_stre... --- /Users/admin/pgsql/src/test/regress/expected/graph_table.out 2025-07-06 16:38:12 +++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/graph_table.out 2025-07-06 16:41:58 @@ -536,8 +536,8 @@ SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo... self | loop_name ------+----------- - v33 | e331 v33 | E331 + v33 | e331 (2 rows) SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo... @@ -613,8 +613,8 @@ SELECT * FROM GRAPH_TABLE (g2 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.elname AS self, b.elname COLLATE pg_catalog."defau... self | loop_name --------+----------- - g2.v33 | g2.e331 g2.v33 | g2.E331 + g2.v33 | g2.e331 ... |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/graph_table.out /Users/admin/pgsql/build/testrun/regress/regress/r... --- /Users/admin/pgsql/src/test/regress/expected/graph_table.out 2025-07-06 16:38:12 +++ /Users/admin/pgsql/build/testrun/regress/regress/results/graph_table.out 2025-07-06 16:41:00 @@ -536,8 +536,8 @@ SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo... self | loop_name ------+----------- - v33 | e331 v33 | E331 + v33 | e331 (2 rows) SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo... @@ -613,8 +613,8 @@ SELECT * FROM GRAPH_TABLE (g2 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.elname AS self, b.elname COLLATE pg_catalog."defau... self | loop_name --------+----------- - g2.v33 | g2.e331 g2.v33 | g2.E331 + g2.v33 | g2.e331 ... |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/graph_table.out C:/cirrus/build/testrun/pg_upgrade/002_... --- C:/cirrus/src/test/regress/expected/graph_table.out 2025-07-06 16:39:15.682416100 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/graph_table.out 2025-07-06 16:42:47.774436000 +0000 @@ -536,8 +536,8 @@ SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo... self | loop_name ------+----------- - v33 | e331 v33 | E331 + v33 | e331 (2 rows) SELECT * FROM GRAPH_TABLE (g1 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.vname AS self, b.ename AS loop_name)) ORDER BY loo... @@ -613,8 +613,8 @@ SELECT * FROM GRAPH_TABLE (g2 MATCH (a)-[b]->(a)-[b]->(a) COLUMNS (a.elname AS self, b.elname COLLATE pg_catalog."defau... self | loop_name --------+----------- - g2.v33 | g2.e331 g2.v33 | g2.E331 + g2.v33 | g2.e331 ... |
53/5808 | display current search_path in psql prompt |
FreeBSD - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/regress-runn... --- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2025-07-06 09:31:12.542000000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress-running/regress/results/create_index.out 2025-07-06 09:38:32.651094000 +0... @@ -2042,7 +2042,7 @@ QUERY PLAN ---------------------------------------------------------------------------- Aggregate - -> Index Only Scan using tenk1_thous_tenthous on tenk1 t1 + -> Seq Scan on tenk1 t1 Filter: ((thousand = 42) OR (thousand = (SubPlan 1))) SubPlan 1 -> Limit @@ -2211,9 +2211,11 @@ Filter: ((thousand = 42) OR (thousand = 41) OR (tenthous = 2)) -> Bitmap Index Scan on tenk2_hundred Index Cond: (hundred = 42) - -> Index Only Scan using tenk1_hundred on tenk1 - Index Cond: (hundred = 42) -(9 rows) + -> Bitmap Heap Scan on tenk1 ... |
53/5755 | Parallel processing of indexes in autovacuum |
macOS - Sonoma - Meson | |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/stats.out /Users/admin/pgsql/build/testrun/recovery/027_stream_reg... --- /Users/admin/pgsql/src/test/regress/expected/stats.out 2025-07-06 08:34:12 +++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/stats.out 2025-07-06 08:37:59 @@ -1414,7 +1414,7 @@ SELECT :io_sum_shared_after_writes > :io_sum_shared_before_writes; ?column? ---------- - t + f (1 row) SELECT current_setting('fsync') = 'off' |
53/5319 | Changing shared_buffers without restart |
Linux - Debian Bookworm - Autoconf | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/numa.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/resul... --- /tmp/cirrus-ci-build/src/test/regress/expected/numa.out 2025-07-05 20:14:03.629909115 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/numa.out 2025-07-05 20:22:18.215972452 +0000 @@ -6,8 +6,4 @@ -- switch to superuser \c - SELECT COUNT(*) >= 0 AS ok FROM pg_shmem_allocations_numa; - ok ----- - t -(1 row) - +ERROR: invalid memory alloc request size 864765899839712 |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/numa.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/result... --- /tmp/cirrus-ci-build/src/test/regress/expected/numa.out 2025-07-05 20:14:03.629909115 +0000 +++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/numa.out 2025-07-05 20:23:35.334876234 +0000 @@ -6,8 +6,4 @@ -- switch to superuser \c - SELECT COUNT(*) >= 0 AS ok FROM pg_shmem_allocations_numa; - ok ----- - t -(1 row) - +ERROR: invalid memory alloc request size 864765899624256 |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/numa.out /tmp/cirrus-ci-build/src/test/regress/results/numa.out --- /tmp/cirrus-ci-build/src/test/regress/expected/numa.out 2025-07-05 20:14:03.629909115 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/numa.out 2025-07-05 20:20:03.782391099 +0000 @@ -6,8 +6,4 @@ -- switch to superuser \c - SELECT COUNT(*) >= 0 AS ok FROM pg_shmem_allocations_numa; - ok ----- - t -(1 row) - +ERROR: invalid memory alloc request size 864765899885808 |
55/5892 | parallel safety of correlated subquery (was: parallel_safe) |
Linux - Debian Bookworm - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/contrib/btree_gist/expected/without_overlaps.out /tmp/cirrus-ci-build/build/testrun/btree_... --- /tmp/cirrus-ci-build/contrib/btree_gist/expected/without_overlaps.out 2025-07-05 19:38:59.168733227 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/without_overlaps.out 2025-07-05 19:45:01.008431081 +00... @@ -9,84 +9,7 @@ CONSTRAINT temporal_rng_pk PRIMARY KEY (id, valid_at WITHOUT OVERLAPS) ); \d temporal_rng - Table "public.temporal_rng" - Column | Type | Collation | Nullable | Default -----------+-----------+-----------+----------+--------- - id | integer | | not null | - valid_at | daterange | | not null | -Indexes: - "temporal_rng_pk" PRIMARY KEY (id, valid_at WITHOUT OVERLAPS) - -SELECT pg_get_constraintdef(oid) FROM pg_constraint WHERE conname = 'temporal_rng_pk'; - pg_get_constraintdef ---------------------------------------------- - PRIMARY KEY (id, valid_at WITHOUT OVERLAPS) -(1 row) ... |
regress | diff -U3 /tmp/cirrus-ci-build/contrib/earthdistance/expected/earthdistance.out /tmp/cirrus-ci-build/build/testrun/earthd... --- /tmp/cirrus-ci-build/contrib/earthdistance/expected/earthdistance.out 2025-07-05 19:38:59.188733226 +0000 +++ /tmp/cirrus-ci-build/build/testrun/earthdistance/regress/results/earthdistance.out 2025-07-05 19:45:03.012431043 +00... @@ -1053,46 +1053,7 @@ drop extension cube cascade; NOTICE: drop cascades to column f1 of table foo \d foo - Table "public.foo" - Column | Type | Collation | Nullable | Default ---------+---------+-----------+----------+--------- - f2 | integer | | | - --- list what's installed -\dT public.* - List of data types - Schema | Name | Description ---------+------+------------- -(0 rows) - -\df public.* ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/bit.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upg... --- /tmp/cirrus-ci-build/src/test/regress/expected/bit.out 2025-07-05 19:39:01.104733152 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/bit.out 2025-07-05 19:43:47.344434857 +000... @@ -772,79 +772,7 @@ b4 bit varying(5) DEFAULT B'0101' ); \d bit_defaults - Table "public.bit_defaults" - Column | Type | Collation | Nullable | Default ---------+----------------+-----------+----------+--------------------- - b1 | bit(4) | | | '1001'::"bit" - b2 | bit(4) | | | '0101'::"bit" - b3 | bit varying(5) | | | '1001'::bit varying - b4 | bit varying(5) | | | '0101'::"bit" - -INSERT INTO bit_defaults DEFAULT VALUES; -TABLE bit_defaults; - b1 | b2 | b3 | b4 -------+------+------+------ - 1001 | 0101 | 1001 | 0101 ... |
regress | diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres... --- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2025-07-05 19:38:59.276733222 +0000 +++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2025-07-05 19:45:16.048430850 +0000 @@ -409,12184 +409,7 @@ -- subquery SELECT * FROM ft1 t1 WHERE t1.c3 IN (SELECT c3 FROM ft2 t2 WHERE c1 <= 10) ORDER BY c1; - c1 | c2 | c3 | c4 | c5 | c6 | c7 | c8 -----+----+-------+------------------------------+--------------------------+----+------------+----- - 1 | 1 | 00001 | Fri Jan 02 00:00:00 1970 PST | Fri Jan 02 00:00:00 1970 | 1 | 1 | foo - 2 | 2 | 00002 | Sat Jan 03 00:00:00 1970 PST | Sat Jan 03 00:00:00 1970 | 2 | 2 | foo - 3 | 3 | 00003 | Sun Jan 04 00:00:00 1970 PST | Sun Jan 04 00:00:00 1970 | 3 | 3 | foo - 4 | 4 | 00004 | Mon Jan 05 00:00:00 1970 PST | Mon Jan 05 00:00:00 1970 | 4 | 4 | foo - 5 | 5 | 00005 | Tue Jan 06 00:00:00 1970 PST | Tue Jan 06 00:00:00 1970 | 5 | 5 | foo - 6 | 6 | 00006 | Wed Jan 07 00:00:00 1970 PST | Wed Jan 07 00:00:00 1970 | 6 | 6 | foo - 7 | 7 | 00007 | Thu Jan 08 00:00:00 1970 PST | Thu Jan 08 00:00:00 1970 | 7 | 7 | foo - 8 | 8 | 00008 | Fri Jan 09 00:00:00 1970 PST | Fri Jan 09 00:00:00 1970 | 8 | 8 | foo - 9 | 9 | 00009 | Sat Jan 10 00:00:00 1970 PST | Sat Jan 10 00:00:00 1970 | 9 | 9 | foo - 10 | 0 | 00010 | Sun Jan 11 00:00:00 1970 PST | Sun Jan 11 00:00:00 1970 | 0 | 0 | foo -(10 rows) ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/bit.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_r... --- /tmp/cirrus-ci-build/src/test/regress/expected/bit.out 2025-07-05 19:39:01.104733152 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/bit.out 2025-07-05 19:44:27.328432117 +0... @@ -772,79 +772,7 @@ b4 bit varying(5) DEFAULT B'0101' ); \d bit_defaults - Table "public.bit_defaults" - Column | Type | Collation | Nullable | Default ---------+----------------+-----------+----------+--------------------- - b1 | bit(4) | | | '1001'::"bit" - b2 | bit(4) | | | '0101'::"bit" - b3 | bit varying(5) | | | '1001'::bit varying - b4 | bit varying(5) | | | '0101'::"bit" - -INSERT INTO bit_defaults DEFAULT VALUES; -TABLE bit_defaults; - b1 | b2 | b3 | b4 -------+------+------+------ - 1001 | 0101 | 1001 | 0101 ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/bit.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resul... --- /tmp/cirrus-ci-build/src/test/regress/expected/bit.out 2025-07-05 19:39:01.104733152 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/bit.out 2025-07-05 19:43:46.544434937 +0000 @@ -772,79 +772,7 @@ b4 bit varying(5) DEFAULT B'0101' ); \d bit_defaults - Table "public.bit_defaults" - Column | Type | Collation | Nullable | Default ---------+----------------+-----------+----------+--------------------- - b1 | bit(4) | | | '1001'::"bit" - b2 | bit(4) | | | '0101'::"bit" - b3 | bit varying(5) | | | '1001'::bit varying - b4 | bit varying(5) | | | '0101'::"bit" - -INSERT INTO bit_defaults DEFAULT VALUES; -TABLE bit_defaults; - b1 | b2 | b3 | b4 -------+------+------+------ - 1001 | 0101 | 1001 | 0101 ... |
regress | diff -U3 /tmp/cirrus-ci-build/contrib/seg/expected/partition.out /tmp/cirrus-ci-build/build/testrun/seg/regress/results/... --- /tmp/cirrus-ci-build/contrib/seg/expected/partition.out 2025-07-05 19:38:59.284733222 +0000 +++ /tmp/cirrus-ci-build/build/testrun/seg/regress/results/partition.out 2025-07-05 19:45:16.244430847 +0000 @@ -24,31 +24,7 @@ create table pt34 partition of pt for values in (3,4); insert into pt values(4, '-1 .. 1'::seg, 'foo'); \d+ pt - Partitioned table "public.pt" - Column | Type | Collation | Nullable | Default | Storage | Stats target | Description -----------+---------+-----------+----------+---------+----------+--------------+------------- - category | integer | | | | plain | | - sdata | seg | | | | plain | | - tdata | text | | | | extended | | -Partition key: LIST (category) -Indexes: - "pti1" btree ((mydouble(category) + 1)) - "pti2" btree (sdata) - "pti3" btree (tdata COLLATE mycollation) -Partitions: pt12 FOR VALUES IN (1, 2), - pt34 FOR VALUES IN (3, 4) ... |
regress | diff -U3 /tmp/cirrus-ci-build/contrib/test_decoding/expected/ddl.out /tmp/cirrus-ci-build/build/testrun/test_decoding/re... --- /tmp/cirrus-ci-build/contrib/test_decoding/expected/ddl.out 2025-07-05 19:38:59.304733221 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_decoding/regress/results/ddl.out 2025-07-05 19:45:19.384430812 +0000 @@ -484,374 +484,7 @@ WITH (user_catalog_table = true) ; \d+ replication_metadata - Table "public.replication_metadata" - Column | Type | Collation | Nullable | Default | Storage | Stats target... -----------+---------+-----------+----------+--------------------------------------------------+----------+-------------... - id | integer | | not null | nextval('replication_metadata_id_seq'::regclass) | plain | ... - relation | name | | not null | | plain | ... - options | text[] | | | | extended | ... -Indexes: - "replication_metadata_pkey" PRIMARY KEY, btree (id) -Not-null constraints: - "replication_metadata_id_not_null" NOT NULL "id" - "replication_metadata_relation_not_null" NOT NULL "relation" -Options: user_catalog_table=true - ... |
53/5829 | VCI (columnar store extension) |
Linux - Debian Bookworm - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/contrib/vci/expected/vci.out /tmp/cirrus-ci-build/build/testrun/vci/regress/results/vci.ou... --- /tmp/cirrus-ci-build/contrib/vci/expected/vci.out 2025-07-05 18:05:12.150435870 +0000 +++ /tmp/cirrus-ci-build/build/testrun/vci/regress/results/vci.out 2025-07-05 18:12:43.316883091 +0000 @@ -88,39 +88,7 @@ INSERT INTO testtable (key, cond, c01a, c01b, c02, c03, c05, c06, c07, c08, c09, c10, c13, c15, c16, c17, c18, c19, c20... -- Create an index which uses VCI index access method CREATE INDEX testindex ON testtable USING vci (key, cond, c01a, c01b, c02, c03, c05, c06, c07, c08, c09, c10, c13, c15,... --- We expect VCI plans are chosen here -EXPLAIN (ANALYZE, TIMING OFF, COSTS OFF, SUMMARY OFF, BUFFERS OFF) -SELECT key, count(*) AS count_star, count(c05) AS count_c05 FROM testtable WHERE NOT cond = 0 GROUP BY key ORDER BY key... - QUERY PLAN ------------------------------------------------------------------------------------------------- - Sort (actual rows=14.00 loops=1) - Sort Key: key - Sort Method: quicksort Memory: 25kB - -> Custom Scan (VCI HashAggregate) (actual rows=14.00 loops=1) - Group Key: key - -> Custom Scan (VCI Scan) using testindex on testtable (actual rows=10221.00 loops=1) - Filter: (cond <> 0) - Rows Removed by Filter: 476 ... |
53/5270 | jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/jsonpath.out C:/cirrus/build/testrun/pg_upgrade/002_pg_... --- C:/cirrus/src/test/regress/expected/jsonpath.out 2025-07-05 17:20:16.860132500 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonpath.out 2025-07-05 17:24:39.761345200 +0000 @@ -436,998 +436,7 @@ (1 row) select '$.replace("hello","bye")'::jsonpath; - jsonpath --------------------------- - $.replace("hello","bye") -(1 row) - -select '$.lower()'::jsonpath; - jsonpath ------------ - $.lower() -(1 row) - -select '$.upper()'::jsonpath; - jsonpath ... |
regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/jsonpath.out C:/cirrus/build/testrun/recovery/027_strea... --- C:/cirrus/src/test/regress/expected/jsonpath.out 2025-07-05 17:20:16.860132500 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/jsonpath.out 2025-07-05 17:27:25.417033200 +0000 @@ -436,998 +436,7 @@ (1 row) select '$.replace("hello","bye")'::jsonpath; - jsonpath --------------------------- - $.replace("hello","bye") -(1 row) - -select '$.lower()'::jsonpath; - jsonpath ------------ - $.lower() -(1 row) - -select '$.upper()'::jsonpath; - jsonpath ... |
regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/jsonpath.out C:/cirrus/build/testrun/regress/regress/re... --- C:/cirrus/src/test/regress/expected/jsonpath.out 2025-07-05 17:20:16.860132500 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/jsonpath.out 2025-07-05 17:25:45.765670700 +0000 @@ -436,998 +436,7 @@ (1 row) select '$.replace("hello","bye")'::jsonpath; - jsonpath --------------------------- - $.replace("hello","bye") -(1 row) - -select '$.lower()'::jsonpath; - jsonpath ------------ - $.lower() -(1 row) - -select '$.upper()'::jsonpath; - jsonpath ... |
macOS - Sonoma - Meson | |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/json.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrad... --- /Users/admin/pgsql/src/test/regress/expected/json.out 2025-07-05 17:19:12 +++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/json.out 2025-07-05 17:22:17 @@ -2245,524 +2245,10 @@ SELECT json_build_object('{1,2,3}'::int[], 3); ERROR: key value must be scalar, not array, composite, or json CREATE TEMP TABLE foo (serial_num int, name text, type text); -INSERT INTO foo VALUES (847001,'t15','GE1043'); -INSERT INTO foo VALUES (847002,'t16','GE1043'); -INSERT INTO foo VALUES (847003,'sub-alpha','GESS90'); -SELECT json_build_object('turbines',json_object_agg(serial_num,json_build_object('name',name,'type',type))) -FROM foo; - json_build_object ... ------------------------------------------------------------------------------------------------------------------------... - {"turbines" : { "847001" : {"name" : "t15", "type" : "GE1043"}, "847002" : {"name" : "t16", "type" : "GE1043"}, "84700... -(1 row) - -SELECT json_object_agg(name, type) FROM foo; - json_object_agg ----------------------------------------------------------------- ... |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/jsonb.out /Users/admin/pgsql/build/testrun/recovery/027_stream_reg... --- /Users/admin/pgsql/src/test/regress/expected/jsonb.out 2025-07-05 17:19:12 +++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/jsonb.out 2025-07-05 17:24:39 @@ -3460,2374 +3460,11 @@ DROP INDEX jidx_array; -- btree CREATE INDEX jidx ON testjsonb USING btree (j); -SET enable_seqscan = off; -SELECT count(*) FROM testjsonb WHERE j > '{"p":1}'; - count -------- - 884 -(1 row) - -SELECT count(*) FROM testjsonb WHERE j = '{"pos":98, "line":371, "node":"CBA", "indexed":true}'; - count -------- - 1 -(1 row) - ... |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/jsonpath.out /Users/admin/pgsql/build/testrun/regress/regress/resu... --- /Users/admin/pgsql/src/test/regress/expected/jsonpath.out 2025-07-05 17:19:12 +++ /Users/admin/pgsql/build/testrun/regress/regress/results/jsonpath.out 2025-07-05 17:22:16 @@ -436,998 +436,7 @@ (1 row) select '$.replace("hello","bye")'::jsonpath; - jsonpath --------------------------- - $.replace("hello","bye") -(1 row) - -select '$.lower()'::jsonpath; - jsonpath ------------ - $.lower() -(1 row) - -select '$.upper()'::jsonpath; - jsonpath ... |
Linux - Debian Bookworm - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonpath.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p... --- /tmp/cirrus-ci-build/src/test/regress/expected/jsonpath.out 2025-07-05 17:20:12.599473762 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonpath.out 2025-07-05 17:22:51.303345775... @@ -436,998 +436,7 @@ (1 row) select '$.replace("hello","bye")'::jsonpath; - jsonpath --------------------------- - $.replace("hello","bye") -(1 row) - -select '$.lower()'::jsonpath; - jsonpath ------------ - $.lower() -(1 row) - -select '$.upper()'::jsonpath; - jsonpath ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/json.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_... --- /tmp/cirrus-ci-build/src/test/regress/expected/json.out 2025-07-05 17:20:12.595495160 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/json.out 2025-07-05 17:24:04.955579984 +... @@ -2175,594 +2175,7 @@ (1 row) SELECT json_build_object(VARIADIC NULL::text[]); -- ok - json_build_object -------------------- - -(1 row) - -SELECT json_build_object(VARIADIC '{}'::text[]); -- ok - json_build_object -------------------- - {} -(1 row) - -SELECT json_build_object(VARIADIC '{a,b,c}'::text[]); -- error -ERROR: argument list must have even number of elements ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonpath.out /tmp/cirrus-ci-build/build/testrun/regress/regress/... --- /tmp/cirrus-ci-build/src/test/regress/expected/jsonpath.out 2025-07-05 17:20:12.599473762 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/jsonpath.out 2025-07-05 17:22:51.023343078 +0000 @@ -436,998 +436,7 @@ (1 row) select '$.replace("hello","bye")'::jsonpath; - jsonpath --------------------------- - $.replace("hello","bye") -(1 row) - -select '$.lower()'::jsonpath; - jsonpath ------------ - $.lower() -(1 row) - -select '$.upper()'::jsonpath; - jsonpath ... |
Linux - Debian Bookworm - Autoconf | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonpath.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r... --- /tmp/cirrus-ci-build/src/test/regress/expected/jsonpath.out 2025-07-05 17:20:13.581354587 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/jsonpath.out 2025-07-05 17:25:44.198561635 +0000 @@ -436,998 +436,7 @@ (1 row) select '$.replace("hello","bye")'::jsonpath; - jsonpath --------------------------- - $.replace("hello","bye") -(1 row) - -select '$.lower()'::jsonpath; - jsonpath ------------ - $.lower() -(1 row) - -select '$.upper()'::jsonpath; - jsonpath ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonpath.out /tmp/cirrus-ci-build/src/test/regress/results/jsonp... --- /tmp/cirrus-ci-build/src/test/regress/expected/jsonpath.out 2025-07-05 17:20:13.581354587 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/jsonpath.out 2025-07-05 17:23:33.850465751 +0000 @@ -436,998 +436,7 @@ (1 row) select '$.replace("hello","bye")'::jsonpath; - jsonpath --------------------------- - $.replace("hello","bye") -(1 row) - -select '$.lower()'::jsonpath; - jsonpath ------------ - $.lower() -(1 row) - -select '$.upper()'::jsonpath; - jsonpath ... |
FreeBSD - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/json.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_up... --- /tmp/cirrus-ci-build/src/test/regress/expected/json.out 2025-07-05 17:20:12.881373000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/json.out 2025-07-05 17:23:21.159479000 +00... @@ -1086,1683 +1086,10 @@ (1 row) select json_extract_path_text('{"f2":{"f3":1},"f4":[0,1,2,null]}','f4','3') is null as expect_true; - expect_true -------------- - t -(1 row) - --- extract_path operators -select '{"f2":{"f3":1},"f4":{"f5":99,"f6":"stringy"}}'::json#>array['f4','f6']; - ?column? ------------ - "stringy" -(1 row) - -select '{"f2":{"f3":1},"f4":{"f5":99,"f6":"stringy"}}'::json#>array['f2']; ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/json.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_... --- /tmp/cirrus-ci-build/src/test/regress/expected/json.out 2025-07-05 17:20:12.881373000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/json.out 2025-07-05 17:24:21.228491000 +... @@ -1074,1695 +1074,10 @@ (1 row) select json_extract_path_text('{"f2":{"f3":1},"f4":{"f5":null,"f6":"stringy"}}','f4','f5') is null as expect_true; - expect_true -------------- - t -(1 row) - -select json_extract_path('{"f2":{"f3":1},"f4":[0,1,2,null]}','f4','3') is null as expect_false; - expect_false --------------- - f -(1 row) - -select json_extract_path_text('{"f2":{"f3":1},"f4":[0,1,2,null]}','f4','3') is null as expect_true; - expect_true ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/json.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resu... --- /tmp/cirrus-ci-build/src/test/regress/expected/json.out 2025-07-05 17:20:12.881373000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/json.out 2025-07-05 17:23:23.058748000 +0000 @@ -1172,1597 +1172,10 @@ (1 row) select '{"a": {"b":{"c": "foo"}}}'::json #> array['a']; - ?column? --------------------- - {"b":{"c": "foo"}} -(1 row) - -select '{"a": {"b":{"c": "foo"}}}'::json #> array['a', null]; - ?column? ----------- - -(1 row) - -select '{"a": {"b":{"c": "foo"}}}'::json #> array['a', '']; - ?column? ... |
53/5382 | Adding compression of temporary files |
macOS - Sonoma - Meson | |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/join_hash_pglz.out /Users/admin/pgsql/build/testrun/pg_upgrade/002... --- /Users/admin/pgsql/src/test/regress/expected/join_hash_pglz.out 2025-07-05 17:09:12 +++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/join_hash_pglz.out 2025-07-05 17:11:48 @@ -252,915 +252,7 @@ (9 rows) select count(*) from simple r join simple s using (id); - count -------- - 20000 -(1 row) - -select original > 1 as initially_multibatch, final > original as increased_batches - from hash_join_batches( -$$ - select count(*) from simple r join simple s using (id); -$$); - initially_multibatch | increased_batches -----------------------+------------------- - t | f ... |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/join_hash_pglz.out /Users/admin/pgsql/build/testrun/regress/regres... --- /Users/admin/pgsql/src/test/regress/expected/join_hash_pglz.out 2025-07-05 17:09:12 +++ /Users/admin/pgsql/build/testrun/regress/regress/results/join_hash_pglz.out 2025-07-05 17:11:23 @@ -262,11 +262,9 @@ $$ select count(*) from simple r join simple s using (id); $$); - initially_multibatch | increased_batches -----------------------+------------------- - t | f -(1 row) - +ERROR: could not read from temporary file: read only 8176 of 14110 bytes +CONTEXT: parallel worker +PL/pgSQL function hash_join_batches(text) line 6 at FOR over EXECUTE statement rollback to settings; -- parallel with parallel-aware hash join savepoint settings; |
Linux - Debian Bookworm - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join_hash_pglz.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade... --- /tmp/cirrus-ci-build/src/test/regress/expected/join_hash_pglz.out 2025-07-05 17:09:25.456236121 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/join_hash_pglz.out 2025-07-05 17:12:27.391... @@ -262,11 +262,8 @@ $$ select count(*) from simple r join simple s using (id); $$); - initially_multibatch | increased_batches -----------------------+------------------- - t | f -(1 row) - +ERROR: could not read from temporary file: read only 8176 of 11860 bytes +CONTEXT: PL/pgSQL function hash_join_batches(text) line 6 at FOR over EXECUTE statement rollback to settings; -- parallel with parallel-aware hash join savepoint settings; |
53/4681 | Make COPY format extendable: Extract COPY TO format implementations |
FreeBSD - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_copy_format/expected/test_copy_format.out /tmp/cirrus-ci-build/build... --- /tmp/cirrus-ci-build/src/test/modules/test_copy_format/expected/test_copy_format.out 2025-07-05 14:43:08.177300000 +... +++ /tmp/cirrus-ci-build/build/testrun/test_copy_format-running/regress/results/test_copy_format.out 2025-07-05 14:50:30... @@ -1,19 +1,13 @@ CREATE TABLE copy_data (a smallint, b integer, c bigint); INSERT INTO copy_data VALUES (1, 2, 3), (12, 34, 56), (123, 456, 789); COPY copy_data FROM stdin WITH (FORMAT 'test_copy_format'); -NOTICE: CopyFromInFunc: attribute: smallint -NOTICE: CopyFromInFunc: attribute: integer -NOTICE: CopyFromInFunc: attribute: bigint -NOTICE: CopyFromStart: the number of attributes: 3 -NOTICE: CopyFromOneRow -NOTICE: CopyFromEnd +ERROR: COPY format "test_copy_format" not recognized +LINE 1: COPY copy_data FROM stdin WITH (FORMAT 'test_copy_format'); + ^ +\. +invalid command \. COPY copy_data TO stdout WITH (FORMAT 'test_copy_format'); -NOTICE: CopyToOutFunc: attribute: smallint ... |
53/5681 | Prevent internal error at concurrent CREATE OR REPLACE / ALTER FUNCTION |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/injection_points/expected/syscache-update-pruned.out C:/cirrus/b... --- C:/cirrus/src/test/modules/injection_points/expected/syscache-update-pruned.out 2025-07-05 07:08:17.052287600 +0000 +++ C:/cirrus/build/testrun/injection_points/isolation/results/syscache-update-pruned.out 2025-07-05 07:16:26.946532200 ... @@ -46,7 +46,7 @@ SELECT FROM injection_points_wakeup('heap_update-before-pin'); <waiting ...> step grant1: <... completed> -ERROR: duplicate key value violates unique constraint "pg_class_oid_index" +ERROR: could not create object because a conflicting object already exists step wakegrant4: <... completed> starting permutation: snap3 cachefill1 at2 mkrels4 r3 waitprunable4 vac4 grant1 wakeinval4 at4 wakegrant4 inspect4 |
regress | diff --strip-trailing-cr -U3 C:/cirrus/contrib/test_decoding/expected/replorigin.out C:/cirrus/build/testrun/test_decodi... --- C:/cirrus/contrib/test_decoding/expected/replorigin.out 2025-07-05 07:08:13.067675000 +0000 +++ C:/cirrus/build/testrun/test_decoding/regress/results/replorigin.out 2025-07-05 07:16:24.539787200 +0000 @@ -39,8 +39,9 @@ -- ensure duplicate creations fail SELECT pg_replication_origin_create('regress_test_decoding: regression_slot'); -ERROR: duplicate key value violates unique constraint "pg_replication_origin_roname_index" -DETAIL: Key (roname)=(regress_test_decoding: regression_slot) already exists. +ERROR: could not create object because a conflicting object already exists +DETAIL: Key (roname)=(regress_test_decoding: regression_slot) conflicts with existing entry in unique index pg_replica... +HINT: Another session might have created an object with the same key concurrently. --ensure deletions work (once) SELECT pg_replication_origin_create('regress_test_decoding: temp'); pg_replication_origin_create |
macOS - Sonoma - Meson | |
regress | diff -U3 /Users/admin/pgsql/src/test/modules/injection_points/expected/syscache-update-pruned.out /Users/admin/pgsql/bui... --- /Users/admin/pgsql/src/test/modules/injection_points/expected/syscache-update-pruned.out 2025-07-05 07:07:11 +++ /Users/admin/pgsql/build/testrun/injection_points/isolation/results/syscache-update-pruned.out 2025-07-05 07:13:00 @@ -46,7 +46,7 @@ SELECT FROM injection_points_wakeup('heap_update-before-pin'); <waiting ...> step grant1: <... completed> -ERROR: duplicate key value violates unique constraint "pg_class_oid_index" +ERROR: could not create object because a conflicting object already exists step wakegrant4: <... completed> starting permutation: snap3 cachefill1 at2 mkrels4 r3 waitprunable4 vac4 grant1 wakeinval4 at4 wakegrant4 inspect4 |
regress | diff -U3 /Users/admin/pgsql/contrib/test_decoding/expected/replorigin.out /Users/admin/pgsql/build/testrun/test_decoding... --- /Users/admin/pgsql/contrib/test_decoding/expected/replorigin.out 2025-07-05 07:07:10 +++ /Users/admin/pgsql/build/testrun/test_decoding/regress/results/replorigin.out 2025-07-05 07:12:57 @@ -39,8 +39,9 @@ -- ensure duplicate creations fail SELECT pg_replication_origin_create('regress_test_decoding: regression_slot'); -ERROR: duplicate key value violates unique constraint "pg_replication_origin_roname_index" -DETAIL: Key (roname)=(regress_test_decoding: regression_slot) already exists. +ERROR: could not create object because a conflicting object already exists +DETAIL: Key (roname)=(regress_test_decoding: regression_slot) conflicts with existing entry in unique index pg_replica... +HINT: Another session might have created an object with the same key concurrently. --ensure deletions work (once) SELECT pg_replication_origin_create('regress_test_decoding: temp'); pg_replication_origin_create |
Linux - Debian Bookworm - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/syscache-update-pruned.out /tmp/cirrus-ci-build... --- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/syscache-update-pruned.out 2025-07-05 07:08:09.06630... +++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/syscache-update-pruned.out 2025-07-05 07:13:59... @@ -46,7 +46,7 @@ SELECT FROM injection_points_wakeup('heap_update-before-pin'); <waiting ...> step grant1: <... completed> -ERROR: duplicate key value violates unique constraint "pg_class_oid_index" +ERROR: could not create object because a conflicting object already exists step wakegrant4: <... completed> starting permutation: snap3 cachefill1 at2 mkrels4 r3 waitprunable4 vac4 grant1 wakeinval4 at4 wakegrant4 inspect4 |
regress | diff -U3 /tmp/cirrus-ci-build/contrib/test_decoding/expected/replorigin.out /tmp/cirrus-ci-build/build/testrun/test_deco... --- /tmp/cirrus-ci-build/contrib/test_decoding/expected/replorigin.out 2025-07-05 07:08:07.336459915 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_decoding/regress/results/replorigin.out 2025-07-05 07:13:53.244971742 +0000 @@ -39,8 +39,9 @@ -- ensure duplicate creations fail SELECT pg_replication_origin_create('regress_test_decoding: regression_slot'); -ERROR: duplicate key value violates unique constraint "pg_replication_origin_roname_index" -DETAIL: Key (roname)=(regress_test_decoding: regression_slot) already exists. +ERROR: could not create object because a conflicting object already exists +DETAIL: Key (roname)=(regress_test_decoding: regression_slot) conflicts with existing entry in unique index pg_replica... +HINT: Another session might have created an object with the same key concurrently. --ensure deletions work (once) SELECT pg_replication_origin_create('regress_test_decoding: temp'); pg_replication_origin_create |
FreeBSD - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/syscache-update-pruned.out /tmp/cirrus-ci-build... --- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/syscache-update-pruned.out 2025-07-05 07:08:08.50368... +++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/syscache-update-pruned.out 2025-07-05 07:11:45... @@ -46,7 +46,7 @@ SELECT FROM injection_points_wakeup('heap_update-before-pin'); <waiting ...> step grant1: <... completed> -ERROR: duplicate key value violates unique constraint "pg_class_oid_index" +ERROR: could not create object because a conflicting object already exists step wakegrant4: <... completed> starting permutation: snap3 cachefill1 at2 mkrels4 r3 waitprunable4 vac4 grant1 wakeinval4 at4 wakegrant4 inspect4 |
regress | diff -U3 /tmp/cirrus-ci-build/contrib/test_decoding/expected/replorigin.out /tmp/cirrus-ci-build/build/testrun/test_deco... --- /tmp/cirrus-ci-build/contrib/test_decoding/expected/replorigin.out 2025-07-05 07:08:07.133466000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_decoding/regress/results/replorigin.out 2025-07-05 07:11:39.037152000 +0000 @@ -39,8 +39,9 @@ -- ensure duplicate creations fail SELECT pg_replication_origin_create('regress_test_decoding: regression_slot'); -ERROR: duplicate key value violates unique constraint "pg_replication_origin_roname_index" -DETAIL: Key (roname)=(regress_test_decoding: regression_slot) already exists. +ERROR: could not create object because a conflicting object already exists +DETAIL: Key (roname)=(regress_test_decoding: regression_slot) conflicts with existing entry in unique index pg_replica... +HINT: Another session might have created an object with the same key concurrently. --ensure deletions work (once) SELECT pg_replication_origin_create('regress_test_decoding: temp'); pg_replication_origin_create |
Linux - Debian Bookworm - Autoconf | |
regress | diff -U3 /tmp/cirrus-ci-build/contrib/test_decoding/expected/replorigin.out /tmp/cirrus-ci-build/contrib/test_decoding/r... --- /tmp/cirrus-ci-build/contrib/test_decoding/expected/replorigin.out 2025-07-05 07:08:09.161085224 +0000 +++ /tmp/cirrus-ci-build/contrib/test_decoding/results/replorigin.out 2025-07-05 07:14:57.813044854 +0000 @@ -39,8 +39,9 @@ -- ensure duplicate creations fail SELECT pg_replication_origin_create('regress_test_decoding: regression_slot'); -ERROR: duplicate key value violates unique constraint "pg_replication_origin_roname_index" -DETAIL: Key (roname)=(regress_test_decoding: regression_slot) already exists. +ERROR: could not create object because a conflicting object already exists +DETAIL: Key (roname)=(regress_test_decoding: regression_slot) conflicts with existing entry in unique index pg_replica... +HINT: Another session might have created an object with the same key concurrently. --ensure deletions work (once) SELECT pg_replication_origin_create('regress_test_decoding: temp'); pg_replication_origin_create |
regress | 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-07-05 07:08:11.067307760 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/plpgsql.out 2025-07-05 07:15:08.725021990 +0000 @@ -3549,2308 +3549,7 @@ end loop; end; $$ language plpgsql; -select forc01(); -NOTICE: 1, 1 -NOTICE: 2, 2 -NOTICE: 3, 3 -NOTICE: 4, 4 -NOTICE: 5, 5 -NOTICE: 6, 6 -NOTICE: 7, 7 -NOTICE: 8, 8 -NOTICE: 9, 9 -NOTICE: 10, 10 - forc01 --------- ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/syscache-update-pruned.out /tmp/cirrus-ci-build... --- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/syscache-update-pruned.out 2025-07-05 07:08:10.90744... +++ /tmp/cirrus-ci-build/src/test/modules/injection_points/output_iso/results/syscache-update-pruned.out 2025-07-05 07:1... @@ -46,7 +46,7 @@ SELECT FROM injection_points_wakeup('heap_update-before-pin'); <waiting ...> step grant1: <... completed> -ERROR: duplicate key value violates unique constraint "pg_class_oid_index" +ERROR: could not create object because a conflicting object already exists step wakegrant4: <... completed> starting permutation: snap3 cachefill1 at2 mkrels4 r3 waitprunable4 vac4 grant1 wakeinval4 at4 wakegrant4 inspect4 |
regress | 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-07-05 07:08:11.067307760 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/plpgsql.out 2025-07-05 07:12:51.089278096 +0000 @@ -3549,2308 +3549,7 @@ end loop; end; $$ language plpgsql; -select forc01(); -NOTICE: 1, 1 -NOTICE: 2, 2 -NOTICE: 3, 3 -NOTICE: 4, 4 -NOTICE: 5, 5 -NOTICE: 6, 6 -NOTICE: 7, 7 -NOTICE: 8, 8 -NOTICE: 9, 9 -NOTICE: 10, 10 - forc01 --------- ... |
53/5814 | Add enable_groupagg GUC parameter to control GroupAggregate usage |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/join_hash.out C:/cirrus/build/testrun/pg_upgrade/002_pg... --- C:/cirrus/src/test/regress/expected/join_hash.out 2025-07-05 04:19:32.562621900 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/join_hash.out 2025-07-05 04:23:06.142365000 +0000 @@ -1137,18 +1137,21 @@ int8_tbl i8, lateral (select t1.fivethous, i4.f1 from tenk1 t1 join int4_tbl i4 on t1.fivethous = i4.f1+i8.q2 order by 1,2) ss; - QUERY PLAN ------------------------------------------------------------ + QUERY PLAN +----------------------------------------------------------------- Nested Loop -> Seq Scan on int8_tbl i8 - -> Sort - Sort Key: t1.fivethous, i4.f1 - -> Hash Join - Hash Cond: (t1.fivethous = (i4.f1 + i8.q2)) - -> Seq Scan on tenk1 t1 - -> Hash - -> Seq Scan on int4_tbl i4 ... |
regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/join_hash.out C:/cirrus/build/testrun/recovery/027_stre... --- C:/cirrus/src/test/regress/expected/join_hash.out 2025-07-05 04:19:32.562621900 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/join_hash.out 2025-07-05 04:25:54.078449700 +0000 @@ -1137,18 +1137,21 @@ int8_tbl i8, lateral (select t1.fivethous, i4.f1 from tenk1 t1 join int4_tbl i4 on t1.fivethous = i4.f1+i8.q2 order by 1,2) ss; - QUERY PLAN ------------------------------------------------------------ + QUERY PLAN +----------------------------------------------------------------- Nested Loop -> Seq Scan on int8_tbl i8 - -> Sort - Sort Key: t1.fivethous, i4.f1 - -> Hash Join - Hash Cond: (t1.fivethous = (i4.f1 + i8.q2)) - -> Seq Scan on tenk1 t1 - -> Hash - -> Seq Scan on int4_tbl i4 ... |
regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/join_hash.out C:/cirrus/build/testrun/regress/regress/r... --- C:/cirrus/src/test/regress/expected/join_hash.out 2025-07-05 04:19:32.562621900 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/join_hash.out 2025-07-05 04:23:01.428568600 +0000 @@ -1137,18 +1137,21 @@ int8_tbl i8, lateral (select t1.fivethous, i4.f1 from tenk1 t1 join int4_tbl i4 on t1.fivethous = i4.f1+i8.q2 order by 1,2) ss; - QUERY PLAN ------------------------------------------------------------ + QUERY PLAN +----------------------------------------------------------------- Nested Loop -> Seq Scan on int8_tbl i8 - -> Sort - Sort Key: t1.fivethous, i4.f1 - -> Hash Join - Hash Cond: (t1.fivethous = (i4.f1 + i8.q2)) - -> Seq Scan on tenk1 t1 - -> Hash - -> Seq Scan on int4_tbl i4 ... |
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-07-05 04:19:15 +++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/join_hash.out 2025-07-05 04:22:32 @@ -1137,18 +1137,21 @@ int8_tbl i8, lateral (select t1.fivethous, i4.f1 from tenk1 t1 join int4_tbl i4 on t1.fivethous = i4.f1+i8.q2 order by 1,2) ss; - QUERY PLAN ------------------------------------------------------------ + QUERY PLAN +----------------------------------------------------------------- Nested Loop -> Seq Scan on int8_tbl i8 - -> Sort - Sort Key: t1.fivethous, i4.f1 - -> Hash Join - Hash Cond: (t1.fivethous = (i4.f1 + i8.q2)) - -> Seq Scan on tenk1 t1 - -> Hash - -> Seq Scan on int4_tbl i4 ... |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/join_hash.out /Users/admin/pgsql/build/testrun/recovery/027_stream... --- /Users/admin/pgsql/src/test/regress/expected/join_hash.out 2025-07-05 04:19:15 +++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/join_hash.out 2025-07-05 04:24:09 @@ -1137,18 +1137,21 @@ int8_tbl i8, lateral (select t1.fivethous, i4.f1 from tenk1 t1 join int4_tbl i4 on t1.fivethous = i4.f1+i8.q2 order by 1,2) ss; - QUERY PLAN ------------------------------------------------------------ + QUERY PLAN +----------------------------------------------------------------- Nested Loop -> Seq Scan on int8_tbl i8 - -> Sort - Sort Key: t1.fivethous, i4.f1 - -> Hash Join - Hash Cond: (t1.fivethous = (i4.f1 + i8.q2)) - -> Seq Scan on tenk1 t1 - -> Hash - -> Seq Scan on int4_tbl i4 ... |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/join_hash.out /Users/admin/pgsql/build/testrun/regress/regress/res... --- /Users/admin/pgsql/src/test/regress/expected/join_hash.out 2025-07-05 04:19:15 +++ /Users/admin/pgsql/build/testrun/regress/regress/results/join_hash.out 2025-07-05 04:22:31 @@ -1137,18 +1137,21 @@ int8_tbl i8, lateral (select t1.fivethous, i4.f1 from tenk1 t1 join int4_tbl i4 on t1.fivethous = i4.f1+i8.q2 order by 1,2) ss; - QUERY PLAN ------------------------------------------------------------ + QUERY PLAN +----------------------------------------------------------------- Nested Loop -> Seq Scan on int8_tbl i8 - -> Sort - Sort Key: t1.fivethous, i4.f1 - -> Hash Join - Hash Cond: (t1.fivethous = (i4.f1 + i8.q2)) - -> Seq Scan on tenk1 t1 - -> Hash - -> Seq Scan on int4_tbl i4 ... |
Linux - Debian Bookworm - 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-07-05 04:19:32.276460567 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/join.out 2025-07-05 04:21:43.786576126 +00... @@ -8186,15 +8186,15 @@ lateral (values(x.q1,y.q1,y.q2)) v(xq1,yq1,yq2); q1 | q2 | q1 | q2 | xq1 | yq1 | ... ------------------+-------------------+------------------+-------------------+------------------+------------------+---... - 123 | 456 | | | 123 | | ... - 123 | 4567890123456789 | 4567890123456789 | -4567890123456789 | 123 | 4567890123456789 | -4... - 123 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 123 | 4567890123456789 | 4... - 123 | 4567890123456789 | 4567890123456789 | 123 | 123 | 4567890123456789 | ... - 4567890123456789 | 123 | 123 | 4567890123456789 | 4567890123456789 | 123 | 4... 4567890123456789 | 123 | 123 | 456 | 4567890123456789 | 123 | ... - 4567890123456789 | 4567890123456789 | 4567890123456789 | -4567890123456789 | 4567890123456789 | 4567890123456789 | -4... - 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4... + 4567890123456789 | 123 | 123 | 4567890123456789 | 4567890123456789 | 123 | 4... 4567890123456789 | 4567890123456789 | 4567890123456789 | 123 | 4567890123456789 | 4567890123456789 | ... + 123 | 4567890123456789 | 4567890123456789 | 123 | 123 | 4567890123456789 | ... + 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4... + 123 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 123 | 4567890123456789 | 4... ... |
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-07-05 04:19:32.276460567 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/join_hash.out 2025-07-05 04:23:08.323364... @@ -1137,18 +1137,21 @@ int8_tbl i8, lateral (select t1.fivethous, i4.f1 from tenk1 t1 join int4_tbl i4 on t1.fivethous = i4.f1+i8.q2 order by 1,2) ss; - QUERY PLAN ------------------------------------------------------------ + QUERY PLAN +----------------------------------------------------------------- Nested Loop -> Seq Scan on int8_tbl i8 - -> Sort - Sort Key: t1.fivethous, i4.f1 - -> Hash Join - Hash Cond: (t1.fivethous = (i4.f1 + i8.q2)) - -> Seq Scan on tenk1 t1 - -> Hash - -> Seq Scan on int4_tbl i4 ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join_hash.out /tmp/cirrus-ci-build/build/testrun/regress/regress... --- /tmp/cirrus-ci-build/src/test/regress/expected/join_hash.out 2025-07-05 04:19:32.276460567 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/join_hash.out 2025-07-05 04:21:55.294666000 +0000 @@ -1137,18 +1137,21 @@ int8_tbl i8, lateral (select t1.fivethous, i4.f1 from tenk1 t1 join int4_tbl i4 on t1.fivethous = i4.f1+i8.q2 order by 1,2) ss; - QUERY PLAN ------------------------------------------------------------ + QUERY PLAN +----------------------------------------------------------------- Nested Loop -> Seq Scan on int8_tbl i8 - -> Sort - Sort Key: t1.fivethous, i4.f1 - -> Hash Join - Hash Cond: (t1.fivethous = (i4.f1 + i8.q2)) - -> Seq Scan on tenk1 t1 - -> Hash - -> Seq Scan on int4_tbl i4 ... |
Linux - Debian Bookworm - Autoconf | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/resul... --- /tmp/cirrus-ci-build/src/test/regress/expected/join.out 2025-07-05 04:19:29.807804914 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/join.out 2025-07-05 04:26:28.438594016 +0000 @@ -3683,12 +3683,12 @@ ----------------------------------------------------------- Sort Sort Key: t1.q1, t1.q2 - -> Hash Left Join - Hash Cond: (t1.q2 = t2.q1) + -> Hash Right Join + Hash Cond: (t2.q1 = t1.q2) Filter: (1 = (SubPlan 1)) - -> Seq Scan on int8_tbl t1 + -> Seq Scan on int8_tbl t2 -> Hash - -> Seq Scan on int8_tbl t2 + -> Seq Scan on int8_tbl t1 SubPlan 1 -> Limit -> Result ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/result... --- /tmp/cirrus-ci-build/src/test/regress/expected/join.out 2025-07-05 04:19:29.807804914 +0000 +++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/join.out 2025-07-05 04:28:08.166600747 +0000 @@ -8186,15 +8186,15 @@ lateral (values(x.q1,y.q1,y.q2)) v(xq1,yq1,yq2); q1 | q2 | q1 | q2 | xq1 | yq1 | ... ------------------+-------------------+------------------+-------------------+------------------+------------------+---... - 123 | 456 | | | 123 | | ... - 123 | 4567890123456789 | 4567890123456789 | -4567890123456789 | 123 | 4567890123456789 | -4... - 123 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 123 | 4567890123456789 | 4... - 123 | 4567890123456789 | 4567890123456789 | 123 | 123 | 4567890123456789 | ... - 4567890123456789 | 123 | 123 | 4567890123456789 | 4567890123456789 | 123 | 4... 4567890123456789 | 123 | 123 | 456 | 4567890123456789 | 123 | ... - 4567890123456789 | 4567890123456789 | 4567890123456789 | -4567890123456789 | 4567890123456789 | 4567890123456789 | -4... - 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4... + 4567890123456789 | 123 | 123 | 4567890123456789 | 4567890123456789 | 123 | 4... 4567890123456789 | 4567890123456789 | 4567890123456789 | 123 | 4567890123456789 | 4567890123456789 | ... + 123 | 4567890123456789 | 4567890123456789 | 123 | 123 | 4567890123456789 | ... + 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 4... + 123 | 4567890123456789 | 4567890123456789 | 4567890123456789 | 123 | 4567890123456789 | 4... ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join.out /tmp/cirrus-ci-build/src/test/regress/results/join.out --- /tmp/cirrus-ci-build/src/test/regress/expected/join.out 2025-07-05 04:19:29.807804914 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/join.out 2025-07-05 04:22:57.354696925 +0000 @@ -6012,22 +6012,26 @@ on t1.q2 = t2.q2 left join onek t4 on t2.q2 < t3.unique2; - QUERY PLAN -------------------------------------------------- + QUERY PLAN +----------------------------------------------------------- Nested Loop Left Join Join Filter: (t2.q2 < t3.unique2) -> Nested Loop Left Join - Join Filter: (t2.q1 > t3.unique1) -> Hash Left Join Hash Cond: (t1.q2 = t2.q2) -> Seq Scan on int8_tbl t1 -> Hash -> Seq Scan on int8_tbl t2 ... |
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-07-05 04:19:29.267483000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/aggregates.out 2025-07-05 04:21:29.9744340... @@ -3612,8 +3612,8 @@ ) AS sub GROUP BY c1 ORDER BY c1; - QUERY PLAN ------------------------------------------------------------------------------ + QUERY PLAN +--------------------------------------------------------------------------------------------------------------- GroupAggregate Group Key: sub.c1 -> Sort @@ -3622,7 +3622,7 @@ -> HashAggregate Group Key: test_groupagg.c1, test_groupagg.c2 -> Seq Scan on test_groupagg - Settings: max_parallel_workers = '0', max_parallel_workers_per_gather = '0' + Settings: debug_parallel_query = 'regress', max_parallel_workers = '0', max_parallel_workers_per_gather = '0' ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/aggregates.out /tmp/cirrus-ci-build/build/testrun/recovery/027_s... --- /tmp/cirrus-ci-build/src/test/regress/expected/aggregates.out 2025-07-05 04:19:29.267483000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/aggregates.out 2025-07-05 04:22:22.82318... @@ -3612,8 +3612,8 @@ ) AS sub GROUP BY c1 ORDER BY c1; - QUERY PLAN ------------------------------------------------------------------------------ + QUERY PLAN +--------------------------------------------------------------------------------------------------------------- GroupAggregate Group Key: sub.c1 -> Sort @@ -3622,7 +3622,7 @@ -> HashAggregate Group Key: test_groupagg.c1, test_groupagg.c2 -> Seq Scan on test_groupagg - Settings: max_parallel_workers = '0', max_parallel_workers_per_gather = '0' + Settings: debug_parallel_query = 'regress', max_parallel_workers = '0', max_parallel_workers_per_gather = '0' ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/aggregates.out /tmp/cirrus-ci-build/build/testrun/regress/regres... --- /tmp/cirrus-ci-build/src/test/regress/expected/aggregates.out 2025-07-05 04:19:29.267483000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/aggregates.out 2025-07-05 04:21:18.419576000 +0000 @@ -3612,8 +3612,8 @@ ) AS sub GROUP BY c1 ORDER BY c1; - QUERY PLAN ------------------------------------------------------------------------------ + QUERY PLAN +--------------------------------------------------------------------------------------------------------------- GroupAggregate Group Key: sub.c1 -> Sort @@ -3622,7 +3622,7 @@ -> HashAggregate Group Key: test_groupagg.c1, test_groupagg.c2 -> Seq Scan on test_groupagg - Settings: max_parallel_workers = '0', max_parallel_workers_per_gather = '0' + Settings: debug_parallel_query = 'regress', max_parallel_workers = '0', max_parallel_workers_per_gather = '0' ... |
53/5881 | array_random |
Linux - Debian Bookworm - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/arrays.out /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade/002_... --- /tmp/cirrus-ci-build/src/test/regress/expected/arrays.out 2025-07-05 04:16:39.675196063 +0000 +++ /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade/002_pg_upgrade/data/results/arrays.out 2025-07-05 04:27:31.14627024... @@ -3004,11 +3004,12 @@ --array_random error case SELECT array_random(1, 10, '{134217728}'); -ERROR: array size exceeds the maximum allowed (134217727) +ERROR: out of memory +DETAIL: Failed on request of size 12 in memory context "printtup". SELECT array_random(2, 1, '{2}'::int[]); ERROR: lower bound must be less than or equal to upper bound SELECT array_random(2, 1, '{-1}'::int[]); -ERROR: array size exceeds the maximum allowed (134217727) +ERROR: array size exceeds the maximum allowed (268435455) SELECT array_random(NULL, 1, NULL); ERROR: dimension array cannot be null SELECT array_random(1, 2, '{NULL}'::int[]); |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/arrays.out /tmp/cirrus-ci-build/build-32/testrun/recovery/027_st... --- /tmp/cirrus-ci-build/src/test/regress/expected/arrays.out 2025-07-05 04:16:39.675196063 +0000 +++ /tmp/cirrus-ci-build/build-32/testrun/recovery/027_stream_regress/data/results/arrays.out 2025-07-05 04:28:58.626210... @@ -3004,11 +3004,12 @@ --array_random error case SELECT array_random(1, 10, '{134217728}'); -ERROR: array size exceeds the maximum allowed (134217727) +ERROR: out of memory +DETAIL: Failed on request of size 12 in memory context "printtup". SELECT array_random(2, 1, '{2}'::int[]); ERROR: lower bound must be less than or equal to upper bound SELECT array_random(2, 1, '{-1}'::int[]); -ERROR: array size exceeds the maximum allowed (134217727) +ERROR: array size exceeds the maximum allowed (268435455) SELECT array_random(NULL, 1, NULL); ERROR: dimension array cannot be null SELECT array_random(1, 2, '{NULL}'::int[]); |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/arrays.out /tmp/cirrus-ci-build/build-32/testrun/regress/regress... --- /tmp/cirrus-ci-build/src/test/regress/expected/arrays.out 2025-07-05 04:16:39.675196063 +0000 +++ /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/arrays.out 2025-07-05 04:27:27.682272868 +0000 @@ -3004,11 +3004,12 @@ --array_random error case SELECT array_random(1, 10, '{134217728}'); -ERROR: array size exceeds the maximum allowed (134217727) +ERROR: out of memory +DETAIL: Failed on request of size 12 in memory context "printtup". SELECT array_random(2, 1, '{2}'::int[]); ERROR: lower bound must be less than or equal to upper bound SELECT array_random(2, 1, '{-1}'::int[]); -ERROR: array size exceeds the maximum allowed (134217727) +ERROR: array size exceeds the maximum allowed (268435455) SELECT array_random(NULL, 1, NULL); ERROR: dimension array cannot be null SELECT array_random(1, 2, '{NULL}'::int[]); |
53/5751 | Disable parallel query by default |
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-07-05 03:15:39.712786800 +0000 +++ C:/cirrus/build/testrun/isolation/isolation/results/deadlock-parallel.out 2025-07-05 03:18:33.833292600 +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-07-05 03:15:36.226166200 +0000 +++ C:/cirrus/build/testrun/pg_overexplain/regress/results/pg_overexplain.out 2025-07-05 03:23:04.615093900 +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-07-05 03:15:40.350475400 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2025-07-05 03:19:25.638475900 +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-07-05 03:15:40.322816800 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plpgsql.out 2025-07-05 03:19:44.212704800 +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-07-05 03:15:40.350475400 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2025-07-05 03:22:03.500831200 +... @@ -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-07-05 03:15:40.322816800 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/plpgsql.out 2025-07-05 03:22:22.126754500 +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-07-05 03:15:40.350475400 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/select_parallel.out 2025-07-05 03:19:23.488102300 +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-07-05 03:15:40.322816800 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/plpgsql.out 2025-07-05 03:19:41.399214100 +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-07-05 03:13:12 +++ /Users/admin/pgsql/build/testrun/isolation/isolation/results/deadlock-parallel.out 2025-07-05 03:14:45 @@ -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-07-05 03:13:10 +++ /Users/admin/pgsql/build/testrun/pg_overexplain/regress/results/pg_overexplain.out 2025-07-05 03:17: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-07-05 03:13:12 +++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2025-07-05 03:15: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 /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-07-05 03:13:12 +++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plpgsql.out 2025-07-05 03:15:29 @@ -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-07-05 03:13:12 +++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2025-07-05 03:17:27 @@ -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-07-05 03:13:12 +++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/plpgsql.out 2025-07-05 03:17: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 ------------------------------------ ... |
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-07-05 03:13:12 +++ /Users/admin/pgsql/build/testrun/regress/regress/results/select_parallel.out 2025-07-05 03:15:20 @@ -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-07-05 03:13:12 +++ /Users/admin/pgsql/build/testrun/regress/regress/results/plpgsql.out 2025-07-05 03:15:35 @@ -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-07-05 03:15:40.542340600 +0000 +++ /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/deadlock-parallel.out 2025-07-05 03:17:23.425708478 +... @@ -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-07-05 03:15:38.802340563 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_overexplain/regress/results/pg_overexplain.out 2025-07-05 03:19:26.933629842 +... @@ -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-07-05 03:15:40.774340605 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2025-07-05 03:17:53.87... @@ -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-07-05 03:15:40.758340605 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plpgsql.out 2025-07-05 03:18:07.921674328 ... @@ -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-07-05 03:15:40.774340605 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2025-07-05 03:19: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-07-05 03:15:40.758340605 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/plpgsql.out 2025-07-05 03:19:20.92563764... @@ -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-07-05 03:15:40.774340605 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/select_parallel.out 2025-07-05 03:17:50.617683947 +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-07-05 03:15:40.758340605 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/plpgsql.out 2025-07-05 03:18:04.965675766 +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-07-05 03:15:38.857620279 +0000 +++ /tmp/cirrus-ci-build/contrib/pg_overexplain/results/pg_overexplain.out 2025-07-05 03:20:14.002622707 +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-07-05 03:15:40.773434735 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/select_parallel.out 2025-07-05 03:20:38.354599147 +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-07-05 03:15:40.757526860 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/plpgsql.out 2025-07-05 03:20:51.798587106 +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-07-05 03:15:40.538793580 +0000 +++ /tmp/cirrus-ci-build/src/test/isolation/output_iso/results/deadlock-parallel.out 2025-07-05 03:17:43.730731827 +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-07-05 03:15:40.773434735 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/select_parallel.out 2025-07-05 03:18:30.050720555 +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-07-05 03:15:40.757526860 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/plpgsql.out 2025-07-05 03:18:56.474707793 +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 ------------------------------------ ... |
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-07-05 03:15:36.042028000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/deadlock-parallel.out 2025-07-05 03:16:39.608556000 +... @@ -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-07-05 03:15:34.623922000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_overexplain/regress/results/pg_overexplain.out 2025-07-05 03:18:01.553304000 +... @@ -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-07-05 03:15:36.219998000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2025-07-05 03:16:59.20... @@ -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-07-05 03:15:36.206602000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/plpgsql.out 2025-07-05 03:17:14.461556000 ... @@ -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-07-05 03:15:36.219998000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2025-07-05 03:18:10.... @@ -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-07-05 03:15:36.206602000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/plpgsql.out 2025-07-05 03:18:31.25237400... @@ -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-07-05 03:15:36.219998000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/select_parallel.out 2025-07-05 03:16:59.700097000 +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-07-05 03:15:36.206602000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/plpgsql.out 2025-07-05 03:17:15.904237000 +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/5669 | Use CLOCK_MONOTONIC_COARSE for instr_time for explain analyze |
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-07-04 23:08:00.162496417 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_stat_statements/regress/results/entry_timestamp.out 2025-07-04 23:14:47.262344... @@ -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 - 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-07-04 23:08:00.441678447 +0000 +++ /tmp/cirrus-ci-build/contrib/pg_stat_statements/results/entry_timestamp.out 2025-07-04 23:14:07.800829009 +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) ... |
FreeBSD - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/entry_timestamp.out /tmp/cirrus-ci-build/build/testrun... --- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/entry_timestamp.out 2025-07-04 23:08:02.374256000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_stat_statements/regress/results/entry_timestamp.out 2025-07-04 23:11:44.300389... @@ -45,7 +45,7 @@ WHERE query LIKE '%STMTTS%'; total | minmax_plan_zero | minmax_exec_zero | minmax_stats_since_after_ref | stats_since_after_ref -------+------------------+------------------+------------------------------+----------------------- - 2 | 0 | 0 | 0 | 0 + 2 | 0 | 1 | 0 | 0 (1 row) -- Perform single min/max reset @@ -71,7 +71,7 @@ WHERE query LIKE '%STMTTS%'; total | minmax_plan_zero | minmax_exec_zero | minmax_stats_since_after_ref | stats_since_after_ref -------+------------------+------------------+------------------------------+----------------------- - 2 | 1 | 1 | 1 | 0 + 2 | 1 | 2 | 1 | 0 (1 row) ... |
53/5447 | log_min_messages per backend type |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/guc.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgra... --- C:/cirrus/src/test/regress/expected/guc.out 2025-07-04 22:53:55.760011400 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/guc.out 2025-07-04 22:57:52.889008000 +0000 @@ -929,35 +929,7 @@ (1 row) SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1'; --fail -ERROR: invalid value for parameter "log_min_messages": "checkpointer:debug2, autovacuum:debug1" -DETAIL: Generic log level was not defined. -SET log_min_messages TO 'debug1, backend:error, fatal'; -- fail -ERROR: invalid value for parameter "log_min_messages": "debug1, backend:error, fatal" -DETAIL: Generic log level was already assigned. -SET log_min_messages TO 'backend:error, foo:fatal, archiver:debug1'; -- fail -ERROR: invalid value for parameter "log_min_messages": "backend:error, foo:fatal, archiver:debug1" -DETAIL: Unrecognized backend type: "foo". -SET log_min_messages TO 'backend:error, checkpointer:bar, archiver:debug1'; -- fail -ERROR: invalid value for parameter "log_min_messages": "backend:error, checkpointer:bar, archiver:debug1" -DETAIL: Unrecognized log level: "bar". -SET log_min_messages TO 'backend:error, checkpointer:debug3, fatal, archiver:debug2, autovacuum:debug1, walsender:debug... -SHOW log_min_messages; ... |
regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/foreign_key.out C:/cirrus/build/testrun/recovery/027_st... --- C:/cirrus/src/test/regress/expected/foreign_key.out 2025-07-04 22:53:55.750468300 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/foreign_key.out 2025-07-04 23:00:18.556838000 +0000 @@ -2622,787 +2622,7 @@ ALTER TABLE fk ADD FOREIGN KEY (a) REFERENCES pk; CREATE TABLE fk2 (b int, a int) ; ALTER TABLE fk2 DROP COLUMN b; -ALTER TABLE fk ATTACH PARTITION fk2 FOR VALUES FROM (750) TO (3500); -CREATE TABLE pk3 PARTITION OF pk FOR VALUES FROM (2000) TO (3000); -CREATE TABLE pk4 (LIKE pk); -ALTER TABLE pk ATTACH PARTITION pk4 FOR VALUES FROM (3000) TO (4000); -CREATE TABLE pk5 (c int, b int, a int NOT NULL) PARTITION BY RANGE (a); -ALTER TABLE pk5 DROP COLUMN b, DROP COLUMN c; -CREATE TABLE pk51 PARTITION OF pk5 FOR VALUES FROM (4000) TO (4500); -CREATE TABLE pk52 PARTITION OF pk5 FOR VALUES FROM (4500) TO (5000); -ALTER TABLE pk ATTACH PARTITION pk5 FOR VALUES FROM (4000) TO (5000); -CREATE TABLE fk3 PARTITION OF fk FOR VALUES FROM (3500) TO (5000); --- these should fail: referenced value not present -INSERT into fk VALUES (1); -ERROR: insert or update on table "fk1" violates foreign key constraint "fk_a_fkey" ... |
regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/guc.out C:/cirrus/build/testrun/regress/regress/results... --- C:/cirrus/src/test/regress/expected/guc.out 2025-07-04 22:53:55.760011400 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/guc.out 2025-07-04 22:57:53.015346500 +0000 @@ -929,35 +929,7 @@ (1 row) SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1'; --fail -ERROR: invalid value for parameter "log_min_messages": "checkpointer:debug2, autovacuum:debug1" -DETAIL: Generic log level was not defined. -SET log_min_messages TO 'debug1, backend:error, fatal'; -- fail -ERROR: invalid value for parameter "log_min_messages": "debug1, backend:error, fatal" -DETAIL: Generic log level was already assigned. -SET log_min_messages TO 'backend:error, foo:fatal, archiver:debug1'; -- fail -ERROR: invalid value for parameter "log_min_messages": "backend:error, foo:fatal, archiver:debug1" -DETAIL: Unrecognized backend type: "foo". -SET log_min_messages TO 'backend:error, checkpointer:bar, archiver:debug1'; -- fail -ERROR: invalid value for parameter "log_min_messages": "backend:error, checkpointer:bar, archiver:debug1" -DETAIL: Unrecognized log level: "bar". -SET log_min_messages TO 'backend:error, checkpointer:debug3, fatal, archiver:debug2, autovacuum:debug1, walsender:debug... -SHOW log_min_messages; ... |
macOS - Sonoma - Meson | |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/guc.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade... --- /Users/admin/pgsql/src/test/regress/expected/guc.out 2025-07-04 22:53:14 +++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/guc.out 2025-07-04 22:57:38 @@ -929,35 +929,7 @@ (1 row) SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1'; --fail -ERROR: invalid value for parameter "log_min_messages": "checkpointer:debug2, autovacuum:debug1" -DETAIL: Generic log level was not defined. -SET log_min_messages TO 'debug1, backend:error, fatal'; -- fail -ERROR: invalid value for parameter "log_min_messages": "debug1, backend:error, fatal" -DETAIL: Generic log level was already assigned. -SET log_min_messages TO 'backend:error, foo:fatal, archiver:debug1'; -- fail -ERROR: invalid value for parameter "log_min_messages": "backend:error, foo:fatal, archiver:debug1" -DETAIL: Unrecognized backend type: "foo". -SET log_min_messages TO 'backend:error, checkpointer:bar, archiver:debug1'; -- fail -ERROR: invalid value for parameter "log_min_messages": "backend:error, checkpointer:bar, archiver:debug1" -DETAIL: Unrecognized log level: "bar". -SET log_min_messages TO 'backend:error, checkpointer:debug3, fatal, archiver:debug2, autovacuum:debug1, walsender:debug... -SHOW log_min_messages; ... |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/cluster.out /Users/admin/pgsql/build/testrun/recovery/027_stream_r... --- /Users/admin/pgsql/src/test/regress/expected/cluster.out 2025-07-04 22:53:14 +++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/cluster.out 2025-07-04 22:59:07 @@ -435,241 +435,10 @@ create temp table clstr_temp (col1 int primary key, col2 text); insert into clstr_temp values (2, 'two'), (1, 'one'); cluster clstr_temp using clstr_temp_pkey; -select * from clstr_temp; - col1 | col2 -------+------ - 1 | one - 2 | two -(2 rows) - -drop table clstr_temp; -RESET SESSION AUTHORIZATION; --- check clustering an empty table -DROP TABLE clustertest; -CREATE TABLE clustertest (f1 int PRIMARY KEY); -CLUSTER clustertest USING clustertest_pkey; ... |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/guc.out /Users/admin/pgsql/build/testrun/regress/regress/results/g... --- /Users/admin/pgsql/src/test/regress/expected/guc.out 2025-07-04 22:53:14 +++ /Users/admin/pgsql/build/testrun/regress/regress/results/guc.out 2025-07-04 22:57:38 @@ -929,35 +929,7 @@ (1 row) SET log_min_messages TO 'checkpointer:debug2, autovacuum:debug1'; --fail -ERROR: invalid value for parameter "log_min_messages": "checkpointer:debug2, autovacuum:debug1" -DETAIL: Generic log level was not defined. -SET log_min_messages TO 'debug1, backend:error, fatal'; -- fail -ERROR: invalid value for parameter "log_min_messages": "debug1, backend:error, fatal" -DETAIL: Generic log level was already assigned. -SET log_min_messages TO 'backend:error, foo:fatal, archiver:debug1'; -- fail -ERROR: invalid value for parameter "log_min_messages": "backend:error, foo:fatal, archiver:debug1" -DETAIL: Unrecognized backend type: "foo". -SET log_min_messages TO 'backend:error, checkpointer:bar, archiver:debug1'; -- fail -ERROR: invalid value for parameter "log_min_messages": "backend:error, checkpointer:bar, archiver:debug1" -DETAIL: Unrecognized log level: "bar". -SET log_min_messages TO 'backend:error, checkpointer:debug3, fatal, archiver:debug2, autovacuum:debug1, walsender:debug... -SHOW log_min_messages; ... |
Linux - Debian Bookworm - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00... --- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out 2025-07-04 22:53:51.301168673 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/foreign_key.out 2025-07-04 22:59:04.627635... @@ -866,2543 +866,10 @@ CREATE TABLE FKTABLE_FAIL1 ( ftest1 int, CONSTRAINT fkfail1 FOREIGN KEY (ftest2) REFERENCES PKTABLE); ERROR: column "ftest2" referenced in foreign key constraint does not exist CREATE TABLE FKTABLE_FAIL2 ( ftest1 int, CONSTRAINT fkfail1 FOREIGN KEY (ftest1) REFERENCES PKTABLE(ptest2)); -ERROR: column "ptest2" referenced in foreign key constraint does not exist -CREATE TABLE FKTABLE_FAIL3 ( ftest1 int, CONSTRAINT fkfail1 FOREIGN KEY (tableoid) REFERENCES PKTABLE(someoid)); -ERROR: system columns cannot be used in foreign keys -CREATE TABLE FKTABLE_FAIL4 ( ftest1 oid, CONSTRAINT fkfail1 FOREIGN KEY (ftest1) REFERENCES PKTABLE(tableoid)); -ERROR: system columns cannot be used in foreign keys -DROP TABLE PKTABLE; --- Test for referencing column number smaller than referenced constraint -CREATE TABLE PKTABLE (ptest1 int, ptest2 int, UNIQUE(ptest1, ptest2)); -CREATE TABLE FKTABLE_FAIL1 (ftest1 int REFERENCES pktable(ptest1)); -ERROR: there is no unique constraint matching given keys for referenced table "pktable" -DROP TABLE FKTABLE_FAIL1; -ERROR: table "fktable_fail1" does not exist -DROP TABLE PKTABLE; ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/build/testrun/recovery/027_... --- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out 2025-07-04 22:53:51.301168673 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/foreign_key.out 2025-07-04 23:00:08.8162... @@ -959,2450 +959,10 @@ CREATE TABLE FKTABLE (ftest1 int, ftest2 inet, FOREIGN KEY(ftest1, ftest2) REFERENCES pktable(ptest1, ptest2)); DROP TABLE FKTABLE; DROP TABLE PKTABLE; --- Two columns, same table --- Make sure this still works... -CREATE TABLE PKTABLE (ptest1 int, ptest2 inet, ptest3 int, ptest4 inet, PRIMARY KEY(ptest1, ptest2), FOREIGN KEY(ptest3... -ptest4) REFERENCES pktable(ptest1, ptest2)); -DROP TABLE PKTABLE; --- And this, -CREATE TABLE PKTABLE (ptest1 int, ptest2 inet, ptest3 int, ptest4 inet, PRIMARY KEY(ptest1, ptest2), FOREIGN KEY(ptest3... -ptest4) REFERENCES pktable); -DROP TABLE PKTABLE; --- This shouldn't (mixed up columns) -CREATE TABLE PKTABLE (ptest1 int, ptest2 inet, ptest3 int, ptest4 inet, PRIMARY KEY(ptest1, ptest2), FOREIGN KEY(ptest3... -ptest4) REFERENCES pktable(ptest2, ptest1)); -ERROR: foreign key constraint "pktable_ptest3_ptest4_fkey" cannot be implemented ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/build/testrun/regress/regre... --- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out 2025-07-04 22:53:51.301168673 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/foreign_key.out 2025-07-04 22:59:03.867631013 +0000 @@ -2182,1227 +2182,10 @@ ALTER TABLE fk_partitioned_fk ALTER CONSTRAINT fk_partitioned_fk_a_b_fkey NOT ENFORCED; ALTER TABLE fk_partitioned_fk ATTACH PARTITION fk_partitioned_fk_2 FOR VALUES IN (1500,1502); \d fk_partitioned_fk_2 - Table "public.fk_partitioned_fk_2" - Column | Type | Collation | Nullable | Default ---------+---------+-----------+----------+--------- - b | integer | | | - a | integer | | | -Partition of: fk_partitioned_fk FOR VALUES IN (1500, 1502) -Foreign-key constraints: - TABLE "fk_partitioned_fk" CONSTRAINT "fk_partitioned_fk_a_b_fkey" FOREIGN KEY (a, b) REFERENCES fk_notpartitioned_p... - -ROLLBACK; -DROP TABLE fk_partitioned_fk_2; -CREATE TABLE fk_partitioned_fk_4 (a int, b int, FOREIGN KEY (a, b) REFERENCES fk_notpartitioned_pk(a, b) ON UPDATE CASC... -CREATE TABLE fk_partitioned_fk_4_1 PARTITION OF fk_partitioned_fk_4 FOR VALUES FROM (1,1) TO (100,100); ... |
Linux - Debian Bookworm - Autoconf | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_chec... --- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out 2025-07-04 22:53:51.993724183 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/foreign_key.out 2025-07-04 23:00:57.361146904 +0000 @@ -1510,1899 +1510,10 @@ insert into pp values(12); insert into pp values(11); update pp set f1=f1+1; -insert into cc values(13); -update pp set f1=f1+1; -update pp set f1=f1+1; -- fail -ERROR: update or delete on table "pp" violates foreign key constraint "cc_f1_fkey" on table "cc" -DETAIL: Key (f1)=(13) is still referenced from table "cc". -delete from pp where f1 = 13; -- fail -ERROR: update or delete on table "pp" violates foreign key constraint "cc_f1_fkey" on table "cc" -DETAIL: Key (f1)=(13) is still referenced from table "cc". -drop table pp, cc; -create temp table pp (f1 int primary key); -create temp table cc (f1 int references pp on update restrict on delete restrict); -insert into pp values(12); -insert into pp values(11); ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/src/test/regress/results/fo... --- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out 2025-07-04 22:53:51.993724183 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/foreign_key.out 2025-07-04 22:59:28.068238653 +0000 @@ -1625,1784 +1625,10 @@ -- Test keys that "look" different but compare as equal -- create table pktable2 (a float8, b float8, primary key (a, b)); -create table fktable2 (x float8, y float8, foreign key (x, y) references pktable2 (a, b) on update cascade); -insert into pktable2 values ('-0', '-0'); -insert into fktable2 values ('-0', '-0'); -select * from pktable2; - a | b -----+---- - -0 | -0 -(1 row) - -select * from fktable2; - x | y -----+---- - -0 | -0 ... |
FreeBSD - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00... --- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out 2025-07-04 22:53:52.773578000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/foreign_key.out 2025-07-04 22:57:25.963780... @@ -841,2568 +841,10 @@ FOREIGN KEY (tid, fk_id_del_set_default) REFERENCES PKTABLE ON DELETE SET DEFAULT (fk_id_del_set_default, fk_id_del_s... ); SELECT pg_get_constraintdef(oid) FROM pg_constraint WHERE conrelid = 'fktable'::regclass::oid ORDER BY oid; - pg_get_constraintdef --------------------------------------------------------------------------------------------------------------------- - FOREIGN KEY (tid, fk_id_del_set_null) REFERENCES pktable(tid, id) ON DELETE SET NULL (fk_id_del_set_null) - FOREIGN KEY (tid, fk_id_del_set_default) REFERENCES pktable(tid, id) ON DELETE SET DEFAULT (fk_id_del_set_default) -(2 rows) - -INSERT INTO PKTABLE VALUES (1, 0), (1, 1), (1, 2); -INSERT INTO FKTABLE VALUES - (1, 1, 1, NULL), - (1, 2, NULL, 2); -DELETE FROM PKTABLE WHERE id = 1 OR id = 2; -SELECT * FROM FKTABLE ORDER BY id; - tid | id | fk_id_del_set_null | fk_id_del_set_default ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/build/testrun/recovery/027_... --- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out 2025-07-04 22:53:52.773578000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/foreign_key.out 2025-07-04 22:58:34.7827... @@ -601,2808 +601,10 @@ (4 rows) DROP TABLE FKTABLE; -DROP TABLE PKTABLE; --- set null update / set default delete -CREATE TABLE PKTABLE ( ptest1 int, ptest2 int, ptest3 int, ptest4 text, PRIMARY KEY(ptest1, ptest2, ptest3) ); -CREATE TABLE FKTABLE ( ftest1 int DEFAULT 0, ftest2 int, ftest3 int, ftest4 int, CONSTRAINT constrname3 - FOREIGN KEY(ftest1, ftest2, ftest3) REFERENCES PKTABLE - ON DELETE SET DEFAULT ON UPDATE SET NULL); --- Insert Primary Key values -INSERT INTO PKTABLE VALUES (1, 2, 3, 'test1'); -INSERT INTO PKTABLE VALUES (1, 3, 3, 'test2'); -INSERT INTO PKTABLE VALUES (2, 3, 4, 'test3'); -INSERT INTO PKTABLE VALUES (2, 4, 5, 'test4'); --- Insert Foreign Key values -INSERT INTO FKTABLE VALUES (1, 2, 3, 1); ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/build/testrun/regress/regre... --- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out 2025-07-04 22:53:52.773578000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/foreign_key.out 2025-07-04 22:57:40.435601000 +0000 @@ -1885,1524 +1885,10 @@ -- All constraints are now valid. SELECT conname, convalidated, conrelid::regclass FROM pg_constraint WHERE conrelid::regclass::text like 'fk_partitioned_fk%' ORDER BY oid::regclass::text; - conname | convalidated | conrelid ---------------------------------+--------------+----------------------- - fk_partitioned_fk_a_b_fkey | t | fk_partitioned_fk - fk_partitioned_fk_1_a_b_fkey | t | fk_partitioned_fk_1 - fk_partitioned_fk_2_a_b_fkey | t | fk_partitioned_fk_2 - fk_partitioned_fk_3_a_b_fkey | t | fk_partitioned_fk_3 - fk_partitioned_fk_3_1_a_b_fkey | t | fk_partitioned_fk_3_1 -(5 rows) - -DROP TABLE fk_partitioned_fk, fk_notpartitioned_pk; --- NOT VALID and NOT ENFORCED foreign key on a non-partitioned table --- referencing a partitioned table -CREATE TABLE fk_partitioned_pk (a int, b int, PRIMARY KEY (a, b)) PARTITION BY RANGE (a, b); ... |