[QGIS-trac] [Quantum GIS] #2170: spatialite problems with reserved word column name

[Quantum GIS]

#2170: spatialite problems with reserved word column name
------------------------------------------------+---------------------------
   Reporter:  Barryrowlingson                   |              Owner:  nobody       
       Type:  bug                               |             Status:  new          
   Priority:  major: does not work as expected  |          Milestone:  Version 1.4.0
  Component:  Data Provider                     |            Version:  HEAD         
   Keywords:                                    |   Platform_version:               
   Platform:  Linux                             |           Must_fix:  No           
Status_info:  0                                 |  
------------------------------------------------+---------------------------
 I have a spatialite table with a column called 'UPDATE'. Loading into Qgis
 causes problems accessing the attributes. The attribute table comes up all
 'ERROR', and querying points on the map cause error messages and the map
 layer points to all disappear. Pretty reproducible.

 Streams of these appear:

 SQL: near "UPDATE": syntax error
 Critical: SQLite error: SELECT ROWID, TYPE, SITECODE, DATE, UPDATE, [etc]

  which looks like column names are unquoted and so reserved words for
 column names will break stuff.

 [This database was full of tricksy names, such as tables called "region-
 code" and "stuff with spaces" that needed quoting and munging as I
 converted it from mdb to spatialite. Thought I'd got 'em all!]

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