db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Dudziak (JIRA)" <j...@apache.org>
Subject [jira] Resolved: (DDLUTILS-175) If there is more than one system index for the same set of fields, DdlUtils might miss some
Date Mon, 04 Jun 2007 02:45:15 GMT

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


Mime
View raw message