Opened 14 years ago
Last modified 14 years ago
#3372 new defect
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.') ) )
Note:
See TracTickets
for help on using tickets.
Post request: wfs-1.1.0-Basic-GetFeature-tc35.2