id	summary	reporter	owner	description	type	status	priority	milestone	component	version	resolution	keywords	cc	platform	cpu
188	MySQL driver: create table command cut	neteler	grass-dev@lists.osgeo.org	"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@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"	defect	closed	major	6.4.0	Default	svn-trunk	invalid