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

Re: Bug 4906 -- Left join of subselect incorrect

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mathieu Fenniak <mathieu(at)fenniak(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug 4906 -- Left join of subselect incorrect
Date: 2009-07-21 02:05:25
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
Mathieu Fenniak <mathieu(at)fenniak(dot)net> writes:
> After running the attached setup.sql.gz SQL script on a PostgreSQL  
> 8.4.0 database, the following two queries which should be logically  
> identical return different results.  As far as I can tell from the  
> query analysis, the LEFT JOIN on query A is happening after  
> "ee.projectid = pc.projectid" is filtered; therefore the rows where  
> projectid is NULL are not visible in query A.

This should fix it.  Thanks for the report!

			regards, tom lane

In response to


pgsql-bugs by date

Next:From: Pavel StehuleDate: 2009-07-21 06:13:45
Subject: Re: fix: plpgsql: return query and dropped columns problem
Previous:From: Tom LaneDate: 2009-07-21 01:48:29
Subject: Re: BUG #4929: Corrupted pg_class, possibly truncate/rollback related

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