[GRASS-dev] [GRASS GIS] #400: Bogous SQL error message handling in db_execute_immediate

GRASS GIS trac at osgeo.org
Mon Dec 15 07:23:06 EST 2008


#400: Bogous SQL error message handling in db_execute_immediate
-------------------------+--------------------------------------------------
 Reporter:  marisn       |       Owner:  grass-dev at lists.osgeo.org
     Type:  defect       |      Status:  new                      
 Priority:  critical     |   Milestone:  6.4.0                    
Component:  Database     |     Version:  svn-develbranch6         
 Keywords:               |    Platform:  Unspecified              
      Cpu:  Unspecified  |  
-------------------------+--------------------------------------------------
 I was trying to import shapefile with v.in.ogr and it failed while trying
 to create database. Only problem - there was no meaningfull error message
 displayed. Using same SQL expression with db.execute also failed to
 produce readable error message. After subsequent runs I once got some
 wired character as error message most likely coming from bogous printf
 statement argument. Still I was not able to identify origin of that error
 message to check printf arguments.[[BR]]
 Revision: 34900 make distclean && make
 {{{
 $ echo "create table gps_pents_osl (cat integer, SHAPEID integer, ELE
 double precision, NAME varchar ( 80 ), DESC varchar ( 80 ), AUGST double
 precision)" | db.execute
 DBMI-DBF driver error:
 SQL parser error: �۷
 in statement:
 create table gps_pents_osl (cat integer, SHAPEID integer, ELE double
 precision, NAME varchar ( 80 ), DESC varchar ( 80 ), AUGST double
 precision)

 Error in db_execute_immediate()
 }}}

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


More information about the grass-dev mailing list