mysql cut,#188 (MySQL driver: create table command cut) – GRASS GIS

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 to current mapset as

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