[#GEOS-2326] incorrect sql statement - jira.codehaus.org

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 :
0

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.

Activity

Ascending order - Click to sort in descending order

Hide

Permalink

Chris Holmes added a comment - 04/Dec/09 12:18 PM

This is probably no longer relevant with postgis-ng, if you confirm then close.

Show

Chris Holmes added a comment - 04/Dec/09 12:18 PM This is probably no longer relevant with postgis-ng, if you confirm then close.

Hide

Permalink

Andrea Aime added a comment - 11/Apr/10 10:00 AM

Tried a very similar one:

<wfs:GetFeature service="WFS" version="1.0.0"
  outputFormat="GML2"
  xmlns:tiger="http://www.census.gov/tiger"
  xmlns:wfs="http://www.opengis.net/wfs"
  xmlns:ogc="http://www.opengis.net/ogc"
  xmlns:gml="http://www.opengis.net/gml"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://www.opengis.net/wfs
                      http://schemas.opengis.net/wfs/1.0.0/WFS-basic.xsd">
  <wfs:Query typeName="tiger:pgstates">
    <ogc:PropertyName>tiger:state_name</ogc:PropertyName>
    <ogc:PropertyName>tiger:persons</ogc:PropertyName>
    <ogc:Filter>
       <And>
<ogc:PropertyIsLike wildCard='*' singleChar='.' escape='!'>
<ogc:PropertyName>state_name</ogc:PropertyName>
<ogc:Literal>M*</ogc:Literal>
</ogc:PropertyIsLike>
<ogc:PropertyIsEqualTo>
<ogc:PropertyName>state_fips</ogc:PropertyName><ogc:Literal>30</ogc:Literal>
</ogc:PropertyIsEqualTo>
</And>
</ogc:Filter>
  </wfs:Query>
</wfs:GetFeature>

against a "states" layer imported in PostGIS, no problems

Show

Andrea Aime added a comment - 11/Apr/10 10:00 AM Tried a very similar one: <wfs:GetFeature service= "WFS" version= "1.0.0" outputFormat= "GML2" xmlns:tiger = "http://www.census.gov/tiger" xmlns:wfs = "http://www.opengis.net/wfs" xmlns:ogc = "http://www.opengis.net/ogc" xmlns:gml = "http://www.opengis.net/gml" xmlns:xsi = "http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.0.0/WFS-basic.xsd"> <wfs:Query typeName= "tiger:pgstates" > <ogc:PropertyName> tiger:state_name </ogc:PropertyName> <ogc:PropertyName> tiger:persons </ogc:PropertyName> <ogc:Filter> <And> <ogc:PropertyIsLike wildCard='*' singleChar='.' escape='!'> <ogc:PropertyName> state_name </ogc:PropertyName> <ogc:Literal> M* </ogc:Literal> </ogc:PropertyIsLike> <ogc:PropertyIsEqualTo> <ogc:PropertyName> state_fips </ogc:PropertyName> <ogc:Literal> 30 </ogc:Literal> </ogc:PropertyIsEqualTo> </And> </ogc:Filter> </wfs:Query> </wfs:GetFeature> against a "states" layer imported in PostGIS, no problems

incorrect sql statement

Details

Description

Activity

People

Dates