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/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-05 19:45:13.608494000 +... +++ /tmp/cirrus-ci-build/build/testrun/injection_points/regress/results/injection_points.out 2024-05-05 19:48:06.0315220... @@ -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-05 19:45:14.878166223 +... +++ /tmp/cirrus-ci-build/src/test/modules/injection_points/results/injection_points.out 2024-05-05 19:50:49.905892661 +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-05 19:45:12.319660696 +... +++ /tmp/cirrus-ci-build/build/testrun/injection_points/regress/results/injection_points.out 2024-05-05 19:50:25.5674461... @@ -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-05 19:45:36.777627300 +0000 +++ C:/cirrus/build/testrun/injection_points/regress/results/injection_points.out 2024-05-05 19:52:47.572982800 +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-05 19:45:16 +++ /Users/admin/pgsql/build/testrun/injection_points/regress/results/injection_points.out 2024-05-05 19:49:38 @@ -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-05 16:36:54.834710000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2024-05-05 16:38:24.51... @@ -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-05 16:36:54.834710000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2024-05-05 16:38:59.... @@ -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-05 16:36:54.834710000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/select_parallel.out 2024-05-05 16:38:23.508010000 +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-05 16:36:54.955489216 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/select_parallel.out 2024-05-05 16:40:49.671491705 +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-05 16:36:54.955489216 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/select_parallel.out 2024-05-05 16:39:37.747485984 +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-05 16:36:53.741322497 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2024-05-05 16:39:39.15... @@ -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-05 16:36:53.741322497 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2024-05-05 16:40:11.... @@ -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-05 16:36:53.741322497 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/select_parallel.out 2024-05-05 16:39:34.185298915 +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-05 16:37:09.656678100 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2024-05-05 16:40:29.058871000 +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-05 16:37:09.656678100 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2024-05-05 16:42:54.833702700 +... @@ -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-05 16:37:09.656678100 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/select_parallel.out 2024-05-05 16:40:25.675557900 +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-05 16:36:53 +++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2024-05-05 16:39:32 @@ -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-05 16:36:53 +++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2024-05-05 16:40:20 @@ -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-05 16:36:53 +++ /Users/admin/pgsql/build/testrun/regress/regress/results/select_parallel.out 2024-05-05 16:39:34 @@ -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-05 12:28:51.905906000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_join.out 2024-05-05 12:30:28.809... @@ -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-05 12:28:51.905906000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/partition_join.out 2024-05-05 12:30:55.5... @@ -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-05 12:28:51.905906000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/partition_join.out 2024-05-05 12:30:24.686373000 +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-05 12:28:46.126373533 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/partition_join.out 2024-05-05 12:32:15.598394407 +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-05 12:28:46.126373533 +0000 +++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/partition_join.out 2024-05-05 12:33:49.086361126 +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-05 12:28:46.126373533 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/partition_join.out 2024-05-05 12:31:21.622391819 +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-05 12:28:49.616932797 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_join.out 2024-05-05 12:31:02.308... @@ -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-05 12:28:49.616932797 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/partition_join.out 2024-05-05 12:31:25.2... @@ -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-05 12:28:49.616932797 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/partition_join.out 2024-05-05 12:30:54.732912675 +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-05 12:28:58.581406000 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_join.out 2024-05-05 12:32:43.305722600 +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-05 12:28:58.581406000 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/partition_join.out 2024-05-05 12:34:50.113780900 +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-05 12:28:58.581406000 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/partition_join.out 2024-05-05 12:32:37.547908300 +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-05 12:28:48 +++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_join.out 2024-05-05 12:31:10 @@ -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-05 12:28:48 +++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/partition_join.out 2024-05-05 12:32:08 @@ -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-05 12:28:48 +++ /Users/admin/pgsql/build/testrun/regress/regress/results/partition_join.out 2024-05-05 12:31:07 @@ -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/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-05 05:17:51.890946000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/alter_table.out 2024-05-05 05:19:20.059350... @@ -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 +-------+------------+---------------+-------------+---------------------- + 37773 | | 0 | 37773 | pktable_pkey + 37770 | | 0 | 37770 | pktable + 37775 | | 0 | 37775 | fktable + 38400 | | 0 | 38405 | foo + 38409 | | 0 | 38409 | pg_toast_38400_index + 38408 | | 0 | 38408 | pg_toast_38400 + 38671 | | 0 | 38671 | old_oids + 38699 | | 0 | 38699 | pg_toast_38696 ... |
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-05 05:17:51.890946000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/alter_table.out 2024-05-05 05:19:52.6656... @@ -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 +-------+------------+---------------+-------------+---------------------- + 37700 | | 0 | 37700 | pktable_pkey + 37697 | | 0 | 37697 | pktable + 37702 | | 0 | 37702 | fktable + 38294 | | 0 | 38303 | foo + 38307 | | 0 | 38307 | pg_toast_38294_index + 38306 | | 0 | 38306 | pg_toast_38294 + 38519 | | 0 | 38519 | old_oids + 38543 | | 0 | 38543 | pg_toast_38540 ... |
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-05 05:17:51.890946000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/alter_table.out 2024-05-05 05:19:19.036660000 +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 +-------+------------+---------------+-------------+---------------------- + 37887 | | 0 | 37887 | pktable_pkey + 37884 | | 0 | 37884 | pktable + 37889 | | 0 | 37889 | fktable + 38403 | | 0 | 38408 | foo + 38412 | | 0 | 38412 | pg_toast_38403_index + 38411 | | 0 | 38411 | pg_toast_38403 + 38673 | | 0 | 38673 | old_oids + 38692 | | 0 | 38692 | pg_toast_38689 ... |
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-05 05:17:44.831470955 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/alter_table.out 2024-05-05 05:21:30.771289568 +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 +-------+------------+---------------+-------------+---------------------- + 37785 | | 0 | 37785 | pktable_pkey + 37781 | | 0 | 37781 | pktable + 37788 | | 0 | 37788 | fktable + 38485 | | 0 | 38490 | foo + 38494 | | 0 | 38494 | pg_toast_38485_index + 38493 | | 0 | 38493 | pg_toast_38485 + 38717 | | 0 | 38717 | old_oids + 38735 | | 0 | 38735 | pg_toast_38732 ... |
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-05 05:17:44.831470955 +0000 +++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/alter_table.out 2024-05-05 05:22:36.999230752 +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 +-------+------------+---------------+-------------+---------------------- + 38885 | | 0 | 38885 | pg_toast_38882 + 38012 | | 0 | 38012 | users_id_seq + 38026 | | 0 | 38026 | pg_toast_38021 + 38028 | | 0 | 38028 | pg_toast_38021_index + 38021 | | 0 | 38021 | users + 38271 | | 0 | 38271 | foo + 38495 | | 0 | 38495 | forc_test + 38886 | | 0 | 38886 | pg_toast_38882_index ... |
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-05 05:17:44.831470955 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/alter_table.out 2024-05-05 05:20:01.811373715 +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 +-------+------------+---------------+-------------+---------------------- + 37965 | | 0 | 37965 | pktable_pkey + 37962 | | 0 | 37962 | pktable + 37967 | | 0 | 37967 | fktable + 38478 | | 0 | 38484 | foo + 38488 | | 0 | 38488 | pg_toast_38478_index + 38487 | | 0 | 38487 | pg_toast_38478 + 38705 | | 0 | 38705 | old_oids + 38723 | | 0 | 38723 | pg_toast_38720 ... |
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-05 05:17:42.933087773 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/alter_table.out 2024-05-05 05:19:43.649016... @@ -3476,9 +3476,26 @@ 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 +-------+------------+---------------+-------------+---------------------- + 38226 | | 0 | 38226 | users_id_seq + 38240 | | 0 | 38240 | pg_toast_38231 + 38241 | | 0 | 38241 | pg_toast_38231_index + 38231 | | 0 | 38231 | users + 38499 | | 0 | 38499 | foo + 38688 | | 0 | 38688 | forc_test + 37783 | | 0 | 37783 | pktable_pkey + 37780 | | 0 | 37780 | pktable ... |
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-05 05:17:42.933087773 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/alter_table.out 2024-05-05 05:20:10.3209... @@ -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 +-------+------------+---------------+-------------+---------------------- + 37792 | | 0 | 37792 | pktable_pkey + 37789 | | 0 | 37789 | pktable + 37794 | | 0 | 37794 | fktable + 38279 | | 0 | 38287 | foo + 38291 | | 0 | 38291 | pg_toast_38279_index + 38290 | | 0 | 38290 | pg_toast_38279 + 38507 | | 0 | 38507 | old_oids + 38525 | | 0 | 38525 | pg_toast_38522 ... |
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-05 05:17:42.933087773 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/alter_table.out 2024-05-05 05:19:37.805019505 +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 +-------+------------+---------------+-------------+---------------------- + 38103 | | 0 | 38103 | users_id_seq + 38110 | | 0 | 38110 | pg_toast_38104 + 38111 | | 0 | 38111 | pg_toast_38104_index + 38104 | | 0 | 38104 | users + 38430 | | 0 | 38430 | foo + 38609 | | 0 | 38609 | forc_test + 39022 | | 0 | 39022 | pg_toast_39019 + 39023 | | 0 | 39023 | pg_toast_39019_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-05 05:18:00.887957600 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/alter_table.out 2024-05-05 05:21:26.073271600 +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) +-------+------------+---------------+-------------+---------------------- + 37641 | | 0 | 37641 | pktable_pkey + 37638 | | 0 | 37638 | pktable + 37643 | | 0 | 37643 | fktable + 38132 | | 0 | 38137 | foo + 38141 | | 0 | 38141 | pg_toast_38132_index + 38140 | | 0 | 38140 | pg_toast_38132 + 38328 | | 0 | 38328 | old_oids + 38345 | | 0 | 38345 | pg_toast_38342 + 38346 | | 0 | 38346 | pg_toast_38342_index + 38342 | | 0 | 38342 | 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-05 05:18:00.887957600 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/alter_table.out 2024-05-05 05:23:40.474570500 +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) +-------+------------+---------------+-------------+---------------------- + 37358 | | 0 | 37358 | pktable_pkey + 37350 | | 0 | 37350 | pktable + 37363 | | 0 | 37363 | fktable + 38069 | | 0 | 38075 | foo + 38080 | | 0 | 38080 | pg_toast_38069_index + 38078 | | 0 | 38078 | pg_toast_38069 + 38327 | | 0 | 38327 | old_oids + 38360 | | 0 | 38360 | pg_toast_38348 + 38361 | | 0 | 38361 | pg_toast_38348_index + 38348 | | 0 | 38348 | 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-05 05:18:00.887957600 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/alter_table.out 2024-05-05 05:21:12.053745700 +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) +-------+------------+---------------+-------------+---------------------- + 36615 | | 0 | 36615 | pktable_pkey + 36610 | | 0 | 36610 | pktable + 36617 | | 0 | 36617 | fktable + 37983 | | 0 | 37991 | foo + 37995 | | 0 | 37995 | pg_toast_37983_index + 37994 | | 0 | 37994 | pg_toast_37983 + 38388 | | 0 | 38388 | old_oids + 38405 | | 0 | 38405 | pg_toast_38402 + 38406 | | 0 | 38406 | pg_toast_38402_index + 38402 | | 0 | 38402 | recur2 ... |
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-05 05:17:41 +++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/alter_table.out 2024-05-05 05:20:04 @@ -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 +-------+------------+---------------+-------------+---------------------- + 37765 | | 0 | 37765 | pktable_pkey + 37759 | | 0 | 37759 | pktable + 37767 | | 0 | 37767 | fktable + 38477 | | 0 | 38482 | foo + 38486 | | 0 | 38486 | pg_toast_38477_index + 38485 | | 0 | 38485 | pg_toast_38477 + 38726 | | 0 | 38726 | pg_toast_38723 + 38727 | | 0 | 38727 | pg_toast_38723_index ... |
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-05 05:17:41 +++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/alter_table.out 2024-05-05 05:22:35 @@ -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 +-------+------------+---------------+-------------+---------------------- + 37622 | | 0 | 37622 | pktable_pkey + 37619 | | 0 | 37619 | pktable + 37624 | | 0 | 37624 | fktable + 38312 | | 0 | 38317 | foo + 38321 | | 0 | 38321 | pg_toast_38312_index + 38320 | | 0 | 38320 | pg_toast_38312 + 38533 | | 0 | 38533 | old_oids + 38550 | | 0 | 38550 | pg_toast_38547 ... |
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-05 05:17:41 +++ /Users/admin/pgsql/build/testrun/regress/regress/results/alter_table.out 2024-05-05 05:20:01 @@ -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 +-------+------------+---------------+-------------+---------------------- + 37700 | | 0 | 37700 | pktable_pkey + 37697 | | 0 | 37697 | pktable + 37702 | | 0 | 37702 | fktable + 38498 | | 0 | 38503 | foo + 38507 | | 0 | 38507 | pg_toast_38498_index + 38506 | | 0 | 38506 | pg_toast_38498 + 38694 | | 0 | 38694 | old_oids + 38711 | | 0 | 38711 | pg_toast_38708 ... |
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-05 02:16:56.579293000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/constraints.out 2024-05-05 02:18:15.843139... @@ -1190,118 +1190,10 @@ 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" - 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-05 02:16:56.579293000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/constraints.out 2024-05-05 02:18:37.1266... @@ -1201,107 +1201,10 @@ notnull_tbl4_cld3 \d+ notnull_tbl4_lk - Table "public.notnull_tbl4_lk" - Column | Type | Collation | Nullable | Default | Storage | Stats target | Description ---------+---------+-----------+----------+---------+---------+--------------+------------- - a | integer | | not null | | plain | | -Not-null constraints: - "notnull_tbl4_lk_a_not_null" NOT NULL "a" - -\d+ notnull_tbl4_lk2 - Table "public.notnull_tbl4_lk2" - Column | Type | Collation | Nullable | Default | Storage | Stats target | Description ---------+---------+-----------+----------+---------+---------+--------------+------------- - a | integer | | not null | | plain | | -Indexes: ... |
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-05 02:16:56.579293000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/constraints.out 2024-05-05 02:18:12.931529000 +0000 @@ -1236,72 +1236,7 @@ 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-05 02:16:56.241718603 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/triggers.out 2024-05-05 02:20:16.621772209 +0000 @@ -2582,1165 +2582,10 @@ 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 --- deferred constraint is also called immediately. The deferred constraint --- is fired at commit time. ... |
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-05 02:16:56.241718603 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/triggers.out 2024-05-05 02:19:14.205747341 +0000 @@ -2432,1315 +2432,10 @@ partition by range (b); alter table parted_irreg_ancestor drop column fd, drop column fd2, drop column fd3; -create table parted_irreg (fd int, a int, fd2 int, b text) - partition by range (b); -alter table parted_irreg drop column fd, drop column fd2; -alter table parted_irreg_ancestor attach partition parted_irreg - for values from ('aaaa') to ('zzzz'); -create table parted1_irreg (b text, fd int, a int); -alter table parted1_irreg drop column fd; -alter table parted_irreg attach partition parted1_irreg - for values from ('aaaa') to ('bbbb'); -create trigger parted_trig after insert on parted_irreg - for each row execute procedure trigger_notice_ab(); -create trigger parted_trig_odd after insert on parted_irreg for each row - when (bark(new.b) AND new.a % 2 = 1) execute procedure trigger_notice_ab(); ... |
Linux - Debian Bullseye - 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-05 02:16:56.541797668 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/constraints.out 2024-05-05 02:20:01.281697... @@ -1001,307 +1001,7 @@ ALTER TABLE notnull_tbl2 REPLICA IDENTITY FULL, ALTER c2 DROP IDENTITY; ALTER TABLE notnull_tbl2 ALTER c1 DROP NOT NULL, ALTER c2 DROP NOT NULL; \d+ notnull_tbl2 - Table "public.notnull_tbl2" - Column | Type | Collation | Nullable | Default | Storage | Stats target | Description ---------+---------+-----------+----------+---------+---------+--------------+------------- - c1 | integer | | | | plain | | - c2 | integer | | | | plain | | -Indexes: - "notnull_tbl2_c1_key" UNIQUE CONSTRAINT, btree (c1) -Replica Identity: FULL - -ROLLBACK; --- Leave this table around for pg_upgrade testing -CREATE TABLE notnull_tbl3 (a INTEGER NOT NULL, CHECK (a IS NOT NULL)); -ALTER TABLE notnull_tbl3 ALTER A DROP NOT NULL; ... |
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-05 02:16:56.541797668 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/constraints.out 2024-05-05 02:20:20.3936... @@ -886,422 +886,10 @@ a | integer | | | select conname, contype, conkey from pg_constraint where conrelid = 'notnull_tbl1'::regclass; - conname | contype | conkey ----------+---------+-------- -(0 rows) - --- SET NOT NULL puts both back -ALTER TABLE notnull_tbl1 ALTER a SET NOT NULL; -\d notnull_tbl1 - Table "public.notnull_tbl1" - Column | Type | Collation | Nullable | Default ---------+---------+-----------+----------+--------- - a | integer | | not null | - -select conname, contype, conkey from pg_constraint where conrelid = 'notnull_tbl1'::regclass; ... |
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-05 02:16:56.617797614 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/triggers.out 2024-05-05 02:19:57.385699773 +0000 @@ -2465,1282 +2465,10 @@ create table parted (a int, b int, c text) partition by list (a); create table parted_1 partition of parted for values in (1) partition by list (b); -create table parted_1_1 partition of parted_1 for values in (1); -create function parted_trigfunc() returns trigger language plpgsql as $$ -begin - new.a = new.a + 1; - return new; -end; -$$; -insert into parted values (1, 1, 'uno uno v1'); -- works -create trigger t before insert or update or delete on parted - for each row execute function parted_trigfunc(); -insert into parted values (1, 1, 'uno uno v2'); -- fail -ERROR: moving row to another partition during a BEFORE FOR EACH ROW trigger is not supported -DETAIL: Before executing trigger "t", the row was to be in partition "public.parted_1_1". ... |
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-05 02:17:14.638739300 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/updatable_views.out 2024-05-05 02:19:49.214734600 +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/triggers.out C:/cirrus/build/testrun/recovery/027_stream_regress/data/re... --- C:/cirrus/src/test/regress/expected/triggers.out 2024-05-05 02:17:14.628020000 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2024-05-05 02:21:42.832636600 +0000 @@ -3046,701 +3046,7 @@ drop trigger child1_delete_trig on child1; drop trigger child2_insert_trig on child2; drop trigger child2_update_trig on child2; -drop trigger child2_delete_trig on child2; -drop trigger child3_insert_trig on child3; -drop trigger child3_update_trig on child3; -drop trigger child3_delete_trig on child3; -delete from parent; -NOTICE: trigger = parent_delete_trig, old table = (AAA,42), (BBB,42), (CCC,42) --- copy into parent sees tuples collected from children even if there --- is no transition-table trigger on the children -copy parent (a, b) from stdin; -NOTICE: trigger = parent_insert_trig, new table = (AAA,42), (BBB,42), (CCC,42) --- insert into parent with a before trigger on a child tuple before --- insertion, and we capture the newly modified row in parent format -create or replace function intercept_insert() returns trigger language plpgsql as ... |
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-05 02:17:14.638739300 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/updatable_views.out 2024-05-05 02:19:48.402233300 +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-05 02:16:54 +++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/updatable_views.out 2024-05-05 02:21:14 @@ -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/updatable_views.out /Users/admin/pgsql/build/testrun/recovery/027_... --- /Users/admin/pgsql/src/test/regress/expected/updatable_views.out 2024-05-05 02:16:54 +++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/updatable_views.out 2024-05-05 02:21:14 @@ -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/updatable_views.out /Users/admin/pgsql/build/testrun/regress/regre... --- /Users/admin/pgsql/src/test/regress/expected/updatable_views.out 2024-05-05 02:16:54 +++ /Users/admin/pgsql/build/testrun/regress/regress/results/updatable_views.out 2024-05-05 02:21:13 @@ -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/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-04 13:19:05.399648000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/without_overlaps.out 2024-05-04 13:21:30.331287000 +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-04 13:18:57.577121020 +0000 +++ /tmp/cirrus-ci-build/contrib/btree_gist/results/without_overlaps.out 2024-05-04 13:22:23.692957441 +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-04 13:18:47.462899221 +0000 +++ /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/without_overlaps.out 2024-05-04 13:22:54.226708994 +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-04 13:19:11.948279300 +0000 +++ C:/cirrus/build/testrun/btree_gist/regress/results/without_overlaps.out 2024-05-04 13:24:54.012511700 +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-04 13:18:11 +++ /Users/admin/pgsql/build/testrun/btree_gist/regress/results/without_overlaps.out 2024-05-04 13:22:53 @@ -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-04 11:21:07.723259000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2024-05-04 11:22:40.590877000... @@ -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-04 11:21:07.723259000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2024-05-04 11:23:16.6003220... @@ -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-04 11:21:07.723259000 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/sysviews.out 2024-05-04 11:22:39.626190000 +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-04 11:21:00.557873336 +0000 +++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/sysviews.out 2024-05-04 11:25:23.101855807 +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-04 11:21:00.557873336 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/sysviews.out 2024-05-04 11:24:19.441871376 +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-04 11:21:00.564859486 +0000 +++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2024-05-04 11:24:43.832729225... @@ -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-04 11:21:00.564859486 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2024-05-04 11:25:21.5326308... @@ -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-04 11:21:00.564859486 +0000 +++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/sysviews.out 2024-05-04 11:24:40.176732151 +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-04 11:21:13.202795700 +0000 +++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2024-05-04 11:23:56.829237100 +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-04 11:21:13.202795700 +0000 +++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2024-05-04 11:25:58.835102100 +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-04 11:21:13.202795700 +0000 +++ C:/cirrus/build/testrun/regress/regress/results/sysviews.out 2024-05-04 11:23:50.214435700 +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-04 11:21:23 +++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/sysviews.out 2024-05-04 11:23:48 @@ -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-04 11:21:23 +++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/sysviews.out 2024-05-04 11:24:34 @@ -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-04 11:21:23 +++ /Users/admin/pgsql/build/testrun/regress/regress/results/sysviews.out 2024-05-04 11:23:48 @@ -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/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/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) ... |