<html><head></head><body lang="en-US" style="background-color: rgb(255, 255, 255); line-height: initial;"> <div style="width: 100%; font-size: initial; font-family: Calibri, 'Slate Pro', sans-serif, sans-serif; color: rgb(31, 73, 125); text-align: initial; background-color: rgb(255, 255, 255);">That's correct for postgis (I think) but not oracle. </div><div style="width: 100%; font-size: initial; font-family: Calibri, 'Slate Pro', sans-serif, sans-serif; color: rgb(31, 73, 125); text-align: initial; background-color: rgb(255, 255, 255);"><br></div><div style="width: 100%; font-size: initial; font-family: Calibri, 'Slate Pro', sans-serif, sans-serif; color: rgb(31, 73, 125); text-align: initial; background-color: rgb(255, 255, 255);">Unless you are only seeing the log for the postgis instance. </div> <div style="width: 100%; font-size: initial; font-family: Calibri, 'Slate Pro', sans-serif, sans-serif; color: rgb(31, 73, 125); text-align: initial; background-color: rgb(255, 255, 255);"><br></div> <div style="font-size: initial; font-family: Calibri, 'Slate Pro', sans-serif, sans-serif; color: rgb(31, 73, 125); text-align: initial; background-color: rgb(255, 255, 255);"></div> <table width="100%" style="background-color:white;border-spacing:0px;"> <tbody><tr><td colspan="2" style="font-size: initial; text-align: initial; background-color: rgb(255, 255, 255);"> <div style="border-style: solid none none; border-top-color: rgb(181, 196, 223); border-top-width: 1pt; padding: 3pt 0in 0in; font-family: Tahoma, 'BB Alpha Sans', 'Slate Pro'; font-size: 10pt;"> <div><b>From: </b>Steve.Toutant@inspq.qc.ca</div><div><b>Sent: </b>Wednesday, July 22, 2015 1:59 PM</div><div><b>To: </b>Michael Smith</div><div><b>Cc: </b>mapserver-users@lists.osgeo.org</div><div><b>Subject: </b>Re: [EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike with oracle</div></div></td></tr></tbody></table><div style="border-style: solid none none; border-top-color: rgb(186, 188, 209); border-top-width: 1pt; font-size: initial; text-align: initial; background-color: rgb(255, 255, 255);"></div><br><div id="_originalContent" style=""><font size="2" face="sans-serif">Good idea we use POST, but I tried using
GET and I still get FLTLayerApplyPlainFilterToLayer(): ("[NOM_STAT]"
=*"Anto") in the log (with postgis and oracle)</font>
<p>
<br>
<br>
<br>
<table width="100%" style="border-collapse:collapse;">
<tbody><tr valign="top" height="8">
<td width="40%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;"><font size="1" face="sans-serif"><b>Michael
Smith <michael.smith.erdc@gmail.com></b> </font>
<p><font size="1" face="sans-serif">2015-07-22 12:02</font>
</p></td><td width="59%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<table width="100%" style="border-collapse:collapse;">
<tbody><tr valign="top" height="21">
<td width="57" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<div align="right"><font size="1" face="sans-serif">A</font></div>
</td><td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;"><font size="1" face="sans-serif">"Steve.Toutant@inspq.qc.ca"
<Steve.Toutant@inspq.qc.ca></font>
</td></tr><tr valign="top" height="21">
<td width="57" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<div align="right"><font size="1" face="sans-serif">cc</font></div>
</td><td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
</td></tr><tr valign="top" height="21">
<td width="57" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
<div align="right"><font size="1" face="sans-serif">Objet</font></div>
</td><td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;"><font size="1" face="sans-serif">Re:
[EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike
with oracle</font></td></tr></tbody></table>
<br>
<table width="393" style="border-collapse:collapse;">
<tbody><tr valign="top" height="8">
<td width="57" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;">
</td><td width="336" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:0px 0px;"></td></tr></tbody></table>
<br></td></tr></tbody></table>
<br>
<br>
<br>
<br>
<br><font size="3">Only other thing I can think of are you doing a GET or
POST? I'm doing GET. <br>
<br>
Michael Smith</font>
<br><font size="3">Remote Sensing/GIS Center</font>
<br><font size="3">US Army Corps of Engineers</font>
<br><font size="3"><br>
On Jul 22, 2015, at 11:42 AM, </font><a href="mailto:Steve.Toutant@inspq.qc.ca"><font size="3" color="blue"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size="3">
wrote:<br>
</font>
<br><font size="2" face="sans-serif">12C</font><font size="3"> <br>
<br>
<br>
</font>
<table width="100%" style="border-collapse:collapse;">
<tbody><tr valign="top" height="8">
<td width="31%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><font size="1" face="sans-serif"><b>Michael
Smith <</b></font><a href="mailto:michael.smith.erdc@gmail.com"><font size="1" color="blue" face="sans-serif"><b><u>michael.smith.erdc@gmail.com</u></b></font></a><font size="1" face="sans-serif"><b>></b>
</font>
<p><font size="1" face="sans-serif">2015-07-22 11:36</font><font size="3">
</font>
</p></td><td width="68%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<br>
<table width="100%" style="border-collapse:collapse;">
<tbody><tr valign="top" height="8">
<td width="9%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<div align="right"><font size="1" face="sans-serif">A</font></div>
</td><td width="90%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><font size="1" face="sans-serif">"</font><a href="mailto:Steve.Toutant@inspq.qc.ca"><font size="1" color="blue" face="sans-serif"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size="1" face="sans-serif">"
<</font><a href="mailto:Steve.Toutant@inspq.qc.ca"><font size="1" color="blue" face="sans-serif"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size="1" face="sans-serif">></font><font size="3">
</font>
</td></tr><tr valign="top" height="8">
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<div align="right"><font size="1" face="sans-serif">cc</font></div>
</td><td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><font size="1" face="sans-serif">"</font><a href="mailto:mapserver-users@lists.osgeo.org"><font size="1" color="blue" face="sans-serif"><u>mapserver-users@lists.osgeo.org</u></font></a><font size="1" face="sans-serif">"
<</font><a href="mailto:mapserver-users@lists.osgeo.org"><font size="1" color="blue" face="sans-serif"><u>mapserver-users@lists.osgeo.org</u></font></a><font size="1" face="sans-serif">></font><font size="3">
</font>
</td></tr><tr valign="top" height="8">
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<div align="right"><font size="1" face="sans-serif">Objet</font></div>
</td><td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><font size="1" face="sans-serif">Re:
[EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike
with oracle</font></td></tr></tbody></table>
<br>
<br>
<table width="393" style="border-collapse:collapse;">
<tbody><tr valign="top" height="8">
<td width="56" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
</td><td width="332" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"></td></tr></tbody></table>
<br></td></tr></tbody></table>
<br><font size="3"><br>
<br>
<br>
<br>
<br>
What version of Oracle? Not that we have any version dependencies in the
regexp code. <br>
<br>
I'm running 11.2 and 12.1. <br>
<br>
Michael Smith <br>
Remote Sensing/GIS Center <br>
US Army Corps of Engineers <br>
<br>
On Jul 22, 2015, at 11:30 AM, </font><a href="mailto:Steve.Toutant@inspq.qc.ca"><font size="3" color="blue"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size="3">
wrote:<br>
</font><font size="2" face="sans-serif"><br>
oracle and postgis are on 2 differents servers physically on 2 cities,
both has a mapserver installation made by 2 different person. One is on
debian, and other on fedora <br>
There are using ms7 since other new wfs improvement made in MS7 are used...</font><font size="3">
</font>
</p><p><font size="3"><br>
</font>
</p><p>
<table width="100%" style="border-collapse:collapse;">
<tbody><tr valign="top" height="8">
<td width="32%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><font size="1" face="sans-serif"><b>Michael
Smith <</b></font><a href="mailto:michael.smith.erdc@gmail.com"><font size="1" color="blue" face="sans-serif"><b><u>michael.smith.erdc@gmail.com</u></b></font></a><font size="1" face="sans-serif"><b>></b>
</font>
<p><font size="1" face="sans-serif">2015-07-22 11:22</font><font size="3">
</font>
</p></td><td width="67%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<br>
<table width="100%" style="border-collapse:collapse;">
<tbody><tr valign="top" height="8">
<td width="5%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<div align="right"><font size="1" face="sans-serif">A</font></div>
</td><td width="94%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><font size="1" face="sans-serif">"</font><a href="mailto:Steve.Toutant@inspq.qc.ca"><font size="1" color="blue" face="sans-serif"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size="1" face="sans-serif">"
<</font><a href="mailto:Steve.Toutant@inspq.qc.ca"><font size="1" color="blue" face="sans-serif"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size="1" face="sans-serif">></font><font size="3">
</font>
</td></tr><tr valign="top" height="8">
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<div align="right"><font size="1" face="sans-serif">cc</font></div>
</td><td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><font size="1" face="sans-serif">"</font><a href="mailto:mapserver-users@lists.osgeo.org"><font size="1" color="blue" face="sans-serif"><u>mapserver-users@lists.osgeo.org</u></font></a><font size="1" face="sans-serif">"
<</font><a href="mailto:mapserver-users@lists.osgeo.org"><font size="1" color="blue" face="sans-serif"><u>mapserver-users@lists.osgeo.org</u></font></a><font size="1" face="sans-serif">></font><font size="3">
</font>
</td></tr><tr valign="top" height="8">
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<div align="right"><font size="1" face="sans-serif">Objet</font></div>
</td><td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><font size="1" face="sans-serif">Re:
[EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike
with oracle</font></td></tr></tbody></table>
<br><font size="3"><br>
</font>
<br>
<table width="392" style="border-collapse:collapse;">
<tbody><tr valign="top" height="8">
<td width="56" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
</td><td width="332" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"></td></tr></tbody></table>
<br></td></tr></tbody></table>
<br><font size="3"><br>
<br>
<br>
<br>
<br>
<br>
Could you be hitting an old installed version?<br>
<br>
Michael Smith <br>
Remote Sensing/GIS Center <br>
US Army Corps of Engineers <br>
<br>
On Jul 22, 2015, at 11:14 AM, </font><a href="mailto:Steve.Toutant@inspq.qc.ca"><font size="3" color="blue"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size="3">
wrote:</font><font size="2" face="sans-serif"><br>
<br>
We are on linux as well.</font><font size="3"> </font><font size="2" face="sans-serif"><br>
Ms7+ postgis.. it doesn't translate the query to regex, I have the same
query than with Oracle... ("[NOM_STAT]" =*"Anto")</font><font size="3">
</font><font size="2" face="sans-serif"><br>
<br>
<br>
Well...I'm more confused now...It doesn't make sens that our MS doesn't
generate the same request...</font><font size="3"> </font><font size="2" face="sans-serif"><br>
Can it be an installation problem, an option is missing when compiling?</font><font size="3">
</font>
</p><p>
</p><p>
<table width="100%" style="border-collapse:collapse;">
<tbody><tr valign="top" height="8">
<td width="32%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><font size="1" face="sans-serif"><b>Michael
Smith <</b></font><a href="mailto:michael.smith.erdc@gmail.com"><font size="1" color="blue" face="sans-serif"><b><u>michael.smith.erdc@gmail.com</u></b></font></a><font size="1" face="sans-serif"><b>></b>
</font>
<p><font size="1" face="sans-serif">2015-07-22 09:55</font><font size="3">
</font>
</p></td><td width="67%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<br>
<table width="100%" style="border-collapse:collapse;">
<tbody><tr valign="top" height="8">
<td width="5%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<div align="right"><font size="1" face="sans-serif">A</font></div>
</td><td width="94%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><font size="1" face="sans-serif">"</font><a href="mailto:Steve.Toutant@inspq.qc.ca"><font size="1" color="blue" face="sans-serif"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size="1" face="sans-serif">"
<</font><a href="mailto:Steve.Toutant@inspq.qc.ca"><font size="1" color="blue" face="sans-serif"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size="1" face="sans-serif">></font><font size="3">
</font>
</td></tr><tr valign="top" height="8">
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<div align="right"><font size="1" face="sans-serif">cc</font></div>
</td><td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><font size="1" face="sans-serif">"</font><a href="mailto:mapserver-users@lists.osgeo.org"><font size="1" color="blue" face="sans-serif"><u>mapserver-users@lists.osgeo.org</u></font></a><font size="1" face="sans-serif">"
<</font><a href="mailto:mapserver-users@lists.osgeo.org"><font size="1" color="blue" face="sans-serif"><u>mapserver-users@lists.osgeo.org</u></font></a><font size="1" face="sans-serif">></font><font size="3">
</font>
</td></tr><tr valign="top" height="8">
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<div align="right"><font size="1" face="sans-serif">Objet</font></div>
</td><td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><font size="1" face="sans-serif">Re:
[EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike
with oracle</font></td></tr></tbody></table>
<br><font size="3"><br>
<br>
</font>
<br>
<table width="392" style="border-collapse:collapse;">
<tbody><tr valign="top" height="8">
<td width="56" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
</td><td width="332" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"></td></tr></tbody></table>
<br></td></tr></tbody></table>
<br><font size="3"><br>
<br>
<br>
<br>
</font><font size="2" face="sans-serif"><br>
<br>
<br>
Just tried with latest master (sha f13cd8825e117b09663bb325a03854c27e9cdd39)
and got correct REGEXP_LIKE sql. Was using rel-7-0-0-beta1 before. Both
same.</font><font size="3"> </font><font size="2" face="sans-serif"><br>
<br>
I'm running on Linux although can't see how that would change the sql being
generated.</font><font size="3"> </font><font size="2" face="sans-serif"><br>
<br>
----</font><font size="3"> </font><font size="2" face="sans-serif"><br>
Michael Smith</font><font size="3"> </font><font size="2" face="sans-serif"><br>
US Army Corps</font><font size="3"> </font><font size="2" face="sans-serif"><br>
Remote Sensing GIS/Center</font><font size="3"> </font><font size="3" color="blue"><u><br>
</u></font><a href="mailto:michael.smith@usace.army.mil"><font size="2" color="blue" face="sans-serif"><u>michael.smith@usace.army.mil</u></font></a><font size="3">
</font><font size="2"><b><br>
<br>
<br>
From: </b><</font><a href="mailto:mapserver-users-bounces@lists.osgeo.org"><font size="2" color="blue"><u>mapserver-users-bounces@lists.osgeo.org</u></font></a><font size="2">>
on behalf of "</font><a href="mailto:Steve.Toutant@inspq.qc.ca"><font size="2" color="blue"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size="2">"
<</font><a href="mailto:Steve.Toutant@inspq.qc.ca"><font size="2" color="blue"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size="2">><b><br>
Date: </b>Wednesday, July 22, 2015 at 9:44 AM<b><br>
To: </b>"</font><a href="mailto:Steve.Toutant@inspq.qc.ca"><font size="2" color="blue"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size="2">"
<</font><a href="mailto:Steve.Toutant@inspq.qc.ca"><font size="2" color="blue"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size="2">><b><br>
Cc: </b>"</font><a href="mailto:mapserver-users@lists.osgeo.org"><font size="2" color="blue"><u>mapserver-users@lists.osgeo.org</u></font></a><font size="2">"
<</font><a href="mailto:mapserver-users@lists.osgeo.org"><font size="2" color="blue"><u>mapserver-users@lists.osgeo.org</u></font></a><font size="2">>,
"</font><a href="mailto:mapserver-users-bounces@lists.osgeo.org"><font size="2" color="blue"><u>mapserver-users-bounces@lists.osgeo.org</u></font></a><font size="2">"
<</font><a href="mailto:mapserver-users-bounces@lists.osgeo.org"><font size="2" color="blue"><u>mapserver-users-bounces@lists.osgeo.org</u></font></a><font size="2">><b><br>
Subject: </b>[EXTERNAL] Re: [mapserver-users] ogc:PropertyIsEqualTo behaves
like PropertyIsLike with oracle<b><br>
Resent-From: </b>Michael Smith <</font><a href="mailto:michael.smith@usace.army.mil"><font size="2" color="blue"><u>michael.smith@usace.army.mil</u></font></a><font size="2">></font><font size="3">
</font><font size="2" face="sans-serif"><br>
<br>
using </font><font size="2" color="#2f2f2f" face="Arial">MapServer version
7.0.0-beta1 </font>
</p><p>
<table width="100%" style="border-collapse:collapse;">
<tbody><tr valign="top" height="8">
<td width="38%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><a href="mailto:Steve.Toutant@inspq.qc.ca"><font size="1" color="blue" face="sans-serif"><b><u>Steve.Toutant@inspq.qc.ca</u></b></font></a><font size="1" face="sans-serif"><b>@</b></font><a href="http://lists.osgeo.org/"><font size="1" color="blue" face="sans-serif"><b><u>lists.osgeo.org</u></b></font></a><font size="1" face="sans-serif"><br>
Envoyé par : </font><a href="mailto:mapserver-users-bounces@lists.osgeo.org"><font size="1" color="blue" face="sans-serif"><u>mapserver-users-bounces@lists.osgeo.org</u></font></a><font size="3">
</font>
<p><font size="1" face="sans-serif">2015-07-22 09:43</font><font size="3" face="sans-serif">
</font>
</p></td><td width="61%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<br>
<table width="100%" style="border-collapse:collapse;">
<tbody><tr valign="top" height="8">
<td width="6%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<div align="right"><font size="1" face="sans-serif">A</font></div>
</td><td width="93%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><font size="1" face="sans-serif">Michael
Smith <</font><a href="mailto:michael.smith.erdc@gmail.com"><font size="1" color="blue" face="sans-serif"><u>michael.smith.erdc@gmail.com</u></font></a><font size="1" face="sans-serif">></font><font size="3">
</font>
</td></tr><tr valign="top" height="8">
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<div align="right"><font size="1" face="sans-serif">cc</font></div>
</td><td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><a href="mailto:mapserver-users@lists.osgeo.org"><font size="1" color="blue" face="sans-serif"><u>mapserver-users@lists.osgeo.org</u></font></a><font size="3" face="sans-serif">
</font>
</td></tr><tr valign="top" height="8">
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<div align="right"><font size="1" face="sans-serif">Objet</font></div>
</td><td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><font size="1" face="sans-serif">Re:
[mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike with
oracle</font></td></tr></tbody></table>
<br><font size="3"><br>
<br>
<br>
</font>
<br>
<table width="392" style="border-collapse:collapse;">
<tbody><tr valign="top" height="8">
<td width="56" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
</td><td width="332" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"></td></tr></tbody></table>
<br></td></tr></tbody></table>
<br><font size="2" face="sans-serif"><br>
<br>
<br>
<br>
</font><font size="2" color="#2f2f2f" face="Arial"><br>
<br>
<br>
<br>
CONNECTIONTYPE oraclespatial<br>
DATA "GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR
FROM D_DEB) = 2015) USING SRID 4326"</font><font size="3"> </font>
</p><p>
<table width="100%" style="border-collapse:collapse;">
<tbody><tr valign="top" height="8">
<td width="36%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><font size="1" face="sans-serif"><b>Michael
Smith <</b></font><a href="mailto:michael.smith.erdc@gmail.com"><font size="1" color="blue" face="sans-serif"><b><u>michael.smith.erdc@gmail.com</u></b></font></a><font size="1" face="sans-serif"><b>></b></font><font size="3">
</font>
<p><font size="1" face="sans-serif">2015-07-22 09:38</font><font size="3" face="sans-serif">
</font>
</p></td><td width="63%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<br>
<table width="100%" style="border-collapse:collapse;">
<tbody><tr valign="top" height="8">
<td width="6%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<div align="right"><font size="1" face="sans-serif">A</font></div>
</td><td width="93%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><font size="1" face="sans-serif"><</font><a href="mailto:Steve.Toutant@inspq.qc.ca"><font size="1" color="blue" face="sans-serif"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size="1" face="sans-serif">></font><font size="3">
</font>
</td></tr><tr valign="top" height="8">
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<div align="right"><font size="1" face="sans-serif">cc</font></div>
</td><td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><font size="1" face="sans-serif"><</font><a href="mailto:mapserver-users@lists.osgeo.org"><font size="1" color="blue" face="sans-serif"><u>mapserver-users@lists.osgeo.org</u></font></a><font size="1" face="sans-serif">></font><font size="3">
</font>
</td></tr><tr valign="top" height="8">
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<div align="right"><font size="1" face="sans-serif">Objet</font></div>
</td><td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><font size="1" face="sans-serif">Re:
[mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike with
oracle</font></td></tr></tbody></table>
<br><font size="3" face="sans-serif"><br>
</font><font size="3"><br>
<br>
<br>
</font>
<br>
<table width="392" style="border-collapse:collapse;">
<tbody><tr valign="top" height="8">
<td width="56" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
</td><td width="332" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"></td></tr></tbody></table>
<br></td></tr></tbody></table>
<br><font size="3" face="sans-serif"><br>
<br>
<br>
<br>
</font><font size="2" face="sans-serif"><br>
<br>
<br>
<br>
<br>
Same result with 1.1.0</font><font size="3" face="sans-serif"> </font><font size="2" face="sans-serif"><br>
<br>
Are you using an CONNECTIONTYPE oraclespatial or a CONNECTIONTYPE OGR to
Oracle?<br>
<br>
Mike</font><font size="3" face="sans-serif"> </font><font size="2" face="sans-serif"><br>
<br>
----</font><font size="3" face="sans-serif"> </font><font size="2" face="sans-serif"><br>
Michael Smith</font><font size="3" face="sans-serif"> </font><font size="2" face="sans-serif"><br>
US Army Corps</font><font size="3" face="sans-serif"> </font><font size="2" face="sans-serif"><br>
Remote Sensing GIS/Center</font><font size="3" face="sans-serif"> </font><font size="3" color="blue"><u><br>
</u></font><a href="mailto:michael.smith@usace.army.mil"><font size="2" color="blue" face="sans-serif"><u>michael.smith@usace.army.mil</u></font></a><font size="3" face="sans-serif">
</font><font size="2" face="sans-serif"><b><br>
<br>
<br>
<br>
From: </b><</font><a href="mailto:Steve.Toutant@inspq.qc.ca"><font size="2" color="blue" face="sans-serif"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size="2" face="sans-serif">><b><br>
Date: </b>Wednesday, July 22, 2015 at 9:34 AM<b><br>
To: </b>Michael Smith <</font><a href="mailto:michael.smith.erdc@gmail.com"><font size="2" color="blue" face="sans-serif"><u>michael.smith.erdc@gmail.com</u></font></a><font size="2" face="sans-serif">><b><br>
Cc: </b><</font><a href="mailto:mapserver-users@lists.osgeo.org"><font size="2" color="blue" face="sans-serif"><u>mapserver-users@lists.osgeo.org</u></font></a><font size="2" face="sans-serif">><b><br>
Subject: </b>Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike
with oracle<br>
<br>
Michael we are using MS7 master and WFS 1.1.0<br>
Can you try with this wfs version instead of 2.0 t osee if you get the
same results?</font><font size="3"> </font>
</p><p>
<table width="100%" style="border-collapse:collapse;">
<tbody><tr valign="top" height="8">
<td width="36%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><font size="1" face="sans-serif"><b>Michael
Smith <</b></font><a href="mailto:michael.smith.erdc@gmail.com"><font size="1" color="blue" face="sans-serif"><b><u>michael.smith.erdc@gmail.com</u></b></font></a><font size="1" face="sans-serif"><b>></b></font><font size="3">
</font>
<p><font size="1" face="sans-serif">2015-07-22 09:32</font><font size="3" face="sans-serif">
</font>
</p></td><td width="63%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<br>
<table width="100%" style="border-collapse:collapse;">
<tbody><tr valign="top" height="8">
<td width="6%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<div align="right"><font size="1" face="sans-serif">A</font></div>
</td><td width="93%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><font size="1" face="sans-serif"><</font><a href="mailto:Steve.Toutant@inspq.qc.ca"><font size="1" color="blue" face="sans-serif"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size="1" face="sans-serif">></font><font size="3">
</font>
</td></tr><tr valign="top" height="8">
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<div align="right"><font size="1" face="sans-serif">cc</font></div>
</td><td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><font size="1" face="sans-serif"><</font><a href="mailto:mapserver-users@lists.osgeo.org"><font size="1" color="blue" face="sans-serif"><u>mapserver-users@lists.osgeo.org</u></font></a><font size="1" face="sans-serif">></font><font size="3">
</font>
</td></tr><tr valign="top" height="8">
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<div align="right"><font size="1" face="sans-serif">Objet</font></div>
</td><td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><font size="1" face="sans-serif">Re:
[mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike with
oracle</font></td></tr></tbody></table>
<br><font size="3" face="sans-serif"><br>
<br>
</font><font size="3"><br>
<br>
<br>
</font>
<br>
<table width="392" style="border-collapse:collapse;">
<tbody><tr valign="top" height="8">
<td width="56" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
</td><td width="332" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"></td></tr></tbody></table>
<br></td></tr></tbody></table>
<br><font size="2" face="sans-serif"><br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
When I do this on my system I get<br>
<br>
request: service=WFS&version=2.0.0&request=GetFeature&typeNames=gridws_pointcloud&Filter=<Filter><PropertyIsEqualto%20MatchCase="FALSE"><PropertyName>FILE_NAME</PropertyName><Literal>test2.las</Literal></PropertyIsEqualTo></Filter><br>
<br>
[Wed Jul 22 09:26:31 2015].885667 got a IEQ comparison<br>
[Wed Jul 22 09:26:31 2015].885676 closing RE comparison<br>
[Wed Jul 22 09:26:31 2015].885681 msOracleSpatialLayerWhichShapes was called.<br>
[Wed Jul 22 09:26:31 2015].885704 msOracleSpatialLayerWhichShapes. Using
this Sql to retrieve the data: SELECT COLLECT_ID, COLLECTION, FILE_NAME,
DATE_LOADED, PC_ID, X, Y, FILE_SIZE_MB, COLLECTDATE, DOWNLOAD_URL, SENSOR_NAME,
rownum, geom WHERE ( REGEXP_LIKE( FILE_NAME, 'test2.las','i' )
) AND SDO_FILTER( geom, MDSYS.SDO_GEOMETRY(2003, :srid, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates
),'querytype=window') = 'TRUE'<br>
<br>
This shows that its translating the PropertyIsEqualTo with MatchCase false
to a regexp_like case insensitive query with no wildcards. Not sure why
you wouldn't get the same thing.<br>
<br>
Mike<br>
<br>
----<br>
Michael Smith<br>
US Army Corps<br>
Remote Sensing GIS/Center</font><font size="3" color="blue"><u><br>
</u></font><a href="mailto:michael.smith@usace.army.mil"><font size="2" color="blue" face="sans-serif"><u>michael.smith@usace.army.mil</u></font></a><font size="2" face="sans-serif"><b><br>
<br>
<br>
From: </b><</font><a href="mailto:Steve.Toutant@inspq.qc.ca"><font size="2" color="blue" face="sans-serif"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size="2" face="sans-serif">><b><br>
Date: </b>Wednesday, July 22, 2015 at 9:13 AM<b><br>
To: </b>Michael Smith <</font><a href="mailto:michael.smith.erdc@gmail.com"><font size="2" color="blue" face="sans-serif"><u>michael.smith.erdc@gmail.com</u></font></a><font size="2" face="sans-serif">><b><br>
Cc: </b><</font><a href="mailto:mapserver-users@lists.osgeo.org"><font size="2" color="blue" face="sans-serif"><u>mapserver-users@lists.osgeo.org</u></font></a><font size="2" face="sans-serif">><b><br>
Subject: </b>Re: [mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike
with oracle<br>
<br>
Thanks for your help, here is the log<br>
Steve</font><font size="3" face="sans-serif"><br>
ul 22 08:14:09 2015].892715 msOracleSpatialLayerWhichShapes. Bind values:
srid:4326 minx:-91.320741 miny:41.948470 maxx:-45.679259 maxy:63.664769<br>
[Wed Jul 22 08:14:09 2015].894113 msOracleSpatialLayerWhichShapes bind
by name and object.<br>
[Wed Jul 22 08:14:09 2015].894134 msOracleSpatialLayerWhichShapes name
and object now bound.<br>
[Wed Jul 22 08:14:10 2015].77889 mapserv request processing time (msLoadMap
not incl.): 0.203s<br>
[Wed Jul 22 08:14:10 2015].77903 msOracleSpatialLayerClose was called.
Layer: 0x1308650, Layer name: SMDVDP_STAT_METE<br>
[Wed Jul 22 08:14:10 2015].78084 msConnPoolRelease(SMDVDP_STAT_METE,USER/*************@DATABASE:1521/DEV.fadq.qc,0x1481850)<br>
[Wed Jul 22 08:14:30 2015].200042 CGI Request 38 on process 14430<br>
[Wed Jul 22 08:14:30 2015].200197 msOracleSpatialLayerOpen called with:
GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR FROM
D_DEB) = 2015) USING SRID 4326 (Layer pointer 0x142bbe0)<br>
[Wed Jul 22 08:14:30 2015].200215 msConnPoolRequest(SMDVDP_STAT_METE,USER/*************@DATABASE:1521/DEV.fadq.qc)
-> got 0x1481850<br>
[Wed Jul 22 08:14:30 2015].208656 msOracleSpatialLayerFreeItemInfo was
called.<br>
[Wed Jul 22 08:14:30 2015].208676 msOracleSpatialLayerGetItems was called.<br>
[Wed Jul 22 08:14:30 2015].209323 msOracleSpatialLayerInitItemInfo was
called.<br>
[Wed Jul 22 08:14:30 2015].209369 msOracleSpatialLayerFreeItemInfo was
called.<br>
[Wed Jul 22 08:14:30 2015].209374 msOracleSpatialLayerClose was called.
Layer: 0x142bbe0, Layer name: SMDVDP_STAT_METE<br>
[Wed Jul 22 08:14:30 2015].209396 msConnPoolRelease(SMDVDP_STAT_METE,USER/*************@DATABASE:1521/DEV.fadq.qc,0x1481850)<br>
[Wed Jul 22 08:14:30 2015].210875 msOracleSpatialLayerOpen called with:
GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR FROM
D_DEB) = 2015) USING SRID 4326 (Layer pointer 0x142bbe0)<br>
[Wed Jul 22 08:14:30 2015].210889 msConnPoolRequest(SMDVDP_STAT_METE,USER/*************@DATABASE:1521/DEV.fadq.qc)
-> got 0x1481850<br>
[Wed Jul 22 08:14:30 2015].218325 msOracleSpatialLayerOpen called with:
GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR FROM
D_DEB) = 2015) USING SRID 4326 (Layer pointer 0x142bbe0)<br>
[Wed Jul 22 08:14:30 2015].218345 msOracleSpatialLayerFreeItemInfo was
called.<br>
[Wed Jul 22 08:14:30 2015].218354 msOracleSpatialLayerGetItems was called.<br>
[Wed Jul 22 08:14:30 2015].218946 msOracleSpatialLayerInitItemInfo was
called.<br>
[Wed Jul 22 08:14:30 2015].218980 msOracleSpatialLayerFreeItemInfo was
called.<br>
[Wed Jul 22 08:14:30 2015].218985 msOracleSpatialLayerClose was called.
Layer: 0x142bbe0, Layer name: SMDVDP_STAT_METE<br>
[Wed Jul 22 08:14:30 2015].219003 msConnPoolRelease(SMDVDP_STAT_METE,USER/*************@DATABASE:1521/DEV.fadq.qc,0x1481850)<br>
[Wed Jul 22 08:14:30 2015].219010 msOracleSpatialLayerOpen called with:
GEOM_POIN from (select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR FROM
D_DEB) = 2015) USING SRID 4326 (Layer pointer 0x142bbe0)<br>
[Wed Jul 22 08:14:30 2015].219018 msConnPoolRequest(SMDVDP_STAT_METE,USER/*************@DATABASE:1521/DEV.fadq.qc)
-> got 0x1481850<br>
[Wed Jul 22 08:14:30 2015].225298 msOracleSpatialLayerEnablePaging was
called.<br>
[Wed Jul 22 08:14:30 2015].225318 msOracleSpatialLayerFreeItemInfo was
called.<br>
[Wed Jul 22 08:14:30 2015].225328 msOracleSpatialLayerFreeItemInfo was
called.<br>
[Wed Jul 22 08:14:30 2015].225334 msOracleSpatialLayerGetItems was called.<br>
[Wed Jul 22 08:14:30 2015].225868 msOracleSpatialLayerInitItemInfo was
called.<br>
[Wed Jul 22 08:14:30 2015].225892 msOracleSpatialLayerInitItemInfo was
called.<br>
[Wed Jul 22 08:14:30 2015].226421 msOracleSpatialLayerTranslateFilter.
String: ("[NOM_STAT]" =*"Anto")<br>
[Wed Jul 22 08:14:30 2015].226429 msOracleSpatialLayerTranslateFilter.
There are tokens to process<br>
[Wed Jul 22 08:14:30 2015].226435 got a IEQ comparison<br>
[Wed Jul 22 08:14:30 2015].226440 closing RE comparison<br>
[Wed Jul 22 08:14:30 2015].226444 msOracleSpatialLayerWhichShapes was called.<br>
[Wed Jul 22 08:14:30 2015].226470 msOracleSpatialLayerWhichShapes. Us</font><font size="3">
</font>
</p><p>
<table width="100%" style="border-collapse:collapse;">
<tbody><tr valign="top" height="8">
<td width="36%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><font size="1" face="sans-serif"><b>Michael
Smith <</b></font><a href="mailto:michael.smith.erdc@gmail.com"><font size="1" color="blue" face="sans-serif"><b><u>michael.smith.erdc@gmail.com</u></b></font></a><font size="1" face="sans-serif"><b>></b></font><font size="3">
</font>
<p><font size="1" face="sans-serif">2015-07-21 11:24</font><font size="3" face="sans-serif">
</font>
</p></td><td width="63%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<br>
<table width="100%" style="border-collapse:collapse;">
<tbody><tr valign="top" height="8">
<td width="6%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<div align="right"><font size="1" face="sans-serif">A</font></div>
</td><td width="93%" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><font size="1" face="sans-serif"><</font><a href="mailto:Steve.Toutant@inspq.qc.ca"><font size="1" color="blue" face="sans-serif"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size="1" face="sans-serif">>,
<</font><a href="mailto:mapserver-users@lists.osgeo.org"><font size="1" color="blue" face="sans-serif"><u>mapserver-users@lists.osgeo.org</u></font></a><font size="1" face="sans-serif">></font><font size="3">
</font>
</td></tr><tr valign="top" height="8">
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<div align="right"><font size="1" face="sans-serif">cc</font></div>
</td><td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
</td></tr><tr valign="top" height="8">
<td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
<div align="right"><font size="1" face="sans-serif">Objet</font></div>
</td><td style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"><font size="1" face="sans-serif">Re:
[mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike with
oracle</font></td></tr></tbody></table>
<br><font size="3" face="sans-serif"><br>
<br>
<br>
</font><font size="3"><br>
<br>
<br>
</font>
<br>
<table width="392" style="border-collapse:collapse;">
<tbody><tr valign="top" height="8">
<td width="56" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;">
</td><td width="332" style="border-style:none none none none;border-color:#000000;border-width:0px 0px 0px 0px;padding:1px 1px;"></td></tr></tbody></table>
<br></td></tr></tbody></table>
<br><font size="2" face="sans-serif"><br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
Steve,<br>
<br>
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.<br>
<br>
Can you do DEBUG 3 and show the log?<br>
<br>
Mike<br>
<br>
-- <br>
Michael Smith<br>
Remote Sensing/GIS Center<br>
US Army Corps of Engineers<b><br>
<br>
From: </b><</font><a href="mailto:mapserver-users-bounces@lists.osgeo.org"><font size="2" color="blue" face="sans-serif"><u>mapserver-users-bounces@lists.osgeo.org</u></font></a><font size="2" face="sans-serif">>
on behalf of <</font><a href="mailto:Steve.Toutant@inspq.qc.ca"><font size="2" color="blue" face="sans-serif"><u>Steve.Toutant@inspq.qc.ca</u></font></a><font size="2" face="sans-serif">><b><br>
Date: </b>Tuesday, July 21, 2015 at 10:07 AM<b><br>
To: </b><</font><a href="mailto:mapserver-users@lists.osgeo.org"><font size="2" color="blue" face="sans-serif"><u>mapserver-users@lists.osgeo.org</u></font></a><font size="2" face="sans-serif">><b><br>
Subject: </b>[mapserver-users] ogc:PropertyIsEqualTo behaves like PropertyIsLike
with oracle<br>
<br>
Hi,<br>
Using MS7+oracle, I apply a wfs filter </font><font size="3" face="sans-serif">PropertyIsEqualTo</font><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.<br>
The complete value is "Antonin". I apply the filter using "Anto"<br>
<br>
<br>
MS7+Postgis</font><font size="3" face="sans-serif"><br>
<wfs:Query typeName="feature:SMDVDP_STAT_METE" srsName="EPSG:3857"><ogc:Filter
xmlns:ogc="</font><a href="http://www.opengis.net/ogc"><font size="3" color="blue" face="sans-serif"><u>http://www.opengis.net/ogc</u></font></a><font size="3" face="sans-serif">"><ogc:PropertyIsEqualTo
matchCase="false"><ogc:PropertyName>NOM_STAT</ogc:PropertyName><ogc:Literal><b>Anto</b></ogc:Literal></ogc:PropertyIsEqualTo></ogc:Filter></wfs:Query><br>
numberOfFeatures="0" , that is ok.<br>
Ms log: </font><font size="2" face="sans-serif">FLTLayerApplyPlainFilterToLayer():
("[NOM_STAT]" =*"Anto")<br>
<br>
Ms7+Oracle</font><font size="3" face="sans-serif"><br>
<wfs:Query typeName="feature:SMDVDP_STAT_METE" srsName="EPSG:32198"><ogc:Filter
xmlns:ogc="</font><a href="http://www.opengis.net/ogc"><font size="3" color="blue" face="sans-serif"><u>http://www.opengis.net/ogc</u></font></a><font size="3" face="sans-serif">"><ogc:PropertyIsEqualTo
matchCase="false"><ogc:PropertyName>NOM_STAT</ogc:PropertyName><ogc:Literal><b>Anto</b></ogc:Literal></ogc:PropertyIsEqualTo></ogc:Filter></wfs:Query><br>
numberOfFeatures="1" , BAD<br>
Mslog: msOracleSpatialLayerTranslateFilter. String: ("[NOM_STAT]"
=*"Anto") <br>
<br>
Is the problem MS o oracle? Should I open a Ms bug?<br>
Regards! </font>
</p><p><font size="2" face="sans-serif">_______________________________________________
mapserver-users mailing list </font><a href="mailto:mapserver-users@lists.osgeo.org"><font size="2" color="blue" face="sans-serif"><u>mapserver-users@lists.osgeo.org</u></font></a><a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users"><font size="2" color="blue" face="sans-serif"><u>http://lists.osgeo.org/mailman/listinfo/mapserver-users</u></font></a><font size="3" face="sans-serif"><br>
<br>
</font><font size="2" face="sans-serif"><br>
<br>
<br>
<br>
_______________________________________________<br>
mapserver-users mailing list</font><font size="3" color="blue"><u><br>
</u></font><a href="mailto:mapserver-users@lists.osgeo.org"><font size="2" color="blue" face="sans-serif"><u>mapserver-users@lists.osgeo.org</u></font></a><font size="3" color="blue"><u><br>
</u></font><a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users"><font size="2" color="blue" face="sans-serif"><u>http://lists.osgeo.org/mailman/listinfo/mapserver-users</u></font></a><font size="3"><br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
</font>
<br>
<br>
<br>
<br><!--end of _originalContent --></p></div></body></html>