forked frompostgres/postgres
- Notifications
You must be signed in to change notification settings - Fork6
Commitd0f9526
committed
Fix thinko in join removal.
In commit9df8f90 I (tgl) switched join_is_removable() fromusing the min relid sets of the join under consideration tousing its full syntactic relid sets. This was a mistake,as it allowed join removal in cases where a reference to thejoin output would survive in some syntactically-lower joincondition. Revert to the former coding.Richard GuoDiscussion:https://postgr.es/m/CAMbWs4-EU9uBGSP7G-iTwLBhRQ=rnZKvFDhD+n+xhajokyPCKg@mail.gmail.com1 parent70b42f2 commitd0f9526
File tree
3 files changed
+25
-7
lines changed- src
- backend/optimizer/plan
- test/regress
- expected
- sql
3 files changed
+25
-7
lines changedLines changed: 4 additions & 7 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
88 | 88 |
| |
89 | 89 |
| |
90 | 90 |
| |
91 |
| - | |
92 |
| - | |
93 |
| - | |
94 |
| - | |
95 |
| - | |
| 91 | + | |
| 92 | + | |
96 | 93 |
| |
97 | 94 |
| |
98 | 95 |
| |
| |||
204 | 201 |
| |
205 | 202 |
| |
206 | 203 |
| |
207 |
| - | |
208 |
| - | |
| 204 | + | |
| 205 | + | |
209 | 206 |
| |
210 | 207 |
| |
211 | 208 |
| |
|
Lines changed: 16 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
5432 | 5432 |
| |
5433 | 5433 |
| |
5434 | 5434 |
| |
| 5435 | + | |
| 5436 | + | |
| 5437 | + | |
| 5438 | + | |
| 5439 | + | |
| 5440 | + | |
| 5441 | + | |
| 5442 | + | |
| 5443 | + | |
| 5444 | + | |
| 5445 | + | |
| 5446 | + | |
| 5447 | + | |
| 5448 | + | |
| 5449 | + | |
| 5450 | + | |
5435 | 5451 |
| |
5436 | 5452 |
| |
5437 | 5453 |
| |
|
Lines changed: 5 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
1958 | 1958 |
| |
1959 | 1959 |
| |
1960 | 1960 |
| |
| 1961 | + | |
| 1962 | + | |
| 1963 | + | |
| 1964 | + | |
| 1965 | + | |
1961 | 1966 |
| |
1962 | 1967 |
| |
1963 | 1968 |
| |
|
0 commit comments
Comments
(0)