[mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature with filter on numeric field

[Steve.Toutant at inspq.qc.ca]

It seems to be a bug isn't?
Do you want me to open an issue?



"Smith, Michael ERDC-RDE-CRREL-NH" <Michael.Smith at erdc.dren.mil> 
2015-05-19 12:24

A
"Steve.Toutant at inspq.qc.ca" <Steve.Toutant at inspq.qc.ca>
cc
"Rahkonen Jukka (MML)" <jukka.rahkonen at maanmittauslaitos.fi>, 
MapserverList OSGEO <mapserver-users at lists.osgeo.org>
Objet
Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs getFeature 
with filter on numeric field






It looks like whats happening is that?s being converted into 3 Tokens and 
the oracle driver converts it into a number + comma + number. 

The tokenizer is not treating that value as a single value. 

Mike

From: "Steve.Toutant at inspq.qc.ca" <Steve.Toutant at inspq.qc.ca>
Date: Tuesday, May 19, 2015 at 11:44 AM
To: Michael Smith <michael.smith at erdc.dren.mil>
Cc: "Rahkonen Jukka (MML)" <jukka.rahkonen at maanmittauslaitos.fi>, 
MapserverList OSGEO <mapserver-users at lists.osgeo.org>
Subject: Re: [mapserver-users] [EXTERNAL] Re: Mapserver 7+oracle - wfs 
getFeature with filter on numeric field

here is the mapserver log with <ogc:PropertyIsEqualTo 
matchCase="true"><ogc:PropertyName>LONG_STAT</ogc:PropertyName><ogc:Literal>-61,8031</ogc:Literal></ogc:PropertyIsEqualTo>


msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data: 
SELECT ID, NO_STAT_CLIM, NO_STAT_FADQ, NOM_STAT, LATI_STAT, LONG_STAT, 
ALTI_STAT, D_DEB, D_FIN, TIMB_MAJ, USAG_MAJ, rownum, GEOM_POIN FROM 
(select * FROM SMDVDP_STAT_METE WHERE EXTRACT(YEAR FROM D_DEB) = 2014) 
WHERE  ( LONG_STAT = -61.000000,8031.000000 )  AND SDO_FILTER( GEOM_POIN, 
MDSYS.SDO_GEOMETRY(2003, :srid, 
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') 
= 'TRUE'


The problem is 
WHERE  ( LONG_STAT = -61.000000,8031.000000 )
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20150519/448ff8b0/attachment.htm>