diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/join.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/join.out	2024-08-24 07:40:23.494058144 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/join.out	2024-08-24 07:47:51.400754163 +0000
@@ -2273,10 +2273,10 @@
 select aa, bb, unique1, unique1
   from tenk1 right join b_star on aa = unique1
   where bb < bb and bb is null;
- aa | bb | unique1 | unique1 
-----+----+---------+---------
-(0 rows)
-
+ERROR:  deadlock detected
+DETAIL:  Process 49135 waits for AccessShareLock on relation 24465 of database 16384; blocked by process 49132.
+Process 49132 waits for AccessExclusiveLock on relation 16418 of database 16384; blocked by process 49135.
+HINT:  See server log for query details.
 --
 -- regression test: check handling of empty-FROM subquery underneath outer join
 --