Horton

Fix buggy recursion in flatten_rtes_walker().

Tom Lane <tgl@sss.pgh.pa.us>

View on postgr.es
Commit: c7468c73f7b6e842a53c12eaee5578a76a8fa7a6
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2023-02-13T17:19:58Z
Releases: 16.0 
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

Files

PathChange+/−
src/backend/optimizer/plan/setrefs.c modified +9 −4
src/test/regress/expected/join.out modified +12 −0
src/test/regress/sql/join.sql modified +6 −0

Discussion