diff -U3 /Users/admin/pgsql/src/test/regress/expected/subselect.out /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/subselect.out
--- /Users/admin/pgsql/src/test/regress/expected/subselect.out	2024-03-07 16:38:08
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/subselect.out	2024-03-07 16:42:05
@@ -2016,16 +2016,16 @@
                    QUERY PLAN                    
 -------------------------------------------------
  Hash Join
-   Hash Cond: (c.odd = b.odd)
+   Hash Cond: (c.hundred = a.hundred)
    ->  Hash Join
-         Hash Cond: (a.hundred = c.hundred)
-         ->  Seq Scan on tenk1 a
+         Hash Cond: (b.odd = c.odd)
+         ->  Seq Scan on tenk2 b
          ->  Hash
                ->  HashAggregate
                      Group Key: c.odd, c.hundred
                      ->  Seq Scan on tenk2 c
    ->  Hash
-         ->  Seq Scan on tenk2 b
+         ->  Seq Scan on tenk1 a
 (11 rows)
 
 -- we can pull up the aggregate sublink into RHS of a left join.