diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out	2024-09-06 13:46:23.183518567 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out	2024-09-06 13:47:58.413249777 +0000
@@ -1112,10 +1112,10 @@
   and exists ( select 1 from tenk1 c where b.hundred = c.hundred
                    and not exists ( select 1 from tenk1 d
                                     where a.thousand = d.thousand ) );
- thousand 
-----------
-(0 rows)
-
+ERROR:  deadlock detected
+DETAIL:  Process 17524 waits for AccessShareLock on relation 24410 of database 16387; blocked by process 17528.
+Process 17528 waits for AccessExclusiveLock on relation 16421 of database 16387; blocked by process 17524.
+HINT:  See server log for query details.
 --
 -- Check that nested sub-selects are not pulled up if they contain volatiles
 --