Steve, When a case insensitive exact match is used, the code should use a regexp_like constructor in Oracle with the case insensitive flag and an exact pattern.
Can you do DEBUG 3 and show the log? Mike -- Michael Smith Remote Sensing/GIS Center US Army Corps of Engineers From: <mapserver-users-boun...@lists.osgeo.org> on behalf of <steve.tout...@inspq.qc.ca> Date: Tuesday, July 21, 2015 at 10:07 AM To: <mapserver-users@lists.osgeo.org> Subject: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike with oracle > Hi, > Using MS7+oracle, I apply a wfs filter PropertyIsEqualTo on a layer attribute > (string) with a truncated string, so it should returns 0 features, but it > returns 1 feature. > The complete value is "Antonin". I apply the filter using "Anto" > > > MS7+Postgis > <wfs:Query typeName="feature:SMDVDP_STAT_METE" srsName="EPSG:3857"><ogc:Filter > xmlns:ogc="http://www.opengis.net/ogc <http://www.opengis.net/ogc> > "><ogc:PropertyIsEqualTo > matchCase="false"><ogc:PropertyName>NOM_STAT</ogc:PropertyName><ogc:Literal>An > to</ogc:Literal></ogc:PropertyIsEqualTo></ogc:Filter></wfs:Query> > numberOfFeatures="0" , that is ok. > Ms log: FLTLayerApplyPlainFilterToLayer(): ("[NOM_STAT]" =*"Anto") > > Ms7+Oracle > <wfs:Query typeName="feature:SMDVDP_STAT_METE" > srsName="EPSG:32198"><ogc:Filter xmlns:ogc="http://www.opengis.net/ogc > <http://www.opengis.net/ogc> "><ogc:PropertyIsEqualTo > matchCase="false"><ogc:PropertyName>NOM_STAT</ogc:PropertyName><ogc:Literal>An > to</ogc:Literal></ogc:PropertyIsEqualTo></ogc:Filter></wfs:Query> > numberOfFeatures="1" , BAD > Mslog: msOracleSpatialLayerTranslateFilter. String: ("[NOM_STAT]" =*"Anto") > > Is the problem MS o oracle? Should I open a Ms bug? > Regards! > > _______________________________________________ mapserver-users mailing list > mapserver-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users