filtering of shapefile with query builder not working when using 'excluding' query

[nirvn]

Let's say you have 4 polygons in a shapefile

id	name
0	polygon-a
1	polygon-b
2	polygon-c
3	polygon-d

If you filter the shapefile using this query:

id = 1 AND id = 2 AND id = 3

QGIS will properly display only the polygons with id 1, 2 and 3.

However, if you filter the shapefile using this query:

id != 0

QGIS will fail to eliminate polygon with id 0.

The problem started to occur 2 days ago.

[nirvn]

Sorry, first query should be:

id = 1 OR id = 2 OR id = 3

Need some sleep...

[jef]

Please include a shapefile and report the OGR version you are using.

[nirvn]

Wow, turns out the shapefile had - unknown to me until now - duplicates of a number of polygons, including the one I was trying to hide.

Sorry for the noise, closing this => invalid.