incorrect sql statement
------------------------
Key: GEOS-2326
URL: http://jira.codehaus.org/browse/GEOS-2326
Project: GeoServer
Issue Type: Bug
Components: PostGIS
Affects Versions: 1.7.0 , 1.6.5
Environment: suse sles 10
Reporter: Uli Rothstein
Assignee: Andrea Aime
sending the filter-condition
<ogc:Filter>
<And>
<ogc:PropertyIsLike wildCard='*' singleChar='.' escape='!'>
<ogc:PropertyName>ud_id</ogc:PropertyName>
<ogc:Literal>*888888888888</ogc:Literal>
</ogc:PropertyIsLike>
<ogc:PropertyIsEqualTo>
<ogc:PropertyName>objekttyp_id</ogc:PropertyName><ogc:Literal>2</ogc:Literal>
</ogc:PropertyIsEqualTo>
</And>
</ogc:Filter>
via get-parameter to geoserver versions 1.6.5 and 1.7.0.
Both versions build the sql statement:
28 Okt 08:18:00 DEBUG [data.jdbc] - About to execute query:
SELECT "object_id", "ud_id", "meldevertreter_id", "objekttyp_id", "bemerkung", "flaeche", "datum",
encode(asBinary(force_2d("the_geom"),'XDR'),'base64'), "objekttyp_name" FROM "gis"."f_lw_digi_flaechen"
WHERE ( ( "ud_id" LIKE '%999999999999' ) AND 'objekttyp_id' = '1') LIMIT 1000000
The attribute-name objekttype_id is single quoted but has to be double quoted.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira