id summary reporter owner description type status priority milestone component version resolution keywords cc cpu platform 2850 v.db.update: value=NULL treated as text with NULL put between quotes mlennert grass-dev@… "v.db.update checks the type of the column to be updated and if it is not integer or double precision the content of the value parameter is automatically enclosed in single quotes. This causes a problem with the NULL value as the column is set to contain the string 'NULL' and not the NULL value. Currently the check is done as such: {{{ if coltype.upper() not in [""INTEGER"", ""DOUBLE PRECISION""]: value = ""'%s'"" % value }}} We could just do this: {{{ if coltype.upper() not in [""INTEGER"", ""DOUBLE PRECISION""] and value.upper() != 'NULL': value = ""'%s'"" % value }}} but this would mean that one could not put the string 'NULL' (or 'null') into a column. So, we can either decide that one should not use the string 'NULL', or we have to find a different way to handle the specific value NULL." defect new normal 7.6.2 Vector svn-releasebranch70 v.db.update NULL Unspecified Unspecified