You are viewing a plain text version of this content. The canonical link for it is here.

Posted to ddlutils-dev@db.apache.org by "Thomas Dudziak (JIRA)" <ji...@apache.org> on 2007/06/04 04:45:15 UTC

[jira] Resolved: (DDLUTILS-175) If there is more than one system index for the same set of fields, DdlUtils might miss some

     [ https://issues.apache.org/jira/browse/DDLUTILS-175?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Thomas Dudziak resolved DDLUTILS-175.
-------------------------------------

    Resolution: Fixed

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