Horton

Replace lateral references to removed rels in subqueries

Alexander Korotkov <akorotkov@postgresql.org>

View on postgr.es
Commit: 466979ef031afff000f3f92b812b946cf3a416c1
Author: Alexander Korotkov <akorotkov@postgresql.org>
Date: 2024-02-23T22:35:17Z
Releases: 17.0 
Replace lateral references to removed rels in subqueries

This commit introduces a new field 'sublevels_up' in ReplaceVarnoContext,
and enhances replace_varno_walker() to:
  1) recurse into subselects with sublevels_up increased, and
  2) perform the replacement only when varlevelsup is equal to sublevels_up.

This commit also fixes some outdated comments.  And besides adding relevant
test cases, it makes some unification over existing SJE test cases.

Discussion: https://postgr.es/m/CAMbWs4-%3DPO6Mm9gNnySbx0VHyXjgnnYYwbN9dth%3DTLQweZ-M%2Bg%40mail.gmail.com
Author: Richard Guo
Reviewed-by: Andrei Lepikhov, Alexander Korotkov

Files

PathChange+/−
src/backend/optimizer/plan/analyzejoins.c modified +76 −71
src/test/regress/expected/join.out modified +141 −137
src/test/regress/sql/join.sql modified +120 −98

Discussion