[mapserver-users] Problem with WFS Intersects filter on oraclespatial datasource

[Ludovic Gnemmi]

Hi List,
I'm experiencing a strange problem with WFS Intersects request on
oraclespatial datasource layer.

1/The following Intersects request :
http://192.168.3.24/cgi-bin/mapserv?map=/var/data/mapfiles/mymap.map&version=1.1.0&service=WFS&REQUEST=GetFeature&TYPENAME=ms:lineaire_div&Filter=<Filter><Intersects><PropertyName>Geometry</PropertyName><gml:Polygon><gml:outerBoundaryIs><gml:LinearRing><gml:coordinates>772507,70056
889500,70056 889500,66553 772507,66553
772507,70056</gml:coordinates></gml:LinearRing></gml:outerBoundaryIs></gml:Polygon></Intersects></Filter>

=> returns no output (<gml:Null>missing</gml:Null>)=msQueryByFilter():
Search returned no results. No matching record(s) found

2/While the same request with BBOX filter (the same BOX)
http://192.168.3.24//cgi-bin/mapserv?map=/var/data/mapfiles/cadastre_depuis_rgd.map&version=1.1.0&service=WFS&REQUEST=GetFeature&TYPENAME=ms:lineaire_div&Filter=<Filter><BBOX><PropertyName>Name>NAME</PropertyName><Box%20srsName='EPSG:27562'><coordinates>70056,66553
889500,70056</coordinates></Box></BBOX></Filter>

=>returns normaly all my records

3/i'm not experiencing this problem on SHPfile datasource( that i've
converted from oracle ). Both requests  return all my records

4/My table is quite big so i tried to reduce the numbers of features
returned by Oracle when trying this Intersects filter and it has succeeded

So it seems that there is a problem with WFS-Intersects Filter on
oraclespatial datasource depending on the numbers of features returned by
the oracle select.

Thanks for your help




--
View this message in context: http://osgeo-org.1560.n6.nabble.com/Problem-with-WFS-Intersects-filter-on-oraclespatial-datasource-tp5009604.html
Sent from the Mapserver - User mailing list archive at Nabble.com.