[GRASS-dev] [GRASS GIS] #188: MySQL driver: create table command cut

[GRASS GIS]

#188: MySQL driver: create table command cut
---------------------+------------------------------------------------------
 Reporter:  neteler  |       Owner:  grass-dev at lists.osgeo.org
     Type:  defect   |      Status:  new                      
 Priority:  major    |   Milestone:  6.4.0                    
Component:  default  |     Version:  svn-trunk                
 Keywords:           |  
---------------------+------------------------------------------------------
 While copying all OSGeo NC data set vector maps from PERMANENT into a
 "mysql" mapset, I got the following problem:

 {{{
 for i in `g.mlist type=vect map=PERMANENT` ; do
   echo "------ $i:"
   g.copy vect=$i,my$i
 done
 ...
 precip_30ynormals_3d:
 Copy vector <precip_30ynormals_3d at PERMANENT> to current mapset as
 <myprecip_30ynormals_3d>
 DBMI-MySQL driver error:
 Cannot create table:
 CREATE TABLE myprecip_30ynormals_3d ( cat INTEGER, station DOUBLE, lat
 DOUBLE, long DOUBLE, elev DOUBLE, jan DOUBLE, feb DOUBLE, mar DOUBLE, apr
 DOUBLE, may DOUBLE, jun DOUBLE, jul DOUBLE, aug DOUBLE, sep DOUBLE, oct
 DOUBLE, nov DOUBLE, dec DOUBLE, annual DOUBLE )
 You have an error in your SQL syntax; check the manual that corresponds to
 your MySQL server version for the right syntax to use near 'long DOUBLE,
 elev DOUBLE, jan DOUBLE, feb DOUBLE, mar DOUBLE, apr DOUBLE, may DO' at
 line 1
 WARNING: Cannot create new table
 }}}

 Apparently the string is cut somewhere. I checked
 db/drivers/mysql/create_table.c but could not find any reason.

 ?

 Markus

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