diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/join.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/join.out	2024-09-08 13:02:26.824429276 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/join.out	2024-09-08 13:05:46.672008969 +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 24473 waits for AccessShareLock on relation 24406 of database 16387; blocked by process 24467.
+Process 24467 waits for AccessExclusiveLock on relation 16421 of database 16387; blocked by process 24473.
+HINT:  See server log for query details.
 --
 -- regression test: check handling of empty-FROM subquery underneath outer join
 --