Re: BUG #1916: selection criteria from one outer join on clause applied to other joins - Mailing list pgsql-bugs

From Klint Gore
Subject Re: BUG #1916: selection criteria from one outer join on clause applied to other joins
Date
Msg-id 433A2BC51ED.6406KG@129.180.47.120
Whole thread Raw
In response to Re: BUG #1916: selection criteria from one outer join on clause applied to other joins  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Wed, 28 Sep 2005 00:34:37 -0400, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Kevin Grittner" <kevin.grittner@wicourts.gov> 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 earlier
> branches?

fails on 7.4.7 (rh9) and 8.0.0 (win) for me.

klint.

+---------------------------------------+-----------------+
: Klint Gore                            : "Non rhyming    :
: EMail   : kg@kgb.une.edu.au           :  slang - the    :
: Snail   : A.B.R.I.                    :  possibilities  :
: Mail      University of New England   :  are useless"   :
:           Armidale NSW 2351 Australia :     L.J.J.      :
: Fax     : +61 2 6772 5376             :                 :
+---------------------------------------+-----------------+

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #1916: selection criteria from one outer join on clause applied to other joins
Next
From: Chris Travers
Date:
Subject: Re: HELP