]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Repair incorrect placement of WHERE clauses when there are multiple,
authorTom Lane <tgl@sss.pgh.pa.us>
Thu, 7 Dec 2006 19:33:48 +0000 (19:33 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 7 Dec 2006 19:33:48 +0000 (19:33 +0000)
commit373bd34e739026e100a231f345bf4d90c900df90
tree90052189e815d14a175f243650399929873b22ba
parentf07f11efde864eff63f8a4036d6286bac40611b2
Repair incorrect placement of WHERE clauses when there are multiple,
rearrangeable outer joins and the WHERE clause is non-strict and mentions
only nullable-side relations.  New bug in 8.2, caused by new logic to allow
rearranging outer joins.  Per bug #2807 from Ross Cohen; thanks to Jeff
Davis for producing a usable test case.
src/backend/optimizer/plan/initsplan.c