[GRASS-dev] [GRASS GIS] #3563: v.in.ogr can't create tables in GRASS 7.4

[GRASS GIS]

#3563: v.in.ogr can't create tables in GRASS 7.4
---------------------------+-------------------------
 Reporter:  pierreroudier  |      Owner:  grass-dev@…
     Type:  defect         |     Status:  new
 Priority:  normal         |  Milestone:
Component:  Vector         |    Version:  7.4.0
 Keywords:                 |        CPU:  Unspecified
 Platform:  Unspecified    |
---------------------------+-------------------------
 I don't seem to be able to import OGR sources (I tried both ESRI Shapefile
 and GPKG sources):


 {{{
 GRASS 7.4.0 (nz_soil_ph):~ > v.in.ogr in=river-flows.gpkg out=rivers --o
 Check if OGR layer <river_flows> contains polygons...
  100%
 WARNING: Vector map <rivers> already exists and will be overwritten
 Creating attribute table for layer <river_flows>...
 DBMI-SQLite driver error:
 Error in sqlite3_prepare():
 near "ORDER": syntax error

 DBMI-SQLite driver error:
 Error in sqlite3_prepare():
 near "ORDER": syntax error

 ERROR: Unable to create table: 'create table rivers (cat integer, ORDER
        double precision, NZREACH double precision, MALFCumecs double
        precision, MeanFlowCumecs double precision, Feb double precision,
        FRE3 double precision, SpecMeanFlowCumecs double precision,
        SpecMALFCumecs double precision, Shape_Length double precision)'

 }}}

 Here is more info about the dataset I'm using:

 {{{
 GRASS 7.4.0 (nz_soil_ph):~ > ogrinfo -al -so river-flows.gpkg
 INFO: Open of `Dropbox/projects/nz-national-grid-ph/covariates/river-
 flows.gpkg'
       using driver `GPKG' successful.

 Layer name: river_flows

 [...]

 Geometry: Multi Line String
 Feature Count: 576277
 Extent: (1090150.000000, 4748850.000000) - (2089110.000000,
 6193370.000000)
 Layer SRS WKT:
 PROJCS["NZGD2000 / New Zealand Transverse Mercator 2000",
     GEOGCS["NZGD2000",
         DATUM["New_Zealand_Geodetic_Datum_2000",
             SPHEROID["GRS 1980",6378137,298.257222101,
                 AUTHORITY["EPSG","7019"]],
             TOWGS84[0,0,0,0,0,0,0],
             AUTHORITY["EPSG","6167"]],
         PRIMEM["Greenwich",0,
             AUTHORITY["EPSG","8901"]],
         UNIT["degree",0.0174532925199433,
             AUTHORITY["EPSG","9122"]],
         AUTHORITY["EPSG","4167"]],
     PROJECTION["Transverse_Mercator"],
     PARAMETER["latitude_of_origin",0],
     PARAMETER["central_meridian",173],
     PARAMETER["scale_factor",0.9996],
     PARAMETER["false_easting",1600000],
     PARAMETER["false_northing",10000000],
     UNIT["metre",1,
         AUTHORITY["EPSG","9001"]],
     AUTHORITY["EPSG","2193"]]
 FID Column = fid
 Geometry Column = geom
 ORDER: Real (0.0)
 NZREACH: Real (0.0)
 MALFCumecs: Real (0.0)
 MeanFlowCumecs: Real (0.0)
 Feb: Real (0.0)
 FRE3: Real (0.0)
 SpecMeanFlowCumecs: Real (0.0)
 SpecMALFCumecs: Real (0.0)
 Shape_Length: Real (0.0)
 }}}

 This dataset is publicly available: https://data.mfe.govt.nz/layer/53309
 -river-flows/

-- 
Ticket URL: <https://trac.osgeo.org/grass/ticket/3563>
GRASS GIS <https://grass.osgeo.org>