[hibernate-issues] [Hibernate-JIRA] Updated: (HHH-5841) Invalid table creation in Annotations Test Cases

[Steve Ebersole (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5841?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steve Ebersole updated HHH-5841:
--------------------------------

    Affects Version/s:     (was: 3.6.next)

> Invalid table creation in Annotations Test Cases
> ------------------------------------------------
>
>                 Key: HHH-5841
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5841
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: annotations
>         Environment: Tested with HSQLDB 2.0.1 
>            Reporter: Fred Toussi
>
> Some tests create a table with the definition like the one below. As Standard SQL does not allow two unique constraints (or one unique and one PK) on the same column(s) the table definition fails, resulting in test failure.
> 23:41:40,437 DEBUG SchemaExport:415 - 
>     create table MedicalHistory (
>         lastupdate date,
>         FK varchar(255) not null,
>         primary key (FK),
>         unique (FK)
>     )
> The pattern of failure shows in several tests. For example:
> package org.hibernate.test.annotations.derivedidentities.e4.a;
> DerivedIdentitySimpleParentSimpleDepTest
> To reproduce, use an up-to-date HSQLDB 2.0.1 RC from http://hsqldb.org (I have not checked with 2.0.0, as this version has been superseded)

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