[
https://issues.apache.org/jira/browse/DERBY-2887?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Bryan Pendleton updated DERBY-2887:
-----------------------------------
Attachment: nullOrderingPatch.diff
Attached is nullOrderingPatch.diff, a patch proposal. This patch builds on the
prototype_v3 patch by:
- adding code to OrderByList to ensure that ORDER BY triggers a sort when
necessary
- adding tests to orderby.sql and orderbyElimination.sql to demonstrate the
behavior of NULLS FIRST/LAST
- adding a few more comments to the code changes.
I'd be most grateful if you could have a look at this patch proposal and tell
me what you think.
> 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: nullOrderingPatch.diff, prototypeCodeNoTests.diff,
> prototypeCodeNoTests_v2.diff, prototypeCodeNoTests_v3.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.
