diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/join.out --- /tmp/cirrus-ci-build/src/test/regress/expected/join.out 2025-02-06 08:04:18.843520382 +0000 +++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/join.out 2025-02-06 08:10:04.705421217 +0000 @@ -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