Hi
We have just upgraded to MS 7.04 from 6.4 (64bit on Win 2012/IIS8) and are having an issue with the PropertyIsLike WFS filter - but only when we use it against SQL Server data. If we issue a filter as so: &filter=<ogc:Filter><ogc:PropertyIsLike matchCase="false" wildCard="*" singleChar="" escapeChar="!"><ogc:PropertyName>ADDRESS</ogc:PropertyName><ogc:Literal>*57 high *</ogc:Literal></ogc:PropertyIsLike></ogc:Filter> ..I get a very long running query which eventually returns some records (but not the correct ones) - it appears to be doing a select all with no where clause. I get this in the MapServer log files - which looks like MapServer cannot from a query for SQL server with Like. [Tue May 02 10:52:27 2017].755000 msWFSParseRequest(): WFS post request: <wfs:GetFeature xmlns:wfs="http://www.opengis.net/wfs"; service="WFS" version="1.1.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.1.0/wfs.xsd <http://www.opengis.net/wfs%20http:/schemas.opengis.net/wfs/1.1.0/wfs.xsd> "><wfs:Query typeName="feature:LLPG_Property_Point_vw" srsName="EPSG:27700"><ogc:Filter xmlns:ogc="http://www.opengis.net/ogc";><ogc:PropertyIsLike matchCase="false" wildCard="*" singleChar="." escapeChar="!"><ogc:PropertyName>ADDRESS</ogc:PropertyName><ogc:Literal>*57 high*</ogc:Literal></ogc:PropertyIsLike></ogc:Filter></wfs:Query></wfs:GetFe ature> [Tue May 02 10:52:27 2017].755000 FLTLayerApplyPlainFilterToLayer(): ("[ADDRESS]" ~* ".*57 high.*"), rect=510500.000000104,165499.999998641,539172.000000336,194171.999999644 [Tue May 02 10:52:27 2017].755000 Filter could not be translated to OGR filter [Tue May 02 10:52:53 2017].380000 mapserv request processing time (msLoadMap not incl.): 25.625s If I use a PropertyIsEqualTo filter I have no problem. If I use the PropertyIsLike against the same data exported to a shape file again it works fine. The exact same filters work fine 6.4. Any help/pointers much appreciated! GDAL with the 7.04 is 2.1.03 (all from gis internals) Steve W
_______________________________________________ mapserver-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/mapserver-users
