Re: BUG #10667: [9.2.4] Incorrect output for query involving where clause with coalesce

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: tgarnett(at)panjiva(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #10667: [9.2.4] Incorrect output for query involving where clause with coalesce
Date: 2014-06-16 23:29:36
Message-ID: 25490.1402961376@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

tgarnett(at)panjiva(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message maxim.boguk 2014-06-17 03:24:38 BUG #10675: alter database set tablespace and unlogged table
Previous Message professor 2014-06-16 22:03:46 BUG #10674: syntax error with CREATE TABLE table AS SELECT (column1, column 2) FROM table2