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 "Guy Davis (JIRA)" <ji...@apache.org> on 2006/04/11 21:09:20 UTC
[jira] Updated: (DDLUTILS-89) Lack of ordering for foreign keys in
WriteSchemaToFile results in spurious diffs
[ http://issues.apache.org/jira/browse/DDLUTILS-89?page=all ]
Guy Davis updated DDLUTILS-89:
------------------------------
Attachment: order_fks.patch
This patch ensures that foreign keys are kept ordered alphabetically by name rather than the seemingly random order the various JDBC drivers return them in. This means the position of the key in the schema.xml file should remain the same between running WriteSchemaToFile.
> 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
> Assignee: Thomas Dudziak
> Attachments: order_fks.patch
>
> 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