diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/join.out --- /tmp/cirrus-ci-build/src/test/regress/expected/join.out 2026-03-02 09:11:39.026275251 +0000 +++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/join.out 2026-03-02 09:19:59.783608426 +0000 @@ -10079,16 +10079,16 @@ select * from hjbucket h1 join hjbucket h2 on h1.val = h2.val where h1.filt = 5; - QUERY PLAN ----------------------------------------------------------- + QUERY PLAN +---------------------------------------------------- Hash Join - Hash Cond: (h2.val = h1.val) - -> Seq Scan on hjbucket h2 + Hash Cond: (h1.val = h2.val) + -> Bitmap Heap Scan on hjbucket h1 + Recheck Cond: (filt = 5) + -> Bitmap Index Scan on hjbucket_filt_idx + Index Cond: (filt = 5) -> Hash - -> Bitmap Heap Scan on hjbucket h1 - Recheck Cond: (filt = 5) - -> Bitmap Index Scan on hjbucket_filt_idx - Index Cond: (filt = 5) + -> Seq Scan on hjbucket h2 (8 rows) reset work_mem;