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.
Yeah, it seems to be confused about whether it can interchange the
order of the semijoin and left join. I'll take a look.
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2009-07-20 23:54:10|
|Subject: Re: BUG #4929: Corrupted pg_class, possibly truncate/rollback related |
|Previous:||From: Andrew Gierth||Date: 2009-07-20 23:05:22|
|Subject: Re: BUG #4929: Corrupted pg_class, possibly