re: BUG in InnoDB tables

2002-09-19 Thread Paul DuBois
At 16:00 +0300 9/19/02, Victoria Reznichenko wrote: >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

re: BUG in InnoDB tables

2002-09-19 Thread Victoria Reznichenko
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_INC

BUG in InnoDB tables

2002-09-19 Thread deep kapasi
Hi, I am using MySQL 4.0.3 and Innodb tables for my application, I have created a unique index on multiple column but its not working, here is sql script to generate an bug CREATE TABLE TESTING ( ID INT AUTO_INCREMENT NOT NULL PRIMARY KEY , FLD1 VARCHAR(100) NOT NULL , FLD2 VARCHAR(15) NOT NUL