[Geoserver-devel] [JIRA] (GEOS-9131) Multiple SortBy Expressions WFS query with nested filter fails on App-schema SQL

GeoServer GeoServer Developer
1

Fernando Miño created an issue

GeoServer / BugGEOS-9131

Multiple SortBy Expressions WFS query with nested filter fails on App-schema SQL

Issue Type:

BugBug

Assignee:

Unassigned

Components:

Application schema

Created:

24/Feb/19 6:10 PM

Priority:

MediumMedium

Reporter:

Fernando Miño

Executing a WFS query with nested filter and multiple sortBy expressions throws an malformed SQL exception on App-schema and Postgresql.

For example this WFS Query executed on Stations example data:

<wfs:GetFeature service="WFS" version="2.0.0"
    xmlns:st="http://www.stations.org/1.0"
    xmlns:wfs="http://www.opengis.net/wfs/2.0"
    xmlns:fes="http://www.opengis.net/fes/2.0"
    xmlns:gml="http://www.opengis.net/gml/3.2">
    <wfs:Query typeNames="st:Station" srsName="EPSG:4326">
        <fes:Filter>
            <fes:PropertyIsLike wildCard="*"
                singleChar="." escapeChar="\">
                <fes:ValueReference>st:Station/st:observation/st:Observation/st:description
                </fes:ValueReference>
                <fes:Literal>*</fes:Literal>
            </fes:PropertyIsLike>
        </fes:Filter>
        <fes:SortBy>
            <fes:SortProperty>
                <fes:ValueReference>st:Station/st:stationName</fes:ValueReference>
                <fes:SortOrder>DESC</fes:SortOrder>
            </fes:SortProperty>
					<fes:SortProperty>
                <fes:ValueReference>st:Station</fes:ValueReference>
                <fes:SortOrder>ASC</fes:SortOrder>
            </fes:SortProperty>
        </fes:SortBy>
    </wfs:Query>
</wfs:GetFeature>

Throws a Postgresql exception:

ERROR:  syntax error at or near "FROM" at character 504

Add Comment

Add Comment

Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS

This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100098-sha1:60b0277)

Atlassian logo