db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: Unique constraints on multiple fields with one nullable
Date Thu, 27 Oct 2005 00:22:12 GMT
Hi Dan,

I believe that the Sybase behavior is correct. I have logged bug 653 to 
track this issue.


Dan Meany wrote:

>I noticed that in Derby a unique constraint on two
>columns A and B, with B nullable, will prevent
>inserting two identical records that contain NULL in
>This is different from some other databases such as
>Sybase that do allow it (I assume where the null
>records are not in stored as part of the unique
>I noticed this while transfering data from Sybase to
>Derby using Apache dbutils and getting rejected
>duplicate records.

View raw message