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.
48/4450 | Replace a large number of OR clauses with ANY expression |
FreeBSD - 13 - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/0... --- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2024-05-04 07:13:59.563638000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_index.out 2024-05-04 07:15:05.63792... @@ -2135,11 +2135,19 @@ -- explain (costs off) SELECT unique1 FROM tenk1 WHERE unique1 IN (1, 42, 7) and unique1 = ANY('{7, 8, 9}'); - QUERY PLAN ----------------------------------------------------------------------------------------------------- - Index Only Scan using tenk1_unique1 on tenk1 - Index Cond: ((unique1 = ANY ('{1,42,7}'::integer[])) AND (unique1 = ANY ('{7,8,9}'::integer[]))) -(2 rows) + QUERY PLAN +------------------------------------------------------------------- + Bitmap Heap Scan on tenk1 + Recheck Cond: ((unique1 = 7) OR (unique1 = 8) OR (unique1 = 9)) + Filter: (unique1 = ANY ('{1,42,7}'::integer[])) + -> BitmapOr + -> Bitmap Index Scan on tenk1_unique1 + Index Cond: (unique1 = 7) ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/recovery/027... --- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2024-05-04 07:13:59.563638000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/create_index.out 2024-05-04 07:15:33.437... @@ -2135,11 +2135,19 @@ -- explain (costs off) SELECT unique1 FROM tenk1 WHERE unique1 IN (1, 42, 7) and unique1 = ANY('{7, 8, 9}'); - QUERY PLAN ----------------------------------------------------------------------------------------------------- - Index Only Scan using tenk1_unique1 on tenk1 - Index Cond: ((unique1 = ANY ('{1,42,7}'::integer[])) AND (unique1 = ANY ('{7,8,9}'::integer[]))) -(2 rows) + QUERY PLAN +------------------------------------------------------------------- + Bitmap Heap Scan on tenk1 + Recheck Cond: ((unique1 = 7) OR (unique1 = 8) OR (unique1 = 9)) + Filter: (unique1 = ANY ('{1,42,7}'::integer[])) + -> BitmapOr + -> Bitmap Index Scan on tenk1_unique1 + Index Cond: (unique1 = 7) ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/regress/regr... --- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2024-05-04 07:13:59.563638000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/create_index.out 2024-05-04 07:15:03.552512000 +0000 @@ -2135,11 +2135,19 @@ -- explain (costs off) SELECT unique1 FROM tenk1 WHERE unique1 IN (1, 42, 7) and unique1 = ANY('{7, 8, 9}'); - QUERY PLAN ----------------------------------------------------------------------------------------------------- - Index Only Scan using tenk1_unique1 on tenk1 - Index Cond: ((unique1 = ANY ('{1,42,7}'::integer[])) AND (unique1 = ANY ('{7,8,9}'::integer[]))) -(2 rows) + QUERY PLAN +------------------------------------------------------------------- + Bitmap Heap Scan on tenk1 + Recheck Cond: ((unique1 = 7) OR (unique1 = 8) OR (unique1 = 9)) + Filter: (unique1 = ANY ('{1,42,7}'::integer[])) + -> BitmapOr + -> Bitmap Index Scan on tenk1_unique1 + Index Cond: (unique1 = 7) ... |
Linux - Debian Bullseye - Autoconf | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_che... --- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2024-05-04 07:13:58.825475638 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/create_index.out 2024-05-04 07:17:33.665532850 +0000 @@ -2135,11 +2135,19 @@ -- explain (costs off) SELECT unique1 FROM tenk1 WHERE unique1 IN (1, 42, 7) and unique1 = ANY('{7, 8, 9}'); - QUERY PLAN ----------------------------------------------------------------------------------------------------- - Index Only Scan using tenk1_unique1 on tenk1 - Index Cond: ((unique1 = ANY ('{1,42,7}'::integer[])) AND (unique1 = ANY ('{7,8,9}'::integer[]))) -(2 rows) + QUERY PLAN +------------------------------------------------------------------- + Bitmap Heap Scan on tenk1 + Recheck Cond: ((unique1 = 7) OR (unique1 = 8) OR (unique1 = 9)) + Filter: (unique1 = ANY ('{1,42,7}'::integer[])) + -> BitmapOr + -> Bitmap Index Scan on tenk1_unique1 + Index Cond: (unique1 = 7) ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/src/test/recovery/tmp_chec... --- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2024-05-04 07:13:58.825475638 +0000 +++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/create_index.out 2024-05-04 07:19:30.913518649 +0000 @@ -2135,11 +2135,19 @@ -- explain (costs off) SELECT unique1 FROM tenk1 WHERE unique1 IN (1, 42, 7) and unique1 = ANY('{7, 8, 9}'); - QUERY PLAN ----------------------------------------------------------------------------------------------------- - Index Only Scan using tenk1_unique1 on tenk1 - Index Cond: ((unique1 = ANY ('{1,42,7}'::integer[])) AND (unique1 = ANY ('{7,8,9}'::integer[]))) -(2 rows) + QUERY PLAN +------------------------------------------------------------------- + Bitmap Heap Scan on tenk1 + Recheck Cond: ((unique1 = 7) OR (unique1 = 8) OR (unique1 = 9)) + Filter: (unique1 = ANY ('{1,42,7}'::integer[])) + -> BitmapOr + -> Bitmap Index Scan on tenk1_unique1 + Index Cond: (unique1 = 7) ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/src/test/regress/results/c... --- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2024-05-04 07:13:58.825475638 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/create_index.out 2024-05-04 07:16:03.893472416 +0000 @@ -2135,11 +2135,19 @@ -- explain (costs off) SELECT unique1 FROM tenk1 WHERE unique1 IN (1, 42, 7) and unique1 = ANY('{7, 8, 9}'); - QUERY PLAN ----------------------------------------------------------------------------------------------------- - Index Only Scan using tenk1_unique1 on tenk1 - Index Cond: ((unique1 = ANY ('{1,42,7}'::integer[])) AND (unique1 = ANY ('{7,8,9}'::integer[]))) -(2 rows) + QUERY PLAN +------------------------------------------------------------------- + Bitmap Heap Scan on tenk1 + Recheck Cond: ((unique1 = 7) OR (unique1 = 8) OR (unique1 = 9)) + Filter: (unique1 = ANY ('{1,42,7}'::integer[])) + -> BitmapOr + -> Bitmap Index Scan on tenk1_unique1 + Index Cond: (unique1 = 7) ... |
Linux - Debian Bullseye - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/0... --- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2024-05-04 07:13:54.850822409 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_index.out 2024-05-04 07:15:51.89081... @@ -2135,11 +2135,19 @@ -- explain (costs off) SELECT unique1 FROM tenk1 WHERE unique1 IN (1, 42, 7) and unique1 = ANY('{7, 8, 9}'); - QUERY PLAN ----------------------------------------------------------------------------------------------------- - Index Only Scan using tenk1_unique1 on tenk1 - Index Cond: ((unique1 = ANY ('{1,42,7}'::integer[])) AND (unique1 = ANY ('{7,8,9}'::integer[]))) -(2 rows) + QUERY PLAN +------------------------------------------------------------------- + Bitmap Heap Scan on tenk1 + Recheck Cond: ((unique1 = 7) OR (unique1 = 8) OR (unique1 = 9)) + Filter: (unique1 = ANY ('{1,42,7}'::integer[])) + -> BitmapOr + -> Bitmap Index Scan on tenk1_unique1 + Index Cond: (unique1 = 7) ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/recovery/027... --- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2024-05-04 07:13:54.850822409 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/create_index.out 2024-05-04 07:16:20.610... @@ -2135,11 +2135,19 @@ -- explain (costs off) SELECT unique1 FROM tenk1 WHERE unique1 IN (1, 42, 7) and unique1 = ANY('{7, 8, 9}'); - QUERY PLAN ----------------------------------------------------------------------------------------------------- - Index Only Scan using tenk1_unique1 on tenk1 - Index Cond: ((unique1 = ANY ('{1,42,7}'::integer[])) AND (unique1 = ANY ('{7,8,9}'::integer[]))) -(2 rows) + QUERY PLAN +------------------------------------------------------------------- + Bitmap Heap Scan on tenk1 + Recheck Cond: ((unique1 = 7) OR (unique1 = 8) OR (unique1 = 9)) + Filter: (unique1 = ANY ('{1,42,7}'::integer[])) + -> BitmapOr + -> Bitmap Index Scan on tenk1_unique1 + Index Cond: (unique1 = 7) ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/regress/regr... --- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2024-05-04 07:13:54.850822409 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/create_index.out 2024-05-04 07:15:49.918815704 +0000 @@ -2135,11 +2135,19 @@ -- explain (costs off) SELECT unique1 FROM tenk1 WHERE unique1 IN (1, 42, 7) and unique1 = ANY('{7, 8, 9}'); - QUERY PLAN ----------------------------------------------------------------------------------------------------- - Index Only Scan using tenk1_unique1 on tenk1 - Index Cond: ((unique1 = ANY ('{1,42,7}'::integer[])) AND (unique1 = ANY ('{7,8,9}'::integer[]))) -(2 rows) + QUERY PLAN +------------------------------------------------------------------- + Bitmap Heap Scan on tenk1 + Recheck Cond: ((unique1 = 7) OR (unique1 = 8) OR (unique1 = 9)) + Filter: (unique1 = ANY ('{1,42,7}'::integer[])) + -> BitmapOr + -> Bitmap Index Scan on tenk1_unique1 + Index Cond: (unique1 = 7) ... |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/create_index.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/... --- C:/cirrus/src/test/regress/expected/create_index.out 2024-05-04 07:14:13.703027100 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_index.out 2024-05-04 07:16:30.954280000 +0000 @@ -2136,10 +2136,18 @@ explain (costs off) SELECT unique1 FROM tenk1 WHERE unique1 IN (1, 42, 7) and unique1 = ANY('{7, 8, 9}'); QUERY PLAN ----------------------------------------------------------------------------------------------------- - Index Only Scan using tenk1_unique1 on tenk1 - Index Cond: ((unique1 = ANY ('{1,42,7}'::integer[])) AND (unique1 = ANY ('{7,8,9}'::integer[]))) -(2 rows) +------------------------------------------------------------------- + Bitmap Heap Scan on tenk1 + Recheck Cond: ((unique1 = 7) OR (unique1 = 8) OR (unique1 = 9)) + Filter: (unique1 = ANY ('{1,42,7}'::integer[])) + -> BitmapOr + -> Bitmap Index Scan on tenk1_unique1 + Index Cond: (unique1 = 7) + -> Bitmap Index Scan on tenk1_unique1 + Index Cond: (unique1 = 8) ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/create_index.out C:/cirrus/build/testrun/recovery/027_stream_regress/dat... --- C:/cirrus/src/test/regress/expected/create_index.out 2024-05-04 07:14:13.703027100 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/create_index.out 2024-05-04 07:18:31.753321000 +000... @@ -2136,10 +2136,18 @@ explain (costs off) SELECT unique1 FROM tenk1 WHERE unique1 IN (1, 42, 7) and unique1 = ANY('{7, 8, 9}'); QUERY PLAN ----------------------------------------------------------------------------------------------------- - Index Only Scan using tenk1_unique1 on tenk1 - Index Cond: ((unique1 = ANY ('{1,42,7}'::integer[])) AND (unique1 = ANY ('{7,8,9}'::integer[]))) -(2 rows) +------------------------------------------------------------------- + Bitmap Heap Scan on tenk1 + Recheck Cond: ((unique1 = 7) OR (unique1 = 8) OR (unique1 = 9)) + Filter: (unique1 = ANY ('{1,42,7}'::integer[])) + -> BitmapOr + -> Bitmap Index Scan on tenk1_unique1 + Index Cond: (unique1 = 7) + -> Bitmap Index Scan on tenk1_unique1 + Index Cond: (unique1 = 8) ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/create_index.out C:/cirrus/build/testrun/regress/regress/results/create_... --- C:/cirrus/src/test/regress/expected/create_index.out 2024-05-04 07:14:13.703027100 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/create_index.out 2024-05-04 07:16:18.512206800 +0000 @@ -2136,10 +2136,18 @@ explain (costs off) SELECT unique1 FROM tenk1 WHERE unique1 IN (1, 42, 7) and unique1 = ANY('{7, 8, 9}'); QUERY PLAN ----------------------------------------------------------------------------------------------------- - Index Only Scan using tenk1_unique1 on tenk1 - Index Cond: ((unique1 = ANY ('{1,42,7}'::integer[])) AND (unique1 = ANY ('{7,8,9}'::integer[]))) -(2 rows) +------------------------------------------------------------------- + Bitmap Heap Scan on tenk1 + Recheck Cond: ((unique1 = 7) OR (unique1 = 8) OR (unique1 = 9)) + Filter: (unique1 = ANY ('{1,42,7}'::integer[])) + -> BitmapOr + -> Bitmap Index Scan on tenk1_unique1 + Index Cond: (unique1 = 7) + -> Bitmap Index Scan on tenk1_unique1 + Index Cond: (unique1 = 8) ... |
macOS - Ventura - Meson | |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/create_index.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_p... --- /Users/admin/pgsql/src/test/regress/expected/create_index.out 2024-05-04 07:13:52 +++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/create_index.out 2024-05-04 07:16:33 @@ -2135,11 +2135,19 @@ -- explain (costs off) SELECT unique1 FROM tenk1 WHERE unique1 IN (1, 42, 7) and unique1 = ANY('{7, 8, 9}'); - QUERY PLAN ----------------------------------------------------------------------------------------------------- - Index Only Scan using tenk1_unique1 on tenk1 - Index Cond: ((unique1 = ANY ('{1,42,7}'::integer[])) AND (unique1 = ANY ('{7,8,9}'::integer[]))) -(2 rows) + QUERY PLAN +------------------------------------------------------------------- + Bitmap Heap Scan on tenk1 + Recheck Cond: ((unique1 = 7) OR (unique1 = 8) OR (unique1 = 9)) + Filter: (unique1 = ANY ('{1,42,7}'::integer[])) + -> BitmapOr + -> Bitmap Index Scan on tenk1_unique1 + Index Cond: (unique1 = 7) ... |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/create_index.out /Users/admin/pgsql/build/testrun/recovery/027_str... --- /Users/admin/pgsql/src/test/regress/expected/create_index.out 2024-05-04 07:13:52 +++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/create_index.out 2024-05-04 07:17:14 @@ -2135,11 +2135,19 @@ -- explain (costs off) SELECT unique1 FROM tenk1 WHERE unique1 IN (1, 42, 7) and unique1 = ANY('{7, 8, 9}'); - QUERY PLAN ----------------------------------------------------------------------------------------------------- - Index Only Scan using tenk1_unique1 on tenk1 - Index Cond: ((unique1 = ANY ('{1,42,7}'::integer[])) AND (unique1 = ANY ('{7,8,9}'::integer[]))) -(2 rows) + QUERY PLAN +------------------------------------------------------------------- + Bitmap Heap Scan on tenk1 + Recheck Cond: ((unique1 = 7) OR (unique1 = 8) OR (unique1 = 9)) + Filter: (unique1 = ANY ('{1,42,7}'::integer[])) + -> BitmapOr + -> Bitmap Index Scan on tenk1_unique1 + Index Cond: (unique1 = 7) ... |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/create_index.out /Users/admin/pgsql/build/testrun/regress/regress/... --- /Users/admin/pgsql/src/test/regress/expected/create_index.out 2024-05-04 07:13:52 +++ /Users/admin/pgsql/build/testrun/regress/regress/results/create_index.out 2024-05-04 07:16:32 @@ -2135,11 +2135,19 @@ -- explain (costs off) SELECT unique1 FROM tenk1 WHERE unique1 IN (1, 42, 7) and unique1 = ANY('{7, 8, 9}'); - QUERY PLAN ----------------------------------------------------------------------------------------------------- - Index Only Scan using tenk1_unique1 on tenk1 - Index Cond: ((unique1 = ANY ('{1,42,7}'::integer[])) AND (unique1 = ANY ('{7,8,9}'::integer[]))) -(2 rows) + QUERY PLAN +------------------------------------------------------------------- + Bitmap Heap Scan on tenk1 + Recheck Cond: ((unique1 = 7) OR (unique1 = 8) OR (unique1 = 9)) + Filter: (unique1 = ANY ('{1,42,7}'::integer[])) + -> BitmapOr + -> Bitmap Index Scan on tenk1_unique1 + Index Cond: (unique1 = 7) ... |
48/4882 | Add a pg_truncate_freespace_map function |
FreeBSD - 13 - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/contrib/pg_freespacemap/expected/pg_freespacemap.out /tmp/cirrus-ci-build/build/testrun/pg... --- /tmp/cirrus-ci-build/contrib/pg_freespacemap/expected/pg_freespacemap.out 2024-05-04 07:04:24.043735000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_freespacemap/regress/results/pg_freespacemap.out 2024-05-04 07:06:19.284828000... @@ -1,4 +1,5 @@ CREATE EXTENSION pg_freespacemap; +ERROR: extension "pg_freespacemap" has no installation script nor update path for version "1.3" CREATE TABLE freespace_tab (c1 int) WITH (autovacuum_enabled = off); CREATE INDEX freespace_brin ON freespace_tab USING brin (c1); CREATE INDEX freespace_btree ON freespace_tab USING btree (c1); @@ -8,78 +9,39 @@ SELECT rel.id, fsm.blkno, (fsm.avail > 0) AS is_avail FROM rel, LATERAL pg_freespace(rel.id) AS fsm ORDER BY 1, 2; - id | blkno | is_avail ------------------+-------+---------- - freespace_brin | 0 | f - freespace_brin | 1 | f - freespace_brin | 2 | t - freespace_btree | 0 | f - freespace_hash | 0 | f ... |
Linux - Debian Bullseye - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/contrib/pg_freespacemap/expected/pg_freespacemap.out /tmp/cirrus-ci-build/build/testrun/pg... --- /tmp/cirrus-ci-build/contrib/pg_freespacemap/expected/pg_freespacemap.out 2024-05-04 07:04:24.069091841 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_freespacemap/regress/results/pg_freespacemap.out 2024-05-04 07:07:33.328967490... @@ -1,4 +1,5 @@ CREATE EXTENSION pg_freespacemap; +ERROR: extension "pg_freespacemap" has no installation script nor update path for version "1.3" CREATE TABLE freespace_tab (c1 int) WITH (autovacuum_enabled = off); CREATE INDEX freespace_brin ON freespace_tab USING brin (c1); CREATE INDEX freespace_btree ON freespace_tab USING btree (c1); @@ -8,78 +9,39 @@ SELECT rel.id, fsm.blkno, (fsm.avail > 0) AS is_avail FROM rel, LATERAL pg_freespace(rel.id) AS fsm ORDER BY 1, 2; - id | blkno | is_avail ------------------+-------+---------- - freespace_brin | 0 | f - freespace_brin | 1 | f - freespace_brin | 2 | t - freespace_btree | 0 | f - freespace_hash | 0 | f ... |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff -w -U3 C:/cirrus/contrib/pg_freespacemap/expected/pg_freespacemap.out C:/cirrus/build/testrun/pg_freespacemap/regre... --- C:/cirrus/contrib/pg_freespacemap/expected/pg_freespacemap.out 2024-05-04 07:04:40.675900700 +0000 +++ C:/cirrus/build/testrun/pg_freespacemap/regress/results/pg_freespacemap.out 2024-05-04 07:11:19.500483600 +0000 @@ -1,4 +1,5 @@ CREATE EXTENSION pg_freespacemap; +ERROR: extension "pg_freespacemap" has no installation script nor update path for version "1.3" CREATE TABLE freespace_tab (c1 int) WITH (autovacuum_enabled = off); CREATE INDEX freespace_brin ON freespace_tab USING brin (c1); CREATE INDEX freespace_btree ON freespace_tab USING btree (c1); @@ -8,78 +9,39 @@ SELECT rel.id, fsm.blkno, (fsm.avail > 0) AS is_avail FROM rel, LATERAL pg_freespace(rel.id) AS fsm ORDER BY 1, 2; - id | blkno | is_avail ------------------+-------+---------- - freespace_brin | 0 | f - freespace_brin | 1 | f - freespace_brin | 2 | t - freespace_btree | 0 | f - freespace_hash | 0 | f ... |
macOS - Ventura - Meson | |
regress | diff -U3 /Users/admin/pgsql/contrib/pg_freespacemap/expected/pg_freespacemap.out /Users/admin/pgsql/build/testrun/pg_fre... --- /Users/admin/pgsql/contrib/pg_freespacemap/expected/pg_freespacemap.out 2024-05-04 07:04:21 +++ /Users/admin/pgsql/build/testrun/pg_freespacemap/regress/results/pg_freespacemap.out 2024-05-04 07:07:11 @@ -1,4 +1,5 @@ CREATE EXTENSION pg_freespacemap; +ERROR: extension "pg_freespacemap" has no installation script nor update path for version "1.3" CREATE TABLE freespace_tab (c1 int) WITH (autovacuum_enabled = off); CREATE INDEX freespace_brin ON freespace_tab USING brin (c1); CREATE INDEX freespace_btree ON freespace_tab USING btree (c1); @@ -8,78 +9,39 @@ SELECT rel.id, fsm.blkno, (fsm.avail > 0) AS is_avail FROM rel, LATERAL pg_freespace(rel.id) AS fsm ORDER BY 1, 2; - id | blkno | is_avail ------------------+-------+---------- - freespace_brin | 0 | f - freespace_brin | 1 | f - freespace_brin | 2 | t - freespace_btree | 0 | f - freespace_hash | 0 | f ... |
48/4888 | Run deferred triggers in the correct security context |
FreeBSD - 13 - 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 2024-05-04 04:26:16.299156000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2024-05-04 04:27:56.613074000... @@ -3720,7 +3720,9 @@ -- test who runs deferred trigger functions -- setup create role groot; +WARNING: roles created by regression test cases should have names starting with "regress_" create role outis; +WARNING: roles created by regression test cases should have names starting with "regress_" create function whoami() returns trigger language plpgsql as $$ begin |
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 2024-05-04 04:26:16.299156000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2024-05-04 04:28:26.0609400... @@ -3720,7 +3720,9 @@ -- test who runs deferred trigger functions -- setup create role groot; +WARNING: roles created by regression test cases should have names starting with "regress_" create role outis; +WARNING: roles created by regression test cases should have names starting with "regress_" create function whoami() returns trigger language plpgsql as $$ begin |
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 2024-05-04 04:26:16.299156000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/triggers.out 2024-05-04 04:27:53.081385000 +0000 @@ -3720,7 +3720,9 @@ -- test who runs deferred trigger functions -- setup create role groot; +WARNING: roles created by regression test cases should have names starting with "regress_" create role outis; +WARNING: roles created by regression test cases should have names starting with "regress_" create function whoami() returns trigger language plpgsql as $$ begin |
48/4873 | unaccent: understand ancient Greek "oxia" and other codepoints merged by Unicode |
FreeBSD - 13 - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/contrib/unaccent/expected/unaccent.out /tmp/cirrus-ci-build/build/testrun/unaccent/regress... --- /tmp/cirrus-ci-build/contrib/unaccent/expected/unaccent.out 2024-05-04 02:14:48.147722000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/unaccent/regress/results/unaccent.out 2024-05-04 02:16:32.015899000 +0000 @@ -8,8 +8,10 @@ \quit \endif CREATE EXTENSION unaccent; +WARNING: duplicate source strings, first one will be used SET client_encoding TO 'UTF8'; SELECT unaccent('foobar'); +WARNING: duplicate source strings, first one will be used unaccent ---------- foobar |
Linux - Debian Bullseye - Autoconf | |
regress | diff -U3 /tmp/cirrus-ci-build/contrib/unaccent/expected/unaccent.out /tmp/cirrus-ci-build/contrib/unaccent/results/unacc... --- /tmp/cirrus-ci-build/contrib/unaccent/expected/unaccent.out 2024-05-04 02:14:39.182339293 +0000 +++ /tmp/cirrus-ci-build/contrib/unaccent/results/unaccent.out 2024-05-04 02:18:03.654175055 +0000 @@ -8,8 +8,10 @@ \quit \endif CREATE EXTENSION unaccent; +WARNING: duplicate source strings, first one will be used SET client_encoding TO 'UTF8'; SELECT unaccent('foobar'); +WARNING: duplicate source strings, first one will be used unaccent ---------- foobar |
Linux - Debian Bullseye - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/contrib/unaccent/expected/unaccent.out /tmp/cirrus-ci-build/build/testrun/unaccent/regress... --- /tmp/cirrus-ci-build/contrib/unaccent/expected/unaccent.out 2024-05-04 02:14:41.455091948 +0000 +++ /tmp/cirrus-ci-build/build/testrun/unaccent/regress/results/unaccent.out 2024-05-04 02:17:02.655102978 +0000 @@ -8,8 +8,10 @@ \quit \endif CREATE EXTENSION unaccent; +WARNING: duplicate source strings, first one will be used SET client_encoding TO 'UTF8'; SELECT unaccent('foobar'); +WARNING: duplicate source strings, first one will be used unaccent ---------- foobar |
macOS - Ventura - Meson | |
regress | diff -U3 /Users/admin/pgsql/contrib/unaccent/expected/unaccent.out /Users/admin/pgsql/build/testrun/unaccent/regress/res... --- /Users/admin/pgsql/contrib/unaccent/expected/unaccent.out 2024-05-04 02:14:40 +++ /Users/admin/pgsql/build/testrun/unaccent/regress/results/unaccent.out 2024-05-04 02:20:53 @@ -8,8 +8,10 @@ \quit \endif CREATE EXTENSION unaccent; +WARNING: duplicate source strings, first one will be used SET client_encoding TO 'UTF8'; SELECT unaccent('foobar'); +WARNING: duplicate source strings, first one will be used unaccent ---------- foobar |
48/4768 | A infrastructure to detect misuse of spin lock easier |
FreeBSD - 13 - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/injection_points.out /tmp/cirrus-ci-build/build... --- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/injection_points.out 2024-05-03 21:12:22.820109000 +... +++ /tmp/cirrus-ci-build/build/testrun/injection_points/regress/results/injection_points.out 2024-05-03 21:15:18.8003690... @@ -169,44 +169,10 @@ -- Wait for the previous backend process to exit, ensuring that its local -- injection points are cleaned up. SELECT wait_pid(:'oldpid'); - wait_pid ----------- - -(1 row) - -SELECT injection_points_run('TestConditionLocal1'); -- nothing - injection_points_run ----------------------- - -(1 row) - -SELECT injection_points_run('TestConditionLocal2'); -- nothing - injection_points_run ... |
Linux - Debian Bullseye - Autoconf | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/injection_points.out /tmp/cirrus-ci-build/src/t... --- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/injection_points.out 2024-05-03 21:12:17.429659968 +... +++ /tmp/cirrus-ci-build/src/test/modules/injection_points/results/injection_points.out 2024-05-03 21:18:12.245679063 +0... @@ -169,44 +169,10 @@ -- Wait for the previous backend process to exit, ensuring that its local -- injection points are cleaned up. SELECT wait_pid(:'oldpid'); - wait_pid ----------- - -(1 row) - -SELECT injection_points_run('TestConditionLocal1'); -- nothing - injection_points_run ----------------------- - -(1 row) - -SELECT injection_points_run('TestConditionLocal2'); -- nothing - injection_points_run ... |
Linux - Debian Bullseye - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/injection_points.out /tmp/cirrus-ci-build/build... --- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/injection_points.out 2024-05-03 21:12:16.825447879 +... +++ /tmp/cirrus-ci-build/build/testrun/injection_points/regress/results/injection_points.out 2024-05-03 21:17:17.8295078... @@ -169,44 +169,10 @@ -- Wait for the previous backend process to exit, ensuring that its local -- injection points are cleaned up. SELECT wait_pid(:'oldpid'); - wait_pid ----------- - -(1 row) - -SELECT injection_points_run('TestConditionLocal1'); -- nothing - injection_points_run ----------------------- - -(1 row) - -SELECT injection_points_run('TestConditionLocal2'); -- nothing - injection_points_run ... |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff -w -U3 C:/cirrus/src/test/modules/injection_points/expected/injection_points.out C:/cirrus/build/testrun/injection_... --- C:/cirrus/src/test/modules/injection_points/expected/injection_points.out 2024-05-03 21:12:35.706299700 +0000 +++ C:/cirrus/build/testrun/injection_points/regress/results/injection_points.out 2024-05-03 21:20:00.418911300 +0000 @@ -169,44 +169,10 @@ -- Wait for the previous backend process to exit, ensuring that its local -- injection points are cleaned up. SELECT wait_pid(:'oldpid'); - wait_pid ----------- - -(1 row) - -SELECT injection_points_run('TestConditionLocal1'); -- nothing - injection_points_run ----------------------- - -(1 row) - -SELECT injection_points_run('TestConditionLocal2'); -- nothing - injection_points_run ... |
macOS - Ventura - Meson | |
regress | diff -U3 /Users/admin/pgsql/src/test/modules/injection_points/expected/injection_points.out /Users/admin/pgsql/build/tes... --- /Users/admin/pgsql/src/test/modules/injection_points/expected/injection_points.out 2024-05-03 21:12:11 +++ /Users/admin/pgsql/build/testrun/injection_points/regress/results/injection_points.out 2024-05-03 21:19:02 @@ -169,44 +169,10 @@ -- Wait for the previous backend process to exit, ensuring that its local -- injection points are cleaned up. SELECT wait_pid(:'oldpid'); - wait_pid ----------- - -(1 row) - -SELECT injection_points_run('TestConditionLocal1'); -- nothing - injection_points_run ----------------------- - -(1 row) - -SELECT injection_points_run('TestConditionLocal2'); -- nothing - injection_points_run ... |
48/3246 | Parallelize correlated subqueries that execute within each worker |
FreeBSD - 13 - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/build/testrun/pg_upgrad... --- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2024-05-03 18:09:55.108109000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2024-05-03 18:11:29.22... @@ -451,26 +451,36 @@ join tenk1 t3 on t3.stringu1 = tenk1.stringu1 where tenk1.four = t.four ); - ... ------------------------------------------------------------------------------------------------------------------------... - Seq Scan on public.tenk1 t + ... +-----------------------------------------------------------------------------------------------------------------------... + Hash Join Output: t.unique1, t.unique2, t.two, t.four, t.ten, t.twenty, t.hundred, t.thousand, t.twothousand, t.fivethous, t.t... - Filter: (SubPlan 1) - SubPlan 1 - -> Hash Join - Output: t.two - Hash Cond: (tenk1.stringu1 = t3.stringu1) - -> Seq Scan on public.tenk1 ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/build/testrun/recovery/... --- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2024-05-03 18:09:55.108109000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2024-05-03 18:12:00.... @@ -451,26 +451,36 @@ join tenk1 t3 on t3.stringu1 = tenk1.stringu1 where tenk1.four = t.four ); - ... ------------------------------------------------------------------------------------------------------------------------... - Seq Scan on public.tenk1 t + ... +-----------------------------------------------------------------------------------------------------------------------... + Hash Join Output: t.unique1, t.unique2, t.two, t.four, t.ten, t.twenty, t.hundred, t.thousand, t.twothousand, t.fivethous, t.t... - Filter: (SubPlan 1) - SubPlan 1 - -> Hash Join - Output: t.two - Hash Cond: (tenk1.stringu1 = t3.stringu1) - -> Seq Scan on public.tenk1 ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/build/testrun/regress/r... --- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2024-05-03 18:09:55.108109000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/select_parallel.out 2024-05-03 18:11:26.325932000 +0000 @@ -451,26 +451,36 @@ join tenk1 t3 on t3.stringu1 = tenk1.stringu1 where tenk1.four = t.four ); - ... ------------------------------------------------------------------------------------------------------------------------... - Seq Scan on public.tenk1 t + ... +-----------------------------------------------------------------------------------------------------------------------... + Hash Join Output: t.unique1, t.unique2, t.two, t.four, t.ten, t.twenty, t.hundred, t.thousand, t.twothousand, t.fivethous, t.t... - Filter: (SubPlan 1) - SubPlan 1 - -> Hash Join - Output: t.two - Hash Cond: (tenk1.stringu1 = t3.stringu1) - -> Seq Scan on public.tenk1 ... |
Linux - Debian Bullseye - Autoconf | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_... --- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2024-05-03 18:09:56.037755660 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/select_parallel.out 2024-05-03 18:13:57.013527110 +0000 @@ -451,26 +451,36 @@ join tenk1 t3 on t3.stringu1 = tenk1.stringu1 where tenk1.four = t.four ); - ... ------------------------------------------------------------------------------------------------------------------------... - Seq Scan on public.tenk1 t + ... +-----------------------------------------------------------------------------------------------------------------------... + Hash Join Output: t.unique1, t.unique2, t.two, t.four, t.ten, t.twenty, t.hundred, t.thousand, t.twothousand, t.fivethous, t.t... - Filter: (SubPlan 1) - SubPlan 1 - -> Hash Join - Output: t.two - Hash Cond: (tenk1.stringu1 = t3.stringu1) - -> Seq Scan on public.tenk1 ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/src/test/regress/result... --- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2024-05-03 18:09:56.037755660 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/select_parallel.out 2024-05-03 18:12:43.689599419 +0000 @@ -451,26 +451,36 @@ join tenk1 t3 on t3.stringu1 = tenk1.stringu1 where tenk1.four = t.four ); - ... ------------------------------------------------------------------------------------------------------------------------... - Seq Scan on public.tenk1 t + ... +-----------------------------------------------------------------------------------------------------------------------... + Hash Join Output: t.unique1, t.unique2, t.two, t.four, t.ten, t.twenty, t.hundred, t.thousand, t.twothousand, t.fivethous, t.t... - Filter: (SubPlan 1) - SubPlan 1 - -> Hash Join - Output: t.two - Hash Cond: (tenk1.stringu1 = t3.stringu1) - -> Seq Scan on public.tenk1 ... |
Linux - Debian Bullseye - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/build/testrun/pg_upgrad... --- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2024-05-03 18:09:56.936397155 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2024-05-03 18:12:35.98... @@ -451,26 +451,36 @@ join tenk1 t3 on t3.stringu1 = tenk1.stringu1 where tenk1.four = t.four ); - ... ------------------------------------------------------------------------------------------------------------------------... - Seq Scan on public.tenk1 t + ... +-----------------------------------------------------------------------------------------------------------------------... + Hash Join Output: t.unique1, t.unique2, t.two, t.four, t.ten, t.twenty, t.hundred, t.thousand, t.twothousand, t.fivethous, t.t... - Filter: (SubPlan 1) - SubPlan 1 - -> Hash Join - Output: t.two - Hash Cond: (tenk1.stringu1 = t3.stringu1) - -> Seq Scan on public.tenk1 ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/build/testrun/recovery/... --- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2024-05-03 18:09:56.936397155 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2024-05-03 18:13:07.... @@ -451,26 +451,36 @@ join tenk1 t3 on t3.stringu1 = tenk1.stringu1 where tenk1.four = t.four ); - ... ------------------------------------------------------------------------------------------------------------------------... - Seq Scan on public.tenk1 t + ... +-----------------------------------------------------------------------------------------------------------------------... + Hash Join Output: t.unique1, t.unique2, t.two, t.four, t.ten, t.twenty, t.hundred, t.thousand, t.twothousand, t.fivethous, t.t... - Filter: (SubPlan 1) - SubPlan 1 - -> Hash Join - Output: t.two - Hash Cond: (tenk1.stringu1 = t3.stringu1) - -> Seq Scan on public.tenk1 ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/build/testrun/regress/r... --- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2024-05-03 18:09:56.936397155 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/select_parallel.out 2024-05-03 18:12:31.668297811 +0000 @@ -451,26 +451,36 @@ join tenk1 t3 on t3.stringu1 = tenk1.stringu1 where tenk1.four = t.four ); - ... ------------------------------------------------------------------------------------------------------------------------... - Seq Scan on public.tenk1 t + ... +-----------------------------------------------------------------------------------------------------------------------... + Hash Join Output: t.unique1, t.unique2, t.two, t.four, t.ten, t.twenty, t.hundred, t.thousand, t.twothousand, t.fivethous, t.t... - Filter: (SubPlan 1) - SubPlan 1 - -> Hash Join - Output: t.two - Hash Cond: (tenk1.stringu1 = t3.stringu1) - -> Seq Scan on public.tenk1 ... |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/select_parallel.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/da... --- C:/cirrus/src/test/regress/expected/select_parallel.out 2024-05-03 18:10:15.150223900 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2024-05-03 18:13:17.527031700 +00... @@ -452,25 +452,35 @@ where tenk1.four = t.four ); ... ------------------------------------------------------------------------------------------------------------------------... - Seq Scan on public.tenk1 t +-----------------------------------------------------------------------------------------------------------------------... + Hash Join Output: t.unique1, t.unique2, t.two, t.four, t.ten, t.twenty, t.hundred, t.thousand, t.twothousand, t.fivethous, t.t... - Filter: (SubPlan 1) - SubPlan 1 - -> Hash Join - Output: t.two - Hash Cond: (tenk1.stringu1 = t3.stringu1) - -> Seq Scan on public.tenk1 - Output: tenk1.unique1, tenk1.unique2, tenk1.two, tenk1.four, tenk1.ten, tenk1.twenty, tenk1.hundred, t... - Filter: (tenk1.four = t.four) ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/select_parallel.out C:/cirrus/build/testrun/recovery/027_stream_regress/... --- C:/cirrus/src/test/regress/expected/select_parallel.out 2024-05-03 18:10:15.150223900 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2024-05-03 18:15:32.785798300 +... @@ -452,25 +452,35 @@ where tenk1.four = t.four ); ... ------------------------------------------------------------------------------------------------------------------------... - Seq Scan on public.tenk1 t +-----------------------------------------------------------------------------------------------------------------------... + Hash Join Output: t.unique1, t.unique2, t.two, t.four, t.ten, t.twenty, t.hundred, t.thousand, t.twothousand, t.fivethous, t.t... - Filter: (SubPlan 1) - SubPlan 1 - -> Hash Join - Output: t.two - Hash Cond: (tenk1.stringu1 = t3.stringu1) - -> Seq Scan on public.tenk1 - Output: tenk1.unique1, tenk1.unique2, tenk1.two, tenk1.four, tenk1.ten, tenk1.twenty, tenk1.hundred, t... - Filter: (tenk1.four = t.four) ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/select_parallel.out C:/cirrus/build/testrun/regress/regress/results/sele... --- C:/cirrus/src/test/regress/expected/select_parallel.out 2024-05-03 18:10:15.150223900 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/select_parallel.out 2024-05-03 18:13:14.804865900 +0000 @@ -452,25 +452,35 @@ where tenk1.four = t.four ); ... ------------------------------------------------------------------------------------------------------------------------... - Seq Scan on public.tenk1 t +-----------------------------------------------------------------------------------------------------------------------... + Hash Join Output: t.unique1, t.unique2, t.two, t.four, t.ten, t.twenty, t.hundred, t.thousand, t.twothousand, t.fivethous, t.t... - Filter: (SubPlan 1) - SubPlan 1 - -> Hash Join - Output: t.two - Hash Cond: (tenk1.stringu1 = t3.stringu1) - -> Seq Scan on public.tenk1 - Output: tenk1.unique1, tenk1.unique2, tenk1.two, tenk1.four, tenk1.ten, tenk1.twenty, tenk1.hundred, t... - Filter: (tenk1.four = t.four) ... |
macOS - Ventura - Meson | |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/select_parallel.out /Users/admin/pgsql/build/testrun/pg_upgrade/00... --- /Users/admin/pgsql/src/test/regress/expected/select_parallel.out 2024-05-03 18:09:57 +++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2024-05-03 18:12:05 @@ -451,26 +451,36 @@ join tenk1 t3 on t3.stringu1 = tenk1.stringu1 where tenk1.four = t.four ); - ... ------------------------------------------------------------------------------------------------------------------------... - Seq Scan on public.tenk1 t + ... +-----------------------------------------------------------------------------------------------------------------------... + Hash Join Output: t.unique1, t.unique2, t.two, t.four, t.ten, t.twenty, t.hundred, t.thousand, t.twothousand, t.fivethous, t.t... - Filter: (SubPlan 1) - SubPlan 1 - -> Hash Join - Output: t.two - Hash Cond: (tenk1.stringu1 = t3.stringu1) - -> Seq Scan on public.tenk1 ... |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/select_parallel.out /Users/admin/pgsql/build/testrun/recovery/027_... --- /Users/admin/pgsql/src/test/regress/expected/select_parallel.out 2024-05-03 18:09:57 +++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2024-05-03 18:13:13 @@ -451,26 +451,36 @@ join tenk1 t3 on t3.stringu1 = tenk1.stringu1 where tenk1.four = t.four ); - ... ------------------------------------------------------------------------------------------------------------------------... - Seq Scan on public.tenk1 t + ... +-----------------------------------------------------------------------------------------------------------------------... + Hash Join Output: t.unique1, t.unique2, t.two, t.four, t.ten, t.twenty, t.hundred, t.thousand, t.twothousand, t.fivethous, t.t... - Filter: (SubPlan 1) - SubPlan 1 - -> Hash Join - Output: t.two - Hash Cond: (tenk1.stringu1 = t3.stringu1) - -> Seq Scan on public.tenk1 ... |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/select_parallel.out /Users/admin/pgsql/build/testrun/regress/regre... --- /Users/admin/pgsql/src/test/regress/expected/select_parallel.out 2024-05-03 18:09:57 +++ /Users/admin/pgsql/build/testrun/regress/regress/results/select_parallel.out 2024-05-03 18:12:06 @@ -451,26 +451,36 @@ join tenk1 t3 on t3.stringu1 = tenk1.stringu1 where tenk1.four = t.four ); - ... ------------------------------------------------------------------------------------------------------------------------... - Seq Scan on public.tenk1 t + ... +-----------------------------------------------------------------------------------------------------------------------... + Hash Join Output: t.unique1, t.unique2, t.two, t.four, t.ten, t.twenty, t.hundred, t.thousand, t.twothousand, t.fivethous, t.t... - Filter: (SubPlan 1) - SubPlan 1 - -> Hash Join - Output: t.two - Hash Cond: (tenk1.stringu1 = t3.stringu1) - -> Seq Scan on public.tenk1 ... |
48/4929 | apply_scanjoin_target_to_paths and partitionwise join |
FreeBSD - 13 - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade... --- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-05-03 14:02:23.317372000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_join.out 2024-05-03 14:03:58.617... @@ -5133,17 +5133,15 @@ QUERY PLAN ----------------------------------------------------------------------- Limit - -> Merge Append - Sort Key: x.id - -> Merge Left Join - Merge Cond: (x_1.id = y_1.id) + -> Merge Left Join + Merge Cond: (x.id = y.id) + -> Append -> Index Only Scan using fract_t0_pkey on fract_t0 x_1 - -> Index Only Scan using fract_t0_pkey on fract_t0 y_1 - -> Merge Left Join - Merge Cond: (x_2.id = y_2.id) -> Index Only Scan using fract_t1_pkey on fract_t1 x_2 + -> Append ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/build/testrun/recovery/0... --- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-05-03 14:02:23.317372000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/partition_join.out 2024-05-03 14:04:27.7... @@ -5133,17 +5133,15 @@ QUERY PLAN ----------------------------------------------------------------------- Limit - -> Merge Append - Sort Key: x.id - -> Merge Left Join - Merge Cond: (x_1.id = y_1.id) + -> Merge Left Join + Merge Cond: (x.id = y.id) + -> Append -> Index Only Scan using fract_t0_pkey on fract_t0 x_1 - -> Index Only Scan using fract_t0_pkey on fract_t0 y_1 - -> Merge Left Join - Merge Cond: (x_2.id = y_2.id) -> Index Only Scan using fract_t1_pkey on fract_t1 x_2 + -> Append ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/build/testrun/regress/re... --- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-05-03 14:02:23.317372000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/partition_join.out 2024-05-03 14:03:52.680121000 +0000 @@ -5133,17 +5133,15 @@ QUERY PLAN ----------------------------------------------------------------------- Limit - -> Merge Append - Sort Key: x.id - -> Merge Left Join - Merge Cond: (x_1.id = y_1.id) + -> Merge Left Join + Merge Cond: (x.id = y.id) + -> Append -> Index Only Scan using fract_t0_pkey on fract_t0 x_1 - -> Index Only Scan using fract_t0_pkey on fract_t0 y_1 - -> Merge Left Join - Merge Cond: (x_2.id = y_2.id) -> Index Only Scan using fract_t1_pkey on fract_t1 x_2 + -> Append ... |
Linux - Debian Bullseye - Autoconf | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_c... --- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-05-03 14:02:15.941312174 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/partition_join.out 2024-05-03 14:06:05.425316625 +0000 @@ -5133,17 +5133,15 @@ QUERY PLAN ----------------------------------------------------------------------- Limit - -> Merge Append - Sort Key: x.id - -> Merge Left Join - Merge Cond: (x_1.id = y_1.id) + -> Merge Left Join + Merge Cond: (x.id = y.id) + -> Append -> Index Only Scan using fract_t0_pkey on fract_t0 x_1 - -> Index Only Scan using fract_t0_pkey on fract_t0 y_1 - -> Merge Left Join - Merge Cond: (x_2.id = y_2.id) -> Index Only Scan using fract_t1_pkey on fract_t1 x_2 + -> Append ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/src/test/recovery/tmp_ch... --- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-05-03 14:02:15.941312174 +0000 +++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/partition_join.out 2024-05-03 14:07:12.041314115 +0000 @@ -5133,17 +5133,15 @@ QUERY PLAN ----------------------------------------------------------------------- Limit - -> Merge Append - Sort Key: x.id - -> Merge Left Join - Merge Cond: (x_1.id = y_1.id) + -> Merge Left Join + Merge Cond: (x.id = y.id) + -> Append -> Index Only Scan using fract_t0_pkey on fract_t0 x_1 - -> Index Only Scan using fract_t0_pkey on fract_t0 y_1 - -> Merge Left Join - Merge Cond: (x_2.id = y_2.id) -> Index Only Scan using fract_t1_pkey on fract_t1 x_2 + -> Append ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/src/test/regress/results... --- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-05-03 14:02:15.941312174 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/partition_join.out 2024-05-03 14:04:35.873340446 +0000 @@ -5133,17 +5133,15 @@ QUERY PLAN ----------------------------------------------------------------------- Limit - -> Merge Append - Sort Key: x.id - -> Merge Left Join - Merge Cond: (x_1.id = y_1.id) + -> Merge Left Join + Merge Cond: (x.id = y.id) + -> Append -> Index Only Scan using fract_t0_pkey on fract_t0 x_1 - -> Index Only Scan using fract_t0_pkey on fract_t0 y_1 - -> Merge Left Join - Merge Cond: (x_2.id = y_2.id) -> Index Only Scan using fract_t1_pkey on fract_t1 x_2 + -> Append ... |
Linux - Debian Bullseye - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade... --- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-05-03 14:02:16.062009864 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_join.out 2024-05-03 14:04:23.421... @@ -5133,17 +5133,15 @@ QUERY PLAN ----------------------------------------------------------------------- Limit - -> Merge Append - Sort Key: x.id - -> Merge Left Join - Merge Cond: (x_1.id = y_1.id) + -> Merge Left Join + Merge Cond: (x.id = y.id) + -> Append -> Index Only Scan using fract_t0_pkey on fract_t0 x_1 - -> Index Only Scan using fract_t0_pkey on fract_t0 y_1 - -> Merge Left Join - Merge Cond: (x_2.id = y_2.id) -> Index Only Scan using fract_t1_pkey on fract_t1 x_2 + -> Append ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/build/testrun/recovery/0... --- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-05-03 14:02:16.062009864 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/partition_join.out 2024-05-03 14:04:49.9... @@ -5133,17 +5133,15 @@ QUERY PLAN ----------------------------------------------------------------------- Limit - -> Merge Append - Sort Key: x.id - -> Merge Left Join - Merge Cond: (x_1.id = y_1.id) + -> Merge Left Join + Merge Cond: (x.id = y.id) + -> Append -> Index Only Scan using fract_t0_pkey on fract_t0 x_1 - -> Index Only Scan using fract_t0_pkey on fract_t0 y_1 - -> Merge Left Join - Merge Cond: (x_2.id = y_2.id) -> Index Only Scan using fract_t1_pkey on fract_t1 x_2 + -> Append ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/build/testrun/regress/re... --- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-05-03 14:02:16.062009864 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/partition_join.out 2024-05-03 14:04:18.721996980 +0000 @@ -5133,17 +5133,15 @@ QUERY PLAN ----------------------------------------------------------------------- Limit - -> Merge Append - Sort Key: x.id - -> Merge Left Join - Merge Cond: (x_1.id = y_1.id) + -> Merge Left Join + Merge Cond: (x.id = y.id) + -> Append -> Index Only Scan using fract_t0_pkey on fract_t0 x_1 - -> Index Only Scan using fract_t0_pkey on fract_t0 y_1 - -> Merge Left Join - Merge Cond: (x_2.id = y_2.id) -> Index Only Scan using fract_t1_pkey on fract_t1 x_2 + -> Append ... |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/partition_join.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/dat... --- C:/cirrus/src/test/regress/expected/partition_join.out 2024-05-03 14:02:34.464214900 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_join.out 2024-05-03 14:06:23.917031900 +000... @@ -5133,17 +5133,15 @@ QUERY PLAN ----------------------------------------------------------------------- Limit - -> Merge Append - Sort Key: x.id -> Merge Left Join - Merge Cond: (x_1.id = y_1.id) + Merge Cond: (x.id = y.id) + -> Append -> Index Only Scan using fract_t0_pkey on fract_t0 x_1 - -> Index Only Scan using fract_t0_pkey on fract_t0 y_1 - -> Merge Left Join - Merge Cond: (x_2.id = y_2.id) -> Index Only Scan using fract_t1_pkey on fract_t1 x_2 + -> Append + -> Index Only Scan using fract_t0_pkey on fract_t0 y_1 ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/partition_join.out C:/cirrus/build/testrun/recovery/027_stream_regress/d... --- C:/cirrus/src/test/regress/expected/partition_join.out 2024-05-03 14:02:34.464214900 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/partition_join.out 2024-05-03 14:08:57.381871000 +0... @@ -5133,17 +5133,15 @@ QUERY PLAN ----------------------------------------------------------------------- Limit - -> Merge Append - Sort Key: x.id -> Merge Left Join - Merge Cond: (x_1.id = y_1.id) + Merge Cond: (x.id = y.id) + -> Append -> Index Only Scan using fract_t0_pkey on fract_t0 x_1 - -> Index Only Scan using fract_t0_pkey on fract_t0 y_1 - -> Merge Left Join - Merge Cond: (x_2.id = y_2.id) -> Index Only Scan using fract_t1_pkey on fract_t1 x_2 + -> Append + -> Index Only Scan using fract_t0_pkey on fract_t0 y_1 ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/partition_join.out C:/cirrus/build/testrun/regress/regress/results/parti... --- C:/cirrus/src/test/regress/expected/partition_join.out 2024-05-03 14:02:34.464214900 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/partition_join.out 2024-05-03 14:06:15.918991400 +0000 @@ -5133,17 +5133,15 @@ QUERY PLAN ----------------------------------------------------------------------- Limit - -> Merge Append - Sort Key: x.id -> Merge Left Join - Merge Cond: (x_1.id = y_1.id) + Merge Cond: (x.id = y.id) + -> Append -> Index Only Scan using fract_t0_pkey on fract_t0 x_1 - -> Index Only Scan using fract_t0_pkey on fract_t0 y_1 - -> Merge Left Join - Merge Cond: (x_2.id = y_2.id) -> Index Only Scan using fract_t1_pkey on fract_t1 x_2 + -> Append + -> Index Only Scan using fract_t0_pkey on fract_t0 y_1 ... |
macOS - Ventura - Meson | |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/partition_join.out /Users/admin/pgsql/build/testrun/pg_upgrade/002... --- /Users/admin/pgsql/src/test/regress/expected/partition_join.out 2024-05-03 14:02:18 +++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_join.out 2024-05-03 14:04:54 @@ -5133,17 +5133,15 @@ QUERY PLAN ----------------------------------------------------------------------- Limit - -> Merge Append - Sort Key: x.id - -> Merge Left Join - Merge Cond: (x_1.id = y_1.id) + -> Merge Left Join + Merge Cond: (x.id = y.id) + -> Append -> Index Only Scan using fract_t0_pkey on fract_t0 x_1 - -> Index Only Scan using fract_t0_pkey on fract_t0 y_1 - -> Merge Left Join - Merge Cond: (x_2.id = y_2.id) -> Index Only Scan using fract_t1_pkey on fract_t1 x_2 + -> Append ... |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/partition_join.out /Users/admin/pgsql/build/testrun/recovery/027_s... --- /Users/admin/pgsql/src/test/regress/expected/partition_join.out 2024-05-03 14:02:18 +++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/partition_join.out 2024-05-03 14:05:58 @@ -5133,17 +5133,15 @@ QUERY PLAN ----------------------------------------------------------------------- Limit - -> Merge Append - Sort Key: x.id - -> Merge Left Join - Merge Cond: (x_1.id = y_1.id) + -> Merge Left Join + Merge Cond: (x.id = y.id) + -> Append -> Index Only Scan using fract_t0_pkey on fract_t0 x_1 - -> Index Only Scan using fract_t0_pkey on fract_t0 y_1 - -> Merge Left Join - Merge Cond: (x_2.id = y_2.id) -> Index Only Scan using fract_t1_pkey on fract_t1 x_2 + -> Append ... |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/partition_join.out /Users/admin/pgsql/build/testrun/regress/regres... --- /Users/admin/pgsql/src/test/regress/expected/partition_join.out 2024-05-03 14:02:18 +++ /Users/admin/pgsql/build/testrun/regress/regress/results/partition_join.out 2024-05-03 14:04:54 @@ -5133,17 +5133,15 @@ QUERY PLAN ----------------------------------------------------------------------- Limit - -> Merge Append - Sort Key: x.id - -> Merge Left Join - Merge Cond: (x_1.id = y_1.id) + -> Merge Left Join + Merge Cond: (x.id = y.id) + -> Append -> Index Only Scan using fract_t0_pkey on fract_t0 x_1 - -> Index Only Scan using fract_t0_pkey on fract_t0 y_1 - -> Merge Left Join - Merge Cond: (x_2.id = y_2.id) -> Index Only Scan using fract_t1_pkey on fract_t1 x_2 + -> Append ... |
48/4766 | data loss bug in initial sync of logical replication |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 13:07:06.257962600 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/compression.out 2024-05-03 13:10:50.205338300 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/recovery/027_stream_regress/da... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 13:07:06.257962600 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/compression.out 2024-05-03 13:13:00.351329700 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/regress/regress/results/compre... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 13:07:06.257962600 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/compression.out 2024-05-03 13:10:43.366943400 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
48/4964 | Reduce the log spam by excluding certain SQLSTATEs |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 13:04:24.930899300 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/compression.out 2024-05-03 13:08:24.826397700 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/recovery/027_stream_regress/da... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 13:04:24.930899300 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/compression.out 2024-05-03 13:10:44.254125600 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/regress/regress/results/compre... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 13:04:24.930899300 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/compression.out 2024-05-03 13:08:20.318587400 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
48/4319 | Avoid unnecessary PlaceHolderVars for simple Vars |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 13:00:56.797252400 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/compression.out 2024-05-03 13:04:44.523974600 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/recovery/027_stream_regress/da... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 13:00:56.797252400 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/compression.out 2024-05-03 13:06:44.458057100 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/regress/regress/results/compre... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 13:00:56.797252400 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/compression.out 2024-05-03 13:04:29.816458900 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
48/4915 | Remove support for OpenSSL older than 1.1.1 |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 12:50:57.421326300 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/compression.out 2024-05-03 12:54:51.092563800 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/recovery/027_stream_regress/da... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 12:50:57.421326300 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/compression.out 2024-05-03 12:57:24.386450700 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/regress/regress/results/compre... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 12:50:57.421326300 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/compression.out 2024-05-03 12:54:43.154097300 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
48/4924 | add multiple client certificate selection feature |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 12:36:26.026916500 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/compression.out 2024-05-03 12:40:02.599744000 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/recovery/027_stream_regress/da... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 12:36:26.026916500 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/compression.out 2024-05-03 12:42:13.715942300 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/regress/regress/results/compre... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 12:36:26.026916500 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/compression.out 2024-05-03 12:39:56.781390000 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
48/4908 | Recheck foreign key if a referenced collation was nondeterministic |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 12:07:24.649401200 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/compression.out 2024-05-03 12:11:17.883605400 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/recovery/027_stream_regress/da... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 12:07:24.649401200 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/compression.out 2024-05-03 12:13:30.947992500 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/regress/regress/results/compre... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 12:07:24.649401200 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/compression.out 2024-05-03 12:11:02.918773000 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
48/4355 | Add last_commit_lsn to pg_stat_database |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 12:05:16.847101400 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/compression.out 2024-05-03 12:08:58.297418400 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/recovery/027_stream_regress/da... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 12:05:16.847101400 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/compression.out 2024-05-03 12:11:06.661671600 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/regress/regress/results/compre... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 12:05:16.847101400 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/compression.out 2024-05-03 12:08:53.010307800 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
48/4886 | CREATE DATABASE ... STRATEGY=FILE_CLONE |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 12:01:05.321115000 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/compression.out 2024-05-03 12:04:49.378645000 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/recovery/027_stream_regress/da... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 12:01:05.321115000 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/compression.out 2024-05-03 12:07:15.266823400 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/regress/regress/results/compre... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 12:01:05.321115000 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/compression.out 2024-05-03 12:04:43.258530100 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
48/4285 | Revise get_cheapest_parallel_safe_total_inner |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 11:36:17.079763600 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/compression.out 2024-05-03 11:39:36.083459300 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/recovery/027_stream_regress/da... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 11:36:17.079763600 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/compression.out 2024-05-03 11:41:52.587789600 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/regress/regress/results/compre... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 11:36:17.079763600 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/compression.out 2024-05-03 11:39:31.013145000 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
48/3482 | warn if GUC set to an invalid shared library |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 11:06:38.763066200 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/compression.out 2024-05-03 11:10:18.307989200 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/recovery/027_stream_regress/da... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 11:06:38.763066200 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/compression.out 2024-05-03 11:12:25.261542700 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/regress/regress/results/compre... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 11:06:38.763066200 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/compression.out 2024-05-03 11:10:06.699598400 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
48/4920 | Require LLVM 14+ in PostgreSQL 18 |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 11:03:58.257093500 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/compression.out 2024-05-03 11:07:31.222956400 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/recovery/027_stream_regress/da... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 11:03:58.257093500 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/compression.out 2024-05-03 11:09:38.048096600 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/regress/regress/results/compre... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 11:03:58.257093500 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/compression.out 2024-05-03 11:07:19.189268700 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
48/4751 | Remove useless GROUP BY columns considering unique index |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 10:59:58.640108100 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/compression.out 2024-05-03 11:03:32.930483400 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/recovery/027_stream_regress/da... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 10:59:58.640108100 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/compression.out 2024-05-03 11:05:32.864065100 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/regress/regress/results/compre... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 10:59:58.640108100 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/compression.out 2024-05-03 11:03:27.187814500 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
48/4744 | change regexp_substr first argument make tests more easier to understand |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 10:49:01.914737000 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/compression.out 2024-05-03 10:52:44.006847000 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/recovery/027_stream_regress/da... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 10:49:01.914737000 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/compression.out 2024-05-03 10:54:55.298804000 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/regress/regress/results/compre... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 10:49:01.914737000 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/compression.out 2024-05-03 10:52:36.960977100 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
48/4750 | Not to invalidate CatalogSnapshot for local invalidation messages |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 10:35:03.180833600 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/compression.out 2024-05-03 10:38:36.786797400 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/recovery/027_stream_regress/da... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 10:35:03.180833600 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/compression.out 2024-05-03 10:40:43.525899100 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/regress/regress/results/compre... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 10:35:03.180833600 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/compression.out 2024-05-03 10:38:31.063665100 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
48/4928 | s/shm_mq_iovec/struct iovec/ |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 10:04:06.940259300 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/compression.out 2024-05-03 10:07:47.780463500 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/recovery/027_stream_regress/da... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 10:04:06.940259300 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/compression.out 2024-05-03 10:10:05.185307000 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/regress/regress/results/compre... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 10:04:06.940259300 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/compression.out 2024-05-03 10:07:32.349794600 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
48/4646 | Mark search_path as GUC_REPORT |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 09:34:59.835414300 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/compression.out 2024-05-03 09:38:26.220048900 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/recovery/027_stream_regress/da... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 09:34:59.835414300 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/compression.out 2024-05-03 09:40:26.655532800 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/compression_1.out C:/cirrus/build/testrun/regress/regress/results/compre... --- C:/cirrus/src/test/regress/expected/compression_1.out 2024-05-03 09:34:59.835414300 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/compression.out 2024-05-03 09:38:19.700515000 +0000 @@ -216,13 +216,16 @@ ----------------------- (0 rows) --- test compression with inheritance, error -CREATE TABLE cminh() INHERITS(cmdata, cmdata1); +-- test compression with inheritance +CREATE TABLE cminh() INHERITS(cmdata, cmdata1); -- error ERROR: relation "cmdata1" does not exist -CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); +CREATE TABLE cminh(f1 TEXT COMPRESSION lz4) INHERITS(cmdata); -- error NOTICE: merging column "f1" with inherited definition ERROR: column "f1" has a compression method conflict DETAIL: pglz versus lz4 +CREATE TABLE cmdata3(f1 text); +CREATE TABLE cminh() INHERITS (cmdata, cmdata3); +NOTICE: merging multiple inherited definitions of column "f1" ... |
48/4951 | teach pg_combinebackup to detect deleted files where possible |
FreeBSD - 13 - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/timeouts.out /tmp/cirrus-ci-build/build/testrun/isolation/isol... --- /tmp/cirrus-ci-build/src/test/isolation/expected/timeouts.out 2024-05-03 08:47:52.620707000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/timeouts.out 2024-05-03 08:49:32.292986000 +0000 @@ -57,7 +57,7 @@ step sto: SET statement_timeout = '10ms'; step update: DELETE FROM accounts WHERE accountid = 'checking'; <waiting ...> step update: <... completed> -ERROR: canceling statement due to statement timeout +ERROR: canceling statement due to user request starting permutation: wrtbl lto update step wrtbl: UPDATE accounts SET balance = balance + 100; |
48/4720 | "unexpected duplicate for tablespace" problem in logical replication |
FreeBSD - 13 - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00... --- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-05-03 06:45:51.119846000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/alter_table.out 2024-05-03 06:47:27.382899... @@ -3476,9 +3476,20 @@ WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid; SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL; - oid | mapped_oid | reltablespace | relfilenode | relname ------+------------+---------------+-------------+--------- -(0 rows) + oid | mapped_oid | reltablespace | relfilenode | relname +-------+------------+---------------+-------------+---------------------- + 37844 | | 0 | 37844 | pktable_pkey + 37841 | | 0 | 37841 | pktable + 37846 | | 0 | 37846 | fktable + 38353 | | 0 | 38360 | foo + 38364 | | 0 | 38364 | pg_toast_38353_index + 38363 | | 0 | 38363 | pg_toast_38353 + 38591 | | 0 | 38591 | old_oids + 38611 | | 0 | 38611 | pg_toast_38608 ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/build/testrun/recovery/027_... --- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-05-03 06:45:51.119846000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/alter_table.out 2024-05-03 06:47:56.4853... @@ -3476,9 +3476,20 @@ WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid; SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL; - oid | mapped_oid | reltablespace | relfilenode | relname ------+------------+---------------+-------------+--------- -(0 rows) + oid | mapped_oid | reltablespace | relfilenode | relname +-------+------------+---------------+-------------+---------------------- + 37676 | | 0 | 37676 | pktable_pkey + 37673 | | 0 | 37673 | pktable + 37686 | | 0 | 37686 | fktable + 38322 | | 0 | 38327 | foo + 38331 | | 0 | 38331 | pg_toast_38322_index + 38330 | | 0 | 38330 | pg_toast_38322 + 38549 | | 0 | 38549 | old_oids + 38580 | | 0 | 38580 | pg_toast_38577 ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/build/testrun/regress/regre... --- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-05-03 06:45:51.119846000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/alter_table.out 2024-05-03 06:47:21.978843000 +0000 @@ -3476,9 +3476,20 @@ WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid; SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL; - oid | mapped_oid | reltablespace | relfilenode | relname ------+------------+---------------+-------------+--------- -(0 rows) + oid | mapped_oid | reltablespace | relfilenode | relname +-------+------------+---------------+-------------+---------------------- + 37877 | | 0 | 37877 | pktable_pkey + 37874 | | 0 | 37874 | pktable + 37879 | | 0 | 37879 | fktable + 38375 | | 0 | 38380 | foo + 38384 | | 0 | 38384 | pg_toast_38375_index + 38383 | | 0 | 38383 | pg_toast_38375 + 38597 | | 0 | 38597 | old_oids + 38615 | | 0 | 38615 | pg_toast_38612 ... |
Linux - Debian Bullseye - Autoconf | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_chec... --- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-05-03 06:45:40.773385309 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/alter_table.out 2024-05-03 06:49:31.361259993 +0000 @@ -3476,9 +3476,29 @@ WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid; SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL; - oid | mapped_oid | reltablespace | relfilenode | relname ------+------------+---------------+-------------+--------- -(0 rows) + oid | mapped_oid | reltablespace | relfilenode | relname +-------+------------+---------------+-------------+---------------------- + 37994 | | 0 | 37994 | users_id_seq + 38000 | | 0 | 38000 | pg_toast_37995 + 38001 | | 0 | 38001 | pg_toast_37995_index + 37995 | | 0 | 37995 | users + 38251 | | 0 | 38251 | foo + 37807 | | 0 | 37807 | pktable_pkey + 37804 | | 0 | 37804 | pktable + 37810 | | 0 | 37810 | fktable ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check... --- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-05-03 06:45:40.773385309 +0000 +++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/alter_table.out 2024-05-03 06:50:48.205180967 +0000 @@ -3476,9 +3476,20 @@ WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid; SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL; - oid | mapped_oid | reltablespace | relfilenode | relname ------+------------+---------------+-------------+--------- -(0 rows) + oid | mapped_oid | reltablespace | relfilenode | relname +-------+------------+---------------+-------------+---------------------- + 37863 | | 0 | 37863 | pktable_pkey + 37860 | | 0 | 37860 | pktable + 37865 | | 0 | 37865 | fktable + 38412 | | 0 | 38417 | foo + 38422 | | 0 | 38422 | pg_toast_38412_index + 38420 | | 0 | 38420 | pg_toast_38412 + 38639 | | 0 | 38639 | old_oids + 38667 | | 0 | 38667 | pg_toast_38664 ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/src/test/regress/results/al... --- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-05-03 06:45:40.773385309 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/alter_table.out 2024-05-03 06:48:06.273358616 +0000 @@ -3476,9 +3476,20 @@ WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid; SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL; - oid | mapped_oid | reltablespace | relfilenode | relname ------+------------+---------------+-------------+--------- -(0 rows) + oid | mapped_oid | reltablespace | relfilenode | relname +-------+------------+---------------+-------------+---------------------- + 37970 | | 0 | 37970 | pktable_pkey + 37967 | | 0 | 37967 | pktable + 37972 | | 0 | 37972 | fktable + 38476 | | 0 | 38481 | foo + 38485 | | 0 | 38485 | pg_toast_38476_index + 38484 | | 0 | 38484 | pg_toast_38476 + 38685 | | 0 | 38685 | old_oids + 38702 | | 0 | 38702 | pg_toast_38699 ... |
Linux - Debian Bullseye - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00... --- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-05-03 06:45:41.361178110 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/alter_table.out 2024-05-03 06:47:51.709161... @@ -3476,9 +3476,29 @@ WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid; SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL; - oid | mapped_oid | reltablespace | relfilenode | relname ------+------------+---------------+-------------+--------- -(0 rows) + oid | mapped_oid | reltablespace | relfilenode | relname +-------+------------+---------------+-------------+---------------------- + 37986 | | 0 | 37986 | users_id_seq + 37992 | | 0 | 37992 | pg_toast_37987 + 37993 | | 0 | 37993 | pg_toast_37987_index + 37987 | | 0 | 37987 | users + 38217 | | 0 | 38217 | foo + 38567 | | 0 | 38567 | forc_test + 38994 | | 0 | 38994 | pg_toast_38991 + 38995 | | 0 | 38995 | pg_toast_38991_index ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/build/testrun/recovery/027_... --- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-05-03 06:45:41.361178110 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/alter_table.out 2024-05-03 06:48:19.0451... @@ -3476,9 +3476,29 @@ WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid; SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL; - oid | mapped_oid | reltablespace | relfilenode | relname ------+------------+---------------+-------------+--------- -(0 rows) + oid | mapped_oid | reltablespace | relfilenode | relname +-------+------------+---------------+-------------+---------------------- + 37975 | | 0 | 37975 | users_id_seq + 37985 | | 0 | 37985 | pg_toast_37979 + 37986 | | 0 | 37986 | pg_toast_37979_index + 37979 | | 0 | 37979 | users + 38316 | | 0 | 38316 | foo + 38522 | | 0 | 38522 | forc_test + 38940 | | 0 | 38940 | pg_toast_38937 + 38941 | | 0 | 38941 | pg_toast_38937_index ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/build/testrun/regress/regre... --- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-05-03 06:45:41.361178110 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/alter_table.out 2024-05-03 06:47:47.329166399 +0000 @@ -3476,9 +3476,29 @@ WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid; SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL; - oid | mapped_oid | reltablespace | relfilenode | relname ------+------------+---------------+-------------+--------- -(0 rows) + oid | mapped_oid | reltablespace | relfilenode | relname +-------+------------+---------------+-------------+---------------------- + 37982 | | 0 | 37982 | pg_toast_37976_index + 37976 | | 0 | 37976 | users + 38202 | | 0 | 38202 | foo + 37975 | | 0 | 37975 | users_id_seq + 37981 | | 0 | 37981 | pg_toast_37976 + 38518 | | 0 | 38518 | forc_test + 38916 | | 0 | 38916 | pg_toast_38913 + 38917 | | 0 | 38917 | pg_toast_38913_index ... |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/alter_table.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/r... --- C:/cirrus/src/test/regress/expected/alter_table.out 2024-05-03 06:46:03.610184300 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/alter_table.out 2024-05-03 06:49:55.473103200 +0000 @@ -3477,8 +3477,19 @@ SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL; oid | mapped_oid | reltablespace | relfilenode | relname ------+------------+---------------+-------------+--------- -(0 rows) +-------+------------+---------------+-------------+---------------------- + 37391 | | 0 | 37391 | pktable_pkey + 37386 | | 0 | 37386 | pktable + 37399 | | 0 | 37399 | fktable + 37975 | | 0 | 37980 | foo + 37984 | | 0 | 37984 | pg_toast_37975_index + 37983 | | 0 | 37983 | pg_toast_37975 + 38212 | | 0 | 38212 | old_oids + 38229 | | 0 | 38229 | pg_toast_38226 + 38230 | | 0 | 38230 | pg_toast_38226_index + 38226 | | 0 | 38226 | recur2 ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/alter_table.out C:/cirrus/build/testrun/recovery/027_stream_regress/data... --- C:/cirrus/src/test/regress/expected/alter_table.out 2024-05-03 06:46:03.610184300 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/alter_table.out 2024-05-03 06:52:02.806131500 +0000 @@ -3477,8 +3477,19 @@ SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL; oid | mapped_oid | reltablespace | relfilenode | relname ------+------------+---------------+-------------+--------- -(0 rows) +-------+------------+---------------+-------------+---------------------- + 37302 | | 0 | 37302 | pktable + 37327 | | 0 | 37327 | fktable + 37316 | | 0 | 37316 | pktable_pkey + 38126 | | 0 | 38136 | foo + 38140 | | 0 | 38140 | pg_toast_38126_index + 38139 | | 0 | 38139 | pg_toast_38126 + 38363 | | 0 | 38363 | old_oids + 38380 | | 0 | 38380 | pg_toast_38377 + 38381 | | 0 | 38381 | pg_toast_38377_index + 38377 | | 0 | 38377 | recur2 ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/alter_table.out C:/cirrus/build/testrun/regress/regress/results/alter_ta... --- C:/cirrus/src/test/regress/expected/alter_table.out 2024-05-03 06:46:03.610184300 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/alter_table.out 2024-05-03 06:49:42.743151300 +0000 @@ -3477,8 +3477,19 @@ SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL; oid | mapped_oid | reltablespace | relfilenode | relname ------+------------+---------------+-------------+--------- -(0 rows) +-------+------------+---------------+-------------+---------------------- + 37205 | | 0 | 37205 | pktable_pkey + 37202 | | 0 | 37202 | pktable + 37207 | | 0 | 37207 | fktable + 38066 | | 0 | 38071 | foo + 38075 | | 0 | 38075 | pg_toast_38066_index + 38074 | | 0 | 38074 | pg_toast_38066 + 38333 | | 0 | 38333 | pg_toast_38330 + 38334 | | 0 | 38334 | pg_toast_38330_index + 38330 | | 0 | 38330 | recur2 + 38324 | | 0 | 38324 | recur1 ... |
macOS - Ventura - Meson | |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/alter_table.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg... --- /Users/admin/pgsql/src/test/regress/expected/alter_table.out 2024-05-03 06:45:37 +++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/alter_table.out 2024-05-03 06:47:56 @@ -3476,9 +3476,20 @@ WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid; SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL; - oid | mapped_oid | reltablespace | relfilenode | relname ------+------------+---------------+-------------+--------- -(0 rows) + oid | mapped_oid | reltablespace | relfilenode | relname +-------+------------+---------------+-------------+---------------------- + 37819 | | 0 | 37819 | pktable_pkey + 37816 | | 0 | 37816 | pktable + 37821 | | 0 | 37821 | fktable + 38397 | | 0 | 38402 | foo + 38406 | | 0 | 38406 | pg_toast_38397_index + 38405 | | 0 | 38405 | pg_toast_38397 + 38709 | | 0 | 38709 | old_oids + 38726 | | 0 | 38726 | pg_toast_38723 ... |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/alter_table.out /Users/admin/pgsql/build/testrun/recovery/027_stre... --- /Users/admin/pgsql/src/test/regress/expected/alter_table.out 2024-05-03 06:45:37 +++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/alter_table.out 2024-05-03 06:49:38 @@ -3476,9 +3476,20 @@ WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid; SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL; - oid | mapped_oid | reltablespace | relfilenode | relname ------+------------+---------------+-------------+--------- -(0 rows) + oid | mapped_oid | reltablespace | relfilenode | relname +-------+------------+---------------+-------------+---------------------- + 37642 | | 0 | 37642 | pktable_pkey + 37639 | | 0 | 37639 | pktable + 37644 | | 0 | 37644 | fktable + 38327 | | 0 | 38333 | foo + 38337 | | 0 | 38337 | pg_toast_38327_index + 38336 | | 0 | 38336 | pg_toast_38327 + 38561 | | 0 | 38561 | old_oids + 38600 | | 0 | 38600 | pg_toast_38595 ... |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/alter_table.out /Users/admin/pgsql/build/testrun/regress/regress/r... --- /Users/admin/pgsql/src/test/regress/expected/alter_table.out 2024-05-03 06:45:37 +++ /Users/admin/pgsql/build/testrun/regress/regress/results/alter_table.out 2024-05-03 06:47:54 @@ -3476,9 +3476,20 @@ WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid; SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL; - oid | mapped_oid | reltablespace | relfilenode | relname ------+------------+---------------+-------------+--------- -(0 rows) + oid | mapped_oid | reltablespace | relfilenode | relname +-------+------------+---------------+-------------+---------------------- + 37732 | | 0 | 37732 | pktable_pkey + 37729 | | 0 | 37729 | pktable + 37735 | | 0 | 37735 | fktable + 38465 | | 0 | 38465 | pg_toast_38456_index + 38464 | | 0 | 38464 | pg_toast_38456 + 38456 | | 0 | 38461 | foo + 38688 | | 0 | 38688 | old_oids + 38705 | | 0 | 38705 | pg_toast_38702 ... |
48/4308 | SQL:2011 application time |
FreeBSD - 13 - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/contrib/btree_gist/expected/without_overlaps.out /tmp/cirrus-ci-build/build/testrun/btree_... --- /tmp/cirrus-ci-build/contrib/btree_gist/expected/without_overlaps.out 2024-05-02 14:50:56.118636000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/without_overlaps.out 2024-05-02 14:53:20.594504000 +00... @@ -16,6 +16,8 @@ valid_at | daterange | | not null | Indexes: "temporal_rng_pk" PRIMARY KEY (id, valid_at WITHOUT OVERLAPS) +Check constraints: + "valid_at_not_empty" CHECK (NOT isempty(valid_at)) SELECT pg_get_constraintdef(oid) FROM pg_constraint WHERE conname = 'temporal_rng_pk'; pg_get_constraintdef @@ -60,6 +62,8 @@ parent_id | integer | | | Indexes: "temporal_fk_rng2rng_pk" PRIMARY KEY (id, valid_at WITHOUT OVERLAPS) +Check constraints: + "valid_at_not_empty" CHECK (NOT isempty(valid_at)) Foreign-key constraints: "temporal_fk_rng2rng_fk" FOREIGN KEY (parent_id, PERIOD valid_at) REFERENCES temporal_rng(id, PERIOD valid_at) ... |
Linux - Debian Bullseye - Autoconf | |
regress | diff -U3 /tmp/cirrus-ci-build/contrib/btree_gist/expected/without_overlaps.out /tmp/cirrus-ci-build/contrib/btree_gist/r... --- /tmp/cirrus-ci-build/contrib/btree_gist/expected/without_overlaps.out 2024-05-02 14:50:47.072341588 +0000 +++ /tmp/cirrus-ci-build/contrib/btree_gist/results/without_overlaps.out 2024-05-02 14:54:15.696169329 +0000 @@ -16,6 +16,8 @@ valid_at | daterange | | not null | Indexes: "temporal_rng_pk" PRIMARY KEY (id, valid_at WITHOUT OVERLAPS) +Check constraints: + "valid_at_not_empty" CHECK (NOT isempty(valid_at)) SELECT pg_get_constraintdef(oid) FROM pg_constraint WHERE conname = 'temporal_rng_pk'; pg_get_constraintdef @@ -60,6 +62,8 @@ parent_id | integer | | | Indexes: "temporal_fk_rng2rng_pk" PRIMARY KEY (id, valid_at WITHOUT OVERLAPS) +Check constraints: + "valid_at_not_empty" CHECK (NOT isempty(valid_at)) Foreign-key constraints: "temporal_fk_rng2rng_fk" FOREIGN KEY (parent_id, PERIOD valid_at) REFERENCES temporal_rng(id, PERIOD valid_at) ... |
Linux - Debian Bullseye - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/contrib/btree_gist/expected/without_overlaps.out /tmp/cirrus-ci-build/build/testrun/btree_... --- /tmp/cirrus-ci-build/contrib/btree_gist/expected/without_overlaps.out 2024-05-02 14:51:02.643057761 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/without_overlaps.out 2024-05-02 14:55:15.134893733 +00... @@ -16,6 +16,8 @@ valid_at | daterange | | not null | Indexes: "temporal_rng_pk" PRIMARY KEY (id, valid_at WITHOUT OVERLAPS) +Check constraints: + "valid_at_not_empty" CHECK (NOT isempty(valid_at)) SELECT pg_get_constraintdef(oid) FROM pg_constraint WHERE conname = 'temporal_rng_pk'; pg_get_constraintdef @@ -60,6 +62,8 @@ parent_id | integer | | | Indexes: "temporal_fk_rng2rng_pk" PRIMARY KEY (id, valid_at WITHOUT OVERLAPS) +Check constraints: + "valid_at_not_empty" CHECK (NOT isempty(valid_at)) Foreign-key constraints: "temporal_fk_rng2rng_fk" FOREIGN KEY (parent_id, PERIOD valid_at) REFERENCES temporal_rng(id, PERIOD valid_at) ... |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff -w -U3 C:/cirrus/contrib/btree_gist/expected/without_overlaps.out C:/cirrus/build/testrun/btree_gist/regress/result... --- C:/cirrus/contrib/btree_gist/expected/without_overlaps.out 2024-05-02 14:51:07.421909200 +0000 +++ C:/cirrus/build/testrun/btree_gist/regress/results/without_overlaps.out 2024-05-02 14:57:14.017885600 +0000 @@ -16,6 +16,8 @@ valid_at | daterange | | not null | Indexes: "temporal_rng_pk" PRIMARY KEY (id, valid_at WITHOUT OVERLAPS) +Check constraints: + "valid_at_not_empty" CHECK (NOT isempty(valid_at)) SELECT pg_get_constraintdef(oid) FROM pg_constraint WHERE conname = 'temporal_rng_pk'; pg_get_constraintdef @@ -60,6 +62,8 @@ parent_id | integer | | | Indexes: "temporal_fk_rng2rng_pk" PRIMARY KEY (id, valid_at WITHOUT OVERLAPS) +Check constraints: + "valid_at_not_empty" CHECK (NOT isempty(valid_at)) Foreign-key constraints: "temporal_fk_rng2rng_fk" FOREIGN KEY (parent_id, PERIOD valid_at) REFERENCES temporal_rng(id, PERIOD valid_at) ... |
macOS - Ventura - Meson | |
regress | diff -U3 /Users/admin/pgsql/contrib/btree_gist/expected/without_overlaps.out /Users/admin/pgsql/build/testrun/btree_gist... --- /Users/admin/pgsql/contrib/btree_gist/expected/without_overlaps.out 2024-05-02 14:50:15 +++ /Users/admin/pgsql/build/testrun/btree_gist/regress/results/without_overlaps.out 2024-05-02 14:53:30 @@ -16,6 +16,8 @@ valid_at | daterange | | not null | Indexes: "temporal_rng_pk" PRIMARY KEY (id, valid_at WITHOUT OVERLAPS) +Check constraints: + "valid_at_not_empty" CHECK (NOT isempty(valid_at)) SELECT pg_get_constraintdef(oid) FROM pg_constraint WHERE conname = 'temporal_rng_pk'; pg_get_constraintdef @@ -60,6 +62,8 @@ parent_id | integer | | | Indexes: "temporal_fk_rng2rng_pk" PRIMARY KEY (id, valid_at WITHOUT OVERLAPS) +Check constraints: + "valid_at_not_empty" CHECK (NOT isempty(valid_at)) Foreign-key constraints: "temporal_fk_rng2rng_fk" FOREIGN KEY (parent_id, PERIOD valid_at) REFERENCES temporal_rng(id, PERIOD valid_at) ... |
48/4759 | shared detoast datum |
FreeBSD - 13 - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p... --- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2024-05-02 13:06:14.770502000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2024-05-02 13:07:52.215687000... @@ -157,7 +157,8 @@ enable_seqscan | on enable_sort | on enable_tidscan | on -(23 rows) + enable_toast_cache | off +(24 rows) -- There are always wait event descriptions for various types. select type, count(*) > 0 as ok FROM pg_wait_events |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str... --- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2024-05-02 13:06:14.770502000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2024-05-02 13:08:25.2784890... @@ -157,7 +157,8 @@ enable_seqscan | on enable_sort | on enable_tidscan | on -(23 rows) + enable_toast_cache | off +(24 rows) -- There are always wait event descriptions for various types. select type, count(*) > 0 as ok FROM pg_wait_events |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/regress/regress/... --- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2024-05-02 13:06:14.770502000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/sysviews.out 2024-05-02 13:07:49.426469000 +0000 @@ -157,7 +157,8 @@ enable_seqscan | on enable_sort | on enable_tidscan | on -(23 rows) + enable_toast_cache | off +(24 rows) -- There are always wait event descriptions for various types. select type, count(*) > 0 as ok FROM pg_wait_events |
Linux - Debian Bullseye - Autoconf | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r... --- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2024-05-02 13:06:10.687394965 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/sysviews.out 2024-05-02 13:10:49.547374843 +0000 @@ -157,7 +157,8 @@ enable_seqscan | on enable_sort | on enable_tidscan | on -(23 rows) + enable_toast_cache | off +(24 rows) -- There are always wait event descriptions for various types. select type, count(*) > 0 as ok FROM pg_wait_events |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/src/test/regress/results/sysvi... --- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2024-05-02 13:06:10.687394965 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/sysviews.out 2024-05-02 13:09:25.915392474 +0000 @@ -157,7 +157,8 @@ enable_seqscan | on enable_sort | on enable_tidscan | on -(23 rows) + enable_toast_cache | off +(24 rows) -- There are always wait event descriptions for various types. select type, count(*) > 0 as ok FROM pg_wait_events |
Linux - Debian Bullseye - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p... --- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2024-05-02 13:06:06.556345535 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2024-05-02 13:09:46.040169772... @@ -157,7 +157,8 @@ enable_seqscan | on enable_sort | on enable_tidscan | on -(23 rows) + enable_toast_cache | off +(24 rows) -- There are always wait event descriptions for various types. select type, count(*) > 0 as ok FROM pg_wait_events |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str... --- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2024-05-02 13:06:06.556345535 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2024-05-02 13:10:23.1801270... @@ -157,7 +157,8 @@ enable_seqscan | on enable_sort | on enable_tidscan | on -(23 rows) + enable_toast_cache | off +(24 rows) -- There are always wait event descriptions for various types. select type, count(*) > 0 as ok FROM pg_wait_events |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out /tmp/cirrus-ci-build/build/testrun/regress/regress/... --- /tmp/cirrus-ci-build/src/test/regress/expected/sysviews.out 2024-05-02 13:06:06.556345535 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/sysviews.out 2024-05-02 13:09:44.068172003 +0000 @@ -157,7 +157,8 @@ enable_seqscan | on enable_sort | on enable_tidscan | on -(23 rows) + enable_toast_cache | off +(24 rows) -- There are always wait event descriptions for various types. select type, count(*) > 0 as ok FROM pg_wait_events |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/sysviews.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/resu... --- C:/cirrus/src/test/regress/expected/sysviews.out 2024-05-02 13:06:25.025111900 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2024-05-02 13:09:34.338549500 +0000 @@ -157,7 +157,8 @@ enable_seqscan | on enable_sort | on enable_tidscan | on -(23 rows) + enable_toast_cache | off +(24 rows) -- There are always wait event descriptions for various types. select type, count(*) > 0 as ok FROM pg_wait_events |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/sysviews.out C:/cirrus/build/testrun/recovery/027_stream_regress/data/re... --- C:/cirrus/src/test/regress/expected/sysviews.out 2024-05-02 13:06:25.025111900 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2024-05-02 13:11:38.675422700 +0000 @@ -157,7 +157,8 @@ enable_seqscan | on enable_sort | on enable_tidscan | on -(23 rows) + enable_toast_cache | off +(24 rows) -- There are always wait event descriptions for various types. select type, count(*) > 0 as ok FROM pg_wait_events |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/sysviews.out C:/cirrus/build/testrun/regress/regress/results/sysviews.ou... --- C:/cirrus/src/test/regress/expected/sysviews.out 2024-05-02 13:06:25.025111900 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/sysviews.out 2024-05-02 13:09:30.100755100 +0000 @@ -157,7 +157,8 @@ enable_seqscan | on enable_sort | on enable_tidscan | on -(23 rows) + enable_toast_cache | off +(24 rows) -- There are always wait event descriptions for various types. select type, count(*) > 0 as ok FROM pg_wait_events |
macOS - Ventura - Meson | |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/sysviews.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up... --- /Users/admin/pgsql/src/test/regress/expected/sysviews.out 2024-05-02 13:06:00 +++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2024-05-02 13:08:51 @@ -157,7 +157,8 @@ enable_seqscan | on enable_sort | on enable_tidscan | on -(23 rows) + enable_toast_cache | off +(24 rows) -- There are always wait event descriptions for various types. select type, count(*) > 0 as ok FROM pg_wait_events |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/sysviews.out /Users/admin/pgsql/build/testrun/recovery/027_stream_... --- /Users/admin/pgsql/src/test/regress/expected/sysviews.out 2024-05-02 13:06:00 +++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2024-05-02 13:09:32 @@ -157,7 +157,8 @@ enable_seqscan | on enable_sort | on enable_tidscan | on -(23 rows) + enable_toast_cache | off +(24 rows) -- There are always wait event descriptions for various types. select type, count(*) > 0 as ok FROM pg_wait_events |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/sysviews.out /Users/admin/pgsql/build/testrun/regress/regress/resu... --- /Users/admin/pgsql/src/test/regress/expected/sysviews.out 2024-05-02 13:06:00 +++ /Users/admin/pgsql/build/testrun/regress/regress/results/sysviews.out 2024-05-02 13:08:51 @@ -157,7 +157,8 @@ enable_seqscan | on enable_sort | on enable_tidscan | on -(23 rows) + enable_toast_cache | off +(24 rows) -- There are always wait event descriptions for various types. select type, count(*) > 0 as ok FROM pg_wait_events |
48/4617 | Allow INSTEAD OF DELETE triggers to modify the tuple for RETURNING |
FreeBSD - 13 - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00... --- /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out 2024-05-01 05:36:37.274368000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/constraints.out 2024-05-01 05:37:57.987776... @@ -1212,91 +1212,7 @@ "notnull_tbl4_lk2_pkey" PRIMARY KEY, btree (a) DEFERRABLE INITIALLY DEFERRED \d+ notnull_tbl4_lk3 - Table "public.notnull_tbl4_lk3" - Column | Type | Collation | Nullable | Default | Storage | Stats target | Description ---------+---------+-----------+----------+---------+---------+--------------+------------- - a | integer | | not null | | plain | | -Indexes: - "notnull_tbl4_lk3_pkey" PRIMARY KEY, btree (a) DEFERRABLE INITIALLY DEFERRED -Not-null constraints: - "a_nn" NOT NULL "a" - -\d+ notnull_tbl4_cld - Table "public.notnull_tbl4_cld" - Column | Type | Collation | Nullable | Default | Storage | Stats target | Description ---------+---------+-----------+----------+---------+---------+--------------+------------- ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out /tmp/cirrus-ci-build/build/testrun/recovery/027_... --- /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out 2024-05-01 05:36:37.274368000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/constraints.out 2024-05-01 05:38:19.4792... @@ -1184,119 +1184,10 @@ CREATE TABLE notnull_tbl4_cld () INHERITS (notnull_tbl4); CREATE TABLE notnull_tbl4_cld2 (PRIMARY KEY (a) DEFERRABLE) INHERITS (notnull_tbl4); CREATE TABLE notnull_tbl4_cld3 (PRIMARY KEY (a) DEFERRABLE, CONSTRAINT a_nn NOT NULL a) INHERITS (notnull_tbl4); -\d+ notnull_tbl4 - Table "public.notnull_tbl4" - Column | Type | Collation | Nullable | Default | Storage | Stats target | Description ---------+---------+-----------+----------+---------+---------+--------------+------------- - a | integer | | not null | | plain | | -Indexes: - "notnull_tbl4_pkey" PRIMARY KEY, btree (a) DEFERRABLE INITIALLY DEFERRED -Child tables: notnull_tbl4_cld, - notnull_tbl4_cld2, - notnull_tbl4_cld3 - -\d+ notnull_tbl4_lk - Table "public.notnull_tbl4_lk" ... |
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 2024-05-01 05:36:37.274368000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/constraints.out 2024-05-01 05:37:54.982730000 +0000 @@ -1231,72 +1231,10 @@ Inherits: notnull_tbl4 \d+ notnull_tbl4_cld2 - Table "public.notnull_tbl4_cld2" - Column | Type | Collation | Nullable | Default | Storage | Stats target | Description ---------+---------+-----------+----------+---------+---------+--------------+------------- - a | integer | | not null | | plain | | -Indexes: - "notnull_tbl4_cld2_pkey" PRIMARY KEY, btree (a) DEFERRABLE -Not-null constraints: - "notnull_tbl4_cld2_a_not_null" NOT NULL "a" (inherited) -Inherits: notnull_tbl4 - -\d+ notnull_tbl4_cld3 - Table "public.notnull_tbl4_cld3" - Column | Type | Collation | Nullable | Default | Storage | Stats target | Description ... |
Linux - Debian Bullseye - 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 2024-05-01 05:36:36.425303423 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/triggers.out 2024-05-01 05:39:37.917179121 +0000 @@ -2900,847 +2900,10 @@ ERROR: except CONTEXT: PL/pgSQL function tgf() line 1 at RAISE DROP TABLE trgfire; -DROP FUNCTION tgf(); --- --- Test the interaction between transition tables and both kinds of --- inheritance. We'll dump the contents of the transition tables in a --- format that shows the attribute order, so that we can distinguish --- tuple formats (though not dropped attributes). --- -create or replace function dump_insert() returns trigger language plpgsql as -$$ - begin - raise notice 'trigger = %, new table = %', - TG_NAME, - (select string_agg(new_table::text, ', ' order by a) from new_table); ... |
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 2024-05-01 05:36:36.425303423 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/triggers.out 2024-05-01 05:38:52.829215659 +0000 @@ -2960,787 +2960,10 @@ create trigger parent_delete_trig after delete on parent referencing old table as old_table for each statement execute procedure dump_delete(); -create trigger child1_insert_trig - after insert on child1 referencing new table as new_table - for each statement execute procedure dump_insert(); -create trigger child1_update_trig - after update on child1 referencing old table as old_table new table as new_table - for each statement execute procedure dump_update(); -create trigger child1_delete_trig - after delete on child1 referencing old table as old_table - for each statement execute procedure dump_delete(); -create trigger child2_insert_trig - after insert on child2 referencing new table as new_table - for each statement execute procedure dump_insert(); -create trigger child2_update_trig ... |
Linux - Debian Bullseye - 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 2024-05-01 05:36:37.182177527 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2024-05-01 05:39:20.713960624... @@ -2580,1167 +2580,10 @@ partition by range (b); create table parted_constr (a int, b text) partition by range (b); -alter table parted_constr_ancestor attach partition parted_constr - for values from ('aaaa') to ('zzzz'); -create table parted1_constr (a int, b text); -alter table parted_constr attach partition parted1_constr - for values from ('aaaa') to ('bbbb'); -create constraint trigger parted_trig after insert on parted_constr_ancestor - deferrable - for each row execute procedure trigger_notice_ab(); -create constraint trigger parted_trig_two after insert on parted_constr - deferrable initially deferred - for each row when (bark(new.b) AND new.a % 2 = 1) - execute procedure trigger_notice_ab(); --- The immediate constraint is fired immediately; the WHEN clause of the ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out /tmp/cirrus-ci-build/build/testrun/recovery/027_... --- /tmp/cirrus-ci-build/src/test/regress/expected/constraints.out 2024-05-01 05:36:37.102177560 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/constraints.out 2024-05-01 05:39:38.1219... @@ -934,369 +934,10 @@ -- make sure attnotnull is reset correctly when a PK is dropped indirectly, -- or kept if there's a reason for that CREATE TABLE notnull_tbl1 (c0 int, c1 int, PRIMARY KEY (c0, c1)); -ALTER TABLE notnull_tbl1 DROP c1; -\d+ notnull_tbl1 - Table "public.notnull_tbl1" - Column | Type | Collation | Nullable | Default | Storage | Stats target | Description ---------+---------+-----------+----------+---------+---------+--------------+------------- - c0 | integer | | | | plain | | - -DROP TABLE notnull_tbl1; --- same, via dropping a domain -CREATE DOMAIN notnull_dom1 AS INTEGER; -CREATE TABLE notnull_tbl1 (c0 notnull_dom1, c1 int, PRIMARY KEY (c0, c1)); -DROP DOMAIN notnull_dom1 CASCADE; -NOTICE: drop cascades to column c0 of table notnull_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 2024-05-01 05:36:37.182177527 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/triggers.out 2024-05-01 05:39:17.161965019 +0000 @@ -2187,1560 +2187,10 @@ create trigger samename after delete on trigpart execute function trigger_nothing(); create trigger samename after delete on trigpart1 execute function trigger_nothing(); \d trigpart1 - Table "public.trigpart1" - Column | Type | Collation | Nullable | Default ---------+---------+-----------+----------+--------- - a | integer | | | - b | integer | | | -Partition of: trigpart FOR VALUES FROM (0) TO (1000) -Triggers: - samename AFTER DELETE ON trigpart1 FOR EACH STATEMENT EXECUTE FUNCTION trigger_nothing() - trg1 AFTER INSERT ON trigpart1 FOR EACH ROW EXECUTE FUNCTION trigger_nothing(), ON TABLE trigpart - -drop table trigpart; -drop function trigger_nothing(); --- ... |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/updatable_views.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/da... --- C:/cirrus/src/test/regress/expected/updatable_views.out 2024-05-01 05:36:53.943774200 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/updatable_views.out 2024-05-01 05:39:26.369445100 +00... @@ -1155,2847 +1155,7 @@ WHEN MATCHED THEN UPDATE SET b = s.b WHEN NOT MATCHED AND s.a > 0 THEN INSERT VALUES (s.a, s.b) RETURNING merge_action(), s.*, t.*; - merge_action | a | b | a | b ---------------+---+----+---+------- - DELETE | 1 | R1 | 1 | Row 1 - UPDATE | 2 | R2 | 2 | R2 - INSERT | 3 | R3 | 3 | R3 -(3 rows) - -SELECT * FROM base_tbl ORDER BY a; - a | b -----+-------- - -2 | Row -2 - -1 | Row -1 - 0 | Row 0 ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/updatable_views.out C:/cirrus/build/testrun/recovery/027_stream_regress/... --- C:/cirrus/src/test/regress/expected/updatable_views.out 2024-05-01 05:36:53.943774200 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/updatable_views.out 2024-05-01 05:41:19.779219200 +... @@ -1155,2847 +1155,7 @@ WHEN MATCHED THEN UPDATE SET b = s.b WHEN NOT MATCHED AND s.a > 0 THEN INSERT VALUES (s.a, s.b) RETURNING merge_action(), s.*, t.*; - merge_action | a | b | a | b ---------------+---+----+---+------- - DELETE | 1 | R1 | 1 | Row 1 - UPDATE | 2 | R2 | 2 | R2 - INSERT | 3 | R3 | 3 | R3 -(3 rows) - -SELECT * FROM base_tbl ORDER BY a; - a | b -----+-------- - -2 | Row -2 - -1 | Row -1 - 0 | Row 0 ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/updatable_views.out C:/cirrus/build/testrun/regress/regress/results/upda... --- C:/cirrus/src/test/regress/expected/updatable_views.out 2024-05-01 05:36:53.943774200 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/updatable_views.out 2024-05-01 05:39:25.663873700 +0000 @@ -1155,2847 +1155,7 @@ WHEN MATCHED THEN UPDATE SET b = s.b WHEN NOT MATCHED AND s.a > 0 THEN INSERT VALUES (s.a, s.b) RETURNING merge_action(), s.*, t.*; - merge_action | a | b | a | b ---------------+---+----+---+------- - DELETE | 1 | R1 | 1 | Row 1 - UPDATE | 2 | R2 | 2 | R2 - INSERT | 3 | R3 | 3 | R3 -(3 rows) - -SELECT * FROM base_tbl ORDER BY a; - a | b -----+-------- - -2 | Row -2 - -1 | Row -1 - 0 | Row 0 ... |
macOS - Ventura - Meson | |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/updatable_views.out /Users/admin/pgsql/build/testrun/pg_upgrade/00... --- /Users/admin/pgsql/src/test/regress/expected/updatable_views.out 2024-05-01 05:35:51 +++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/updatable_views.out 2024-05-01 05:42:35 @@ -1152,2850 +1152,10 @@ MERGE INTO rw_view2 t USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a WHEN MATCHED AND t.a <= 1 THEN DELETE - WHEN MATCHED THEN UPDATE SET b = s.b - WHEN NOT MATCHED AND s.a > 0 THEN INSERT VALUES (s.a, s.b) - RETURNING merge_action(), s.*, t.*; - merge_action | a | b | a | b ---------------+---+----+---+------- - DELETE | 1 | R1 | 1 | Row 1 - UPDATE | 2 | R2 | 2 | R2 - INSERT | 3 | R3 | 3 | R3 -(3 rows) - -SELECT * FROM base_tbl ORDER BY a; - a | b -----+-------- ... |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/constraints.out /Users/admin/pgsql/build/testrun/recovery/027_stre... --- /Users/admin/pgsql/src/test/regress/expected/constraints.out 2024-05-01 05:35:51 +++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/constraints.out 2024-05-01 05:42:55 @@ -1034,269 +1034,16 @@ -- Primary keys in parent table cause NOT NULL constraint to spawn on their -- children. Verify that they work correctly. CREATE TABLE cnn_parent (a int, b int); -CREATE TABLE cnn_child () INHERITS (cnn_parent); -CREATE TABLE cnn_grandchild (NOT NULL b) INHERITS (cnn_child); -CREATE TABLE cnn_child2 (NOT NULL a NO INHERIT) INHERITS (cnn_parent); -CREATE TABLE cnn_grandchild2 () INHERITS (cnn_grandchild, cnn_child2); -NOTICE: merging multiple inherited definitions of column "a" -NOTICE: merging multiple inherited definitions of column "b" -ALTER TABLE cnn_parent ADD PRIMARY KEY (b); -\d+ cnn_grandchild - Table "public.cnn_grandchild" - Column | Type | Collation | Nullable | Default | Storage | Stats target | Description ---------+---------+-----------+----------+---------+---------+--------------+------------- - a | integer | | | | plain | | - b | integer | | not null | | plain | | ... |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/updatable_views.out /Users/admin/pgsql/build/testrun/regress/regre... --- /Users/admin/pgsql/src/test/regress/expected/updatable_views.out 2024-05-01 05:35:51 +++ /Users/admin/pgsql/build/testrun/regress/regress/results/updatable_views.out 2024-05-01 05:42:35 @@ -1152,2850 +1152,10 @@ MERGE INTO rw_view2 t USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a WHEN MATCHED AND t.a <= 1 THEN DELETE - WHEN MATCHED THEN UPDATE SET b = s.b - WHEN NOT MATCHED AND s.a > 0 THEN INSERT VALUES (s.a, s.b) - RETURNING merge_action(), s.*, t.*; - merge_action | a | b | a | b ---------------+---+----+---+------- - DELETE | 1 | R1 | 1 | Row 1 - UPDATE | 2 | R2 | 2 | R2 - INSERT | 3 | R3 | 3 | R3 -(3 rows) - -SELECT * FROM base_tbl ORDER BY a; - a | b -----+-------- ... |
48/4961 | Fix bug when calling strncmp in check_authmethod_valid |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff -w -U3 C:/cirrus/src/test/modules/test_pg_dump/expected/test_pg_dump.out C:/cirrus/build/testrun/test_pg_dump/regre... --- C:/cirrus/src/test/modules/test_pg_dump/expected/test_pg_dump.out 2024-04-30 06:16:56.555839700 +0000 +++ C:/cirrus/build/testrun/test_pg_dump/regress/results/test_pg_dump.out 2024-04-30 06:23:32.456421100 +0000 @@ -75,64 +75,64 @@ aclexplode(s.initprivs) a; obj | grantor | grantee | privilege_type | is_grantable... ----------------------------------------------------+----------+------------------------+----------------+-------------... - column col1 of table regress_pg_dump_table | postgres | - | SELECT | f - function regress_pg_dump_schema.test_agg(smallint) | postgres | - | EXECUTE | f - function regress_pg_dump_schema.test_agg(smallint) | postgres | postgres | EXECUTE | f - function regress_pg_dump_schema.test_agg(smallint) | postgres | regress_dump_test_role | EXECUTE | f - function regress_pg_dump_schema.test_func() | postgres | - | EXECUTE | f - function regress_pg_dump_schema.test_func() | postgres | postgres | EXECUTE | f - function regress_pg_dump_schema.test_func() | postgres | regress_dump_test_role | EXECUTE | f - function wgo_then_no_access() | postgres | - | EXECUTE | f - function wgo_then_no_access() | postgres | postgres | EXECUTE | f - function wgo_then_no_access() | postgres | pg_signal_backend | EXECUTE | t - sequence regress_pg_dump_schema.test_seq | postgres | postgres | SELECT | f - sequence regress_pg_dump_schema.test_seq | postgres | postgres | UPDATE | f - sequence regress_pg_dump_schema.test_seq | postgres | postgres | USAGE | f ... |
48/4866 | Table AM Interface Enhancements |
Linux - Debian Bullseye - Autoconf | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/injection_points.out /tmp/cirrus-ci-build/src/t... --- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/injection_points.out 2024-04-08 11:39:47.579035464 +... +++ /tmp/cirrus-ci-build/src/test/modules/injection_points/results/injection_points.out 2024-04-08 11:44:17.351012032 +0... @@ -159,11 +159,7 @@ -- reload, local injection points should be gone. \c SELECT injection_points_run('TestConditionLocal1'); -- nothing - injection_points_run ----------------------- - -(1 row) - +ERROR: error triggered for injection point TestConditionLocal1 SELECT injection_points_run('TestConditionLocal2'); -- nothing injection_points_run ---------------------- |
47/4060 | Improve WALRead() to suck data directly from WAL buffers when possible |
FreeBSD - 13 - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/injection_points.out /tmp/cirrus-ci-build/build... --- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/injection_points.out 2024-04-08 05:34:05.563827000 +... +++ /tmp/cirrus-ci-build/build/testrun/injection_points/regress/results/injection_points.out 2024-04-08 05:36:44.8653220... @@ -181,11 +181,7 @@ -- Attaching injection points that use the same name as one defined locally -- previously should work. SELECT injection_points_attach('TestConditionLocal1', 'error'); - injection_points_attach -------------------------- - -(1 row) - +ERROR: injection point "TestConditionLocal1" already defined SELECT injection_points_detach('TestConditionLocal1'); injection_points_detach ------------------------- |
48/4384 | Opportunistically pruning page before insert |
SanityCheck | |
regress | diff -U3 /tmp/cirrus-ci-build/contrib/cube/expected/cube.out /tmp/cirrus-ci-build/build/testrun/cube/regress/results/cub... --- /tmp/cirrus-ci-build/contrib/cube/expected/cube.out 2024-04-02 17:04:22.223813381 +0000 +++ /tmp/cirrus-ci-build/build/testrun/cube/regress/results/cube.out 2024-04-02 17:05:25.979761694 +0000 @@ -2,6 +2,16 @@ -- Test cube datatype -- CREATE EXTENSION cube; +WARNING: PageSetPrunable setting pd_prune_xid=740 +WARNING: PageSetPrunable setting pd_prune_xid=740 +WARNING: PageSetPrunable setting pd_prune_xid=740 +WARNING: PageSetPrunable setting pd_prune_xid=740 +WARNING: PageSetPrunable setting pd_prune_xid=740 +WARNING: PageSetPrunable setting pd_prune_xid=740 +WARNING: PageSetPrunable setting pd_prune_xid=740 +WARNING: PageSetPrunable setting pd_prune_xid=740 +WARNING: PageSetPrunable setting pd_prune_xid=740 +WARNING: PageSetPrunable setting pd_prune_xid=740 -- Check whether any of our opclasses fail amvalidate SELECT amname, opcname FROM pg_opclass opc LEFT JOIN pg_am am ON am.oid = opcmethod ... |
48/4412 | Client authentication via OAuth 2.0 |
Linux - Debian Bullseye - Autoconf | |
regress | diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/contrib/postgres_fdw/r... --- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2024-03-31 00:08:19.222218585 +0000 +++ /tmp/cirrus-ci-build/contrib/postgres_fdw/results/postgres_fdw.out 2024-03-31 00:15:02.981884043 +0000 @@ -2754,6 +2754,7 @@ SET LOCAL statement_timeout = '10ms'; select count(*) from ft1 CROSS JOIN ft2 CROSS JOIN ft4 CROSS JOIN ft5; -- this takes very long ERROR: canceling statement due to statement timeout +WARNING: could not get result of cancel request due to timeout COMMIT; -- ==================================================================== -- Check that userid to use when querying the remote table is correctly |
48/4837 | JIT compilation per plan node |
FreeBSD - 13 - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/merge.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u... --- /tmp/cirrus-ci-build/src/test/regress/expected/merge.out 2024-03-19 12:34:37.403272000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/merge.out 2024-03-19 12:36:28.786579000 +0... @@ -1675,8 +1675,10 @@ QUERY PLAN ------------------------------------------------------------------------------------- Merge on public.tgt t + JIT: true -> Hash Join Output: t.ctid, s.a, s.b, s.c, s.d, s.ctid + JIT: true Hash Cond: (t.a = s.a) Join Filter: (t.b < (SubPlan 1)) -> Seq Scan on public.tgt t @@ -1706,7 +1708,7 @@ -> Seq Scan on public.ref r_1 Output: r_1.ab, r_1.cd Filter: ((r_1.ab = (s.a + s.b)) AND (r_1.cd = (s.c - s.d))) -(32 rows) +(34 rows) ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/merge.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream... --- /tmp/cirrus-ci-build/src/test/regress/expected/merge.out 2024-03-19 12:34:37.403272000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/merge.out 2024-03-19 12:37:01.524193000 ... @@ -1675,8 +1675,10 @@ QUERY PLAN ------------------------------------------------------------------------------------- Merge on public.tgt t + JIT: true -> Hash Join Output: t.ctid, s.a, s.b, s.c, s.d, s.ctid + JIT: true Hash Cond: (t.a = s.a) Join Filter: (t.b < (SubPlan 1)) -> Seq Scan on public.tgt t @@ -1706,7 +1708,7 @@ -> Seq Scan on public.ref r_1 Output: r_1.ab, r_1.cd Filter: ((r_1.ab = (s.a + s.b)) AND (r_1.cd = (s.c - s.d))) -(32 rows) +(34 rows) ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/merge.out /tmp/cirrus-ci-build/build/testrun/regress/regress/res... --- /tmp/cirrus-ci-build/src/test/regress/expected/merge.out 2024-03-19 12:34:37.403272000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/merge.out 2024-03-19 12:36:25.803345000 +0000 @@ -1675,8 +1675,10 @@ QUERY PLAN ------------------------------------------------------------------------------------- Merge on public.tgt t + JIT: true -> Hash Join Output: t.ctid, s.a, s.b, s.c, s.d, s.ctid + JIT: true Hash Cond: (t.a = s.a) Join Filter: (t.b < (SubPlan 1)) -> Seq Scan on public.tgt t @@ -1706,7 +1708,7 @@ -> Seq Scan on public.ref r_1 Output: r_1.ab, r_1.cd Filter: ((r_1.ab = (s.a + s.b)) AND (r_1.cd = (s.c - s.d))) -(32 rows) +(34 rows) ... |
Linux - Debian Bullseye - Autoconf | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/merge.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/resu... --- /tmp/cirrus-ci-build/src/test/regress/expected/merge.out 2024-03-19 12:34:28.003588371 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/merge.out 2024-03-19 12:39:29.275648201 +0000 @@ -1675,8 +1675,10 @@ QUERY PLAN ------------------------------------------------------------------------------------- Merge on public.tgt t + JIT: true -> Hash Join Output: t.ctid, s.a, s.b, s.c, s.d, s.ctid + JIT: true Hash Cond: (t.a = s.a) Join Filter: (t.b < (SubPlan 1)) -> Seq Scan on public.tgt t @@ -1706,7 +1708,7 @@ -> Seq Scan on public.ref r_1 Output: r_1.ab, r_1.cd Filter: ((r_1.ab = (s.a + s.b)) AND (r_1.cd = (s.c - s.d))) -(32 rows) +(34 rows) ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/merge.out /tmp/cirrus-ci-build/src/test/regress/results/merge.ou... --- /tmp/cirrus-ci-build/src/test/regress/expected/merge.out 2024-03-19 12:34:28.003588371 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/merge.out 2024-03-19 12:38:26.343646899 +0000 @@ -1675,8 +1675,10 @@ QUERY PLAN ------------------------------------------------------------------------------------- Merge on public.tgt t + JIT: true -> Hash Join Output: t.ctid, s.a, s.b, s.c, s.d, s.ctid + JIT: true Hash Cond: (t.a = s.a) Join Filter: (t.b < (SubPlan 1)) -> Seq Scan on public.tgt t @@ -1706,7 +1708,7 @@ -> Seq Scan on public.ref r_1 Output: r_1.ab, r_1.cd Filter: ((r_1.ab = (s.a + s.b)) AND (r_1.cd = (s.c - s.d))) -(32 rows) +(34 rows) ... |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/merge.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results... --- C:/cirrus/src/test/regress/expected/merge.out 2024-03-19 12:34:46.925783000 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/merge.out 2024-03-19 12:37:39.748421800 +0000 @@ -1675,8 +1675,10 @@ QUERY PLAN ------------------------------------------------------------------------------------- Merge on public.tgt t + JIT: true -> Hash Join Output: t.ctid, s.a, s.b, s.c, s.d, s.ctid + JIT: true Hash Cond: (t.a = s.a) Join Filter: (t.b < (SubPlan 1)) -> Seq Scan on public.tgt t @@ -1706,7 +1708,7 @@ -> Seq Scan on public.ref r_1 Output: r_1.ab, r_1.cd Filter: ((r_1.ab = (s.a + s.b)) AND (r_1.cd = (s.c - s.d))) -(32 rows) +(34 rows) ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/merge.out C:/cirrus/build/testrun/recovery/027_stream_regress/data/resul... --- C:/cirrus/src/test/regress/expected/merge.out 2024-03-19 12:34:46.925783000 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/merge.out 2024-03-19 12:39:44.869517200 +0000 @@ -1675,8 +1675,10 @@ QUERY PLAN ------------------------------------------------------------------------------------- Merge on public.tgt t + JIT: true -> Hash Join Output: t.ctid, s.a, s.b, s.c, s.d, s.ctid + JIT: true Hash Cond: (t.a = s.a) Join Filter: (t.b < (SubPlan 1)) -> Seq Scan on public.tgt t @@ -1706,7 +1708,7 @@ -> Seq Scan on public.ref r_1 Output: r_1.ab, r_1.cd Filter: ((r_1.ab = (s.a + s.b)) AND (r_1.cd = (s.c - s.d))) -(32 rows) +(34 rows) ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/merge.out C:/cirrus/build/testrun/regress/regress/results/merge.out --- C:/cirrus/src/test/regress/expected/merge.out 2024-03-19 12:34:46.925783000 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/merge.out 2024-03-19 12:37:36.134158100 +0000 @@ -1675,8 +1675,10 @@ QUERY PLAN ------------------------------------------------------------------------------------- Merge on public.tgt t + JIT: true -> Hash Join Output: t.ctid, s.a, s.b, s.c, s.d, s.ctid + JIT: true Hash Cond: (t.a = s.a) Join Filter: (t.b < (SubPlan 1)) -> Seq Scan on public.tgt t @@ -1706,7 +1708,7 @@ -> Seq Scan on public.ref r_1 Output: r_1.ab, r_1.cd Filter: ((r_1.ab = (s.a + s.b)) AND (r_1.cd = (s.c - s.d))) -(32 rows) +(34 rows) ... |
macOS - Ventura - Meson | |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/merge.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgra... --- /Users/admin/pgsql/src/test/regress/expected/merge.out 2024-03-19 12:34:25 +++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/merge.out 2024-03-19 12:36:02 @@ -1675,8 +1675,10 @@ QUERY PLAN ------------------------------------------------------------------------------------- Merge on public.tgt t + JIT: true -> Hash Join Output: t.ctid, s.a, s.b, s.c, s.d, s.ctid + JIT: true Hash Cond: (t.a = s.a) Join Filter: (t.b < (SubPlan 1)) -> Seq Scan on public.tgt t @@ -1706,7 +1708,7 @@ -> Seq Scan on public.ref r_1 Output: r_1.ab, r_1.cd Filter: ((r_1.ab = (s.a + s.b)) AND (r_1.cd = (s.c - s.d))) -(32 rows) +(34 rows) ... |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/merge.out /Users/admin/pgsql/build/testrun/recovery/027_stream_reg... --- /Users/admin/pgsql/src/test/regress/expected/merge.out 2024-03-19 12:34:25 +++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/merge.out 2024-03-19 12:37:37 @@ -1675,8 +1675,10 @@ QUERY PLAN ------------------------------------------------------------------------------------- Merge on public.tgt t + JIT: true -> Hash Join Output: t.ctid, s.a, s.b, s.c, s.d, s.ctid + JIT: true Hash Cond: (t.a = s.a) Join Filter: (t.b < (SubPlan 1)) -> Seq Scan on public.tgt t @@ -1706,7 +1708,7 @@ -> Seq Scan on public.ref r_1 Output: r_1.ab, r_1.cd Filter: ((r_1.ab = (s.a + s.b)) AND (r_1.cd = (s.c - s.d))) -(32 rows) +(34 rows) ... |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/merge.out /Users/admin/pgsql/build/testrun/regress/regress/results... --- /Users/admin/pgsql/src/test/regress/expected/merge.out 2024-03-19 12:34:25 +++ /Users/admin/pgsql/build/testrun/regress/regress/results/merge.out 2024-03-19 12:36:02 @@ -1675,8 +1675,10 @@ QUERY PLAN ------------------------------------------------------------------------------------- Merge on public.tgt t + JIT: true -> Hash Join Output: t.ctid, s.a, s.b, s.c, s.d, s.ctid + JIT: true Hash Cond: (t.a = s.a) Join Filter: (t.b < (SubPlan 1)) -> Seq Scan on public.tgt t @@ -1706,7 +1708,7 @@ -> Seq Scan on public.ref r_1 Output: r_1.ab, r_1.cd Filter: ((r_1.ab = (s.a + s.b)) AND (r_1.cd = (s.c - s.d))) -(32 rows) +(34 rows) ... |
48/4754 | Add LSN <-> time conversion facility |
FreeBSD - 13 - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out /tmp/cirrus-ci-build/build/testrun/regress-runn... --- /tmp/cirrus-ci-build/src/test/regress/expected/create_index.out 2024-03-13 13:05:39.947454000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress-running/regress/results/create_index.out 2024-03-13 13:09:33.446700000 +0... @@ -1185,6 +1185,7 @@ CREATE TABLE array_gin_test (a int[]); INSERT INTO array_gin_test SELECT ARRAY[1, g%5, g] FROM generate_series(1, 10000) g; CREATE INDEX array_gin_test_idx ON array_gin_test USING gin (a); +ERROR: error triggered for injection point gin-leave-leaf-split-incomplete SELECT COUNT(*) FROM array_gin_test WHERE a @> '{2}'; count ------- |
48/3478 | AcquireExecutorLocks() and run-time pruning |
FreeBSD - 13 - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00... --- /tmp/cirrus-ci-build/src/test/regress/expected/foreign_key.out 2024-01-27 18:10:39.600445000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/foreign_key.out 2024-01-27 18:13:01.082063... @@ -1988,6 +1988,7 @@ set role regress_other_partitioned_fk_owner; alter table other_partitioned_fk add foreign key (a, b) references fk_notpartitioned_pk(a, b); +WARNING: resource was not closed: relation "fk_notpartitioned_pk_pkey" -- clean up drop table other_partitioned_fk; reset role; 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 2024-01-27 18:10:39.599570000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/copy2.out 2024-01-27 18:13:04.632374000 +0... @@ -129,739 +129,7 @@ COPY x (b, c, d, e) from stdin delimiter ',' null 'x'; COPY x from stdin WITH DELIMITER AS ';' NULL AS ''; COPY x from stdin WITH DELIMITER AS ':' NULL AS E'\\X' ENCODING 'sql_ascii'; -COPY x TO stdout WHERE a = 1; -ERROR: WHERE clause not allowed with COPY TO ... |
48/4352 | Index-only filters without IOS |
FreeBSD - 13 - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/inet.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_up... --- /tmp/cirrus-ci-build/src/test/regress/expected/inet.out 2024-01-21 13:43:34.063738000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/inet.out 2024-01-21 13:45:17.084443000 +00... @@ -270,8 +270,9 @@ ------------------------------------------------------------------------------- Index Scan using inet_idx1 on inet_tbl Index Cond: ((i > '192.168.1.0/24'::inet) AND (i <= '192.168.1.255'::inet)) + Index Filter (non-index): (i << '192.168.1.0/24'::inet) Filter: (i << '192.168.1.0/24'::inet) -(3 rows) +(4 rows) SELECT * FROM inet_tbl WHERE i<<'192.168.1.0/24'::cidr; c | i @@ -287,8 +288,9 @@ -------------------------------------------------------------------------------- Index Scan using inet_idx1 on inet_tbl Index Cond: ((i >= '192.168.1.0/24'::inet) AND (i <= '192.168.1.255'::inet)) + Index Filter (non-index): (i <<= '192.168.1.0/24'::inet) Filter: (i <<= '192.168.1.0/24'::inet) ... |
regress | diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres... --- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2024-01-21 13:43:32.710146000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2024-01-21 13:47:18.331754000 +0000 @@ -3656,6 +3656,7 @@ -> Index Scan using t1_pkey on "S 1"."T 1" t1 Output: t1."C 1", t1.c2, t1.c3, t1.c4, t1.c5, t1.c6, t1.c7, t1.c8 Index Cond: (t1."C 1" < 100) + Index Filter (non-index): (t1.c2 < 3) Filter: (t1.c2 < 3) -> Subquery Scan on qry Output: qry.sum, t2.c1 @@ -3664,7 +3665,7 @@ Output: (sum((t2.c1 + t1."C 1"))), t2.c1 Relations: Aggregate on (public.ft2 t2) Remote SQL: SELECT sum(("C 1" + $1::integer)), "C 1" FROM "S 1"."T 1" GROUP BY 2 -(16 rows) +(17 rows) select c2, sum from "S 1"."T 1" t1, lateral (select sum(t2.c1 + t1."C 1") sum from ft2 t2 group by t2.c1) qry where t1.... c2 | sum |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/inet.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_... --- /tmp/cirrus-ci-build/src/test/regress/expected/inet.out 2024-01-21 13:43:34.063738000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/inet.out 2024-01-21 13:46:31.342391000 +... @@ -270,8 +270,9 @@ ------------------------------------------------------------------------------- Index Scan using inet_idx1 on inet_tbl Index Cond: ((i > '192.168.1.0/24'::inet) AND (i <= '192.168.1.255'::inet)) + Index Filter (non-index): (i << '192.168.1.0/24'::inet) Filter: (i << '192.168.1.0/24'::inet) -(3 rows) +(4 rows) SELECT * FROM inet_tbl WHERE i<<'192.168.1.0/24'::cidr; c | i @@ -287,8 +288,9 @@ -------------------------------------------------------------------------------- Index Scan using inet_idx1 on inet_tbl Index Cond: ((i >= '192.168.1.0/24'::inet) AND (i <= '192.168.1.255'::inet)) + Index Filter (non-index): (i <<= '192.168.1.0/24'::inet) Filter: (i <<= '192.168.1.0/24'::inet) ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/inet.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resu... --- /tmp/cirrus-ci-build/src/test/regress/expected/inet.out 2024-01-21 13:43:34.063738000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/inet.out 2024-01-21 13:45:15.355462000 +0000 @@ -270,8 +270,9 @@ ------------------------------------------------------------------------------- Index Scan using inet_idx1 on inet_tbl Index Cond: ((i > '192.168.1.0/24'::inet) AND (i <= '192.168.1.255'::inet)) + Index Filter (non-index): (i << '192.168.1.0/24'::inet) Filter: (i << '192.168.1.0/24'::inet) -(3 rows) +(4 rows) SELECT * FROM inet_tbl WHERE i<<'192.168.1.0/24'::cidr; c | i @@ -287,8 +288,9 @@ -------------------------------------------------------------------------------- Index Scan using inet_idx1 on inet_tbl Index Cond: ((i >= '192.168.1.0/24'::inet) AND (i <= '192.168.1.255'::inet)) + Index Filter (non-index): (i <<= '192.168.1.0/24'::inet) Filter: (i <<= '192.168.1.0/24'::inet) ... |
Linux - Debian Bullseye - Autoconf | |
regress | diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/contrib/postgres_fdw/r... --- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2024-01-21 13:43:21.127029120 +0000 +++ /tmp/cirrus-ci-build/contrib/postgres_fdw/results/postgres_fdw.out 2024-01-21 13:47:37.582974200 +0000 @@ -3656,6 +3656,7 @@ -> Index Scan using t1_pkey on "S 1"."T 1" t1 Output: t1."C 1", t1.c2, t1.c3, t1.c4, t1.c5, t1.c6, t1.c7, t1.c8 Index Cond: (t1."C 1" < 100) + Index Filter (non-index): (t1.c2 < 3) Filter: (t1.c2 < 3) -> Subquery Scan on qry Output: qry.sum, t2.c1 @@ -3664,7 +3665,7 @@ Output: (sum((t2.c1 + t1."C 1"))), t2.c1 Relations: Aggregate on (public.ft2 t2) Remote SQL: SELECT sum(("C 1" + $1::integer)), "C 1" FROM "S 1"."T 1" GROUP BY 2 -(16 rows) +(17 rows) select c2, sum from "S 1"."T 1" t1, lateral (select sum(t2.c1 + t1."C 1") sum from ft2 t2 group by t2.c1) qry where t1.... c2 | sum |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/inet.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/resul... --- /tmp/cirrus-ci-build/src/test/regress/expected/inet.out 2024-01-21 13:43:22.691026750 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/inet.out 2024-01-21 13:47:57.994948827 +0000 @@ -270,8 +270,9 @@ ------------------------------------------------------------------------------- Index Scan using inet_idx1 on inet_tbl Index Cond: ((i > '192.168.1.0/24'::inet) AND (i <= '192.168.1.255'::inet)) + Index Filter (non-index): (i << '192.168.1.0/24'::inet) Filter: (i << '192.168.1.0/24'::inet) -(3 rows) +(4 rows) SELECT * FROM inet_tbl WHERE i<<'192.168.1.0/24'::cidr; c | i @@ -287,8 +288,9 @@ -------------------------------------------------------------------------------- Index Scan using inet_idx1 on inet_tbl Index Cond: ((i >= '192.168.1.0/24'::inet) AND (i <= '192.168.1.255'::inet)) + Index Filter (non-index): (i <<= '192.168.1.0/24'::inet) Filter: (i <<= '192.168.1.0/24'::inet) ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/inet.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/result... --- /tmp/cirrus-ci-build/src/test/regress/expected/inet.out 2024-01-21 13:43:22.691026750 +0000 +++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/inet.out 2024-01-21 13:49:28.386866418 +0000 @@ -270,8 +270,9 @@ ------------------------------------------------------------------------------- Index Scan using inet_idx1 on inet_tbl Index Cond: ((i > '192.168.1.0/24'::inet) AND (i <= '192.168.1.255'::inet)) + Index Filter (non-index): (i << '192.168.1.0/24'::inet) Filter: (i << '192.168.1.0/24'::inet) -(3 rows) +(4 rows) SELECT * FROM inet_tbl WHERE i<<'192.168.1.0/24'::cidr; c | i @@ -287,8 +288,9 @@ -------------------------------------------------------------------------------- Index Scan using inet_idx1 on inet_tbl Index Cond: ((i >= '192.168.1.0/24'::inet) AND (i <= '192.168.1.255'::inet)) + Index Filter (non-index): (i <<= '192.168.1.0/24'::inet) Filter: (i <<= '192.168.1.0/24'::inet) ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/inet.out /tmp/cirrus-ci-build/src/test/regress/results/inet.out --- /tmp/cirrus-ci-build/src/test/regress/expected/inet.out 2024-01-21 13:43:22.691026750 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/inet.out 2024-01-21 13:46:25.050995586 +0000 @@ -270,8 +270,9 @@ ------------------------------------------------------------------------------- Index Scan using inet_idx1 on inet_tbl Index Cond: ((i > '192.168.1.0/24'::inet) AND (i <= '192.168.1.255'::inet)) + Index Filter (non-index): (i << '192.168.1.0/24'::inet) Filter: (i << '192.168.1.0/24'::inet) -(3 rows) +(4 rows) SELECT * FROM inet_tbl WHERE i<<'192.168.1.0/24'::cidr; c | i @@ -287,8 +288,9 @@ -------------------------------------------------------------------------------- Index Scan using inet_idx1 on inet_tbl Index Cond: ((i >= '192.168.1.0/24'::inet) AND (i <= '192.168.1.255'::inet)) + Index Filter (non-index): (i <<= '192.168.1.0/24'::inet) Filter: (i <<= '192.168.1.0/24'::inet) ... |
Linux - Debian Bullseye - Meson | |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/inet.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_up... --- /tmp/cirrus-ci-build/src/test/regress/expected/inet.out 2024-01-21 13:43:22.721824830 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/inet.out 2024-01-21 13:46:24.993669777 +00... @@ -270,8 +270,9 @@ ------------------------------------------------------------------------------- Index Scan using inet_idx1 on inet_tbl Index Cond: ((i > '192.168.1.0/24'::inet) AND (i <= '192.168.1.255'::inet)) + Index Filter (non-index): (i << '192.168.1.0/24'::inet) Filter: (i << '192.168.1.0/24'::inet) -(3 rows) +(4 rows) SELECT * FROM inet_tbl WHERE i<<'192.168.1.0/24'::cidr; c | i @@ -287,8 +288,9 @@ -------------------------------------------------------------------------------- Index Scan using inet_idx1 on inet_tbl Index Cond: ((i >= '192.168.1.0/24'::inet) AND (i <= '192.168.1.255'::inet)) + Index Filter (non-index): (i <<= '192.168.1.0/24'::inet) Filter: (i <<= '192.168.1.0/24'::inet) ... |
regress | diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/build/testrun/postgres... --- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2024-01-21 13:43:21.141823678 +0000 +++ /tmp/cirrus-ci-build/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2024-01-21 13:47:32.361653582 +0000 @@ -3656,6 +3656,7 @@ -> Index Scan using t1_pkey on "S 1"."T 1" t1 Output: t1."C 1", t1.c2, t1.c3, t1.c4, t1.c5, t1.c6, t1.c7, t1.c8 Index Cond: (t1."C 1" < 100) + Index Filter (non-index): (t1.c2 < 3) Filter: (t1.c2 < 3) -> Subquery Scan on qry Output: qry.sum, t2.c1 @@ -3664,7 +3665,7 @@ Output: (sum((t2.c1 + t1."C 1"))), t2.c1 Relations: Aggregate on (public.ft2 t2) Remote SQL: SELECT sum(("C 1" + $1::integer)), "C 1" FROM "S 1"."T 1" GROUP BY 2 -(16 rows) +(17 rows) select c2, sum from "S 1"."T 1" t1, lateral (select sum(t2.c1 + t1."C 1") sum from ft2 t2 group by t2.c1) qry where t1.... c2 | sum |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/inet.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_... --- /tmp/cirrus-ci-build/src/test/regress/expected/inet.out 2024-01-21 13:43:22.721824830 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/inet.out 2024-01-21 13:46:51.293660454 +... @@ -270,8 +270,9 @@ ------------------------------------------------------------------------------- Index Scan using inet_idx1 on inet_tbl Index Cond: ((i > '192.168.1.0/24'::inet) AND (i <= '192.168.1.255'::inet)) + Index Filter (non-index): (i << '192.168.1.0/24'::inet) Filter: (i << '192.168.1.0/24'::inet) -(3 rows) +(4 rows) SELECT * FROM inet_tbl WHERE i<<'192.168.1.0/24'::cidr; c | i @@ -287,8 +288,9 @@ -------------------------------------------------------------------------------- Index Scan using inet_idx1 on inet_tbl Index Cond: ((i >= '192.168.1.0/24'::inet) AND (i <= '192.168.1.255'::inet)) + Index Filter (non-index): (i <<= '192.168.1.0/24'::inet) Filter: (i <<= '192.168.1.0/24'::inet) ... |
regress | diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/inet.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resu... --- /tmp/cirrus-ci-build/src/test/regress/expected/inet.out 2024-01-21 13:43:22.721824830 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/inet.out 2024-01-21 13:46:22.293671934 +0000 @@ -270,8 +270,9 @@ ------------------------------------------------------------------------------- Index Scan using inet_idx1 on inet_tbl Index Cond: ((i > '192.168.1.0/24'::inet) AND (i <= '192.168.1.255'::inet)) + Index Filter (non-index): (i << '192.168.1.0/24'::inet) Filter: (i << '192.168.1.0/24'::inet) -(3 rows) +(4 rows) SELECT * FROM inet_tbl WHERE i<<'192.168.1.0/24'::cidr; c | i @@ -287,8 +288,9 @@ -------------------------------------------------------------------------------- Index Scan using inet_idx1 on inet_tbl Index Cond: ((i >= '192.168.1.0/24'::inet) AND (i <= '192.168.1.255'::inet)) + Index Filter (non-index): (i <<= '192.168.1.0/24'::inet) Filter: (i <<= '192.168.1.0/24'::inet) ... |
Windows - Server 2019, VS 2019 - Meson & ninja | |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/inet.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/... --- C:/cirrus/src/test/regress/expected/inet.out 2024-01-21 13:43:39.075883500 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/inet.out 2024-01-21 13:45:46.879273500 +0000 @@ -270,8 +270,9 @@ ------------------------------------------------------------------------------- Index Scan using inet_idx1 on inet_tbl Index Cond: ((i > '192.168.1.0/24'::inet) AND (i <= '192.168.1.255'::inet)) + Index Filter (non-index): (i << '192.168.1.0/24'::inet) Filter: (i << '192.168.1.0/24'::inet) -(3 rows) +(4 rows) SELECT * FROM inet_tbl WHERE i<<'192.168.1.0/24'::cidr; c | i @@ -287,8 +288,9 @@ -------------------------------------------------------------------------------- Index Scan using inet_idx1 on inet_tbl Index Cond: ((i >= '192.168.1.0/24'::inet) AND (i <= '192.168.1.255'::inet)) + Index Filter (non-index): (i <<= '192.168.1.0/24'::inet) Filter: (i <<= '192.168.1.0/24'::inet) ... |
regress | diff -w -U3 C:/cirrus/contrib/postgres_fdw/expected/postgres_fdw.out C:/cirrus/build/testrun/postgres_fdw/regress/result... --- C:/cirrus/contrib/postgres_fdw/expected/postgres_fdw.out 2024-01-21 13:43:35.174036700 +0000 +++ C:/cirrus/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2024-01-21 13:49:53.769872100 +0000 @@ -3656,6 +3656,7 @@ -> Index Scan using t1_pkey on "S 1"."T 1" t1 Output: t1."C 1", t1.c2, t1.c3, t1.c4, t1.c5, t1.c6, t1.c7, t1.c8 Index Cond: (t1."C 1" < 100) + Index Filter (non-index): (t1.c2 < 3) Filter: (t1.c2 < 3) -> Subquery Scan on qry Output: qry.sum, t2.c1 @@ -3664,7 +3665,7 @@ Output: (sum((t2.c1 + t1."C 1"))), t2.c1 Relations: Aggregate on (public.ft2 t2) Remote SQL: SELECT sum(("C 1" + $1::integer)), "C 1" FROM "S 1"."T 1" GROUP BY 2 -(16 rows) +(17 rows) select c2, sum from "S 1"."T 1" t1, lateral (select sum(t2.c1 + t1."C 1") sum from ft2 t2 group by t2.c1) qry where t1.... c2 | sum |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/inet.out C:/cirrus/build/testrun/recovery/027_stream_regress/data/result... --- C:/cirrus/src/test/regress/expected/inet.out 2024-01-21 13:43:39.075883500 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/inet.out 2024-01-21 13:47:56.800106800 +0000 @@ -270,8 +270,9 @@ ------------------------------------------------------------------------------- Index Scan using inet_idx1 on inet_tbl Index Cond: ((i > '192.168.1.0/24'::inet) AND (i <= '192.168.1.255'::inet)) + Index Filter (non-index): (i << '192.168.1.0/24'::inet) Filter: (i << '192.168.1.0/24'::inet) -(3 rows) +(4 rows) SELECT * FROM inet_tbl WHERE i<<'192.168.1.0/24'::cidr; c | i @@ -287,8 +288,9 @@ -------------------------------------------------------------------------------- Index Scan using inet_idx1 on inet_tbl Index Cond: ((i >= '192.168.1.0/24'::inet) AND (i <= '192.168.1.255'::inet)) + Index Filter (non-index): (i <<= '192.168.1.0/24'::inet) Filter: (i <<= '192.168.1.0/24'::inet) ... |
regress | diff -w -U3 C:/cirrus/src/test/regress/expected/inet.out C:/cirrus/build/testrun/regress/regress/results/inet.out --- C:/cirrus/src/test/regress/expected/inet.out 2024-01-21 13:43:39.075883500 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/inet.out 2024-01-21 13:45:41.009014400 +0000 @@ -270,8 +270,9 @@ ------------------------------------------------------------------------------- Index Scan using inet_idx1 on inet_tbl Index Cond: ((i > '192.168.1.0/24'::inet) AND (i <= '192.168.1.255'::inet)) + Index Filter (non-index): (i << '192.168.1.0/24'::inet) Filter: (i << '192.168.1.0/24'::inet) -(3 rows) +(4 rows) SELECT * FROM inet_tbl WHERE i<<'192.168.1.0/24'::cidr; c | i @@ -287,8 +288,9 @@ -------------------------------------------------------------------------------- Index Scan using inet_idx1 on inet_tbl Index Cond: ((i >= '192.168.1.0/24'::inet) AND (i <= '192.168.1.255'::inet)) + Index Filter (non-index): (i <<= '192.168.1.0/24'::inet) Filter: (i <<= '192.168.1.0/24'::inet) ... |
macOS - Ventura - Meson | |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/inet.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrad... --- /Users/admin/pgsql/src/test/regress/expected/inet.out 2024-01-21 13:43:18 +++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/inet.out 2024-01-21 13:45:45 @@ -270,8 +270,9 @@ ------------------------------------------------------------------------------- Index Scan using inet_idx1 on inet_tbl Index Cond: ((i > '192.168.1.0/24'::inet) AND (i <= '192.168.1.255'::inet)) + Index Filter (non-index): (i << '192.168.1.0/24'::inet) Filter: (i << '192.168.1.0/24'::inet) -(3 rows) +(4 rows) SELECT * FROM inet_tbl WHERE i<<'192.168.1.0/24'::cidr; c | i @@ -287,8 +288,9 @@ -------------------------------------------------------------------------------- Index Scan using inet_idx1 on inet_tbl Index Cond: ((i >= '192.168.1.0/24'::inet) AND (i <= '192.168.1.255'::inet)) + Index Filter (non-index): (i <<= '192.168.1.0/24'::inet) Filter: (i <<= '192.168.1.0/24'::inet) ... |
regress | diff -U3 /Users/admin/pgsql/contrib/postgres_fdw/expected/postgres_fdw.out /Users/admin/pgsql/build/testrun/postgres_fdw... --- /Users/admin/pgsql/contrib/postgres_fdw/expected/postgres_fdw.out 2024-01-21 13:43:16 +++ /Users/admin/pgsql/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2024-01-21 13:47:02 @@ -3656,6 +3656,7 @@ -> Index Scan using t1_pkey on "S 1"."T 1" t1 Output: t1."C 1", t1.c2, t1.c3, t1.c4, t1.c5, t1.c6, t1.c7, t1.c8 Index Cond: (t1."C 1" < 100) + Index Filter (non-index): (t1.c2 < 3) Filter: (t1.c2 < 3) -> Subquery Scan on qry Output: qry.sum, t2.c1 @@ -3664,7 +3665,7 @@ Output: (sum((t2.c1 + t1."C 1"))), t2.c1 Relations: Aggregate on (public.ft2 t2) Remote SQL: SELECT sum(("C 1" + $1::integer)), "C 1" FROM "S 1"."T 1" GROUP BY 2 -(16 rows) +(17 rows) select c2, sum from "S 1"."T 1" t1, lateral (select sum(t2.c1 + t1."C 1") sum from ft2 t2 group by t2.c1) qry where t1.... c2 | sum |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/inet.out /Users/admin/pgsql/build/testrun/recovery/027_stream_regr... --- /Users/admin/pgsql/src/test/regress/expected/inet.out 2024-01-21 13:43:18 +++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/inet.out 2024-01-21 13:46:19 @@ -270,8 +270,9 @@ ------------------------------------------------------------------------------- Index Scan using inet_idx1 on inet_tbl Index Cond: ((i > '192.168.1.0/24'::inet) AND (i <= '192.168.1.255'::inet)) + Index Filter (non-index): (i << '192.168.1.0/24'::inet) Filter: (i << '192.168.1.0/24'::inet) -(3 rows) +(4 rows) SELECT * FROM inet_tbl WHERE i<<'192.168.1.0/24'::cidr; c | i @@ -287,8 +288,9 @@ -------------------------------------------------------------------------------- Index Scan using inet_idx1 on inet_tbl Index Cond: ((i >= '192.168.1.0/24'::inet) AND (i <= '192.168.1.255'::inet)) + Index Filter (non-index): (i <<= '192.168.1.0/24'::inet) Filter: (i <<= '192.168.1.0/24'::inet) ... |
regress | diff -U3 /Users/admin/pgsql/src/test/regress/expected/inet.out /Users/admin/pgsql/build/testrun/regress/regress/results/... --- /Users/admin/pgsql/src/test/regress/expected/inet.out 2024-01-21 13:43:18 +++ /Users/admin/pgsql/build/testrun/regress/regress/results/inet.out 2024-01-21 13:45:44 @@ -270,8 +270,9 @@ ------------------------------------------------------------------------------- Index Scan using inet_idx1 on inet_tbl Index Cond: ((i > '192.168.1.0/24'::inet) AND (i <= '192.168.1.255'::inet)) + Index Filter (non-index): (i << '192.168.1.0/24'::inet) Filter: (i << '192.168.1.0/24'::inet) -(3 rows) +(4 rows) SELECT * FROM inet_tbl WHERE i<<'192.168.1.0/24'::cidr; c | i @@ -287,8 +288,9 @@ -------------------------------------------------------------------------------- Index Scan using inet_idx1 on inet_tbl Index Cond: ((i >= '192.168.1.0/24'::inet) AND (i <= '192.168.1.255'::inet)) + Index Filter (non-index): (i <<= '192.168.1.0/24'::inet) Filter: (i <<= '192.168.1.0/24'::inet) ... |