[GRASS-user] 7.9.dev: SQLite3 error

Rich Shepard rshepard at appl-ecosys.com
Mon Aug 26 09:46:25 PDT 2019


Looks like there's a SQLite driver bug in the development code. Version is
7.9.dev 1bd88db63

points.dat (same result without quotes on the text):
-123.754167|45.704167|"USGS Gauge"
-123.818006|45.691833|"Mohler S&G"

> v.in.ascii in=$HOME/projects/oregon/mohler/data/features/points.dat \
> out=points for=point columns='x double precision, y double precision, \
> name=char(10)' x=1 y=2 --o

ERROR: Unable to open input file # WHY?
        </home/rshepard/projects/oregon/mohler/data/features/points.dat>
Scanning input for column types...
Number of columns: 3
Number of rows: 2
DBMI-SQLite driver error:
Error in sqlite3_prepare():
near "=": syntax error

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

ERROR: Unable to create table: create table points ( cat integer, x double
        precision, y=double precision, name=char(10) )
WARNING: Table <points> linked to vector map <points> does not exist

Installed here is sqlite-3.13.0-x86_64-1.

Regards,

Rich


More information about the grass-user mailing list