[mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike with oracle

[Michael Smith]

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-bounces at lists.osgeo.org> on behalf of
<Steve.Toutant at inspq.qc.ca>
Date:  Tuesday, July 21, 2015 at  10:07 AM
To:  <mapserver-users at 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 at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20150721/ec011179/attachment.htm>