diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_distinct.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/select_distinct.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_distinct.out	2024-11-10 08:02:03.281456243 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/select_distinct.out	2024-11-10 08:09:41.059513964 +0000
@@ -334,13 +334,10 @@
 -- Ensure we get a plan with a Limit 1 when the SELECT list contains constants
 EXPLAIN (COSTS OFF)
 SELECT DISTINCT four,1,2,3 FROM tenk1 WHERE four = 0;
-         QUERY PLAN         
-----------------------------
- Limit
-   ->  Seq Scan on tenk1
-         Filter: (four = 0)
-(3 rows)
-
+ERROR:  deadlock detected
+DETAIL:  Process 44282 waits for AccessShareLock on relation 25202 of database 16387; blocked by process 44274.
+Process 44274 waits for AccessExclusiveLock on relation 16421 of database 16387; blocked by process 44282.
+HINT:  See server log for query details.
 -- Ensure we only get 1 row
 SELECT DISTINCT four,1,2,3 FROM tenk1 WHERE four = 0;
  four | ?column? | ?column? | ?column?