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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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