[fdo-users] FDO MySQL Defect : Unsupported FDO spatial operation

[Gavin Cramer]

Hello, Bruno.  Actually, it was never supported, but it looks like this fact was never checked before.  The Expression Engine now checks the operator.

The list of supported spatial operators is returned in FdoIFilterCapabilities::GetSpatialOperations.  For the MySQL Provider, this is implemented by the FdoRdbmsMysqlFilterCapabilities class.  For this method, the list returned consists of:

- FdoSpatialOperations_EnvelopeIntersects
- FdoSpatialOperations_Intersects

The exception that you are getting is returned in the current codebase by FdoCommonFilterValidator::ProcessSpatialCondition, which checks the list of supported operators.

Previously, it went straight to FdoRdbmsMySqlFilterProcessor::ProcessSpatialCondition, which never checked the condition.  It maps everything to MBRIntersects, since MySQL 5.0 never supported secondary filtering anyway.

Gavin


-----Original Message-----
From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Bruno Scott
Sent: Tuesday, January 15, 2008 5:37 AM
To: fdo-users at lists.osgeo.org
Subject: Re: [fdo-users] FDO MySQL Defect : Unsupported FDO spatial operation


i've also tried the same test using the exact same table in SDF
it works great on all fdo version 3.2.1,3.2.2,3.2.3 and 3.3.0 RC1


Bruno Scott wrote:
>
> I'm trying to retreive data from mysql with this type of statement
>
> Select KEY from POINT where GEOMETRY INSIDE GeomFromText('POLYGON XY ((-13
> 196 , 45 196 , 45 145 , -13 145 , -13 196))')
>
> Using the FdoISelect class
> FdoPtr<FdoISelect>        sampleSelect;
> sampleSelect->SetFilter(_T("GEOMETRY INSIDE GeomFromText('POLYGON XY ((-13
> 196 , 45 196 , 45 145 , -13 145 , -13 196))')");
>
> It works great with FDO 3.2.1
> But it fails with version 3.2.2, 3.2.3 and 3.3.0 RC1 with this error
> "Unsupported FDO spatial operation"
>
> I've tryed also with other spatial operation but still got this error
>
> It's stange that it only work with the old 3.2.1 version
>
> Bruno
>

--
View this message in context: http://www.nabble.com/FDO-MySQL-Defect-%3A-Unsupported-FDO-spatial-operation-tp14836540s18162p14836887.html
Sent from the fdo-users mailing list archive at Nabble.com.

_______________________________________________
fdo-users mailing list
fdo-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-users