[GRASS-dev] [GRASS GIS] #3093: v.in.ogr: shapefile with Date/NULL-field prevents creation of db-table

[GRASS GIS]

#3093: v.in.ogr: shapefile with Date/NULL-field prevents creation of db-table
-------------------------+-------------------------
 Reporter:  Melwin       |      Owner:  grass-dev@…
     Type:  defect       |     Status:  new
 Priority:  normal       |  Milestone:  7.0.5
Component:  Database     |    Version:  7.0.3
 Keywords:               |        CPU:  Unspecified
 Platform:  MSWindows 7  |
-------------------------+-------------------------
 The attached shapefile contains a single polygon. The respective data
 table has a field ("Date") which is NULL. When I import the attached
 shapefile

 v.in.ogr dsn=./Water_RE_20091111.shp output=raiz_outline
 layer=Water_RE_20091111 min_area=0.0001 type=boundary snap=-1

 I get the warning

 WARNUNG: Kann Datei
 './madalena_test/PERMANENT/.tmp/unknown/vector/tmp_6680/coor' nicht
 löschen.

 ("cannot delete file ...")

 and the corresponding table is not created.

 When switching to dbf-driver, the problem persist and issues

 ERROR: cannot create table: 'create table raiz_outline3 (cat
         integer, OBJECTID integer, Date date, SHAPE_Leng double precision,
         SHAPE_Area double precision, Name varchar ( 50 ))'

 If I remove the column "Date", everything works as expected.

 I can produce this behaviour in GRASS 7.0.3 and 6.4.1 (Windows 7, 64 bit).
 The latter even hangs when I try to display the attribute table from the
 GUI then.

 cheers, Melwin

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