Ticket #3372 (new defect)

Opened 2 years ago

Last modified 2 years ago

invalid postgresql function added when generating a sql request from a filter expression

Reported by: nsavard Owned by: mapserverbugs
Priority: normal Milestone:
Component: WFS Server Version: svn-trunk (development)
Severity: normal Keywords: wfs1.1 getfeature filter sql
Cc: assefa, tomkralidis

Description

The 'lower' function call in a SQL request to postgresql is invalid. The request is resulting from the conversion of a filter expression.

getfeature request:

   URL: http://gw.mapgears.com:8500/cgi-bin/mswfs110_ogc_cite?
   Body: 
<wfs:GetFeature xmlns="http://www.occamlab.com/ctl" xmlns:ctl="http://www.occamlab.com/ctl"
                xmlns:gml="http://www.opengis.net/gml"
                xmlns:myparsers="http://teamengine.sourceforge.net/parsers"
                xmlns:ogc="http://www.opengis.net/ogc"
                xmlns:ows="http://www.opengis.net/ows"
                xmlns:p="http://teamengine.sourceforge.net/parsers"
                xmlns:parsers="http://www.occamlab.com/te/parsers"
                xmlns:saxon="http://saxon.sf.net/"
                xmlns:sf="http://cite.opengeospatial.org/gmlsf"
                xmlns:te="http://www.occamlab.com/te"
                xmlns:tec="java:com.occamlab.te.TECore"
                xmlns:wfs="http://www.opengis.net/wfs"
                xmlns:xi="http://www.w3.org/2001/XInclude"
                xmlns:xlink="http://www.w3.org/1999/xlink"
                xmlns:xs="http://www.w3.org/2001/XMLSchema"
                xmlns:xsd="http://www.w3.org/2001/XMLSchema"
                xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                service="WFS"
                version="1.1.0">
   <wfs:Query srsName="urn:x-ogc:def:crs:EPSG:4326" typeName="sf:AggregateGeoFeature">
      <ogc:Filter>
         <ogc:PropertyIsEqualTo matchCase="false">
            <ogc:PropertyName>sf:strProperty</ogc:PropertyName>
            <ogc:Literal>mA quANde lIngues COALEsce, li graMMatiCa dEl reSULtAnt.</ogc:Literal>
         </ogc:PropertyIsEqualTo>
      </ogc:Filter>
   </wfs:Query>
</wfs:GetFeature>


sql request:

 select "description","name","doubleProperty","intRangeProperty","strProperty","featureCode","id",encode(AsBinary(force_collection(force_2d("the_geom")),'NDR'),'hex') as geom,"id" from aggregategeofeature where the_geom && GeomFromText('POLYGON((-25000000.000000000000000 -25000000.000000000000000,-25000000.000000000000000 25000000.000000000000000,25000000.000000000000000 25000000.000000000000000,25000000.000000000000000 -25000000.000000000000000,-25000000.000000000000000 -25000000.000000000000000))',4326) and ( ("lower(strProperty) "= lower('mA quANde lIngues COALEsce, li graMMatiCa dEl reSULtAnt.') ) )


Change History

Changed 2 years ago by nsavard

Post request: wfs-1.1.0-Basic-GetFeature?-tc35.2

Note: See TracTickets for help on using tickets.