Skip site navigation (1) Skip section navigation (2)

pgsql: Improve EXPLAIN's ability to cope with LATERAL references inpla

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Improve EXPLAIN's ability to cope with LATERAL references inpla
Date: 2012-08-30 16:57:06
Message-ID: E1T783G-00058H-D7@gemulon.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Improve EXPLAIN's ability to cope with LATERAL references in plans.

push_child_plan/pop_child_plan didn't bother to adjust the "ancestors"
list of parent plan nodes when descending to a child plan node.  I think
this was okay when it was written, but it's not okay in the presence of
LATERAL references, since a subplan node could easily be returning a
LATERAL value back up to the same nestloop node that provides the value.
Per changed regression test results, the omission led to failure to
interpret Param nodes that have perfectly good interpretations.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/d1a4db8d25ec53fd17e99168bc5efa0b16ef6fed

Modified Files
--------------
src/backend/utils/adt/ruleutils.c  |   18 ++++++++++--------
src/test/regress/expected/join.out |    2 +-
2 files changed, 11 insertions(+), 9 deletions(-)

pgsql-committers by date

Next:From: Robert HaasDate: 2012-08-30 17:10:02
Subject: pgsql: Fix logic bug in gistchoose andgistRelocateBuildBuffersOnSplit.
Previous:From: Robert HaasDate: 2012-08-30 14:42:50
Subject: pgsql: Comment fixes.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group