Ticket #3372 (new defect)
invalid postgresql function added when generating a sql request from a filter expression
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
Note: See
TracTickets for help on using
tickets.
