[GRASS-dev] [GRASS GIS] #3108: db selection: integer overflow

[GRASS GIS]

#3108: db selection: integer overflow
--------------------------+--------------------------------------------
  Reporter:  mlennert     |      Owner:  grass-dev@…
      Type:  defect       |     Status:  new
  Priority:  normal       |  Milestone:  7.0.5
 Component:  Database     |    Version:  svn-trunk
Resolution:               |   Keywords:  v.db.univar db.select overflow
       CPU:  Unspecified  |   Platform:  Unspecified
--------------------------+--------------------------------------------

Comment (by sbl):

 Not sure if this is related:

 But also here GRASS tools give a buffer overflow whlie sqlite3 works:

 This is my query example:

 {{{
 g.copy vector="geonames_NC,geonames_NC_cp"
 v.db.addcolumn map=geonames_NC_cp columns="test integer"
 cats=$(v.db.select -c geonames_NC_cp columns=cat where=cat< 25000)
 echo "UPDATE geonames_NC_cp SET test = 1 WHERE cat in (${cats});" >
 db_test.sql
 }}}

 Then db.execute results in a core dump:
 {{{
 db.execute input=db_test.sql
 }}}

 while

 {{{
 sqlite3 /grassdata/nc_spm_08_grass/sbl/sqlite/sqlite.db < db_test.sql
 }}}

 works without issues...

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/3108#comment:1>
GRASS GIS <https://grass.osgeo.org>