git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit

Repair incorrect placement of WHERE clauses when there are multiple,

author Tom Lane <tgl@sss.pgh.pa.us>

Thu, 7 Dec 2006 19:33:40 +0000 (19:33 +0000)

committer Tom Lane <tgl@sss.pgh.pa.us>

Thu, 7 Dec 2006 19:33:40 +0000 (19:33 +0000)

commit 8124215cc39a6c1f15ab8555c9fae4d776b6d9fd

tree d0f1feabbe2e5b7b669341afeadeec822b97b4fe tree

parent b307d7a6c4af2de8b6b25d5614152f7cd4378f03 commit | diff

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 diff | blob | blame | history

This is the main PostgreSQL git repository.

RSS Atom