[fdo-trac] #220: Can't check in multiple features created in mysql

[FDO]

#220: Can't check in multiple features created in mysql
----------------------------+-----------------------------------------------
 Reporter:  gregboone       |         Owner:  gregboone
     Type:  defect          |        Status:  assigned 
 Priority:  major           |     Milestone:  3.3.0    
Component:  MySQL Provider  |       Version:  3.3.0    
 Severity:  2               |    Resolution:           
 Keywords:                  |   External_id:  1030026  
----------------------------+-----------------------------------------------
Comment (by gregboone):

 This defect has its origins in the manner in which the the AutoCAD map
 specific bulk copy process reads schema definitions from a shape file and
 creates the resulting schema in MySQL. Since the origin of the schema is a
 shape file, there is a limitation on the types of Geometry that can be
 created for a specific Shape table. For instance, if the Geometric Type is
 Point and the Specific Geometry SubType is Point in the Shape file, this
 restriction will be carried forward to the schema definition created in
 the MySQL data store. However, once a user has bulk copied data from Shape
 to MySQL, there is an implied expectation that the user will be able to
 perform an insertion of a multi-point feature due to the fact that MySQL
 does support multi-point geometry. The Map DataManager UI reflects this
 expectation by displaying both the ‘Create Point’ and ‘Create Multi-Point’
 options. This expectation will not be honored by the MySQL provider
 because the provider provides an extra level of checking that determines
 if the geometry subtypes match. If they do not, an exception is thrown.
 This level of checking is only performed in the MySQL and PostGIS
 providers and is not present in the other RDBMS or SDF providers.
 Therefore, it is prudent to relax the check in the MySQL provider so that
 it remains consistent with the other FDO providers.

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/220#comment:2>
FDO <http://fdo.osgeo.org/>
Feature Data Objects