deep, Thursday, September 19, 2002, 2:28:07 PM, you wrote: dk> I am using MySQL 4.0.3 and Innodb tables for my dk> application, I have created a unique index on dk> multiple column but its not working, here is sql dk> script to generate an bug
dk> CREATE TABLE TESTING dk> ( dk> ID INT AUTO_INCREMENT NOT NULL PRIMARY KEY , dk> FLD1 VARCHAR(100) NOT NULL , dk> FLD2 VARCHAR(15) NOT NULL, dk> FLD3 INT NOT NULL , dk> FLD4 INT NOT NULL , dk> FLD5 INT NULL dk> )TYPE=InnoDB; dk> CREATE UNIQUE INDEX IX_FLD12345_TESTING ON TESTING dk> (FLD1,FLD2,FLD3,FLD4,FLD5); dk> INSERT INTO TESTING (FLD1,FLD2,FLD3,FLD4,FLD5) dk> VALUES("A","B",1,2,NULL), ("A","B",1,2,NULL); dk> Above INSERT statment tries to insert duplicate dk> records and though UNIQUE INDEX is created it allows dk> it. dk> Problem is with NULL value, if any of the index field dk> contains NULL than only this bug is generated. dk> Is it BUG or Behaviour? It's not a bug, it's a behaviour feature. UNIQUE can has multiple NULL values. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php