Re: BUG #3012: Wrong JOIN order when a JOIN depends on result from a LEFT JOIN.

From: Pelle Johansson <morth(at)morth(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3012: Wrong JOIN order when a JOIN depends on result from a LEFT JOIN.
Date: 2007-02-19 09:13:35
Message-ID: CB4E41BE-E528-40C8-BE32-CD3922CCA0EF@morth.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


16 feb 2007 kl. 22.00 skrev Tom Lane:

> "Pelle Johansson" <morth(at)morth(dot)org> writes:
>> We have a join where we select which row to join on a subquery with a
>> coalesce on a column from a left join, which is not working as
>> expected.
>
> The attached patch should fix this.

Hi Tom,

Thanks for the quick fix. We don't really have any good way to apply
the patch, so we'll just use our workaround in the mean time, but
it's good to know the issue is resolved.
--
Pelle Johansson

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Dr. Axel Reimann 2007-02-19 13:43:18 BUG #3030: Unable to query SQL_WCHAR column via ODBC
Previous Message Tom Lane 2007-02-18 21:58:52 Re: BUG #3015: libpq: PQftype() on a lo type result column returns Oid of type oid instead of Oid of type lo.