Return-Path: 
 <derby-dev-return-47153-apmail-db-derby-dev-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-dev-archive@www.apache.org
Received: (qmail 93224 invoked from network); 27 Jul 2007 14:45:40 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 27 Jul 2007 14:45:40 -0000
Received: (qmail 37078 invoked by uid 500); 27 Jul 2007 14:45:40 -0000
Delivered-To: apmail-db-derby-dev-archive@db.apache.org
Received: (qmail 37051 invoked by uid 500); 27 Jul 2007 14:45:40 -0000
Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:derby-dev-help@db.apache.org>
List-Unsubscribe: <mailto:derby-dev-unsubscribe@db.apache.org>
List-Post: <mailto:derby-dev@db.apache.org>
List-Id: <derby-dev.db.apache.org>
Reply-To: <derby-dev@db.apache.org>
Delivered-To: mailing list derby-dev@db.apache.org
Received: (qmail 37042 invoked by uid 99); 27 Jul 2007 14:45:39 -0000
Received: from Unknown (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 27 Jul 2007 07:45:39 -0700
X-ASF-Spam-Status: No, hits=-100.0 required=10.0
	tests=ALL_TRUSTED
X-Spam-Check-By: apache.org
Received: from [140.211.11.4] (HELO brutus.apache.org) (140.211.11.4)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 27 Jul 2007 14:45:38 +0000
Received: from brutus (localhost [127.0.0.1])
	by brutus.apache.org (Postfix) with ESMTP id 580E0714191
	for <derby-dev@db.apache.org>; Fri, 27 Jul 2007 07:45:18 -0700 (PDT)
Message-ID: <28579867.1185547518313.JavaMail.jira@brutus>
Date: Fri, 27 Jul 2007 07:45:18 -0700 (PDT)
From: "Bryan Pendleton (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Updated: (DERBY-2887) NULLS FIRST / LAST for ORDER BY
In-Reply-To: <28153304.1183236364452.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org


     [ 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.