diff -U3 /Users/admin/pgsql/src/test/regress/expected/join.out /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/join.out --- /Users/admin/pgsql/src/test/regress/expected/join.out 2025-02-08 05:36:13 +++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/join.out 2025-02-08 05:39:29 @@ -5966,6 +5966,8 @@ -> Seq Scan on c (7 rows) +-- check the case when placeholder relates on an outer join and its inner in the +-- phrels field but actually uses only outer side of the join. explain (costs off) SELECT q.val FROM b LEFT JOIN ( SELECT (q1.z IS NOT NULL) AS val