[mapguide-users] MySQL Spatial Queries with FDO

[George McLean]

I am having trouble writing spatial queries against MySQL 5.0.18 using 
the OSGeo.MySQL.3.2 provider

I pass the string 'geometry INTERSECTS GEOMFROMTEXT ('POINT XY (2536400 
481800)')' to the SetFilter method of an MgFeatureQueryOptions object. 
When I call selectFeatures from a feature service object, I get no errors.

When I use the filter string 'geometry INTERSECTS GEOMFROMTEXT 
('LINESTRING XY (2536400 481800, 2536500 481900)')' I get the following 
error on selection:

An exception occurred in FDO component. String does not represent a 
valid filter.

As far as I can tell the query string is OK. I have the same problem 
with using POLYGON as the geometry as well. Only POINT seems to work. 
When I query the capabilities of the MySQL provider it appears to me 
that LINESTRING and POLYGON are supported.

Any suggestions?

Thanks

George McLean