Re: BUG #6154: wrong result with nested left-joins

"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