[QGIS-trac] [Quantum GIS] #2007: Query builders LIKE statement treats every string like '%string%' with DBF backend

[Quantum GIS]

#2007: Query builders LIKE statement treats every string like '%string%' with DBF
backend
------------------------------------------------+---------------------------
   Reporter:  marisn                            |              Owner:  nobody
       Type:  bug                               |             Status:  new   
   Priority:  major: does not work as expected  |          Milestone:        
  Component:  Vectors                           |            Version:  HEAD  
   Keywords:  SQL                               |   Platform_version:        
   Platform:  Gentoo                            |           Must_fix:  No    
Status_info:  0                                 |  
------------------------------------------------+---------------------------
 Steps to reproduce:
  * Open Shapefile;
  * Open attribute table;
  * Open query builder;
  * Create following query:
 {{{
 mycolumn LIKE 'A%'
 }}}
  * Test result.
 Result set should contain only mycolumn entries that start with "A"
 letter, still they will contain also any entry that has "A" letter in it.
 Seems like "%" and "_" are ignored and string is allways treated like "%%"
 one.

 I have no idea if it's only DBF related (limitation?) or not, but as
 queries in query builder return wrong data sets, something must be done to
 warn user about QGIS specific SQL dialect, if it's not possible to fix
 this issue.

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