FDO RFC 40 - Add standardized ordering support

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 ModifiedZac Spitzer

Error: Failed to load processor Timestamp
No macro or processor named 'Timestamp' found

AuthorZac 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