<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; color: rgb(0, 0, 0); font-size: 14px; font-family: Calibri, sans-serif;"><div>Steve,</div><div><br></div><div>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.</div><div><br></div><div>Can you do DEBUG 3 and show the log?</div><div><br></div><div>Mike</div><div><br></div><div><div><div><div>-- </div><div>Michael Smith</div></div><div>Remote Sensing/GIS Center</div><div>US Army Corps of Engineers</div></div></div><div><br></div><span id="OLK_SRC_BODY_SECTION"><div style="font-family:Calibri; font-size:11pt; text-align:left; color:black; BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt"><span style="font-weight:bold">From: </span> <<a href="mailto:mapserver-users-bounces@lists.osgeo.org">mapserver-users-bounces@lists.osgeo.org</a>> on behalf of <<a href="mailto:Steve.Toutant@inspq.qc.ca">Steve.Toutant@inspq.qc.ca</a>><br><span style="font-weight:bold">Date: </span> Tuesday, July 21, 2015 at 10:07 AM<br><span style="font-weight:bold">To: </span> <<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>><br><span style="font-weight:bold">Subject: </span> [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike with oracle<br></div><div><br></div><blockquote id="MAC_OUTLOOK_ATTRIBUTION_BLOCKQUOTE" style="BORDER-LEFT: #b5c4df 5 solid; PADDING:0 0 0 5; MARGIN:0 0 0 5;"><font size="2" face="sans-serif">Hi,</font><br><font size="2" face="sans-serif">Using MS7+oracle, I apply a wfs filter
</font><tt><font size="3">PropertyIsEqualTo</font></tt><font size="2" face="sans-serif">
on a layer attribute (string) with a truncated string, so it should returns
0 features, but it returns 1 feature.</font><br><font size="2" face="sans-serif">The complete value is "Antonin".
I apply the filter using "Anto"</font><br><br><br><font size="2" face="sans-serif">MS7+Postgis</font><br><tt><font size="3"><wfs:Query typeName="feature:SMDVDP_STAT_METE"
srsName="EPSG:3857"><ogc:Filter xmlns:ogc="</font></tt><a href="http://www.opengis.net/ogc"><tt><font size="3" color="blue">http://www.opengis.net/ogc</font></tt></a><tt><font size="3">"><ogc:PropertyIsEqualTo
matchCase="false"><ogc:PropertyName>NOM_STAT</ogc:PropertyName><ogc:Literal><b>Anto</b></ogc:Literal></ogc:PropertyIsEqualTo></ogc:Filter></wfs:Query></font></tt><br><font size="3">numberOfFeatures="0" , that is ok.</font><br><font size="3">Ms log: </font><font size="2" face="Monospace">FLTLayerApplyPlainFilterToLayer():
("[NOM_STAT]" =*"Anto")</font><br><br><font size="2" face="sans-serif">Ms7+Oracle</font><br><tt><font size="3"><wfs:Query typeName="feature:SMDVDP_STAT_METE"
srsName="EPSG:32198"><ogc:Filter xmlns:ogc="</font></tt><a href="http://www.opengis.net/ogc"><tt><font size="3" color="blue">http://www.opengis.net/ogc</font></tt></a><tt><font size="3">"><ogc:PropertyIsEqualTo
matchCase="false"><ogc:PropertyName>NOM_STAT</ogc:PropertyName><ogc:Literal><b>Anto</b></ogc:Literal></ogc:PropertyIsEqualTo></ogc:Filter></wfs:Query></font></tt><br><font size="3">numberOfFeatures="1" , BAD</font><br><font size="3">Mslog: msOracleSpatialLayerTranslateFilter. String: ("[NOM_STAT]"
=*"Anto") </font><br><br><font size="3">Is the problem MS o oracle? Should I open a Ms bug?</font><br><font size="3">Regards!</font><br><p>_______________________________________________
mapserver-users mailing list
<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a></p></blockquote></span></body></html>