[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.htm>
More information about the MapServer-users
mailing list