[hibernate-issues] [Hibernate-JIRA] Commented: (ANN-673) Guaranty column order in genereted schema

[Emmanuel Bernard (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/ANN-673?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_28636 ] 

Emmanuel Bernard commented on ANN-673:
--------------------------------------

interesting.
I am debating whether applying the patch in 3.3.x or wait until a 3.4 for backward compatibility.
I imagine that today's code is not backward compatible between 2 runs though :)

> Guaranty column order in genereted schema
> -----------------------------------------
>
>                 Key: ANN-673
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-673
>             Project: Hibernate Annotations
>          Issue Type: Bug
>          Components: binder
>    Affects Versions: 3.3.0.ga
>         Environment: Hibernate 3.2.1 and SVN, PostgreSQL 8.1
>            Reporter: Ivo Danihelka
>            Priority: Minor
>             Fix For: 3.3.1
>
>         Attachments: fk-order.path
>
>
> Problem:
> - AnnotationConfiguration does not define stable ordering for foreign key columns. They then could appear in generated SQL schema in any order. For example, sometimes table foreign key column person_id is before another foreign key column dog_id and sometimes it is behind it.
> Tool hbm2ddl could be used to see the generated schema. The order of foreign key columns in one table changes
> when unrelated change is made inside mapping of a different table.
> Proposed Solution:
> - Don't base the ordering of foreign keys on hashCode. Base it on tableName+propertyName.
> A patch against hibernate 3.2.1 is attached (it also backportes #ANN-551 into 3.2.1).

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