Return-Path: Delivered-To: apmail-db-ddlutils-dev-archive@www.apache.org Received: (qmail 61884 invoked from network); 4 Jun 2007 02:45:37 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 4 Jun 2007 02:45:37 -0000 Received: (qmail 87523 invoked by uid 500); 4 Jun 2007 02:45:40 -0000 Delivered-To: apmail-db-ddlutils-dev-archive@db.apache.org Received: (qmail 87502 invoked by uid 500); 4 Jun 2007 02:45:40 -0000 Mailing-List: contact ddlutils-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ddlutils-dev@db.apache.org Delivered-To: mailing list ddlutils-dev@db.apache.org Received: (qmail 87473 invoked by uid 99); 4 Jun 2007 02:45:40 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 03 Jun 2007 19:45:40 -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; Sun, 03 Jun 2007 19:45:36 -0700 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id C8F5F71418F for ; Sun, 3 Jun 2007 19:45:15 -0700 (PDT) Message-ID: <25920749.1180925115820.JavaMail.jira@brutus> Date: Sun, 3 Jun 2007 19:45:15 -0700 (PDT) From: "Thomas Dudziak (JIRA)" To: ddlutils-dev@db.apache.org Subject: [jira] Created: (DDLUTILS-175) If there is more than one system index for the same set of fields, DdlUtils might miss some MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org If there is more than one system index for the same set of fields, DdlUtils might miss some ------------------------------------------------------------------------------------------- Key: DDLUTILS-175 URL: https://issues.apache.org/jira/browse/DDLUTILS-175 Project: DdlUtils Issue Type: Bug Components: Core (No specific database) Affects Versions: 1.0 RC1 Reporter: Thomas Dudziak Assignee: Thomas Dudziak Fix For: 1.0 RC2 DdlUtils removes system indexes from the model when reading it from a live database. Due to a bug in that index handling, it might however miss some. For instance if the primary key column is also used in a foreign key, then some databases (e.g. Derby) have two system indexes for it. DdlUtils misses the second one (system index for either pk or fk depending on what's reported first), which causes problems later on (e.g. when altering the database, DdlUtils will try to drop the index which of course fails). -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.