#1930: Quote column names when creating tables via sqlite
-------------------------+--------------------------------------------------
Reporter: scw | Owner: grass-dev@…
Type: defect | Status: new
Priority: normal | Milestone: 7.0.0
Component: Default | Version: unspecified
Keywords: | Platform: Unspecified
Cpu: Unspecified |
-------------------------+--------------------------------------------------
I have an input table which includes the column 'unique', and it failed to
import, with the error:
{{{
DBMI-SQLite driver error:
Error in sqlite3_prepare():
near "varchar": syntax error
}}}
This is due to "unique" being a reserved keyword in SQLite. This can be
fixed by quoting column names prior to passing them to SQLite, see this
page for details: http://www.sqlite.org/lang_keywords.html