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

Re: Joins on over 10 tables returns unreliable results

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jeffery(dot)l(dot)seaman(at)intel(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Joins on over 10 tables returns unreliable results
Date: 2000-11-02 07:41:28
Message-ID: 24517.973150888@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
pgsql-bugs(at)postgresql(dot)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

In response to

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2000-11-02 09:34:08
Subject: JDBC-Driver produces wrong output.
Previous:From: Thomas LockhartDate: 2000-11-02 07:22:40
Subject: Re: RPM install weirdness & BugreportPage Bug

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