Opened 14 years ago
Closed 14 years ago
#2170 closed bug (fixed)
spatialite problems with reserved word column name
Reported by: | Barryrowlingson | Owned by: | nobody |
---|---|---|---|
Priority: | major: does not work as expected | Milestone: | Version 1.4.0 |
Component: | Data Provider | Version: | Trunk |
Keywords: | Cc: | a.furieri@… | |
Must Fix for Release: | No | Platform: | Linux |
Platform Version: | Awaiting user input: | no |
Description
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!]
Attachments (1)
Change History (3)
comment:1 by , 14 years ago
Cc: | added |
---|
by , 14 years ago
Attachment: | crazydb.zip added |
---|
comment:2 by , 14 years ago
Resolution: | → fixed |
---|---|
Status: | new → closed |
fixed in rev.12324
I've attached the sample DB I used for actual testing