db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Anurag shekhar <Anurag.Shek...@Sun.COM>
Subject Re: any feedback on this?
Date Thu, 26 Jun 2008 14:22:33 GMT

> Ah, you have to add it as a 'unique' table constraint, if you add a 
> unique index it doesn't work.  Odd, shouldn't you be able to do it 
> either way?
>
SQL spec defines behavior of unique constrain over null able field to 
allow multiple
null for the fields participating in the constraint.
For Index it doesn't specifically says anything about it. So for now 
even though the
index and constraint are behaving differently the behavior is not 
violating any guidelines.

anurag

Mime
View raw message