Improper handling of complex features served from denormalized views
--------------------------------------------------------------------
Key: GEOS-3808
URL: http://jira.codehaus.org/browse/GEOS-3808
Project: GeoServer
Issue Type: Bug
Components: WFS
Environment: GeoServer 2.1 trunk
Reporter: Pavel Golodoniuc
Assignee: Andrea Aime
Fix For: 2.1.x
I have configured er:Mine feature type using demornalized unsorted (it makes a difference!) view. The feature that comes firsts in that unsorted recordset is er.mine.871, which contains has two associated rows in the database:
SELECT *
FROM ER_MINE
WHERE site_id = 871;
||SITE_ID||GML_ID||NAME_VALUE||NAME_CODESPACE||OCCURRENCE_URN||STATUS||
|871|er.mine.871|urn:cgi:feature:NTGS:Mine:871|http://www.ietf.org/rfc/rfc2141|urn:cgi:feature:NTGS:MiningFeatureOccurrence:871|unknown|
|871|er.mine.871|Horizontal|http://services.auscope.org/ntgs-earthresource|urn:cgi:feature:NTGS:MiningFeatureOccurrence:871|unknown|
2 rows selected
Ideally, these two records should be grouped together and they should compose a single feature with two gml:name attributes (populated with the data from NAME_VALUE and NAME_CODESPACE). If you will do a simple GetFeature request http://services-test.auscope.org/ntgs-earthresource/ows?service=WFS&version=1.1.0&request=GetFeature&typeName=er:Mine&maxFeatures=50 the WFS response will only contain the first gml:name attribute. The other one will be missing. However, if you will request this particular feature by gml:id http://services-test.auscope.org/ntgs-earthresource/ows?service=WFS&version=1.1.0&request=GetFeature&typeName=er:Mine&featureid=er.mine.871 everything will be okay. It seems that maxFeatures=50 parameter prevents GeoServer from finding the second row associated with the same gml:id. Shoud I add ORDER BY clause at the end of ER_MINE view it will be working fine. Weird. Isn't it?
--
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