#136: sqlite: confusing error message
---------------------+------------------------------------------------------
Reporter: neteler | Owner: grass-dev@lists.osgeo.org
Type: defect | Status: new
Priority: major | Milestone: 6.4.0
Component: default | Version: svn-trunk
Keywords: sqlite |
---------------------+------------------------------------------------------
I tried to import
{{{
cat tin.asc
cat,x,y,z
1,0,0,0
1,0,10,1
1,0,20,2
2,10,0,1
2,10,10,3
2,10,20,4
3,20,0,1
3,20,10,4
3,20,20,5
}}}
Import:
{{{
v.in.ascii -z tin.asc out=tinpoints z=3 fs=comma skip=1 cat=1 --o
Scanning input for column types...
Maximum input row length: 10
Maximum number of columns: 4
Minimum number of columns: 4
Importing points...
DBMI-SQLite driver error:
Error in sqlite3_step():
SQL logic error or missing database
ERROR: Unable to insert new record: insert into tinpoints values ( 1, 0,
10, 1)
}}}
but this is the wrong (confusing) error:
Trying the same on console:
{{{
sqlite3 ddd.sb
SQLite version 3.4.2
Enter ".help" for instructions
sqlite> create table tinpoints ( int_1 integer, int_2 integer, int_3
integer, int_4 integer );
sqlite> create unique index tinpoints_int_1 on tinpoints ( int_1 );
sqlite> insert into tinpoints values ( 1, 0, 0, 0);
sqlite> insert into tinpoints values ( 1, 0, 10, 1);
SQL error: column int_1 is not unique
sqlite>
}}}
That's the right error.... would like to see that message in GRASS, too.
The code is in
db/drivers/sqlite/execute.c line 47
strange that it isn't identical...
--
Ticket URL: <http://trac.osgeo.org/grass/ticket/136>
GRASS GIS <http://grass.osgeo.org>
GRASS Geographic Information System (GRASS GIS) - http://grass.osgeo.org/