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

[Fred Toussi (JIRA)]

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
    Affects Versions: 3.6.next
         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