Skip site navigation (1) Skip section navigation (2)

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

From: Klint Gore <kg(at)kgb(dot)une(dot)edu(dot)au>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org,Kevin Grittner <kevin(dot)grittner(at)wicourts(dot)gov>
Subject: Re: BUG #1916: selection criteria from one outer join on clause applied to other joins
Date: 2005-09-28 05:36:05
Message-ID: 433A2BC51ED.6406KG@129.180.47.120 (view raw or flat)
Thread:
Lists: pgsql-bugs
On Wed, 28 Sep 2005 00:34:37 -0400, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Kevin Grittner" <kevin(dot)grittner(at)wicourts(dot)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(at)kgb(dot)une(dot)edu(dot)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             :                 :
+---------------------------------------+-----------------+

In response to

pgsql-bugs by date

Next:From: Chris TraversDate: 2005-09-28 06:03:28
Subject: Re: HELP
Previous:From: Tom LaneDate: 2005-09-28 04:34:37
Subject: Re: BUG #1916: selection criteria from one outer join on clause applied to other joins

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group