[mapserver-dev] attribute queries through WFS on Oracle Spatial

[bartvde at osgis.nl]

Hi list,

when using an attribute query (a Filter without a spatial entry such as
BBOX) through WFS, Mapserver is doing the following:

1) trying to get the extent of the table, something like:

SELECT SDO_GEOM.SDO_CONVEXHULL(SHAPE, 0.001000) AS GEOM from (SELECT SHAPE
FROM VW_VEXPLOITATIE

2) and then using this extent in the query

SELECT ID, OBJECTSUBCATEGORIE, SHAPE FROM VW_VEXPLOITATIE WHERE 
OBJECTNAAM like '%nieuw%' escape '!'  AND SDO_FILTER( SHAPE,
MDSYS.SDO_GEOMETRY(2003, NULL,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(14165.52,307293.125,276564.813,619315.626)
),'querytype=window') = 'TRUE'

Ofcourse this is kind of madness, the better thing to do is leave out the
whole spatial part of the query. It will speed up things by many factors.

1) can be stopped by setting ows_extent METADATA on the LAYER
2) can be stopped by setting USING NONE in the DATA part

It this something the WFS code should do? If so, I can open up an
enhancement bug for this and possibly a patch.

Best regards,
Bart