pgsql: Fix buggy recursion in flatten_rtes_walker().

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix buggy recursion in flatten_rtes_walker().
Date: 2023-02-13 17:20:02
Message-ID: E1pRcUj-000xg1-Fq@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix buggy recursion in flatten_rtes_walker().

Must save-and-restore the context we are modifying.
Oversight in commit a61b1f748.

Tender Wang

Discussion: https://postgr.es/m/CAHewXNnnNySD_YcKNuFpQDV2gxWA7_YLWqHmYVcyoOYxn8kY2A@mail.gmail.com
Discussion: https://postgr.es/m/20230212233711.GA1316@telsasoft.com

Branch
------
master

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

Modified Files
--------------
src/backend/optimizer/plan/setrefs.c | 13 +++++++++----
src/test/regress/expected/join.out | 12 ++++++++++++
src/test/regress/sql/join.sql | 6 ++++++
3 files changed, 27 insertions(+), 4 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2023-02-13 18:35:48 pgsql: When removing a relation from the query, drop its RelOptInfo.
Previous Message Tom Lane 2023-02-13 16:45:45 pgsql: Fix thinkos in have_unsafe_outer_join_ref; reduce to Assert chec