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

Wed Jul 22 06:13:35 PDT 2015

Thanks for your help, here is the log
Steve
 ul 22 08:14:09 2015].892715 msOracleSpatialLayerWhichShapes. Bind values: 
srid:4326 minx:-91.320741 miny:41.948470 maxx:-45.679259 maxy:63.664769
[Wed Jul 22 08:14:09 2015].894113 msOracleSpatialLayerWhichShapes bind by 
name and object.
[Wed Jul 22 08:14:09 2015].894134 msOracleSpatialLayerWhichShapes name and 
object now bound.
[Wed Jul 22 08:14:10 2015].77889 mapserv request processing time 
(msLoadMap not incl.): 0.203s
[Wed Jul 22 08:14:10 2015].77903 msOracleSpatialLayerClose was called. 
Layer: 0x1308650, Layer name: SMDVDP_STAT_METE
[Wed Jul 22 08:14:10 2015].78084 
msConnPoolRelease(SMDVDP_STAT_METE,USER/*************@DATABASE:1521/DEV.fadq.qc,0x1481850)
[Wed Jul 22 08:14:30 2015].200042 CGI Request 38 on process 14430
[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)
[Wed Jul 22 08:14:30 2015].200215 
msConnPoolRequest(SMDVDP_STAT_METE,USER/*************@DATABASE:1521/DEV.fadq.qc) 
-> got 0x1481850
[Wed Jul 22 08:14:30 2015].208656 msOracleSpatialLayerFreeItemInfo was 
called.
[Wed Jul 22 08:14:30 2015].208676 msOracleSpatialLayerGetItems was called.
[Wed Jul 22 08:14:30 2015].209323 msOracleSpatialLayerInitItemInfo was 
called.
[Wed Jul 22 08:14:30 2015].209369 msOracleSpatialLayerFreeItemInfo was 
called.
[Wed Jul 22 08:14:30 2015].209374 msOracleSpatialLayerClose was called. 
Layer: 0x142bbe0, Layer name: SMDVDP_STAT_METE
[Wed Jul 22 08:14:30 2015].209396 
msConnPoolRelease(SMDVDP_STAT_METE,USER/*************@DATABASE:1521/DEV.fadq.qc,0x1481850)
[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)
[Wed Jul 22 08:14:30 2015].210889 
msConnPoolRequest(SMDVDP_STAT_METE,USER/*************@DATABASE:1521/DEV.fadq.qc) 
-> got 0x1481850
[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)
[Wed Jul 22 08:14:30 2015].218345 msOracleSpatialLayerFreeItemInfo was 
called.
[Wed Jul 22 08:14:30 2015].218354 msOracleSpatialLayerGetItems was called.
[Wed Jul 22 08:14:30 2015].218946 msOracleSpatialLayerInitItemInfo was 
called.
[Wed Jul 22 08:14:30 2015].218980 msOracleSpatialLayerFreeItemInfo was 
called.
[Wed Jul 22 08:14:30 2015].218985 msOracleSpatialLayerClose was called. 
Layer: 0x142bbe0, Layer name: SMDVDP_STAT_METE
[Wed Jul 22 08:14:30 2015].219003 
msConnPoolRelease(SMDVDP_STAT_METE,USER/*************@DATABASE:1521/DEV.fadq.qc,0x1481850)
[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)
[Wed Jul 22 08:14:30 2015].219018 
msConnPoolRequest(SMDVDP_STAT_METE,USER/*************@DATABASE:1521/DEV.fadq.qc) 
-> got 0x1481850
[Wed Jul 22 08:14:30 2015].225298 msOracleSpatialLayerEnablePaging was 
called.
[Wed Jul 22 08:14:30 2015].225318 msOracleSpatialLayerFreeItemInfo was 
called.
[Wed Jul 22 08:14:30 2015].225328 msOracleSpatialLayerFreeItemInfo was 
called.
[Wed Jul 22 08:14:30 2015].225334 msOracleSpatialLayerGetItems was called.
[Wed Jul 22 08:14:30 2015].225868 msOracleSpatialLayerInitItemInfo was 
called.
[Wed Jul 22 08:14:30 2015].225892 msOracleSpatialLayerInitItemInfo was 
called.
[Wed Jul 22 08:14:30 2015].226421 msOracleSpatialLayerTranslateFilter. 
String: ("[NOM_STAT]" =*"Anto")
[Wed Jul 22 08:14:30 2015].226429 msOracleSpatialLayerTranslateFilter. 
There are tokens to process
[Wed Jul 22 08:14:30 2015].226435 got a IEQ comparison
[Wed Jul 22 08:14:30 2015].226440 closing RE comparison
[Wed Jul 22 08:14:30 2015].226444 msOracleSpatialLayerWhichShapes was 
called.
[Wed Jul 22 08:14:30 2015].226470 msOracleSpatialLayerWhichShapes. Us

Michael Smith <michael.smith.erdc at gmail.com> 
2015-07-21 11:24

A
<Steve.Toutant at inspq.qc.ca>, <mapserver-users at lists.osgeo.org>
cc

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

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-bounces at lists.osgeo.org> on behalf of <
Steve.Toutant at inspq.qc.ca>
Date: Tuesday, July 21, 2015 at 10:07 AM
To: <mapserver-users at 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: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!
_______________________________________________ mapserver-users mailing 
list mapserver-users at lists.osgeo.org 
http://lists.osgeo.org/mailman/listinfo/mapserver-users

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