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.
| 59/6673 | More jsonpath methods: translate, split, join |
| OpenBSD - Meson | |
| regress | diff -U3 /home/postgres/postgres/src/test/isolation/expected/timeouts.out /home/postgres/postgres/build/testrun/isolatio... --- /home/postgres/postgres/src/test/isolation/expected/timeouts.out Sat Apr 25 23:14:37 2026 +++ /home/postgres/postgres/build/testrun/isolation/isolation/results/timeouts.out Sat Apr 25 23:18:46 2026 @@ -11,7 +11,7 @@ step sto: SET statement_timeout = '10ms'; step locktbl: LOCK TABLE accounts; <waiting ...> step locktbl: <... completed> -ERROR: canceling statement due to statement timeout +ERROR: canceling statement due to user request starting permutation: rdtbl lto locktbl step rdtbl: SELECT * FROM accounts; |
| 59/6534 | amcheck: fix bug of missing corruption in allequalimage validation |
| Windows - Server 2022, VS 2019 - Meson & ninja | |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/partition_aggregate.out C:/cirrus/build/testrun/recover... --- C:/cirrus/src/test/regress/expected/partition_aggregate.out 2026-04-25 22:52:30.158091300 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/partition_aggregate.out 2026-04-25 23:02:23.4860328... @@ -1257,19 +1257,7 @@ (41 rows) SELECT a, sum(b), count(*) FROM pagg_tab_ml GROUP BY a HAVING avg(b) < 3 ORDER BY 1, 2, 3; - a | sum | count -----+------+------- - 0 | 0 | 1000 - 1 | 1000 | 1000 - 2 | 2000 | 1000 - 10 | 0 | 1000 - 11 | 1000 | 1000 - 12 | 2000 | 1000 - 20 | 0 | 1000 - 21 | 1000 | 1000 - 22 | 2000 | 1000 -(9 rows) - ... |
| 59/4817 | COPY (on_error table) saving error info to a table |
| macOS - Sequoia - Meson | |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/copy2.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgra... --- /Users/admin/pgsql/src/test/regress/expected/copy2.out 2026-04-25 13:01:36 +++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy2.out 2026-04-25 13:07:10 @@ -969,13 +969,13 @@ ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2); COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: new row for relation "err_tbl" violates check constraint "cc2" -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 42092, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc2; ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail; COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 42092, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc3; BEGIN; |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/copy2.out /Users/admin/pgsql/build/testrun/recovery/027_stream_reg... --- /Users/admin/pgsql/src/test/regress/expected/copy2.out 2026-04-25 13:01:36 +++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/copy2.out 2026-04-25 13:09:08 @@ -969,13 +969,13 @@ ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2); COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: new row for relation "err_tbl" violates check constraint "cc2" -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 42676, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc2; ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail; COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 42676, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc3; BEGIN; |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/copy2.out /Users/admin/pgsql/build/testrun/regress/regress/results... --- /Users/admin/pgsql/src/test/regress/expected/copy2.out 2026-04-25 13:01:36 +++ /Users/admin/pgsql/build/testrun/regress/regress/results/copy2.out 2026-04-25 13:07:08 @@ -969,13 +969,13 @@ ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2); COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: new row for relation "err_tbl" violates check constraint "cc2" -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 42424, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc2; ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail; COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 42424, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc3; BEGIN; |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/copy2.out /Users/admin/pgsql/build/testrun/test_plan_advice/001_re... --- /Users/admin/pgsql/src/test/regress/expected/copy2.out 2026-04-25 13:01:36 +++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/copy2.out 2026-04-25 13:07:08 @@ -969,13 +969,13 @@ ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2); COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: new row for relation "err_tbl" violates check constraint "cc2" -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43459, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc2; ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail; COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43459, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc3; BEGIN; |
| Windows - Server 2022, VS 2019 - Meson & ninja | |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/copy2.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upg... --- C:/cirrus/src/test/regress/expected/copy2.out 2026-04-25 12:57:54.021815400 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy2.out 2026-04-25 13:03:11.693798200 +0000 @@ -969,13 +969,13 @@ ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2); COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: new row for relation "err_tbl" violates check constraint "cc2" -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 42264, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc2; ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail; COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 42264, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc3; BEGIN; |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/copy2.out C:/cirrus/build/testrun/recovery/027_stream_r... --- C:/cirrus/src/test/regress/expected/copy2.out 2026-04-25 12:57:54.021815400 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/copy2.out 2026-04-25 13:07:05.611714200 +0000 @@ -969,13 +969,13 @@ ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2); COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: new row for relation "err_tbl" violates check constraint "cc2" -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 41523, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc2; ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail; COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 41523, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc3; BEGIN; |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/copy2.out C:/cirrus/build/testrun/regress/regress/resul... --- C:/cirrus/src/test/regress/expected/copy2.out 2026-04-25 12:57:54.021815400 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/copy2.out 2026-04-25 13:03:08.248982300 +0000 @@ -969,13 +969,13 @@ ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2); COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: new row for relation "err_tbl" violates check constraint "cc2" -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43041, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc2; ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail; COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43041, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc3; BEGIN; |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/copy2.out C:/cirrus/build/testrun/test_plan_advice/001_... --- C:/cirrus/src/test/regress/expected/copy2.out 2026-04-25 12:57:54.021815400 +0000 +++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/copy2.out 2026-04-25 13:03:01.687444700 +00... @@ -969,13 +969,13 @@ ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2); COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: new row for relation "err_tbl" violates check constraint "cc2" -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43380, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc2; ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail; COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43380, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc3; BEGIN; |
| Linux - Debian Trixie - Meson | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u... --- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:57:48.227616398 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy2.out 2026-04-25 13:01:23.083552358 +0... @@ -969,13 +969,13 @@ ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2); COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: new row for relation "err_tbl" violates check constraint "cc2" -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43271, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc2; ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail; COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43271, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc3; BEGIN; |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream... --- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:57:48.227616398 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/copy2.out 2026-04-25 13:02:59.359010510 ... @@ -969,13 +969,13 @@ ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2); COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: new row for relation "err_tbl" violates check constraint "cc2" -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 42987, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc2; ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail; COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 42987, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc3; BEGIN; |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/build/testrun/regress/regress/res... --- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:57:48.227616398 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/copy2.out 2026-04-25 13:01:22.219577476 +0000 @@ -969,13 +969,13 @@ ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2); COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: new row for relation "err_tbl" violates check constraint "cc2" -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43080, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc2; ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail; COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43080, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc3; BEGIN; |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice/00... --- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:57:48.227616398 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/copy2.out 2026-04-25 13:01:28.22... @@ -969,13 +969,13 @@ ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2); COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: new row for relation "err_tbl" violates check constraint "cc2" -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43167, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc2; ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail; COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43167, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc3; BEGIN; |
| OpenBSD - Meson | |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/copy2.out /home/postgres/postgres/build/testrun/pg_upgrade/00... --- /home/postgres/postgres/src/test/regress/expected/copy2.out Sat Apr 25 12:58:07 2026 +++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy2.out Sat Apr 25 13:02:13 2026 @@ -969,13 +969,13 @@ ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2); COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: new row for relation "err_tbl" violates check constraint "cc2" -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43577, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc2; ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail; COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43577, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc3; BEGIN; |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/copy2.out /home/postgres/postgres/build/testrun/recovery/027_... --- /home/postgres/postgres/src/test/regress/expected/copy2.out Sat Apr 25 12:58:07 2026 +++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/copy2.out Sat Apr 25 13:05:07 2026 @@ -969,13 +969,13 @@ ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2); COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: new row for relation "err_tbl" violates check constraint "cc2" -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43385, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc2; ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail; COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43385, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc3; BEGIN; |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/copy2.out /home/postgres/postgres/build/testrun/regress/regre... --- /home/postgres/postgres/src/test/regress/expected/copy2.out Sat Apr 25 12:58:07 2026 +++ /home/postgres/postgres/build/testrun/regress/regress/results/copy2.out Sat Apr 25 13:02:02 2026 @@ -969,13 +969,13 @@ ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2); COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: new row for relation "err_tbl" violates check constraint "cc2" -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43397, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc2; ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail; COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43397, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc3; BEGIN; |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/copy2.out /home/postgres/postgres/build/testrun/test_plan_adv... --- /home/postgres/postgres/src/test/regress/expected/copy2.out Sat Apr 25 12:58:07 2026 +++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/copy2.out Sat Apr 25 13:02:08... @@ -969,13 +969,13 @@ ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2); COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: new row for relation "err_tbl" violates check constraint "cc2" -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43306, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc2; ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail; COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43306, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc3; BEGIN; |
| FreeBSD - Meson | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u... --- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:57:45.280121000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy2.out 2026-04-25 13:02:34.414774000 +0... @@ -969,13 +969,13 @@ ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2); COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: new row for relation "err_tbl" violates check constraint "cc2" -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43076, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc2; ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail; COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43076, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc3; BEGIN; |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream... --- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:57:45.280121000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/copy2.out 2026-04-25 13:03:59.415752000 ... @@ -969,13 +969,13 @@ ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2); COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: new row for relation "err_tbl" violates check constraint "cc2" -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43300, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc2; ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail; COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43300, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc3; BEGIN; |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/build/testrun/regress/regress/res... --- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:57:45.280121000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/copy2.out 2026-04-25 13:02:25.148187000 +0000 @@ -969,13 +969,13 @@ ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2); COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: new row for relation "err_tbl" violates check constraint "cc2" -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43395, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc2; ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail; COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43395, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc3; BEGIN; |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice/00... --- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:57:45.280121000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/copy2.out 2026-04-25 13:02:36.91... @@ -969,13 +969,13 @@ ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2); COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: new row for relation "err_tbl" violates check constraint "cc2" -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43074, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc2; ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail; COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43074, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc3; BEGIN; |
| Linux - Debian Trixie - Autoconf | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/resu... --- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:58:05.721932707 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/copy2.out 2026-04-25 13:08:10.635814744 +0000 @@ -969,13 +969,13 @@ ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2); COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: new row for relation "err_tbl" violates check constraint "cc2" -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43297, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc2; ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail; COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43297, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc3; BEGIN; |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/src/test/modules/test_plan_advice... --- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:58:05.721932707 +0000 +++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/copy2.out 2026-04-25 13:10:11.901256677 +00... @@ -969,13 +969,13 @@ ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2); COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: new row for relation "err_tbl" violates check constraint "cc2" -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43295, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc2; ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail; COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43295, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc3; BEGIN; |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/resul... --- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:58:05.721932707 +0000 +++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/copy2.out 2026-04-25 13:09:40.904724222 +0000 @@ -969,13 +969,13 @@ ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2); COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: new row for relation "err_tbl" violates check constraint "cc2" -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43133, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc2; ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail; COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43133, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc3; BEGIN; |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out /tmp/cirrus-ci-build/src/test/regress/results/copy2.ou... --- /tmp/cirrus-ci-build/src/test/regress/expected/copy2.out 2026-04-25 12:58:05.721932707 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/copy2.out 2026-04-25 13:04:05.871209460 +0000 @@ -969,13 +969,13 @@ ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2); COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: new row for relation "err_tbl" violates check constraint "cc2" -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43210, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc2; ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail; COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43210, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc3; BEGIN; |
| NetBSD - Meson | |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/copy2.out /home/postgres/postgres/build/testrun/pg_upgrade/00... --- /home/postgres/postgres/src/test/regress/expected/copy2.out 2026-04-25 12:58:52.620791196 +0000 +++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy2.out 2026-04-25 13:01:45.825405430... @@ -969,13 +969,13 @@ ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2); COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: new row for relation "err_tbl" violates check constraint "cc2" -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43625, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc2; ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail; COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 43625, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc3; BEGIN; |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/copy2.out /home/postgres/postgres/build/testrun/recovery/027_... --- /home/postgres/postgres/src/test/regress/expected/copy2.out 2026-04-25 12:58:52.620791196 +0000 +++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/copy2.out 2026-04-25 13:02:46.7571469... @@ -969,13 +969,13 @@ ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2); COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: new row for relation "err_tbl" violates check constraint "cc2" -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 42441, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc2; ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail; COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 42441, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc3; BEGIN; |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/copy2.out /home/postgres/postgres/build/testrun/regress/regre... --- /home/postgres/postgres/src/test/regress/expected/copy2.out 2026-04-25 12:58:52.620791196 +0000 +++ /home/postgres/postgres/build/testrun/regress/regress/results/copy2.out 2026-04-25 13:01:47.884748339 +0000 @@ -969,13 +969,13 @@ ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2); COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: new row for relation "err_tbl" violates check constraint "cc2" -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 42566, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc2; ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail; COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 42566, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc3; BEGIN; |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/copy2.out /home/postgres/postgres/build/testrun/test_plan_adv... --- /home/postgres/postgres/src/test/regress/expected/copy2.out 2026-04-25 12:58:52.620791196 +0000 +++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/copy2.out 2026-04-25 13:01:56... @@ -969,13 +969,13 @@ ALTER TABLE err_tbl ADD CONSTRAINT cc2 CHECK(lineno > 2); COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: new row for relation "err_tbl" violates check constraint "cc2" -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 42220, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc2; ALTER TABLE err_tbl ADD CONSTRAINT cc3 NOT NULL err_detail; COPY save_error FROM STDIN WITH (DELIMITER ',', ON_ERROR TABLE, ERROR_TABLE err_tbl); ERROR: null value in column "err_detail" of relation "err_tbl" violates not-null constraint -DETAIL: Failing row contains (10, 16848, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... +DETAIL: Failing row contains (10, 42220, STDIN, 1, a,b,3,4, a, a, invalid input syntax for type integer: "a", null, 22... CONTEXT: COPY save_error, line 1, column a: "a" ALTER TABLE err_tbl DROP CONSTRAINT cc3; BEGIN; |
| 59/6664 | Support EXCEPT for ALL SEQUENCES publications |
| Windows - Server 2022, VS 2019 - Meson & ninja | |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/publication.out C:/cirrus/build/testrun/pg_upgrade/002_...
--- C:/cirrus/src/test/regress/expected/publication.out 2026-04-25 12:36:12.761405200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2026-04-25 12:41:51.397211800 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/publication.out C:/cirrus/build/testrun/recovery/027_st...
--- C:/cirrus/src/test/regress/expected/publication.out 2026-04-25 12:36:12.761405200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/publication.out 2026-04-25 12:46:27.499710400 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/publication.out C:/cirrus/build/testrun/regress/regress...
--- C:/cirrus/src/test/regress/expected/publication.out 2026-04-25 12:36:12.761405200 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/publication.out 2026-04-25 12:41:42.002175300 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/publication.out C:/cirrus/build/testrun/test_plan_advic...
--- C:/cirrus/src/test/regress/expected/publication.out 2026-04-25 12:36:12.761405200 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/publication.out 2026-04-25 12:41:50.0519948...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| macOS - Sequoia - Meson | |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/publication.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg...
--- /Users/admin/pgsql/src/test/regress/expected/publication.out 2026-04-25 12:40:13
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2026-04-25 12:44:06
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/publication.out /Users/admin/pgsql/build/testrun/recovery/027_stre...
--- /Users/admin/pgsql/src/test/regress/expected/publication.out 2026-04-25 12:40:13
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/publication.out 2026-04-25 12:45:21
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/publication.out /Users/admin/pgsql/build/testrun/regress/regress/r...
--- /Users/admin/pgsql/src/test/regress/expected/publication.out 2026-04-25 12:40:13
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/publication.out 2026-04-25 12:44:08
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/publication.out /Users/admin/pgsql/build/testrun/test_plan_advice/...
--- /Users/admin/pgsql/src/test/regress/expected/publication.out 2026-04-25 12:40:13
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/publication.out 2026-04-25 12:44:0...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| Linux - Debian Trixie - Meson | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-04-25 12:36:11.010695132 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2026-04-25 12:42:38.266986...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-04-25 12:36:11.010695132 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/publication.out 2026-04-25 12:44:28.9185...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-04-25 12:36:11.010695132 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/publication.out 2026-04-25 12:42:34.555017125 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/test_plan_adv...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-04-25 12:36:11.010695132 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/publication.out 2026-04-25 12:42...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| FreeBSD - Meson | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-04-25 12:36:11.383462000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2026-04-25 12:42:35.632684...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-04-25 12:36:11.383462000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/publication.out 2026-04-25 12:44:42.5139...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-04-25 12:36:11.383462000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/publication.out 2026-04-25 12:42:43.923309000 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/build/testrun/test_plan_adv...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-04-25 12:36:11.383462000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/publication.out 2026-04-25 12:43...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| Linux - Debian Trixie - Autoconf | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_chec...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-04-25 12:36:17.856832727 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/publication.out 2026-04-25 12:48:31.667565022 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/src/test/modules/test_plan_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-04-25 12:36:17.856832727 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/publication.out 2026-04-25 12:50:07.4114187...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-04-25 12:36:17.856832727 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/publication.out 2026-04-25 12:50:24.239388461 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/publication.out /tmp/cirrus-ci-build/src/test/regress/results/pu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/publication.out 2026-04-25 12:36:17.856832727 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/publication.out 2026-04-25 12:45:34.479353498 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| OpenBSD - Meson | |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/pg_upgr...
--- /home/postgres/postgres/src/test/regress/expected/publication.out Sat Apr 25 12:36:30 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out Sat Apr 25 12:42:40 202...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/recover...
--- /home/postgres/postgres/src/test/regress/expected/publication.out Sat Apr 25 12:36:30 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/publication.out Sat Apr 25 12:45:52 2...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/regress...
--- /home/postgres/postgres/src/test/regress/expected/publication.out Sat Apr 25 12:36:30 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/publication.out Sat Apr 25 12:42:35 2026
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/test_pl...
--- /home/postgres/postgres/src/test/regress/expected/publication.out Sat Apr 25 12:36:30 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/publication.out Sat Apr 25 12...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| NetBSD - Meson | |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/pg_upgr...
--- /home/postgres/postgres/src/test/regress/expected/publication.out 2026-04-25 12:36:39.980385222 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/publication.out 2026-04-25 12:41:13.037...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/recover...
--- /home/postgres/postgres/src/test/regress/expected/publication.out 2026-04-25 12:36:39.980385222 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/publication.out 2026-04-25 12:42:16.6...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/regress...
--- /home/postgres/postgres/src/test/regress/expected/publication.out 2026-04-25 12:36:39.980385222 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/publication.out 2026-04-25 12:41:08.896701467 +0000
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/publication.out /home/postgres/postgres/build/testrun/test_pl...
--- /home/postgres/postgres/src/test/regress/expected/publication.out 2026-04-25 12:36:39.980385222 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/publication.out 2026-04-25 12...
@@ -555,7 +555,7 @@
Type | Start | Minimum | Maximum | Increment | Cycles? | Cache
--------+-------+---------+---------------------+-----------+---------+-------
bigint | 1 | 1 | 9223372036854775807 | 1 | no | 1
-Publications:
+Included in publications:
"regress_pub_for_allsequences_alltables"
"regress_pub_forallsequences1"
"regress_pub_forallsequences2" |
| 59/4971 | [CREATE|RE] INDEX CONCURRENTLY with single heap scan |
| macOS - Sequoia - Meson | |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-04-24 09:59:15
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-24 10:03:08
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-04-24 09:59:15
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-24 10:04:59
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/regress/regress/resu...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-04-24 09:59:15
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/indexing.out 2026-04-24 10:03:14
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/test_plan_advice/001...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-04-24 09:59:15
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-24 10:03:16
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| Windows - Server 2022, VS 2019 - Meson & ninja | |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/indexing.out 2026-04-24 10:00:38.155598500 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-24 10:05:49.563752000 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/indexing.out 2026-04-24 10:00:38.155598500 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-24 10:09:10.704275100 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/indexing.out 2026-04-24 10:00:38.155598500 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/indexing.out 2026-04-24 10:05:36.447549800 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/test_plan_advice/0...
--- C:/cirrus/src/test/regress/expected/indexing.out 2026-04-24 10:00:38.155598500 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-24 10:05:43.650185400 ...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| Linux - Debian Trixie - Meson | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-24 10:00:34.549553373 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-24 10:06:25.941203359...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-24 10:00:34.549553373 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-24 10:08:07.9611631...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-24 10:00:34.549553373 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/indexing.out 2026-04-24 10:06:26.421203106 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-24 10:00:34.549553373 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-24 10:06:32...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| Linux - Debian Trixie - Autoconf | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-24 09:59:31.684765681 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/indexing.out 2026-04-24 10:10:15.098311783 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/test/modules/test_plan_adv...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-24 09:59:31.684765681 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/indexing.out 2026-04-24 10:12:53.791039233 ...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-24 09:59:31.684765681 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/indexing.out 2026-04-24 10:12:19.498839517 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/test/regress/results/index...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-24 09:59:31.684765681 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/indexing.out 2026-04-24 10:07:17.322959674 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| FreeBSD - Meson | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-24 09:59:46.315482000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-24 10:06:19.969554000...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-24 09:59:46.315482000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-24 10:08:12.0429800...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-24 09:59:46.315482000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/indexing.out 2026-04-24 10:06:28.350729000 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-24 09:59:46.315482000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-24 10:06:29...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| OpenBSD - Meson | |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/pg_upgrade...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out Fri Apr 24 09:59:54 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out Fri Apr 24 10:05:39 2026
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out Fri Apr 24 09:59:54 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/indexing.out Fri Apr 24 10:08:39 2026
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/regress/re...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out Fri Apr 24 09:59:54 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/indexing.out Fri Apr 24 10:05:30 2026
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/test_plan_...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out Fri Apr 24 09:59:54 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out Fri Apr 24 10:05...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| NetBSD - Meson | |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/pg_upgrade...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out 2026-04-24 09:59:55.801168330 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-24 10:03:57.148992...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out 2026-04-24 09:59:55.801168330 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-24 10:05:02.6958...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/regress/re...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out 2026-04-24 09:59:55.801168330 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/indexing.out 2026-04-24 10:03:53.284331502 +0000
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/test_plan_...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out 2026-04-24 09:59:55.801168330 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-24 10:04...
@@ -559,13 +559,14 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
-(4 rows)
+ relname | indisvalid
+--------------------------+------------
+ idxpart11_expr_idx | f
+ idxpart11_expr_idx_ccaux | f
+ idxpart1_expr_idx | f
+ idxpart2_expr_idx | t
... |
| 59/6059 | Improving the names generated for indexes on expressions |
| macOS - Sequoia - Meson | |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-04-24 07:35:32
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-24 07:42:27
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-04-24 07:35:32
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-24 07:44:40
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/regress/regress/resu...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-04-24 07:35:32
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/indexing.out 2026-04-24 07:42:22
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/test_plan_advice/001...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2026-04-24 07:35:32
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-24 07:42:31
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| Windows - Server 2022, VS 2019 - Meson & ninja | |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/indexing.out 2026-04-24 07:35:54.992114600 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-24 07:41:19.678546300 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/indexing.out 2026-04-24 07:35:54.992114600 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-24 07:44:55.756321300 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/indexing.out 2026-04-24 07:35:54.992114600 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/indexing.out 2026-04-24 07:40:58.882155700 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/test_plan_advice/0...
--- C:/cirrus/src/test/regress/expected/indexing.out 2026-04-24 07:35:54.992114600 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-24 07:41:11.484206900 ...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| Linux - Debian Trixie - Meson | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-24 07:35:41.933819594 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-24 07:41:46.341542232...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-24 07:35:41.933819594 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-24 07:43:32.9537598...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-24 07:35:41.933819594 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/indexing.out 2026-04-24 07:41:39.169585395 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-24 07:35:41.933819594 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-24 07:41:49...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| FreeBSD - Meson | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-24 07:36:10.585166000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-24 07:42:38.202342000...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-24 07:36:10.585166000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-24 07:44:17.8254410...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-24 07:36:10.585166000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/indexing.out 2026-04-24 07:42:40.121280000 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-24 07:36:10.585166000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-24 07:42:48...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| OpenBSD - Meson | |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/pg_upgrade...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out Fri Apr 24 07:36:18 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out Fri Apr 24 07:42:28 2026
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out Fri Apr 24 07:36:18 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/indexing.out Fri Apr 24 07:45:39 2026
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/regress/re...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out Fri Apr 24 07:36:18 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/indexing.out Fri Apr 24 07:42:12 2026
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/test_plan_...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out Fri Apr 24 07:36:18 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out Fri Apr 24 07:42...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| Linux - Debian Trixie - Autoconf | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-24 07:36:10.048334401 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/indexing.out 2026-04-24 07:45:26.612644712 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/test/modules/test_plan_adv...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-24 07:36:10.048334401 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/indexing.out 2026-04-24 07:47:21.329088542 ...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-24 07:36:10.048334401 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/indexing.out 2026-04-24 07:46:47.072652272 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/test/regress/results/index...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2026-04-24 07:36:10.048334401 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/indexing.out 2026-04-24 07:42:25.320283119 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| NetBSD - Meson | |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/pg_upgrade...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out 2026-04-24 07:37:11.086991876 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2026-04-24 07:41:13.679244...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/recovery/0...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out 2026-04-24 07:37:11.086991876 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2026-04-24 07:42:02.0783...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/regress/re...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out 2026-04-24 07:37:11.086991876 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/indexing.out 2026-04-24 07:41:08.287428796 +0000
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/indexing.out /home/postgres/postgres/build/testrun/test_plan_...
--- /home/postgres/postgres/src/test/regress/expected/indexing.out 2026-04-24 07:37:11.086991876 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/indexing.out 2026-04-24 07:41...
@@ -559,41 +559,46 @@
ERROR: division by zero
select relname, indisvalid from pg_class join pg_index on indexrelid = oid
where relname like 'idxpart%' order by relname;
- relname | indisvalid
---------------------+------------
- idxpart11_expr_idx | f
- idxpart1_expr_idx | f
- idxpart2_expr_idx | t
- idxpart_expr_idx | f
+ relname | indisvalid
+-------------------+------------
+ idxpart11_a_b_idx | f
+ idxpart1_a_b_idx | f
+ idxpart2_a_b_idx | t
+ idxpart_a_b_idx | f
(4 rows)
... |
| 59/6701 | Fix FOR PORTION OF recomputing GENERATED STORED columns that depend on the range column |
| Windows - Server 2022, VS 2019 - Meson & ninja | |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/injection_points/expected/repack.out C:/cirrus/build/testrun/inj...
--- C:/cirrus/src/test/modules/injection_points/expected/repack.out 2026-04-24 03:41:51.072422600 +0000
+++ C:/cirrus/build/testrun/injection_points/isolation/results/repack.out 2026-04-24 03:52:51.655738900 +0000
@@ -68,46 +68,7 @@
(1 row)
-step wait_before_lock: <... completed>
-step check1:
- INSERT INTO relfilenodes(node)
- SELECT relfilenode FROM pg_class WHERE relname='repack_test';
-
- SELECT count(DISTINCT node) FROM relfilenodes;
-
- SELECT i, j FROM repack_test ORDER BY i, j;
-
- INSERT INTO data_s1(i, j)
- SELECT i, j FROM repack_test;
-
- SELECT count(*)
... |
| macOS - Sequoia - Meson | |
| regress | diff -U3 /Users/admin/pgsql/src/test/modules/injection_points/expected/repack.out /Users/admin/pgsql/build/testrun/injec...
--- /Users/admin/pgsql/src/test/modules/injection_points/expected/repack.out 2026-04-24 03:42:02
+++ /Users/admin/pgsql/build/testrun/injection_points/isolation/results/repack.out 2026-04-24 03:49:37
@@ -68,46 +68,7 @@
(1 row)
-step wait_before_lock: <... completed>
-step check1:
- INSERT INTO relfilenodes(node)
- SELECT relfilenode FROM pg_class WHERE relname='repack_test';
+PQconsumeInput failed: server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
- SELECT count(DISTINCT node) FROM relfilenodes;
-
- SELECT i, j FROM repack_test ORDER BY i, j;
-
- INSERT INTO data_s1(i, j)
... |
| Linux - Debian Trixie - Meson | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/repack.out /tmp/cirrus-ci-build/build/testrun/i...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/repack.out 2026-04-24 03:41:47.511693511 +0000
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/repack.out 2026-04-24 03:48:30.967898810 +0000
@@ -68,46 +68,7 @@
(1 row)
-step wait_before_lock: <... completed>
-step check1:
- INSERT INTO relfilenodes(node)
- SELECT relfilenode FROM pg_class WHERE relname='repack_test';
-
- SELECT count(DISTINCT node) FROM relfilenodes;
-
- SELECT i, j FROM repack_test ORDER BY i, j;
-
- INSERT INTO data_s1(i, j)
- SELECT i, j FROM repack_test;
-
- SELECT count(*)
... |
| OpenBSD - Meson | |
| regress | diff -U3 /home/postgres/postgres/src/test/modules/injection_points/expected/repack.out /home/postgres/postgres/build/tes...
--- /home/postgres/postgres/src/test/modules/injection_points/expected/repack.out Fri Apr 24 03:41:55 2026
+++ /home/postgres/postgres/build/testrun/injection_points/isolation/results/repack.out Fri Apr 24 03:47:57 2026
@@ -68,46 +68,7 @@
(1 row)
-step wait_before_lock: <... completed>
-step check1:
- INSERT INTO relfilenodes(node)
- SELECT relfilenode FROM pg_class WHERE relname='repack_test';
-
- SELECT count(DISTINCT node) FROM relfilenodes;
-
- SELECT i, j FROM repack_test ORDER BY i, j;
-
- INSERT INTO data_s1(i, j)
- SELECT i, j FROM repack_test;
-
- SELECT count(*)
... |
| FreeBSD - Meson | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/repack.out /tmp/cirrus-ci-build/build/testrun/i...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/repack.out 2026-04-24 03:41:44.159473000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/repack.out 2026-04-24 03:46:50.241633000 +0000
@@ -68,46 +68,6 @@
(1 row)
-step wait_before_lock: <... completed>
-step check1:
- INSERT INTO relfilenodes(node)
- SELECT relfilenode FROM pg_class WHERE relname='repack_test';
-
- SELECT count(DISTINCT node) FROM relfilenodes;
-
- SELECT i, j FROM repack_test ORDER BY i, j;
-
- INSERT INTO data_s1(i, j)
- SELECT i, j FROM repack_test;
-
- SELECT count(*)
... |
| NetBSD - Meson | |
| regress | diff -U3 /home/postgres/postgres/src/test/modules/injection_points/expected/repack.out /home/postgres/postgres/build/tes...
--- /home/postgres/postgres/src/test/modules/injection_points/expected/repack.out 2026-04-24 03:42:28.740638686 +0000
+++ /home/postgres/postgres/build/testrun/injection_points/isolation/results/repack.out 2026-04-24 03:46:41.710463880 +0...
@@ -68,46 +68,7 @@
(1 row)
-step wait_before_lock: <... completed>
-step check1:
- INSERT INTO relfilenodes(node)
- SELECT relfilenode FROM pg_class WHERE relname='repack_test';
-
- SELECT count(DISTINCT node) FROM relfilenodes;
-
- SELECT i, j FROM repack_test ORDER BY i, j;
-
- INSERT INTO data_s1(i, j)
- SELECT i, j FROM repack_test;
-
- SELECT count(*)
... |
| Linux - Debian Trixie - Autoconf | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/repack.out /tmp/cirrus-ci-build/src/test/module...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/repack.out 2026-04-24 03:42:03.020355276 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/injection_points/output_iso/results/repack.out 2026-04-24 03:51:46.307976200 +...
@@ -68,46 +68,7 @@
(1 row)
-step wait_before_lock: <... completed>
-step check1:
- INSERT INTO relfilenodes(node)
- SELECT relfilenode FROM pg_class WHERE relname='repack_test';
-
- SELECT count(DISTINCT node) FROM relfilenodes;
-
- SELECT i, j FROM repack_test ORDER BY i, j;
-
- INSERT INTO data_s1(i, j)
- SELECT i, j FROM repack_test;
-
- SELECT count(*)
... |
| 59/6543 | synchronized_standby_slots behavior inconsistent with quorum-based synchronous replication |
| macOS - Sequoia - Meson | |
| regress | diff -U3 /Users/admin/pgsql/src/test/modules/unsafe_tests/expected/guc_privs.out /Users/admin/pgsql/build/testrun/unsafe... --- /Users/admin/pgsql/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-04-23 10:59:10 +++ /Users/admin/pgsql/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-04-23 11:07:16 @@ -590,8 +590,7 @@ -- Cannot set synchronized_standby_slots to an invalid slot name ALTER SYSTEM SET synchronized_standby_slots='invalid*'; ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*" -DETAIL: replication slot name "invalid*" contains invalid character -HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character. +DETAIL: syntax error at or near "*" -- Can set synchronized_standby_slots to a non-existent slot name ALTER SYSTEM SET synchronized_standby_slots='missing'; -- Reset the GUC |
| Windows - Server 2022, VS 2019 - Meson & ninja | |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/unsafe_tests/expected/guc_privs.out C:/cirrus/build/testrun/unsa... --- C:/cirrus/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-04-23 10:59:51.673780500 +0000 +++ C:/cirrus/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-04-23 11:10:49.033696100 +0000 @@ -590,8 +590,7 @@ -- Cannot set synchronized_standby_slots to an invalid slot name ALTER SYSTEM SET synchronized_standby_slots='invalid*'; ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*" -DETAIL: replication slot name "invalid*" contains invalid character -HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character. +DETAIL: syntax error at or near "*" -- Can set synchronized_standby_slots to a non-existent slot name ALTER SYSTEM SET synchronized_standby_slots='missing'; -- Reset the GUC |
| Linux - Debian Trixie - Meson | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out /tmp/cirrus-ci-build/build/testrun/un... --- /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-04-23 11:00:16.762061579 +0000 +++ /tmp/cirrus-ci-build/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-04-23 11:07:10.269710855 +0000 @@ -590,8 +590,7 @@ -- Cannot set synchronized_standby_slots to an invalid slot name ALTER SYSTEM SET synchronized_standby_slots='invalid*'; ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*" -DETAIL: replication slot name "invalid*" contains invalid character -HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character. +DETAIL: syntax error at or near "*" -- Can set synchronized_standby_slots to a non-existent slot name ALTER SYSTEM SET synchronized_standby_slots='missing'; -- Reset the GUC |
| OpenBSD - Meson | |
| regress | diff -U3 /home/postgres/postgres/src/test/modules/unsafe_tests/expected/guc_privs.out /home/postgres/postgres/build/test... --- /home/postgres/postgres/src/test/modules/unsafe_tests/expected/guc_privs.out Thu Apr 23 10:59:48 2026 +++ /home/postgres/postgres/build/testrun/unsafe_tests/regress/results/guc_privs.out Thu Apr 23 11:06:57 2026 @@ -590,8 +590,7 @@ -- Cannot set synchronized_standby_slots to an invalid slot name ALTER SYSTEM SET synchronized_standby_slots='invalid*'; ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*" -DETAIL: replication slot name "invalid*" contains invalid character -HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character. +DETAIL: syntax error at or near "*" -- Can set synchronized_standby_slots to a non-existent slot name ALTER SYSTEM SET synchronized_standby_slots='missing'; -- Reset the GUC |
| FreeBSD - Meson | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out /tmp/cirrus-ci-build/build/testrun/un... --- /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-04-23 10:59:39.646701000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-04-23 11:05:17.714380000 +0000 @@ -590,8 +590,7 @@ -- Cannot set synchronized_standby_slots to an invalid slot name ALTER SYSTEM SET synchronized_standby_slots='invalid*'; ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*" -DETAIL: replication slot name "invalid*" contains invalid character -HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character. +DETAIL: syntax error at or near "*" -- Can set synchronized_standby_slots to a non-existent slot name ALTER SYSTEM SET synchronized_standby_slots='missing'; -- Reset the GUC |
| Linux - Debian Trixie - Autoconf | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out /tmp/cirrus-ci-build/src/test/modules... --- /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-04-23 10:59:19.268809549 +0000 +++ /tmp/cirrus-ci-build/src/test/modules/unsafe_tests/results/guc_privs.out 2026-04-23 11:08:26.315086921 +0000 @@ -590,8 +590,7 @@ -- Cannot set synchronized_standby_slots to an invalid slot name ALTER SYSTEM SET synchronized_standby_slots='invalid*'; ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*" -DETAIL: replication slot name "invalid*" contains invalid character -HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character. +DETAIL: syntax error at or near "*" -- Can set synchronized_standby_slots to a non-existent slot name ALTER SYSTEM SET synchronized_standby_slots='missing'; -- Reset the GUC |
| NetBSD - Meson | |
| regress | diff -U3 /home/postgres/postgres/src/test/modules/unsafe_tests/expected/guc_privs.out /home/postgres/postgres/build/test... --- /home/postgres/postgres/src/test/modules/unsafe_tests/expected/guc_privs.out 2026-04-23 10:59:48.909004417 +0000 +++ /home/postgres/postgres/build/testrun/unsafe_tests/regress/results/guc_privs.out 2026-04-23 11:03:40.230976227 +0000 @@ -590,8 +590,7 @@ -- Cannot set synchronized_standby_slots to an invalid slot name ALTER SYSTEM SET synchronized_standby_slots='invalid*'; ERROR: invalid value for parameter "synchronized_standby_slots": "invalid*" -DETAIL: replication slot name "invalid*" contains invalid character -HINT: Replication slot names may only contain lower case letters, numbers, and the underscore character. +DETAIL: syntax error at or near "*" -- Can set synchronized_standby_slots to a non-existent slot name ALTER SYSTEM SET synchronized_standby_slots='missing'; -- Reset the GUC |
| 59/6055 | let ALTER TABLE DROP COLUMN drop whole-row referenced object |
| Windows - Server 2022, VS 2019 - Meson & ninja | |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/triggers.out C:/cirrus/build/testrun/pg_upgrade/002_pg_... --- C:/cirrus/src/test/regress/expected/triggers.out 2026-04-21 21:57:58.102037300 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2026-04-21 22:01:38.465237400 +0000 @@ -250,7 +250,8 @@ --------+---------+-----------+----------+---------+---------+--------------+------------- a | integer | | | | plain | | Partition key: RANGE (a) -Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000) +Partitions: + test_tbl1p1 FOR VALUES FROM (0) TO (1000) DROP TABLE test_tbl1; -- |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/triggers.out C:/cirrus/build/testrun/recovery/027_strea... --- C:/cirrus/src/test/regress/expected/triggers.out 2026-04-21 21:57:58.102037300 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2026-04-21 22:05:54.093161200 +0000 @@ -250,7 +250,8 @@ --------+---------+-----------+----------+---------+---------+--------------+------------- a | integer | | | | plain | | Partition key: RANGE (a) -Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000) +Partitions: + test_tbl1p1 FOR VALUES FROM (0) TO (1000) DROP TABLE test_tbl1; -- |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/triggers.out C:/cirrus/build/testrun/regress/regress/re... --- C:/cirrus/src/test/regress/expected/triggers.out 2026-04-21 21:57:58.102037300 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/triggers.out 2026-04-21 22:01:25.116604200 +0000 @@ -250,7 +250,8 @@ --------+---------+-----------+----------+---------+---------+--------------+------------- a | integer | | | | plain | | Partition key: RANGE (a) -Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000) +Partitions: + test_tbl1p1 FOR VALUES FROM (0) TO (1000) DROP TABLE test_tbl1; -- |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/triggers.out C:/cirrus/build/testrun/test_plan_advice/0... --- C:/cirrus/src/test/regress/expected/triggers.out 2026-04-21 21:57:58.102037300 +0000 +++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/triggers.out 2026-04-21 22:01:31.951555100 ... @@ -250,7 +250,8 @@ --------+---------+-----------+----------+---------+---------+--------------+------------- a | integer | | | | plain | | Partition key: RANGE (a) -Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000) +Partitions: + test_tbl1p1 FOR VALUES FROM (0) TO (1000) DROP TABLE test_tbl1; -- |
| macOS - Sequoia - Meson | |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/triggers.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up... --- /Users/admin/pgsql/src/test/regress/expected/triggers.out 2026-04-21 21:57:55 +++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2026-04-21 22:02:06 @@ -250,7 +250,8 @@ --------+---------+-----------+----------+---------+---------+--------------+------------- a | integer | | | | plain | | Partition key: RANGE (a) -Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000) +Partitions: + test_tbl1p1 FOR VALUES FROM (0) TO (1000) DROP TABLE test_tbl1; -- |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/triggers.out /Users/admin/pgsql/build/testrun/recovery/027_stream_... --- /Users/admin/pgsql/src/test/regress/expected/triggers.out 2026-04-21 21:57:55 +++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2026-04-21 22:05:07 @@ -250,7 +250,8 @@ --------+---------+-----------+----------+---------+---------+--------------+------------- a | integer | | | | plain | | Partition key: RANGE (a) -Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000) +Partitions: + test_tbl1p1 FOR VALUES FROM (0) TO (1000) DROP TABLE test_tbl1; -- |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/triggers.out /Users/admin/pgsql/build/testrun/regress/regress/resu... --- /Users/admin/pgsql/src/test/regress/expected/triggers.out 2026-04-21 21:57:55 +++ /Users/admin/pgsql/build/testrun/regress/regress/results/triggers.out 2026-04-21 22:02:02 @@ -250,7 +250,8 @@ --------+---------+-----------+----------+---------+---------+--------------+------------- a | integer | | | | plain | | Partition key: RANGE (a) -Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000) +Partitions: + test_tbl1p1 FOR VALUES FROM (0) TO (1000) DROP TABLE test_tbl1; -- |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/triggers.out /Users/admin/pgsql/build/testrun/test_plan_advice/001... --- /Users/admin/pgsql/src/test/regress/expected/triggers.out 2026-04-21 21:57:55 +++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/triggers.out 2026-04-21 22:02:05 @@ -250,7 +250,8 @@ --------+---------+-----------+----------+---------+---------+--------------+------------- a | integer | | | | plain | | Partition key: RANGE (a) -Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000) +Partitions: + test_tbl1p1 FOR VALUES FROM (0) TO (1000) DROP TABLE test_tbl1; -- |
| Linux - Debian Trixie - Meson | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p... --- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:52.387995851 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2026-04-21 22:00:27.693711738... @@ -250,7 +250,8 @@ --------+---------+-----------+----------+---------+---------+--------------+------------- a | integer | | | | plain | | Partition key: RANGE (a) -Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000) +Partitions: + test_tbl1p1 FOR VALUES FROM (0) TO (1000) DROP TABLE test_tbl1; -- |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str... --- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:52.387995851 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2026-04-21 22:02:02.3616239... @@ -250,7 +250,8 @@ --------+---------+-----------+----------+---------+---------+--------------+------------- a | integer | | | | plain | | Partition key: RANGE (a) -Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000) +Partitions: + test_tbl1p1 FOR VALUES FROM (0) TO (1000) DROP TABLE test_tbl1; -- |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/regress/regress/... --- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:52.387995851 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/triggers.out 2026-04-21 22:00:24.525715206 +0000 @@ -250,7 +250,8 @@ --------+---------+-----------+----------+---------+---------+--------------+------------- a | integer | | | | plain | | Partition key: RANGE (a) -Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000) +Partitions: + test_tbl1p1 FOR VALUES FROM (0) TO (1000) DROP TABLE test_tbl1; -- |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice... --- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:52.387995851 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/triggers.out 2026-04-21 22:00:30... @@ -250,7 +250,8 @@ --------+---------+-----------+----------+---------+---------+--------------+------------- a | integer | | | | plain | | Partition key: RANGE (a) -Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000) +Partitions: + test_tbl1p1 FOR VALUES FROM (0) TO (1000) DROP TABLE test_tbl1; -- |
| Linux - Debian Trixie - Autoconf | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r... --- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:48.678826296 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/triggers.out 2026-04-21 22:04:44.489855094 +0000 @@ -250,7 +250,8 @@ --------+---------+-----------+----------+---------+---------+--------------+------------- a | integer | | | | plain | | Partition key: RANGE (a) -Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000) +Partitions: + test_tbl1p1 FOR VALUES FROM (0) TO (1000) DROP TABLE test_tbl1; -- |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/test/modules/test_plan_adv... --- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:48.678826296 +0000 +++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/triggers.out 2026-04-21 22:06:53.261767864 ... @@ -250,7 +250,8 @@ --------+---------+-----------+----------+---------+---------+--------------+------------- a | integer | | | | plain | | Partition key: RANGE (a) -Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000) +Partitions: + test_tbl1p1 FOR VALUES FROM (0) TO (1000) DROP TABLE test_tbl1; -- |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/re... --- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:48.678826296 +0000 +++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/triggers.out 2026-04-21 22:05:55.917830271 +0000 @@ -250,7 +250,8 @@ --------+---------+-----------+----------+---------+---------+--------------+------------- a | integer | | | | plain | | Partition key: RANGE (a) -Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000) +Partitions: + test_tbl1p1 FOR VALUES FROM (0) TO (1000) DROP TABLE test_tbl1; -- |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/test/regress/results/trigg... --- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:48.678826296 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/triggers.out 2026-04-21 22:01:50.209796885 +0000 @@ -250,7 +250,8 @@ --------+---------+-----------+----------+---------+---------+--------------+------------- a | integer | | | | plain | | Partition key: RANGE (a) -Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000) +Partitions: + test_tbl1p1 FOR VALUES FROM (0) TO (1000) DROP TABLE test_tbl1; -- |
| OpenBSD - Meson | |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/triggers.out /home/postgres/postgres/build/testrun/pg_upgrade... --- /home/postgres/postgres/src/test/regress/expected/triggers.out Tue Apr 21 21:58:04 2026 +++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out Tue Apr 21 22:00:43 2026 @@ -250,7 +250,8 @@ --------+---------+-----------+----------+---------+---------+--------------+------------- a | integer | | | | plain | | Partition key: RANGE (a) -Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000) +Partitions: + test_tbl1p1 FOR VALUES FROM (0) TO (1000) DROP TABLE test_tbl1; -- |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/triggers.out /home/postgres/postgres/build/testrun/recovery/0... --- /home/postgres/postgres/src/test/regress/expected/triggers.out Tue Apr 21 21:58:04 2026 +++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/triggers.out Tue Apr 21 22:02:51 2026 @@ -250,7 +250,8 @@ --------+---------+-----------+----------+---------+---------+--------------+------------- a | integer | | | | plain | | Partition key: RANGE (a) -Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000) +Partitions: + test_tbl1p1 FOR VALUES FROM (0) TO (1000) DROP TABLE test_tbl1; -- |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/triggers.out /home/postgres/postgres/build/testrun/regress/re... --- /home/postgres/postgres/src/test/regress/expected/triggers.out Tue Apr 21 21:58:04 2026 +++ /home/postgres/postgres/build/testrun/regress/regress/results/triggers.out Tue Apr 21 22:00:36 2026 @@ -250,7 +250,8 @@ --------+---------+-----------+----------+---------+---------+--------------+------------- a | integer | | | | plain | | Partition key: RANGE (a) -Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000) +Partitions: + test_tbl1p1 FOR VALUES FROM (0) TO (1000) DROP TABLE test_tbl1; -- |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/triggers.out /home/postgres/postgres/build/testrun/test_plan_... --- /home/postgres/postgres/src/test/regress/expected/triggers.out Tue Apr 21 21:58:04 2026 +++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/triggers.out Tue Apr 21 22:00... @@ -250,7 +250,8 @@ --------+---------+-----------+----------+---------+---------+--------------+------------- a | integer | | | | plain | | Partition key: RANGE (a) -Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000) +Partitions: + test_tbl1p1 FOR VALUES FROM (0) TO (1000) DROP TABLE test_tbl1; -- |
| NetBSD - Meson | |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/triggers.out /home/postgres/postgres/build/testrun/pg_upgrade... --- /home/postgres/postgres/src/test/regress/expected/triggers.out 2026-04-21 21:58:04.278147131 +0000 +++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2026-04-21 21:59:51.663282... @@ -250,7 +250,8 @@ --------+---------+-----------+----------+---------+---------+--------------+------------- a | integer | | | | plain | | Partition key: RANGE (a) -Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000) +Partitions: + test_tbl1p1 FOR VALUES FROM (0) TO (1000) DROP TABLE test_tbl1; -- |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/triggers.out /home/postgres/postgres/build/testrun/recovery/0... --- /home/postgres/postgres/src/test/regress/expected/triggers.out 2026-04-21 21:58:04.278147131 +0000 +++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2026-04-21 22:00:28.3844... @@ -250,7 +250,8 @@ --------+---------+-----------+----------+---------+---------+--------------+------------- a | integer | | | | plain | | Partition key: RANGE (a) -Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000) +Partitions: + test_tbl1p1 FOR VALUES FROM (0) TO (1000) DROP TABLE test_tbl1; -- |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/triggers.out /home/postgres/postgres/build/testrun/regress/re... --- /home/postgres/postgres/src/test/regress/expected/triggers.out 2026-04-21 21:58:04.278147131 +0000 +++ /home/postgres/postgres/build/testrun/regress/regress/results/triggers.out 2026-04-21 21:59:51.082260250 +0000 @@ -250,7 +250,8 @@ --------+---------+-----------+----------+---------+---------+--------------+------------- a | integer | | | | plain | | Partition key: RANGE (a) -Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000) +Partitions: + test_tbl1p1 FOR VALUES FROM (0) TO (1000) DROP TABLE test_tbl1; -- |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/triggers.out /home/postgres/postgres/build/testrun/test_plan_... --- /home/postgres/postgres/src/test/regress/expected/triggers.out 2026-04-21 21:58:04.278147131 +0000 +++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/triggers.out 2026-04-21 21:59... @@ -250,7 +250,8 @@ --------+---------+-----------+----------+---------+---------+--------------+------------- a | integer | | | | plain | | Partition key: RANGE (a) -Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000) +Partitions: + test_tbl1p1 FOR VALUES FROM (0) TO (1000) DROP TABLE test_tbl1; -- |
| FreeBSD - Meson | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p... --- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:53.832725000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2026-04-21 21:59:47.252429000... @@ -250,7 +250,8 @@ --------+---------+-----------+----------+---------+---------+--------------+------------- a | integer | | | | plain | | Partition key: RANGE (a) -Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000) +Partitions: + test_tbl1p1 FOR VALUES FROM (0) TO (1000) DROP TABLE test_tbl1; -- |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str... --- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:53.832725000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2026-04-21 22:01:18.5989250... @@ -250,7 +250,8 @@ --------+---------+-----------+----------+---------+---------+--------------+------------- a | integer | | | | plain | | Partition key: RANGE (a) -Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000) +Partitions: + test_tbl1p1 FOR VALUES FROM (0) TO (1000) DROP TABLE test_tbl1; -- |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/regress/regress/... --- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:53.832725000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/triggers.out 2026-04-21 21:59:47.775470000 +0000 @@ -250,7 +250,8 @@ --------+---------+-----------+----------+---------+---------+--------------+------------- a | integer | | | | plain | | Partition key: RANGE (a) -Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000) +Partitions: + test_tbl1p1 FOR VALUES FROM (0) TO (1000) DROP TABLE test_tbl1; -- |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice... --- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2026-04-21 21:57:53.832725000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/triggers.out 2026-04-21 21:59:47... @@ -250,7 +250,8 @@ --------+---------+-----------+----------+---------+---------+--------------+------------- a | integer | | | | plain | | Partition key: RANGE (a) -Partitions: test_tbl1p1 FOR VALUES FROM (0) TO (1000) +Partitions: + test_tbl1p1 FOR VALUES FROM (0) TO (1000) DROP TABLE test_tbl1; -- |
| 59/6397 | extended statistic (examine_variable) ignored CollateExpr |
| macOS - Sequoia - Meson | |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out /Users/admin/pgsql/build/testrun/pg_upgrade/0...
--- /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:41:58
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/collate.icu.utf8.out 2026-04-21 21:47:14
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out /Users/admin/pgsql/build/testrun/recovery/027...
--- /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:41:58
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/collate.icu.utf8.out 2026-04-21 21:49:24
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out /Users/admin/pgsql/build/testrun/regress/regr...
--- /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:41:58
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/collate.icu.utf8.out 2026-04-21 21:47:03
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out /Users/admin/pgsql/build/testrun/test_plan_ad...
--- /Users/admin/pgsql/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:41:58
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/collate.icu.utf8.out 2026-04-21 21...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| Linux - Debian Trixie - Meson | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/pg_upgra...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:42:14.455850429 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/collate.icu.utf8.out 2026-04-21 21:45:59.6...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/recovery...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:42:14.455850429 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/collate.icu.utf8.out 2026-04-21 21:47:32...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:42:14.455850429 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/collate.icu.utf8.out 2026-04-21 21:45:54.683259576 +0000
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/test_pla...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:42:14.455850429 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/collate.icu.utf8.out 2026-04-21 ...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| Linux - Debian Trixie - Autoconf | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:41:52.298215014 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/collate.icu.utf8.out 2026-04-21 21:49:08.867031249 +0000
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/src/test/modules/test_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:41:52.298215014 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/collate.icu.utf8.out 2026-04-21 21:51:11.06...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/src/test/recovery/tmp_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:41:52.298215014 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/collate.icu.utf8.out 2026-04-21 21:51:00.422481716 +0000
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/src/test/regress/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:41:52.298215014 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/collate.icu.utf8.out 2026-04-21 21:46:37.227889277 +0000
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| NetBSD - Meson | |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out /home/postgres/postgres/build/testrun/pg...
--- /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:42:51.520961419 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/collate.icu.utf8.out 2026-04-21 21:45:3...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| OpenBSD - Meson | |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out /home/postgres/postgres/build/testrun/pg...
--- /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out Tue Apr 21 21:44:01 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/collate.icu.utf8.out Tue Apr 21 21:47:2...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out /home/postgres/postgres/build/testrun/re...
--- /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out Tue Apr 21 21:44:01 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/collate.icu.utf8.out Tue Apr 21 21:49...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out /home/postgres/postgres/build/testrun/re...
--- /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out Tue Apr 21 21:44:01 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/collate.icu.utf8.out Tue Apr 21 21:47:23 2026
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out /home/postgres/postgres/build/testrun/te...
--- /home/postgres/postgres/src/test/regress/expected/collate.icu.utf8.out Tue Apr 21 21:44:01 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/collate.icu.utf8.out Tue Apr ...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| FreeBSD - Meson | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/pg_upgra...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:42:10.091788000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/collate.icu.utf8.out 2026-04-21 21:45:30.7...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/recovery...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:42:10.091788000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/collate.icu.utf8.out 2026-04-21 21:47:10...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:42:10.091788000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/collate.icu.utf8.out 2026-04-21 21:45:22.856301000 +0000
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out /tmp/cirrus-ci-build/build/testrun/test_pla...
--- /tmp/cirrus-ci-build/src/test/regress/expected/collate.icu.utf8.out 2026-04-21 21:42:10.091788000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/collate.icu.utf8.out 2026-04-21 ...
@@ -2753,15 +2753,18 @@
FROM eager_agg_t1 t1
JOIN eager_agg_t2 t2 ON t1.val = t2.val COLLATE "C"
GROUP BY t1.id;
- QUERY PLAN
---------------------------------------------------------
- HashAggregate
+ QUERY PLAN
+------------------------------------------------------------
+ GroupAggregate
Group Key: t1.id
- -> Nested Loop
- Join Filter: ((t1.val)::text = (t2.val)::text)
- -> Seq Scan on eager_agg_t2 t2
- -> Seq Scan on eager_agg_t1 t1
-(6 rows)
+ -> Sort
... |
| 59/6274 | Add a greedy join search algorithm to handle large join problems |
| Windows - Server 2022, VS 2019 - Meson & ninja | |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgra...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-04-19 12:49:15.874279600 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-04-19 12:53:48.950804600 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/recovery/027_stream_reg...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-04-19 12:49:15.874279600 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-04-19 12:58:27.726541900 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/regress/regress/results...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-04-19 12:49:15.874279600 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/goo.out 2026-04-19 12:53:46.505500400 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/goo.out C:/cirrus/build/testrun/test_plan_advice/001_re...
--- C:/cirrus/src/test/regress/expected/goo.out 2026-04-19 12:49:15.874279600 +0000
+++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out 2026-04-19 12:53:49.607070700 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| Linux - Debian Trixie - Meson | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-19 12:47:51.702237095 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-04-19 12:50:55.246748241 +000...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-19 12:47:51.702237095 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-04-19 12:52:33.730310991 +0...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-19 12:47:51.702237095 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/goo.out 2026-04-19 12:50:52.778683289 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-19 12:47:51.702237095 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out 2026-04-19 12:50:55.7787...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| macOS - Sequoia - Meson | |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/goo.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade...
--- /Users/admin/pgsql/src/test/regress/expected/goo.out 2026-04-19 12:47:55
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-04-19 12:51:13
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/goo.out /Users/admin/pgsql/build/testrun/recovery/027_stream_regre...
--- /Users/admin/pgsql/src/test/regress/expected/goo.out 2026-04-19 12:47:55
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-04-19 12:52:47
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/goo.out /Users/admin/pgsql/build/testrun/regress/regress/results/g...
--- /Users/admin/pgsql/src/test/regress/expected/goo.out 2026-04-19 12:47:55
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/goo.out 2026-04-19 12:51:18
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/goo.out /Users/admin/pgsql/build/testrun/test_plan_advice/001_repl...
--- /Users/admin/pgsql/src/test/regress/expected/goo.out 2026-04-19 12:47:55
+++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out 2026-04-19 12:51:20
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| FreeBSD - Meson | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-19 12:48:25.358305000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-04-19 12:51:21.688262000 +000...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-19 12:48:25.358305000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-04-19 12:53:17.040060000 +0...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-19 12:48:25.358305000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/goo.out 2026-04-19 12:51:24.466030000 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-19 12:48:25.358305000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out 2026-04-19 12:51:22.8277...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| OpenBSD - Meson | |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/pg_upgrade/002_...
--- /home/postgres/postgres/src/test/regress/expected/goo.out Sun Apr 19 12:48:52 2026
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out Sun Apr 19 12:53:13 2026
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/recovery/027_st...
--- /home/postgres/postgres/src/test/regress/expected/goo.out Sun Apr 19 12:48:52 2026
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/goo.out Sun Apr 19 12:57:07 2026
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/regress/regress...
--- /home/postgres/postgres/src/test/regress/expected/goo.out Sun Apr 19 12:48:52 2026
+++ /home/postgres/postgres/build/testrun/regress/regress/results/goo.out Sun Apr 19 12:53:06 2026
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/test_plan_advic...
--- /home/postgres/postgres/src/test/regress/expected/goo.out Sun Apr 19 12:48:52 2026
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out Sun Apr 19 12:53:17 2...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| Linux - Debian Trixie - Autoconf | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/result...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-19 12:47:50.682771504 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/goo.out 2026-04-19 12:54:55.453858090 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results...
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-19 12:47:50.682771504 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/goo.out 2026-04-19 12:56:17.185720838 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/goo.out /tmp/cirrus-ci-build/src/test/regress/results/goo.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/goo.out 2026-04-19 12:47:50.682771504 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/goo.out 2026-04-19 12:52:07.958092382 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| NetBSD - Meson | |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/pg_upgrade/002_...
--- /home/postgres/postgres/src/test/regress/expected/goo.out 2026-04-19 12:48:11.897653584 +0000
+++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/goo.out 2026-04-19 12:50:34.844673195 +...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/recovery/027_st...
--- /home/postgres/postgres/src/test/regress/expected/goo.out 2026-04-19 12:48:11.897653584 +0000
+++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/goo.out 2026-04-19 12:51:22.796973634...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/regress/regress...
--- /home/postgres/postgres/src/test/regress/expected/goo.out 2026-04-19 12:48:11.897653584 +0000
+++ /home/postgres/postgres/build/testrun/regress/regress/results/goo.out 2026-04-19 12:50:35.544468749 +0000
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/goo.out /home/postgres/postgres/build/testrun/test_plan_advic...
--- /home/postgres/postgres/src/test/regress/expected/goo.out 2026-04-19 12:48:11.897653584 +0000
+++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/goo.out 2026-04-19 12:50:40.9...
@@ -139,8 +139,8 @@
JOIN dim3 ON fact.dim3_id = dim3.id
JOIN dim4 ON fact.dim4_id = dim4.id
WHERE dim1.id < 5;
- QUERY PLAN
----------------------------------------------------------------------
+ QUERY PLAN
+---------------------------------------------------------------------------
Aggregate
-> Nested Loop
Join Filter: (fact.dim4_id = dim4.id)
@@ -149,15 +149,15 @@
-> Seq Scan on dim3
-> Hash
-> Hash Join
- Hash Cond: (fact.dim1_id = dim1.id)
- -> Hash Join
... |
| 59/6270 | skip check constraints verification for unaffected columns during UPDATE |
| Windows - Server 2022, VS 2019 - Meson & ninja | |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/for_portion_of.out C:/cirrus/build/testrun/pg_upgrade/0... --- C:/cirrus/src/test/regress/expected/for_portion_of.out 2026-04-19 06:48:25.579589200 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out 2026-04-19 06:51:55.904358000 +000... @@ -1099,8 +1099,6 @@ FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11' SET name = 'one^3' WHERE id = 1; -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" -DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3). ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; -- test inserts violating CHECK constraints ALTER TABLE for_portion_of_test2 @@ -1115,12 +1113,13 @@ SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; id | valid_at | name ----+-------------------------+------- - 1 | [2000-01-01,2010-01-01) | one + 1 | [2000-01-01,2001-01-11) | one^3 + 1 | [2001-01-11,2010-01-01) | one 1 | [2010-01-01,2010-01-05) | one^1 ... |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/for_portion_of.out C:/cirrus/build/testrun/recovery/027... --- C:/cirrus/src/test/regress/expected/for_portion_of.out 2026-04-19 06:48:25.579589200 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out 2026-04-19 06:56:15.293456000 +0... @@ -1099,8 +1099,6 @@ FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11' SET name = 'one^3' WHERE id = 1; -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" -DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3). ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; -- test inserts violating CHECK constraints ALTER TABLE for_portion_of_test2 @@ -1115,12 +1113,13 @@ SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; id | valid_at | name ----+-------------------------+------- - 1 | [2000-01-01,2010-01-01) | one + 1 | [2000-01-01,2001-01-11) | one^3 + 1 | [2001-01-11,2010-01-01) | one 1 | [2010-01-01,2010-01-05) | one^1 ... |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/for_portion_of.out C:/cirrus/build/testrun/regress/regr... --- C:/cirrus/src/test/regress/expected/for_portion_of.out 2026-04-19 06:48:25.579589200 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/for_portion_of.out 2026-04-19 06:51:44.351155300 +0000 @@ -1099,8 +1099,6 @@ FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11' SET name = 'one^3' WHERE id = 1; -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" -DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3). ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; -- test inserts violating CHECK constraints ALTER TABLE for_portion_of_test2 @@ -1115,12 +1113,13 @@ SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; id | valid_at | name ----+-------------------------+------- - 1 | [2000-01-01,2010-01-01) | one + 1 | [2000-01-01,2001-01-11) | one^3 + 1 | [2001-01-11,2010-01-01) | one 1 | [2010-01-01,2010-01-05) | one^1 ... |
| regress | diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/for_portion_of.out C:/cirrus/build/testrun/test_plan_ad... --- C:/cirrus/src/test/regress/expected/for_portion_of.out 2026-04-19 06:48:25.579589200 +0000 +++ C:/cirrus/build/testrun/test_plan_advice/001_replan_regress/data/results/for_portion_of.out 2026-04-19 06:51:49.3208... @@ -1099,8 +1099,6 @@ FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11' SET name = 'one^3' WHERE id = 1; -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" -DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3). ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; -- test inserts violating CHECK constraints ALTER TABLE for_portion_of_test2 @@ -1115,12 +1113,13 @@ SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; id | valid_at | name ----+-------------------------+------- - 1 | [2000-01-01,2010-01-01) | one + 1 | [2000-01-01,2001-01-11) | one^3 + 1 | [2001-01-11,2010-01-01) | one 1 | [2010-01-01,2010-01-05) | one^1 ... |
| Linux - Debian Trixie - Meson | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade... --- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-04-19 06:47:10.371701979 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out 2026-04-19 06:50:47.057... @@ -1099,8 +1099,6 @@ FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11' SET name = 'one^3' WHERE id = 1; -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" -DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3). ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; -- test inserts violating CHECK constraints ALTER TABLE for_portion_of_test2 @@ -1115,12 +1113,13 @@ SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; id | valid_at | name ----+-------------------------+------- - 1 | [2000-01-01,2010-01-01) | one + 1 | [2000-01-01,2001-01-11) | one^3 + 1 | [2001-01-11,2010-01-01) | one 1 | [2010-01-01,2010-01-05) | one^1 ... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/recovery/0... --- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-04-19 06:47:10.371701979 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out 2026-04-19 06:52:39.6... @@ -1099,8 +1099,6 @@ FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11' SET name = 'one^3' WHERE id = 1; -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" -DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3). ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; -- test inserts violating CHECK constraints ALTER TABLE for_portion_of_test2 @@ -1115,12 +1113,13 @@ SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; id | valid_at | name ----+-------------------------+------- - 1 | [2000-01-01,2010-01-01) | one + 1 | [2000-01-01,2001-01-11) | one^3 + 1 | [2001-01-11,2010-01-01) | one 1 | [2010-01-01,2010-01-05) | one^1 ... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/regress/re... --- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-04-19 06:47:10.371701979 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/for_portion_of.out 2026-04-19 06:50:45.913761850 +0000 @@ -1099,8 +1099,6 @@ FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11' SET name = 'one^3' WHERE id = 1; -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" -DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3). ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; -- test inserts violating CHECK constraints ALTER TABLE for_portion_of_test2 @@ -1115,12 +1113,13 @@ SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; id | valid_at | name ----+-------------------------+------- - 1 | [2000-01-01,2010-01-01) | one + 1 | [2000-01-01,2001-01-11) | one^3 + 1 | [2001-01-11,2010-01-01) | one 1 | [2010-01-01,2010-01-05) | one^1 ... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/test_plan_... --- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-04-19 06:47:10.371701979 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/for_portion_of.out 2026-04-19 06... @@ -1099,8 +1099,6 @@ FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11' SET name = 'one^3' WHERE id = 1; -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" -DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3). ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; -- test inserts violating CHECK constraints ALTER TABLE for_portion_of_test2 @@ -1115,12 +1113,13 @@ SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; id | valid_at | name ----+-------------------------+------- - 1 | [2000-01-01,2010-01-01) | one + 1 | [2000-01-01,2001-01-11) | one^3 + 1 | [2001-01-11,2010-01-01) | one 1 | [2010-01-01,2010-01-05) | one^1 ... |
| macOS - Sequoia - Meson | |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out /Users/admin/pgsql/build/testrun/pg_upgrade/002... --- /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out 2026-04-19 06:46:55 +++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out 2026-04-19 06:49:34 @@ -1099,8 +1099,6 @@ FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11' SET name = 'one^3' WHERE id = 1; -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" -DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3). ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; -- test inserts violating CHECK constraints ALTER TABLE for_portion_of_test2 @@ -1115,12 +1113,13 @@ SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; id | valid_at | name ----+-------------------------+------- - 1 | [2000-01-01,2010-01-01) | one + 1 | [2000-01-01,2001-01-11) | one^3 + 1 | [2001-01-11,2010-01-01) | one 1 | [2010-01-01,2010-01-05) | one^1 ... |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out /Users/admin/pgsql/build/testrun/recovery/027_s... --- /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out 2026-04-19 06:46:55 +++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out 2026-04-19 06:51:01 @@ -1099,8 +1099,6 @@ FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11' SET name = 'one^3' WHERE id = 1; -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" -DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3). ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; -- test inserts violating CHECK constraints ALTER TABLE for_portion_of_test2 @@ -1115,12 +1113,13 @@ SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; id | valid_at | name ----+-------------------------+------- - 1 | [2000-01-01,2010-01-01) | one + 1 | [2000-01-01,2001-01-11) | one^3 + 1 | [2001-01-11,2010-01-01) | one 1 | [2010-01-01,2010-01-05) | one^1 ... |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out /Users/admin/pgsql/build/testrun/regress/regres... --- /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out 2026-04-19 06:46:55 +++ /Users/admin/pgsql/build/testrun/regress/regress/results/for_portion_of.out 2026-04-19 06:49:28 @@ -1099,8 +1099,6 @@ FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11' SET name = 'one^3' WHERE id = 1; -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" -DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3). ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; -- test inserts violating CHECK constraints ALTER TABLE for_portion_of_test2 @@ -1115,12 +1113,13 @@ SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; id | valid_at | name ----+-------------------------+------- - 1 | [2000-01-01,2010-01-01) | one + 1 | [2000-01-01,2001-01-11) | one^3 + 1 | [2001-01-11,2010-01-01) | one 1 | [2010-01-01,2010-01-05) | one^1 ... |
| regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out /Users/admin/pgsql/build/testrun/test_plan_advi... --- /Users/admin/pgsql/src/test/regress/expected/for_portion_of.out 2026-04-19 06:46:55 +++ /Users/admin/pgsql/build/testrun/test_plan_advice/001_replan_regress/data/results/for_portion_of.out 2026-04-19 06:4... @@ -1099,8 +1099,6 @@ FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11' SET name = 'one^3' WHERE id = 1; -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" -DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3). ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; -- test inserts violating CHECK constraints ALTER TABLE for_portion_of_test2 @@ -1115,12 +1113,13 @@ SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; id | valid_at | name ----+-------------------------+------- - 1 | [2000-01-01,2010-01-01) | one + 1 | [2000-01-01,2001-01-11) | one^3 + 1 | [2001-01-11,2010-01-01) | one 1 | [2010-01-01,2010-01-05) | one^1 ... |
| NetBSD - Meson | |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/for_portion_of.out /home/postgres/postgres/build/testrun/pg_u... --- /home/postgres/postgres/src/test/regress/expected/for_portion_of.out 2026-04-19 06:49:03.708145722 +0000 +++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out 2026-04-19 06:51:37.... @@ -1099,8 +1099,6 @@ FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11' SET name = 'one^3' WHERE id = 1; -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" -DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3). ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; -- test inserts violating CHECK constraints ALTER TABLE for_portion_of_test2 @@ -1115,12 +1113,13 @@ SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; id | valid_at | name ----+-------------------------+------- - 1 | [2000-01-01,2010-01-01) | one + 1 | [2000-01-01,2001-01-11) | one^3 + 1 | [2001-01-11,2010-01-01) | one 1 | [2010-01-01,2010-01-05) | one^1 ... |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/for_portion_of.out /home/postgres/postgres/build/testrun/reco... --- /home/postgres/postgres/src/test/regress/expected/for_portion_of.out 2026-04-19 06:49:03.708145722 +0000 +++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out 2026-04-19 06:52:3... @@ -1099,8 +1099,6 @@ FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11' SET name = 'one^3' WHERE id = 1; -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" -DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3). ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; -- test inserts violating CHECK constraints ALTER TABLE for_portion_of_test2 @@ -1115,12 +1113,13 @@ SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; id | valid_at | name ----+-------------------------+------- - 1 | [2000-01-01,2010-01-01) | one + 1 | [2000-01-01,2001-01-11) | one^3 + 1 | [2001-01-11,2010-01-01) | one 1 | [2010-01-01,2010-01-05) | one^1 ... |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/for_portion_of.out /home/postgres/postgres/build/testrun/regr... --- /home/postgres/postgres/src/test/regress/expected/for_portion_of.out 2026-04-19 06:49:03.708145722 +0000 +++ /home/postgres/postgres/build/testrun/regress/regress/results/for_portion_of.out 2026-04-19 06:51:32.999318383 +0000 @@ -1099,8 +1099,6 @@ FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11' SET name = 'one^3' WHERE id = 1; -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" -DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3). ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; -- test inserts violating CHECK constraints ALTER TABLE for_portion_of_test2 @@ -1115,12 +1113,13 @@ SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; id | valid_at | name ----+-------------------------+------- - 1 | [2000-01-01,2010-01-01) | one + 1 | [2000-01-01,2001-01-11) | one^3 + 1 | [2001-01-11,2010-01-01) | one 1 | [2010-01-01,2010-01-05) | one^1 ... |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/for_portion_of.out /home/postgres/postgres/build/testrun/test... --- /home/postgres/postgres/src/test/regress/expected/for_portion_of.out 2026-04-19 06:49:03.708145722 +0000 +++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/for_portion_of.out 2026-04-19... @@ -1099,8 +1099,6 @@ FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11' SET name = 'one^3' WHERE id = 1; -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" -DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3). ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; -- test inserts violating CHECK constraints ALTER TABLE for_portion_of_test2 @@ -1115,12 +1113,13 @@ SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; id | valid_at | name ----+-------------------------+------- - 1 | [2000-01-01,2010-01-01) | one + 1 | [2000-01-01,2001-01-11) | one^3 + 1 | [2001-01-11,2010-01-01) | one 1 | [2010-01-01,2010-01-05) | one^1 ... |
| Linux - Debian Trixie - Autoconf | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_c... --- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-04-19 06:48:02.978980874 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/for_portion_of.out 2026-04-19 06:54:56.026938235 +0000 @@ -1099,8 +1099,6 @@ FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11' SET name = 'one^3' WHERE id = 1; -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" -DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3). ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; -- test inserts violating CHECK constraints ALTER TABLE for_portion_of_test2 @@ -1115,12 +1113,13 @@ SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; id | valid_at | name ----+-------------------------+------- - 1 | [2000-01-01,2010-01-01) | one + 1 | [2000-01-01,2001-01-11) | one^3 + 1 | [2001-01-11,2010-01-01) | one 1 | [2010-01-01,2010-01-05) | one^1 ... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/src/test/modules/test_pl... --- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-04-19 06:48:02.978980874 +0000 +++ /tmp/cirrus-ci-build/src/test/modules/test_plan_advice/tmp_check/results/for_portion_of.out 2026-04-19 06:56:52.2829... @@ -1099,8 +1099,6 @@ FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11' SET name = 'one^3' WHERE id = 1; -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" -DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3). ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; -- test inserts violating CHECK constraints ALTER TABLE for_portion_of_test2 @@ -1115,12 +1113,13 @@ SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; id | valid_at | name ----+-------------------------+------- - 1 | [2000-01-01,2010-01-01) | one + 1 | [2000-01-01,2001-01-11) | one^3 + 1 | [2001-01-11,2010-01-01) | one 1 | [2010-01-01,2010-01-05) | one^1 ... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/src/test/recovery/tmp_ch... --- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-04-19 06:48:02.978980874 +0000 +++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/for_portion_of.out 2026-04-19 06:56:37.418923342 +0000 @@ -1099,8 +1099,6 @@ FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11' SET name = 'one^3' WHERE id = 1; -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" -DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3). ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; -- test inserts violating CHECK constraints ALTER TABLE for_portion_of_test2 @@ -1115,12 +1113,13 @@ SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; id | valid_at | name ----+-------------------------+------- - 1 | [2000-01-01,2010-01-01) | one + 1 | [2000-01-01,2001-01-11) | one^3 + 1 | [2001-01-11,2010-01-01) | one 1 | [2010-01-01,2010-01-05) | one^1 ... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/src/test/regress/results... --- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-04-19 06:48:02.978980874 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/for_portion_of.out 2026-04-19 06:52:30.306969082 +0000 @@ -1099,8 +1099,6 @@ FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11' SET name = 'one^3' WHERE id = 1; -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" -DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3). ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; -- test inserts violating CHECK constraints ALTER TABLE for_portion_of_test2 @@ -1115,12 +1113,13 @@ SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; id | valid_at | name ----+-------------------------+------- - 1 | [2000-01-01,2010-01-01) | one + 1 | [2000-01-01,2001-01-11) | one^3 + 1 | [2001-01-11,2010-01-01) | one 1 | [2010-01-01,2010-01-05) | one^1 ... |
| OpenBSD - Meson | |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/for_portion_of.out /home/postgres/postgres/build/testrun/pg_u... --- /home/postgres/postgres/src/test/regress/expected/for_portion_of.out Sun Apr 19 06:47:37 2026 +++ /home/postgres/postgres/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out Sun Apr 19 06:51:01 ... @@ -1099,8 +1099,6 @@ FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11' SET name = 'one^3' WHERE id = 1; -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" -DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3). ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; -- test inserts violating CHECK constraints ALTER TABLE for_portion_of_test2 @@ -1115,12 +1113,13 @@ SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; id | valid_at | name ----+-------------------------+------- - 1 | [2000-01-01,2010-01-01) | one + 1 | [2000-01-01,2001-01-11) | one^3 + 1 | [2001-01-11,2010-01-01) | one 1 | [2010-01-01,2010-01-05) | one^1 ... |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/for_portion_of.out /home/postgres/postgres/build/testrun/reco... --- /home/postgres/postgres/src/test/regress/expected/for_portion_of.out Sun Apr 19 06:47:37 2026 +++ /home/postgres/postgres/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out Sun Apr 19 06:53:2... @@ -1099,8 +1099,6 @@ FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11' SET name = 'one^3' WHERE id = 1; -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" -DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3). ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; -- test inserts violating CHECK constraints ALTER TABLE for_portion_of_test2 @@ -1115,12 +1113,13 @@ SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; id | valid_at | name ----+-------------------------+------- - 1 | [2000-01-01,2010-01-01) | one + 1 | [2000-01-01,2001-01-11) | one^3 + 1 | [2001-01-11,2010-01-01) | one 1 | [2010-01-01,2010-01-05) | one^1 ... |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/for_portion_of.out /home/postgres/postgres/build/testrun/regr... --- /home/postgres/postgres/src/test/regress/expected/for_portion_of.out Sun Apr 19 06:47:37 2026 +++ /home/postgres/postgres/build/testrun/regress/regress/results/for_portion_of.out Sun Apr 19 06:50:51 2026 @@ -1099,8 +1099,6 @@ FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11' SET name = 'one^3' WHERE id = 1; -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" -DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3). ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; -- test inserts violating CHECK constraints ALTER TABLE for_portion_of_test2 @@ -1115,12 +1113,13 @@ SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; id | valid_at | name ----+-------------------------+------- - 1 | [2000-01-01,2010-01-01) | one + 1 | [2000-01-01,2001-01-11) | one^3 + 1 | [2001-01-11,2010-01-01) | one 1 | [2010-01-01,2010-01-05) | one^1 ... |
| regress | diff -U3 /home/postgres/postgres/src/test/regress/expected/for_portion_of.out /home/postgres/postgres/build/testrun/test... --- /home/postgres/postgres/src/test/regress/expected/for_portion_of.out Sun Apr 19 06:47:37 2026 +++ /home/postgres/postgres/build/testrun/test_plan_advice/001_replan_regress/data/results/for_portion_of.out Sun Apr 19... @@ -1099,8 +1099,6 @@ FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11' SET name = 'one^3' WHERE id = 1; -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" -DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3). ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; -- test inserts violating CHECK constraints ALTER TABLE for_portion_of_test2 @@ -1115,12 +1113,13 @@ SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; id | valid_at | name ----+-------------------------+------- - 1 | [2000-01-01,2010-01-01) | one + 1 | [2000-01-01,2001-01-11) | one^3 + 1 | [2001-01-11,2010-01-01) | one 1 | [2010-01-01,2010-01-05) | one^1 ... |
| FreeBSD - Meson | |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade... --- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-04-19 06:46:59.400879000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/for_portion_of.out 2026-04-19 06:49:34.458... @@ -1099,8 +1099,6 @@ FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11' SET name = 'one^3' WHERE id = 1; -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" -DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3). ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; -- test inserts violating CHECK constraints ALTER TABLE for_portion_of_test2 @@ -1115,12 +1113,13 @@ SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; id | valid_at | name ----+-------------------------+------- - 1 | [2000-01-01,2010-01-01) | one + 1 | [2000-01-01,2001-01-11) | one^3 + 1 | [2001-01-11,2010-01-01) | one 1 | [2010-01-01,2010-01-05) | one^1 ... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/recovery/0... --- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-04-19 06:46:59.400879000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/for_portion_of.out 2026-04-19 06:51:18.8... @@ -1099,8 +1099,6 @@ FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11' SET name = 'one^3' WHERE id = 1; -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" -DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3). ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; -- test inserts violating CHECK constraints ALTER TABLE for_portion_of_test2 @@ -1115,12 +1113,13 @@ SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; id | valid_at | name ----+-------------------------+------- - 1 | [2000-01-01,2010-01-01) | one + 1 | [2000-01-01,2001-01-11) | one^3 + 1 | [2001-01-11,2010-01-01) | one 1 | [2010-01-01,2010-01-05) | one^1 ... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out /tmp/cirrus-ci-build/build/testrun/regress/regre... --- /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out 2026-04-19 06:46:59.386481000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/constraints.out 2026-04-19 06:49:55.983758000 +0000 @@ -1922,5 +1922,6 @@ DROP FUNCTION dummy_update_func_in_constr; DROP TABLE upd_check_skip0; DROP TABLE upd_check_skip; +DEBUG: rehashing catalog cache id 89 for pg_type; 129 tups, 64 buckets RESET client_min_messages; RESET log_statement; diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/regress/re... --- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-04-19 06:46:59.400879000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/for_portion_of.out 2026-04-19 06:49:42.905651000 +0000 @@ -1099,8 +1099,6 @@ FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11' SET name = 'one^3' WHERE id = 1; -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" -DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3). ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; ... |
| regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out /tmp/cirrus-ci-build/build/testrun/test_plan_... --- /tmp/cirrus-ci-build/src/test/regress/expected/for_portion_of.out 2026-04-19 06:46:59.400879000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/test_plan_advice/001_replan_regress/data/results/for_portion_of.out 2026-04-19 06... @@ -1099,8 +1099,6 @@ FOR PORTION OF valid_at FROM '2000-01-01' TO '2001-01-11' SET name = 'one^3' WHERE id = 1; -ERROR: new row for relation "for_portion_of_test2" violates check constraint "fpo2_check" -DETAIL: Failing row contains (1, [2000-01-01,2001-01-11), one^3). ALTER TABLE for_portion_of_test2 DROP CONSTRAINT fpo2_check; -- test inserts violating CHECK constraints ALTER TABLE for_portion_of_test2 @@ -1115,12 +1113,13 @@ SELECT * FROM for_portion_of_test2 WHERE id = 1 ORDER BY valid_at; id | valid_at | name ----+-------------------------+------- - 1 | [2000-01-01,2010-01-01) | one + 1 | [2000-01-01,2001-01-11) | one^3 + 1 | [2001-01-11,2010-01-01) | one 1 | [2010-01-01,2010-01-05) | one^1 ... |