[GRASS-dev] [bug #4496] (grass) v.rast.calc does not handle null values with sqlite dirver

[Request Tracker]

this bug's URL: http://intevation.de/rt/webrt?serial_num=4496
-------------------------------------------------------------------------

Subject: v.rast.calc does not handle null values with sqlite dirver

Platform: GNU/Linux/x86
grass obtained from: Trento Italy site
grass binary for platform: Compiled from Sources
GRASS Version: grass-6.1.cvs_src_snapshot_2006_05_13

using sqlite driver.

When executing v.rast.stats on a vector file that is larger than the underlying raster, v.rast.stats attempts to insert "nan" into the sqlite table for categories where no data was found. 

If fails with the following (syntax?) error:

DBMI-SQLite driver error:
Error in sqlite3_prepare():
no such column: nan

ERROR: Error while executing: "UPDATE ps_model SET navd88_cf_var=nan where
       cat=35
       "
I think that if you insert a "nan" (quoted) it will work. However, maybe a null would be better here since this is a numeric column?




-------------------------------------------- Managed by Request Tracker