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

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Kevin Grittner" <kevin(dot)grittner(at)wicourts(dot)gov>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1916: selection criteria from one outer join on clause applied to other joins
Date: 2005-09-28 04:34:37
Message-ID: 1909.1127882077@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"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?

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Klint GoreDate: 2005-09-28 05:36:05
Subject: Re: BUG #1916: selection criteria from one outer join on clause applied to other joins
Previous:From: Theo SchlossnagleDate: 2005-09-28 03:21:16
Subject: BUG #1917: autovaccuum crashes

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