OSDN Git Service

Repair incorrect placement of WHERE clauses when there are multiple,
authorTom Lane <tgl@sss.pgh.pa.us>
Thu, 7 Dec 2006 19:33:40 +0000 (19:33 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 7 Dec 2006 19:33:40 +0000 (19:33 +0000)
commit8124215cc39a6c1f15ab8555c9fae4d776b6d9fd
treed0f1feabbe2e5b7b669341afeadeec822b97b4fe
parentb307d7a6c4af2de8b6b25d5614152f7cd4378f03
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