From derby-commits-return-8133-apmail-db-derby-commits-archive=db.apache.org@db.apache.org Fri Jul 20 03:38:17 2007 Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 55162 invoked from network); 20 Jul 2007 03:38:16 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 20 Jul 2007 03:38:16 -0000 Received: (qmail 839 invoked by uid 500); 20 Jul 2007 03:37:46 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 817 invoked by uid 500); 20 Jul 2007 03:37:46 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" List-Id: Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 804 invoked by uid 99); 20 Jul 2007 03:37:46 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 19 Jul 2007 20:37:46 -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.130] (HELO eos.apache.org) (140.211.11.130) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 19 Jul 2007 20:37:44 -0700 Received: from eos.apache.org (localhost [127.0.0.1]) by eos.apache.org (Postfix) with ESMTP id 0077159A07 for ; Fri, 20 Jul 2007 03:37:23 +0000 (GMT) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: Apache Wiki To: derby-commits@db.apache.org Date: Fri, 20 Jul 2007 03:37:23 -0000 Message-ID: <20070720033723.20819.95541@eos.apache.org> Subject: [Db-derby Wiki] Trivial Update of "OLAPNullOrdering" by BryanPendleton X-Virus-Checked: Checked by ClamAV on apache.org Dear Wiki user, You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification. The following page has been changed by BryanPendleton: http://wiki.apache.org/db-derby/OLAPNullOrdering ------------------------------------------------------------------------------ } }}} - (As an aside, I wonder if there once was a time when NULL values sorted low in Derby, rather than sorting HIGH. The reason I think this might have been true is that the JavaDoc for {{{DataValueDescriptor.compare()}}} is incorrect, and says that null will be treated as '''less''' than all other values, and also the code comment in NumberDataType.java is backward. Thirdly, the code in SQLBoolean.java seems backward, which might be an un-noticed bug because the boolean data type is not surfaced to users in current Derby?) + (As an aside, I wonder if there once was a time when NULL values sorted low in Derby, rather than sorting HIGH. The reason I think this might have been true is that the JavaDoc for {{{DataValueDescriptor.compare()}}} is incorrect, and says that null will be treated as '''less''' than all other values, and also the code comment in NumberDataType.java is backward. Thirdly, the code in SQLBoolean.java and in XML.java seems backward, which might be an un-noticed bug because the boolean data type is not surfaced to users in current Derby, and the XML type is now and not much used yet?) == Proposed Changes ==