Repair planning bug introduced in 7.4: outer-join ON clauses that referenced
Tom Lane <tgl@sss.pgh.pa.us>
Repair planning bug introduced in 7.4: outer-join ON clauses that referenced only the inner-side relation would be considered as potential equijoin clauses, which is wrong because the condition doesn't necessarily hold above the point of the outer join. Per test case from Kevin Grittner (bug#1916).
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/optimizer/plan/initsplan.c | modified | +62 −15 |
| src/backend/optimizer/plan/planmain.c | modified | +2 −2 |
| src/include/optimizer/planmain.h | modified | +3 −2 |