diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/join.out /tmp/cirrus-ci-build/src/test/regress/results/join.out --- /tmp/cirrus-ci-build/src/test/regress/expected/join.out 2025-02-06 08:04:18.082340677 +0000 +++ /tmp/cirrus-ci-build/src/test/regress/results/join.out 2025-02-06 08:08:55.559260751 +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