"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)-
"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
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
"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
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