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] Created: (DDLUTILS-175) If there is more than one system index for the same set of fields, DdlUtils might miss some

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.

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

Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
     [ 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.