pgsql: Fix setrefs.c code for Result Cache nodes

От:

David Rowley <drowley@postgresql.org>

Дата:

25 мая 2021 г. в 00:51:08

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(-)