Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 62159 invoked from network); 31 Oct 2008 23:08:17 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 31 Oct 2008 23:08:17 -0000 Received: (qmail 27864 invoked by uid 500); 31 Oct 2008 23:08:14 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 27842 invoked by uid 500); 31 Oct 2008 23:08:14 -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 27821 invoked by uid 99); 31 Oct 2008 23:08:13 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 31 Oct 2008 16:08:13 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of david.vancouvering@gmail.com designates 209.85.200.169 as permitted sender) Received: from [209.85.200.169] (HELO wf-out-1314.google.com) (209.85.200.169) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 31 Oct 2008 23:06:59 +0000 Received: by wf-out-1314.google.com with SMTP id 26so1642635wfd.13 for ; Fri, 31 Oct 2008 16:07:40 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:sender :to:subject:mime-version:content-type:x-google-sender-auth; bh=tCxEhQVfPQBA8xyjbCMeEUapURvN48TxYJu11z5qYFo=; b=nHynv2rpYne9Mtqb9Mi2Nls3bL1XuPjsynChw98505N+19100ZZguPbVWn7W2sAlqB ZlTY/IAzWbGHIeMSbPBm3KpMgSh+sofgfDk33i+Z0Ywg+xFqw7zXzro1PlkevRvLDbli aoyqZM+YnfG7SuNnVvOBT3sh1yTqab9RcplRQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:sender:to:subject:mime-version:content-type :x-google-sender-auth; b=WfPhZ6GwJw3rE3/MMJdQgEh2MLZoNZRl+4otFnmzvHY/CHCzsyOzqhv5GwDY+47Yx9 7ieMsoKIy6fdtp95GhnSDF+T7UIDn0CP9OSc4lZ28FXS5BQ+/OEz4iDTFcUCRrzcgv+m CCUnbnQ/RrmxDV6OEXQ6dsyCWU7xF7RWHiKPE= Received: by 10.142.143.7 with SMTP id q7mr107556wfd.36.1225494460288; Fri, 31 Oct 2008 16:07:40 -0700 (PDT) Received: by 10.142.79.3 with HTTP; Fri, 31 Oct 2008 16:07:40 -0700 (PDT) Message-ID: <56a83cd00810311607j67b82643u2676cd3f1c77aff9@mail.gmail.com> Date: Fri, 31 Oct 2008 16:07:40 -0700 From: "David Van Couvering" Sender: david.vancouvering@gmail.com To: "Derby Discussion" Subject: Creating multiple indexes with different names on the same column does nothing. MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_35469_27386869.1225494460273" X-Google-Sender-Auth: 506c10bb8de5e20d X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_35469_27386869.1225494460273 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I noticed that if you try to create two indexes with different names on the same column set that Derby silently ignores the command. I can understand the rationale - it doesn't make sense to maintain two keys against the same columns - they're the same key. But it would be useful to say something that lets the user know that the index already exists, rather than silently succeeding. Just saying... David FWIW, MySQL let's you create two indexes with different names on the same columns... -- David W. Van Couvering http://davidvancouvering.blogspot.com ------=_Part_35469_27386869.1225494460273 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I noticed that if you try to create two indexes with different names on the same column set that Derby silently ignores the command.

I can understand the rationale - it doesn't make sense to maintain two keys against the same columns - they're the same key.  But it would be useful to say something that lets the user know that the index already exists, rather than silently succeeding.

Just saying...

David

FWIW, MySQL let's you create two indexes with different names on the same columns...

--
David W. Van Couvering
http://davidvancouvering.blogspot.com
------=_Part_35469_27386869.1225494460273--