[GRASS-dev] [GRASS GIS] #136: sqlite: confusing error message

[GRASS GIS]

#136: sqlite: confusing error message
--------------------------+-------------------------------------------------
  Reporter:  neteler      |       Owner:  grass-dev@…              
      Type:  defect       |      Status:  closed                   
  Priority:  major        |   Milestone:  6.4.0                    
 Component:  Default      |     Version:  svn-trunk                
Resolution:  fixed        |    Keywords:  sqlite                   
  Platform:  Unspecified  |         Cpu:  Unspecified              
--------------------------+-------------------------------------------------
Changes (by neteler):

  * status:  new => closed
  * resolution:  => fixed


Comment:

 With wrong parameters the error message is better now:
 {{{
 GRASS 6.4.3svn (nc_spm_08):~ > 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
 Column: 1 type: integer
 Column: 2 type: integer
 Column: 3 type: integer
 Column: 4 type: integer
 Importing points...
 DBMI-SQLite driver error:
 Error in sqlite3_step():
 column int_1 is not unique

 ERROR: Unable to insert new record: insert into tinpoints values ( 1, 0,
        10, 1)
 }}}


 With correct parameters it works:
 {{{
 GRASS 6.4.3svn (nc_spm_08):~ > v.in.ascii -z tin.asc out=tinpoints x=2 y=3
 z=4 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...
  100%
 Building topology for vector map <tinpoints>...
 Registering primitives...
 9 primitives registered
 9 vertices registered
 Building areas...
  100%
 0 areas built
 0 isles built
 Attaching islands...
 Attaching centroids...
  100%
 Number of nodes: 9
 Number of primitives: 9
 Number of points: 9
 Number of lines: 0
 Number of boundaries: 0
 Number of centroids: 0
 Number of areas: 0
 Number of isles: 0
 v.in.ascii complete.
 }}}

 Hence, closing.

-- 
Ticket URL: <http://trac.osgeo.org/grass/ticket/136#comment:2>
GRASS GIS <http://grass.osgeo.org>