Re: BUG #3588: coalesce not working in join

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Richard Harris" <richard_haris(at)adp(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3588: coalesce not working in join
Date: 2007-08-30 00:00:01
Message-ID: 13471.1188432001@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Richard Harris" <richard_haris(at)adp(dot)com> writes:
> Is PG 8.2.4 behavior correct?

Nope :-( ... looks like some sorta bug in the rules for when outer
joins can be rearranged. It's doing the t1a/t1b join first, and
then taking that as the right side of the join to t2, which means
that the t1b column goes to null if there's not a match to t2.pkt2.
Needs some study ...

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message fuminori ido 2007-08-30 03:02:54 BUG #3589: /etc/init.d/postgresql reload doesn't reflect /etc/postgresql/postgresql.conf log_statement
Previous Message Tom Lane 2007-08-29 23:34:10 Re: BUG #3587: EXECUTE and trigger problem [VASCL:A163D284A86]