When I tried our test suite against 9.2.1 one of the tests failed,
it looked really strange, the query had returned a row which could
impossibly match the WHERE statement.
I heard on #postgresql this bug has already been reported.
If helpful, here is a simple test to reproduce the problem:
From what I understand from the discussion, this "bug" or behaviour
has been around for quite some time, dating back to 7.4,
perhaps not exactly the same in all major versions though.
Would you recommend me to rewrite all queries of this particular
type, where you have COALESCE in the WHERE statement,
as a precaution?
We haven't migrated to 9.2 yet, but perhaps there is a risk
similar queries can render the same problems even in 9.1?
pgsql-hackers by date
|Next:||From: Jeff Janes||Date: 2012-11-02 20:06:56|
|Subject: Re: Synchronous commit not... synchronous?|
|Previous:||From: Merlin Moncure||Date: 2012-11-02 19:05:47|
|Subject: Re: Unresolved error 0xC0000409 on Windows Server|