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

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 (view raw or flat)
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

pgsql-bugs by date

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

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