Bugs: Browse | Submit New | Admin

[#25575] mysql_adapter produces multi_polygon

Date:
2009-04-21 15:23		 Priority:
3
Submitted By:
Nobody 		Assigned To:
Nobody (None)
Category:
None		 State:
Open
Summary:
mysql_adapter produces multi_polygon

Detailed description 
This may not be a bug at all, as I'm still learning about the spatial extensions. On MySQL 5.1.33 on Mac OS X 10.5,
shp2sql.rb tries to add a column with type 'multi_polygon', which generates an error. The sql statement generated is:

ALTER TABLE `zt44_d00` ADD `the_geom` multi_polygon NOT NULL

This statement will work if modified to:

ALTER TABLE `zt44_d00` ADD `the_geom` multipolygon NOT NULL

In my db.yml, I have adapter set to 'mysql'.

Add A Comment: Notepad

Please login


Followup

Message 
Date: 2009-04-21 15:38
Sender: Peter Landry

Forgot to add, this is on rails 2.3.2

Attached Files:

Name Description Download
No Files Currently Attached

Changes:

No Changes Have Been Made to This Item