Bug 1077240 - [HHH-9054] org.hibernate.test.annotations.quote.QuoteTest violates unique key constraint on some DBs
Summary: [HHH-9054] org.hibernate.test.annotations.quote.QuoteTest violates unique key...
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss Enterprise Application Platform 6
Classification: JBoss
Component: Hibernate
Version: 6.3.0
Hardware: Unspecified
OS: Unspecified
unspecified
medium
Target Milestone: DR6
: EAP 6.3.0
Assignee: Brett Meyer
QA Contact: Jan Martiska
Russell Dickenson
URL:
Whiteboard:
Depends On:
Blocks: 1073085
TreeView+ depends on / blocked
 
Reported: 2014-03-17 14:55 UTC by Jan Martiska
Modified: 2015-09-01 04:00 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2014-06-28 15:27:16 UTC
Type: Bug
Embargoed:

Attachments (Terms of Use)

Description Jan Martiska 2014-03-17 14:55:34 UTC 
(testsuite-only issue)

Two tests in QuoteTest (testQuoteManytoMany, testDoubleQuoteJoinColumn) each create one instance of User which has house3=null. House3 column has a @UniqueConstraint. On some databases, unique (without not-null) constraint allows multiple null values to be in the column, but some databases disallow it (DB2, Sybase, MSSQL..). On these databases, testQuoteManytoMany fails - it violates the constraint, because  testDoubleQuoteJoinColumn persisted a User with house3=null.
Comment 1 Brett Meyer 2014-03-17 19:21:50 UTC 
Corrected upstream and will be a part of the ORM component upgrade in 1073085
Comment 2 Brett Meyer 2014-03-17 19:22:25 UTC 
Test-only fix -- no docs required
Comment 4 Martin Simka 2014-04-01 11:30:13 UTC 
verified on EAP 6.3.0.DR6
Note You need to log in before you can comment on or make changes to this bug.