Thread: pgsql: Fix miscomputation of direct_lateral_relids for join relations.
Fix miscomputation of direct_lateral_relids for join relations. If a PlaceHolderVar is to be evaluated at a join relation, but its value is only needed there and not at higher levels, we neglected to update the joinrel's direct_lateral_relids to include the PHV's source rel. This causes problems because join_is_legal() then won't allow joining the joinrel to the PHV's source rel at all, leading to "failed to build any N-way joins" planner failures. Per report from Andreas Seltenreich. Back-patch to 9.5 where the problem originated. Discussion: https://postgr.es/m/87blfgqa4t.fsf@aurora.ydns.eu Branch ------ REL_10_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/785f4462daaf6897ab3ac56b3170c2f988d0e93f Modified Files -------------- src/backend/optimizer/util/placeholder.c | 38 +++++++++++++------ src/test/regress/expected/join.out | 64 ++++++++++++++++++++++++++++++++ src/test/regress/sql/join.sql | 27 ++++++++++++++ 3 files changed, 118 insertions(+), 11 deletions(-)