pgsql: Fix setrefs.c code for Result Cache nodes

From: David Rowley <drowley(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix setrefs.c code for Result Cache nodes
Date: 2021-05-25 00:51:08
Message-ID: E1llLHo-0005OQ-Tz@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix setrefs.c code for Result Cache nodes

Result Cache, added in 9eacee2e6 neglected to properly adjust the plan
references in setrefs.c. This could lead to the following error during
EXPLAIN:

ERROR: cannot decompile join alias var in plan tree

Fix that.

Bug: 17030
Reported-by: Hans Buschmann
Discussion: https://postgr.es/m/17030-5844aecae42fe223@postgresql.org

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/cba5c70b956810c61b3778f7041f92fbb8065acb

Modified Files
--------------
src/backend/optimizer/plan/setrefs.c | 6 ++++++
src/test/regress/expected/join.out | 26 +++++++++++++-------------
2 files changed, 19 insertions(+), 13 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Michael Paquier 2021-05-25 01:12:13 pgsql: Disallow SSL renegotiation
Previous Message Peter Geoghegan 2021-05-25 00:14:27 pgsql: Consider triggering VACUUM failsafe during scan.