diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/join.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/join.out
--- C:/cirrus/src/test/regress/expected/join.out	2025-02-18 17:03:27.106334900 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/join.out	2025-02-18 17:06:00.896584800 +0000
@@ -5874,16 +5874,16 @@
 explain (costs off)
 select d.* from d left join (select * from b group by b.id, b.c_id) s
   on d.a = s.id;
-                QUERY PLAN                
-------------------------------------------
- Merge Right Join
-   Merge Cond: (b.id = d.a)
-   ->  Group
-         Group Key: b.id
-         ->  Index Scan using b_pkey on b
-   ->  Sort
-         Sort Key: d.a
-         ->  Seq Scan on d
+              QUERY PLAN               
+---------------------------------------
+ Hash Left Join
+   Hash Cond: (d.a = s.id)
+   ->  Seq Scan on d
+   ->  Hash
+         ->  Subquery Scan on s
+               ->  HashAggregate
+                     Group Key: b.id
+                     ->  Seq Scan on b
 (8 rows)
 
 -- similarly, but keying off a DISTINCT clause