List,
I have been mulling over this for a few days reading docs and going back and
forth with people on this, so I figured I would come here before writing up a
bug report.
First of all, I have tested this on 4.1.18, 5.0.16, and 5.0.22 within Solaris
9 and Mandrake Linux LE 2005
Dan, this is documented behavior:
http://dev.mysql.com/doc/refman/5.0/en/create-index.html
Specifically,
A UNIQUE index creates a constraint such that all values in the index
must be distinct. An error occurs if you try to add a new row with a
key value that matches an existing row. This
I have been mulling over this for a few days reading docs and going back
and
forth with people on this, so I figured I would come here before writing
up a
bug report.
First of all, I have tested this on 4.1.18, 5.0.16, and 5.0.22 within
Solaris
9 and Mandrake Linux LE 2005 environments.