[GRASS-dev] [GRASS GIS] #2499: GRASS70: v.in.ogr in does not handle "nan" in attribute tables properly

[GRASS GIS]

#2499: GRASS70: v.in.ogr in does not handle "nan" in attribute tables properly
--------------------------+-----------------------------------------
  Reporter:  sbl          |      Owner:  grass-dev@…
      Type:  defect       |     Status:  new
  Priority:  normal       |  Milestone:  7.6.2
 Component:  Vector       |    Version:  unspecified
Resolution:               |   Keywords:  v.in.ogr, DBMI, SQLite, nan
       CPU:  Unspecified  |   Platform:  Unspecified
--------------------------+-----------------------------------------

Comment (by alexbruy):

 Seems still true with 7.8.2. For example, when I run v.net.centrality it
 fails during saving results with the following message


 {{{
 Flattening the graph...
 Graph was built
 Computing degree centrality measure
 Computing betweenness and/or closeness centrality measure
 0..5..10..15..20..25..30..35..40..45..50..55..60..65..70..75..80..85..90..95..Computing
 eigenvector centrality measure
 Writing data into the table...
 3..7..11..15..19..23..26..30..34..38..42..46..50..53..57..61..65..69..73..76..80..84..88..92..96..100
 DBMI-SQLite driver error:
 Error in sqlite3_prepare():
 no such column: nan
 DBMI-SQLite driver error:
 Error in sqlite3_prepare():
 no such column: nan
 ERROR: Cannot insert new record: INSERT INTO
 output748b41e8dcf84a96b7d78ba17246cc20
 VALUES(27,0.100000,0.000000,30.000000,-nan)
 }}}

 Using network.shp from QGIS test dataset at
 https://github.com/qgis/QGIS/tree/master/python/plugins/processing/tests/testdata/custom/grass7

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