Horton

Re: Joins on over 10 tables returns unreliable results

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: jeffery.l.seaman@intel.com, pgsql-bugs@postgresql.org
Date: 2000-11-02T07:41:28Z
Lists: pgsql-bugs 
pgsql-bugs@postgresql.org writes:
> Running Postgres version 7.01 on Redhat linux 6.2.  When joining on
> more than 10 tables not all of the expected results are returned.

Do you get a query plan involving mergejoins for these queries?
If so it's probably fixed for 7.0.3, please try that as soon as
it's out...

			regards, tom lane