Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 1.6.5, 1.7.0
-
Fix Version/s: None
-
Component/s: PostGIS
-
Labels:None
-
Environment:suse sles 10
-
Number of attachments :
Description
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 is probably no longer relevant with postgis-ng, if you confirm then close.