[
https://issues.apache.org/jira/browse/DERBY-2887?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12515023
]
Christian d'Heureuse commented on DERBY-2887:
---------------------------------------------
The Oracle documentation says:
ASC | DESC Specify the ordering sequence (ascending or descending). ASC is the
default.
NULLS FIRST | NULLS LAST Specify whether returned rows containing nulls should
appear first or last in the ordering sequence.
NULLS LAST is the default for ascending order, and NULLS FIRST is the default
for
descending order.
(The default for NULLS FIRST/LAST is the same as in Derby)
> NULLS FIRST / LAST for ORDER BY
> -------------------------------
>
> Key: DERBY-2887
> URL: https://issues.apache.org/jira/browse/DERBY-2887
> Project: Derby
> Issue Type: Improvement
> Components: SQL
> Reporter: Christian d'Heureuse
> Assignee: Bryan Pendleton
> Priority: Minor
> Attachments: prototypeCodeNoTests.diff, prototypeCodeNoTests_v2.diff
>
>
> I suggest to implement the "null ordering" option for the "ORDER BY" clause:
> According to the SQL standard, 10.10 <sort specification list>:
> <null ordering> ::=
> NULLS FIRST
> | NULLS LAST
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
