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:3857ogc:Filter
xmlns:ogc=http://www.opengis.net/ogc http://www.opengis.net/ogc
ogc:PropertyIsEqualTo
matchCase=falseogc:PropertyNameNOM_STAT/ogc:PropertyNameogc:LiteralAn
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:32198ogc:Filter xmlns:ogc=http://www.opengis.net/ogc
http://www.opengis.net/ogc ogc:PropertyIsEqualTo
matchCase=falseogc:PropertyNameNOM_STAT/ogc:PropertyNameogc:LiteralAn
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
