#180: Sqlite driver doesn't handle blank numeric entries
---------------------------+------------------------------------------------
Reporter: ferrouswheel | Owner: grass-dev@lists.osgeo.org
Type: defect | Status: new
Priority: minor | Milestone: 6.3.1
Component: default | Version: 6.3.0
Resolution: | Keywords: sqlite db
---------------------------+------------------------------------------------
Comment (by ferrouswheel):
in db/drivers/sqlite/fetch.c:
{{{
146 case SQLITE_TEXT:
147 if (sqltype == 6 ) { /* date string */
148 /* Example: '1999-01-25' */
}}}
shouldn't it be
{{{
146 case SQLITE_TEXT:
147 if (sqltype == DB_SQL_TYPE_DATE ) { /* date string */
148 /* Example: '1999-01-25' */
}}}
?
6 is equivalent to DB_SQL_TYPE_DOUBLE_PRECISION, and often it
unsurprisingly fails when trying to read a date from it.
This fixes the problem I was having...
--
Ticket URL: <http://trac.osgeo.org/grass/ticket/180#comment:2>
GRASS GIS <http://grass.osgeo.org>
_______________________________________________
grass-dev mailing list
grass-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-dev
