[GRASS-dev] [GRASS GIS] #391: SQLite driver doesn't complain enough with stupid mistakes

[GRASS GIS]

#391: SQLite driver doesn't complain enough with stupid mistakes
-------------------------+--------------------------------------------------
 Reporter:  hamish       |       Owner:  grass-dev at lists.osgeo.org
     Type:  defect       |      Status:  new                      
 Priority:  major        |   Milestone:  6.4.0                    
Component:  Database     |     Version:  svn-develbranch6         
 Keywords:  sqlite       |    Platform:  Linux                    
      Cpu:  Unspecified  |  
-------------------------+--------------------------------------------------
 Using the SQLite driver, the following v.db.addcol command runs without
 error:

 {{{
 G64:spearf> g.copy vect=archsites,tmp_arch
 G64:spearf> v.db.addcol tmp_arch column='x double y double'
 }}}

 (typo, no comma between column defs)

 but when you try and do something with it you get an error:

 {{{
 G64:spearf> v.info -c tmp_arch
 Displaying column types/names for database connection of layer 1:
 WARNING: SQLite driver: unable to parse decltype: double y double
 WARNING: SQLite driver: unable to parse decltype: double y double
 WARNING: SQLite driver: column 'x', SQLite type 2 is not supported
 INTEGER|cat
 CHARACTER|str1
 }}}


 a fatal error from v.db.addcol or from the driver would be nice.


 Hamish

-- 
Ticket URL: <https://trac.osgeo.org/grass/ticket/391>
GRASS GIS <http://grass.osgeo.org>