db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Konstantinos Stathatos (JIRA)" <j...@apache.org>
Subject [jira] Created: (DDLUTILS-54) Column comparison does not check on native types
Date Sat, 17 Dec 2005 01:58:35 GMT
Column comparison does not check on native types

         Key: DDLUTILS-54
         URL: http://issues.apache.org/jira/browse/DDLUTILS-54
     Project: DdlUtils
        Type: Bug
    Reporter: Konstantinos Stathatos
 Assigned to: Thomas Dudziak 
    Priority: Minor
 Attachments: zementis_tests.ant

The attached Ant script  creates a table (in Derby) and then tries to alter it, using the
same database description. I would expect the DdlUtils would not try to modify anything as
the database has not changed.

However, the database defines a BOOLEAN column and a FLOAT column which in a Derby are mapped
to a SMALLINT column and a DOUBLE column. With such a mapping, next time the columns are compared
DdlUtils finds them different since the type codes are different. As a result, it tries to
modify the columns even though the modification is not necessary.

Generally, such modification is really harmless. However,  under my particular use case, occasionally
a DBA would have to get involved and manually update the database if modifications are needed
(i.e. if a non-empty alter sql is generated).  This means that taking the extra step to check
based on the native types if the modifications are material or not would be important.

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
For more information on JIRA, see:

View raw message