Re: [BUGS] BUG #5645: Query Optimizer fails when it encounters an unsatisfiable part of a query

2010-09-06 Thread Tom Lane
"Daniel Wagner" writes: > I posted this earlier on the general mailing list and received no reply. I > assume I found a genuine bug: > "select * from kvstore where deviceid = 7 AND (locid >= 1410929 AND locid <= > 1690468) OR (locid = 1690469 and locid <= 1690468)" No, you're just expecting the o

[BUGS] BUG #5645: Query Optimizer fails when it encounters an unsatisfiable part of a query

2010-09-06 Thread Daniel Wagner
The following bug has been logged online: Bug reference: 5645 Logged by: Daniel Wagner Email address: dt...@cam.ac.uk PostgreSQL version: 8.4.4 Operating system: tested under Linux (Ubuntu 10.4) and Windows (7) Description:Query Optimizer fails when it encounters an u