Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 34940 invoked from network); 29 Oct 2008 09:01:04 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 29 Oct 2008 09:01:04 -0000 Received: (qmail 88762 invoked by uid 500); 29 Oct 2008 09:01:07 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 88734 invoked by uid 500); 29 Oct 2008 09:01:07 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 88721 invoked by uid 99); 29 Oct 2008 09:01:07 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 29 Oct 2008 02:01:07 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [194.7.185.204] (HELO smtp.inventivegroup.com) (194.7.185.204) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 29 Oct 2008 08:59:51 +0000 Received: from exchange.erganix.dc.intranet (unknown [10.0.0.179]) by smtp.inventivegroup.com (Postfix) with ESMTP id 985F87ECC for ; Wed, 29 Oct 2008 09:59:40 +0100 (CET) Received: from erganix.dc.intranet ([::1]) by erganix.dc.intranet ([::1]) with mapi; Wed, 29 Oct 2008 09:59:40 +0100 From: Tars Joris To: Derby Discussion Date: Wed, 29 Oct 2008 09:59:36 +0100 Subject: RE: Incorrect ORDER BY caused by index? Thread-Topic: Incorrect ORDER BY caused by index? Thread-Index: Ack5WLpdC3ARfBHXRYWMevhpqjmiewASNuJg Message-ID: <98F519CDC2FA6146AE00069E9A1D91FD4A46AAEEFC@erganix.dc.intranet> References: <98F519CDC2FA6146AE00069E9A1D91FD4A46AAEEF8@erganix.dc.intranet> <4907A5A2.4050707@sbcglobal.net> In-Reply-To: <4907A5A2.4050707@sbcglobal.net> Accept-Language: nl-NL, nl-BE Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: nl-NL, nl-BE Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-inventivegroup-MailScanner: Found to be clean X-inventivegroup-MailScanner-From: tjoris@inventivegroup.com X-Virus-Checked: Checked by ClamAV on apache.org X-Old-Spam-Status: No Hi Kathey, Thanks for your reply. I filed the following bug DERBY-3926 Kind regards, Tars. -- Tars Joris Project Development Manager Inventive Designers nv http://www.inventivedesigners.com > -----Original Message----- > From: Kathey Marsden [mailto:kmarsdenderby@sbcglobal.net] > Sent: woensdag 29 oktober 2008 0:52 > To: Derby Discussion > Subject: Re: Incorrect ORDER BY caused by index? > > Tars Joris wrote: > > this looks like a bug. I use Derby version 10.4.2.0. > > > > > I agree. A couple other notes. It seems to also exist with 10.2 and > 10.1. Also I noticed if I recreate the index I see the right result. > > Please file an issue in Jira. Thanks for the report. > > Kathey > > > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > -- > --=20 This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. --