spatialite problems with reserved word column name #12230
Labels
Bug
Either a bug report, or a bug fix. Let's hope for the latter!
Data Provider
Related to specific vector, raster or mesh data providers
Milestone
Author Name: barryrowlingson - (barryrowlingson -)
Original Redmine Issue: 2170
Redmine category:data_provider
Assignee: nobody -
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!]
The text was updated successfully, but these errors were encountered: