QGIS » QGIS Application

The changeset r8183 introduced the use of a reserved SQL word ('Column') as column name which renders the import of a graticule (SHAPE) file rather hard:

GRASS 6.5.svn (latlong_tbe_climate):~ > v.in.ogr italy_white_box_LL.shp out=italy_white_box_LL
Projection of input dataset and current location appear to match
Layer: italy_white_box_LL
DBMI-DBF driver error:
SQL parser error: syntax error, unexpected COLUMN, expecting NAME processing 'Column'
in statement:
create table italy_white_box_LL (cat integer, LabelX double precision, LabelY double precision, [[LblOffsetX]] integer, [[LblOffsetY]] integer, Label varchar ( 80 ), Row varchar ( 80 ), Column varchar ( 80 ), [[RowCol]] varchar ( 80 ))
Error in db_execute_immediate()

ERROR: Unable to create table: 'create table italy_white_box_LL (cat
       integer, LabelX double precision, LabelY double precision,
       [[LblOffsetX]] integer, [[LblOffsetY]] integer, Label varchar ( 80 ), Row
       varchar ( 80 ), Column varchar ( 80 ), [[RowCol]] varchar ( 80 ))'

Ref: http://developer.mimer.com/validator/sql-reserved-words.tml

Please select a different column name - suggestion: e.g., add a preceding "g" for graticule.