| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
| Cc: | "listar" <listar(at)mail(dot)ru>, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #6154: wrong result with nested left-joins |
| Date: | 2011-08-08 15:01:32 |
| Message-ID: | 25701.1312815692@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> writes:
> "listar" <listar(at)mail(dot)ru> wrote:
>> PostgreSQL version: 8.4.5
>> Description: wrong result with nested left-joins
>> And this is the problem - value2 can't be NULL because of COALESCE
>> in sub4 (at least I think that it can't be =))
> This works correctly in release 9.0.4 and development HEAD. I
> don't still have any machines handy which are running 8.4, but you
> might want to try it on the latest bug-fix version of 8.4 (currently
> 8.4.8) to see if the fix was back-patched.
It works for me too in 8.4.recent; but I believe the relevant fix is in
8.4.5, which makes me doubt the OP's report of his server version.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ai | 2011-08-08 15:08:05 | Re: BUG #6154: wrong result with nested left-joins |
| Previous Message | ai | 2011-08-08 14:37:07 | Re: BUG #6154: wrong result with nested left-joins |