Re: [BUGS] BUG #1916: selection criteria from one outer join on clause applied to other joins

2005-09-28 Thread Tom Lane
"Kevin Grittner" <[EMAIL PROTECTED]> writes: > Description:selection criteria from one outer join on clause applied > to other joins I've committed a fix for this. Many thanks for the test case. regards, tom lane ---(end of broadcast)-

Re: [BUGS] BUG #1916: selection criteria from one outer join on clause applied to other joins

2005-09-28 Thread Tom Lane
"Kevin Grittner" <[EMAIL PROTECTED]> writes: > Any idea on when a fix might be available, or what > conditions must exist in a query for this failure to occur? It would be fairly easy to fix just by disabling all consideration of deducing anything from outer-join conditions. I want to think a lit

Re: [BUGS] BUG #1916: selection criteria from one outer join on clause applied to other joins

2005-09-27 Thread Klint Gore
On Wed, 28 Sep 2005 00:34:37 -0400, Tom Lane <[EMAIL PROTECTED]> wrote: > "Kevin Grittner" <[EMAIL PROTECTED]> writes: > > Obviously, adding an outer join to a query which is already returning rows > > should never reduce the number of rows returned. > > I think this is a case of overenthusiastic

Re: [BUGS] BUG #1916: selection criteria from one outer join on clause applied to other joins

2005-09-27 Thread Tom Lane
"Kevin Grittner" <[EMAIL PROTECTED]> writes: > Obviously, adding an outer join to a query which is already returning rows > should never reduce the number of rows returned. I think this is a case of overenthusiastic propagation of implied equalities. Do you know offhand if it fails in 8.0.* or ea

[BUGS] BUG #1916: selection criteria from one outer join on clause applied to other joins

2005-09-27 Thread Kevin Grittner
The following bug has been logged online: Bug reference: 1916 Logged by: Kevin Grittner Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1beta2 Operating system: Linux and Windows Description:selection criteria from one outer join on clause applied to other join