Re: BUG #6154: wrong result with nested left-joins - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #6154: wrong result with nested left-joins
Date
Msg-id 9240.1312827077@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #6154: wrong result with nested left-joins  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: BUG #6154: wrong result with nested left-joins
List pgsql-bugs
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> "ai" <listar@mail.ru> wrote:
>> Oops.. I just saw, that I send you "correct" (already with
> "workaround")
>> sql-code instead of "wrong"...

>> here is "wrong" (difference is in "SELECT sub3.key3, sub4.value2
> FROM" ):

> OK, that is still happening, and looks wrong to me.

Yeah, I see it too.  It seems to be evaluating the placeholder for the
COALESCE expression at the wrong join level.  Not sure why, yet.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "ai"
Date:
Subject: Re: BUG #6154: wrong result with nested left-joins
Next
From: "listar"
Date:
Subject: BUG #6155: literal definition of arrays with double qoutes leads to error