From: | David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | 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 19:32:04 |
Message-ID: | 1402947124302-5807418.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Timothy Garnett wrote
> The following bug has been logged on the website:
>
> Bug reference: 10667
> Logged by: Timothy Garnett
> Email address:
> tgarnett@
> PostgreSQL version: 9.2.4
> Operating system: Ubuntu Linux x86_64 12.04.3 LTS
> Description:
>
> Hi All,
>
> 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.
If you cannot reproduce this in 9.2.8 - the most recent version - then you
either need to work around it or upgrade. Reporting a bug on a 4 behind
point version does little good.
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/BUG-10667-9-2-4-Incorrect-output-for-query-involving-where-clause-with-coalesce-tp5807410p5807418.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2014-06-16 20:30:40 | Re: BUG #10667: [9.2.4] Incorrect output for query involving where clause with coalesce |
Previous Message | Alvaro Herrera | 2014-06-16 19:31:14 | Re: BUG #10667: [9.2.4] Incorrect output for query involving where clause with coalesce |