db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Guy Davis (JIRA)" <j...@apache.org>
Subject [jira] Created: (DDLUTILS-89) Lack of ordering for foreign keys in WriteSchemaToFile results in spurious diffs
Date Tue, 11 Apr 2006 19:03:19 GMT
Lack of ordering for foreign keys in WriteSchemaToFile results in spurious diffs
--------------------------------------------------------------------------------

         Key: DDLUTILS-89
         URL: http://issues.apache.org/jira/browse/DDLUTILS-89
     Project: DdlUtils
        Type: Improvement

 Environment: Oracle 10g EE
SQLServer 2005 EE
Windows XP SP2
Java 1.5.0_06
    Reporter: Guy Davis
 Assigned to: Thomas Dudziak 


We use the WriteSchemaToFile task to store our applications schema in a file we place in our
Subversion CM tool.  Every time we run this task, it reorders the foreign keys on a table.
 So, for example, if Table A has FKs X, Y, Z then schema.xml file alternates between:

<table ...>
   <fk name='X' .../>
   <fk name='Y' .../>
   <fk name='Z' .../>
</table>

AND 

<table ...>
   <fk name='Z' .../>
   <fk name='Y' .../>
   <fk name='X' .../>
</table>

Notice, that the keys haven't changed between schema dumps, just the ordering of them in the
file.  This means tracking version changes is more complicated as a developer's real changes
are mixed in with these spurious key position changes.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message