Re: BUG #10667: [9.2.4] Incorrect output for query involving where clause with coalesce - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #10667: [9.2.4] Incorrect output for query involving where clause with coalesce
Date
Msg-id 25490.1402961376@sss.pgh.pa.us
Whole thread Raw
In response to BUG #10667: [9.2.4] Incorrect output for query involving where clause with coalesce  (tgarnett@panjiva.com)
List pgsql-bugs
tgarnett@panjiva.com writes:
> I'm not sure if this is appropriate to report or not since I'm only able to
> produce it in 9.2.4 (not able to produce it 9.3.4) but I didn't see anything
> in the change logs that looked specific to what we saw here [though this
> ("Fix incorrect planning in cases where the same non-strict expression
> appears in multiple WHERE and outer JOIN equality clauses (Tom Lane)") might
> be similar?] so thought it might be useful as a record if nothing else.

I think this is the same thing as bug #8049, which was fixed in 9.2.5.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #10667: [9.2.4] Incorrect output for query involving where clause with coalesce
Next
From: maxim.boguk@gmail.com
Date:
Subject: BUG #10675: alter database set tablespace and unlogged table