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

Steve.Toutant at inspq.qc.ca Steve.Toutant at inspq.qc.ca
Tue Jul 21 07:07:37 PDT 2015


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
"><ogc:PropertyIsEqualTo 
matchCase="false"><ogc:PropertyName>NOM_STAT</ogc:PropertyName><ogc:Literal>
Anto</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
"><ogc:PropertyIsEqualTo 
matchCase="false"><ogc:PropertyName>NOM_STAT</ogc:PropertyName><ogc:Literal>
Anto</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!

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


More information about the mapserver-users mailing list