DataNucleus JIRA is now in read-only mode. Raise any new issues in GitHub against the plugin that it applies to. DataNucleus JIRA will remain for the foreseeable future but will eventually be discontinued
Issue Details (XML | Word | Printable)

Key: NUCRDBMS-685
Type: New Feature New Feature
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Unassigned
Reporter: Andy Jefferson
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
DataNucleus Store RDBMS

Support query ordering "NULLS FIRST"/"NULLS LAST" directives when available for RDBMS that support it

Created: 29/Jul/13 03:31 PM   Updated: 31/Jul/13 04:54 PM   Resolved: 29/Jul/13 04:11 PM
Component/s: Queries
Affects Version/s: None
Fix Version/s: 3.2.5


 Description  « Hide
ANSI SQL 99 apparently supports ordering clauses with
"NULLS FIRST"/"NULLS LAST" after the ASC/DESC. NUCCORE-1060 supports parsing/compiling of this

Sort Order: Ascending order - Click to sort in descending order
Andy Jefferson added a comment - 29/Jul/13 04:11 PM
SVN trunk now supports this syntax for H2, HSQLDB, PostgreSQL, Oracle and DB2.