[QGIS-trac] Re: [Quantum GIS] #3030: Query Builder in Properties produces "Query Failed"

[Quantum GIS]

#3030: Query Builder in Properties produces "Query Failed"
-----------------------------------------------------+----------------------
        Reporter:  alobo                             |         Owner:  jef          
            Type:  bug                               |        Status:  closed       
        Priority:  major: does not work as expected  |     Milestone:  Version 1.6.0
       Component:  Vectors                           |       Version:  Trunk        
      Resolution:  upstream                          |      Keywords:               
Platform_version:  ubuntu 9.10                       |      Platform:  All          
        Must_fix:  Yes                               |   Status_info:  0            
-----------------------------------------------------+----------------------
Changes (by jef):

  * status:  reopened => closed
  * resolution:  => upstream


Comment:

 Seems to be an OGR (vector part of GDAL) problem:

 {{{
 ogrinfo -sql "SELECT * FROM polsfl1_1000 WHERE ID=12" polsfl1_1000.shp
 INFO: Open of `polsfl1_1000.shp'
       using driver `ESRI Shapefile' successful.
 ERROR 1: SQL: Unrecognised field name coords.x1.
 }}}

 Looks like the attributes with dots in the name are the actual problem for
 OGR (the query is the same as the one the OGR provider uses.

 I see the same on Windows, so I suppose Gerhard didn't use that shape,
 when testing on Windows.

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