FDO RFC 40 - Support for Ordering

This page contains a request for comments document (RFC) for the FDO Open Source project. More FDO RFCs can be found on the RFCs page.

Status

RFC Template Version	(1.0)
Submission Date	(Date/Time submitted)
Last Modified	Zac Spitzer Timestamp
Author	Zac Spitzer
RFC Status	(draft)
Implementation Status	(pending)
Proposed Milestone	(e.g. 3.5)
Assigned PSC guide(s)	(when determined)

Overview

FDO currently has no standardized support for result set ordering.

Motivation

Ordering is a very commonly used operation with databases.

Clients such as MapGuide can support rendering of complex roads networks if the resultset are ordered, allowing major features to be rendered atop minor features.

​http://trac.osgeo.org/mapguide/wiki/MapGuideRfc69 would require such support.

Proposed Solution

Add support for ordering to the FDO spec.

Help Wanted

Implications

TBD

Test Plan

TBD

Funding/Resources

Help Wanted

Related Trac Tickets

​New ExtendedSelect command and Scrollable Reader
​http://trac.osgeo.org/mapguide/wiki/MapGuideRfc69
#618 Theming stylisation order isn't respected in a layer
​FDO Core enhancment: support standard ORDER BY expressions

Discussions

​http://n2.nabble.com/RE%3A--fdo-trac---516%3A-FDO-Core-enhancment%3A-support-standard-ORDER-BY-expressions-td2741343.html#a2741343
​http://n2.nabble.com/MapGuide-RFC-69---Rendering-Layer-Styles-using-Style-Order-td3158848.html
​http://n2.nabble.com/RE%3A-MapGuide-RFC-69---Rendering-Layer-Styles-td3159460.html