Replace relids in lateral subquery parse tree during SJE
Alexander Korotkov <akorotkov@postgresql.org>
Replace relids in lateral subquery parse tree during SJE Reported-by: Alexander Lakhin Discussion: https://postgr.es/m/56ee4520-e9d1-d519-54fe-c8bff880ce9b%40gmail.com Author: Alexander Korotkov, Andrei Lepikhov
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/optimizer/plan/analyzejoins.c | modified | +28 −1 |
| src/test/regress/expected/join.out | modified | +44 −0 |
| src/test/regress/sql/join.sql | modified | +12 −0 |
Discussion
- Removing unneeded self joins 246 messages · 2018-05-16 → 2025-07-15