[GRASS-dev] Re: [GRASS GIS] #180: Sqlite driver doesn't handle blank numeric entries

[GRASS GIS]

#180: Sqlite driver doesn't handle blank numeric entries
---------------------------+------------------------------------------------
  Reporter:  ferrouswheel  |       Owner:  grass-dev at 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>