[QGIS-trac] Re: [Quantum GIS] #3111: filtering of shapefile with query builder not working when using 'excluding' query

[Quantum GIS]

#3111: filtering of shapefile with query builder not working when using
'excluding' query
------------------------------------------------+---------------------------
   Reporter:  nirvn                             |              Owner:  jef          
       Type:  bug                               |             Status:  new          
   Priority:  major: does not work as expected  |          Milestone:  Version 1.6.0
  Component:  Vectors                           |            Version:               
   Keywords:                                    |   Platform_version:               
   Platform:  All                               |           Must_fix:  Yes          
Status_info:  0                                 |  
------------------------------------------------+---------------------------

Old description:

> 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.

New description:

 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.

--

Comment(by jef):

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

-- 
Ticket URL: <https://trac.osgeo.org/qgis/ticket/3111#comment:2>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats