diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/subselect.out --- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2024-09-18 00:26:11.042788761 +0000 +++ /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/subselect.out 2024-09-18 00:34:21.184755408 +0000 @@ -1043,19 +1043,10 @@ select count(*) from tenk1 t where (exists(select 1 from tenk1 k where k.unique1 = t.unique2) or ten < 0) and thousand = 1; - QUERY PLAN --------------------------------------------------------------- - Aggregate - -> Bitmap Heap Scan on tenk1 t - Recheck Cond: (thousand = 1) - Filter: (EXISTS(SubPlan 1) OR (ten < 0)) - -> Bitmap Index Scan on tenk1_thous_tenthous - Index Cond: (thousand = 1) - SubPlan 1 - -> Index Only Scan using tenk1_unique1 on tenk1 k - Index Cond: (unique1 = t.unique2) -(9 rows) - +ERROR: deadlock detected +DETAIL: Process 67822 waits for AccessShareLock on relation 24499 of database 16384; blocked by process 67831. +Process 67831 waits for AccessExclusiveLock on relation 16418 of database 16384; blocked by process 67822. +HINT: See server log for query details. select count(*) from tenk1 t where (exists(select 1 from tenk1 k where k.unique1 = t.unique2) or ten < 0) and thousand = 1; diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/btree_index.out --- /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out 2024-09-18 00:26:10.962426856 +0000 +++ /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/btree_index.out 2024-09-18 00:34:24.948628840 +0000 @@ -158,13 +158,10 @@ set enable_bitmapscan to false; explain (costs off) select hundred, twenty from tenk1 where hundred < 48 order by hundred desc limit 1; - QUERY PLAN --------------------------------------------------------- - Limit - -> Index Scan Backward using tenk1_hundred on tenk1 - Index Cond: (hundred < 48) -(3 rows) - +ERROR: deadlock detected +DETAIL: Process 67834 waits for AccessShareLock on relation 24499 of database 16384; blocked by process 67831. +Process 67831 waits for AccessExclusiveLock on relation 16418 of database 16384; blocked by process 67834. +HINT: See server log for query details. select hundred, twenty from tenk1 where hundred < 48 order by hundred desc limit 1; hundred | twenty ---------+--------