[GRASS-dev] Re: [GRASS GIS] #548: grass7: v.reclass segfaults on string column

[GRASS GIS]

#548: grass7: v.reclass segfaults on string column
--------------------------+-------------------------------------------------
  Reporter:  mlennert     |       Owner:  grass-dev at lists.osgeo.org
      Type:  defect       |      Status:  new                      
  Priority:  normal       |   Milestone:  7.0.0                    
 Component:  Vector       |     Version:  svn-trunk                
Resolution:               |    Keywords:  v.reclass                
  Platform:  Unspecified  |         Cpu:  Unspecified              
--------------------------+-------------------------------------------------
Comment (by neteler):

 After the fix in the spatial index I can reproduce the problem with
 SQLite:

 {{{
 g.gisenv set=DEBUG=3
 v.reclass in=boundary_county out=test_recl column=DOT_GROUP_ --o
 ...
 db_driver_open_database()
 D3/3: name = '/home/neteler/grassdata/nc_spm_08/sqlite/sqlite.db'
 D2/3: name2 = '/home/neteler/grassdata/nc_spm_08/sqlite/sqlite.db'
 D3/3:   SQL: SELECT cat, DOT_GROUP_ FROM boundary_county ORDER BY
 DOT_GROUP_
 D3/3: Escaped SQL: SELECT cat, DOT_GROUP_ FROM boundary_county ORDER BY
 DOT_GROUP_
 D3/3: describe_table()
 D3/3: ncols = 2
 D3/3: sqltype = 3
 D3/3: litetype = 1
 D3/3: sqltype = 1
 D3/3: litetype = 3
 D3/3: nkcols = 2
 D3/3: sqltype = 3
 D3/3: litetype = 1
 D2/3: col: cat, nkcols 0, litetype : 1, sqltype 3
 D3/3: sqltype = 1
 D3/3: litetype = 3
 D2/3: col: DOT_GROUP_, nkcols 1, litetype : 3, sqltype 1
 D3/3:   926 rows selected
 D3/3:   key type = 15
 D3/3: execute: create table test_recl (cat integer, DOT_GROUP_
 varchar(20))
 D3/3: db__create_index()
 D3/3:  SQL: create unique index test_recl_cat on test_recl ( cat )
 D3/3: fetch row = -1
 DBMI-SQLite driver error:
 Cannot step:
 SQL logic error or missing database

 ERROR: Unable to fetch data from table <boundary_county>
 }}}

 No mention on http://www.sqlite.org/omitted.html, so I don't know why this
 statement is rejected.

 Markus

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