Unique key issue with Archive Engine

[Rameshkumar Venkatachalam]

Hi,

I am having issue with Archive engine when i create table with Unique keys.

Could any one please tell me if you come across any such issues?

Here is my code.

CREATE TABLE IF NOT EXISTS SAMPLE (
SESSION_ID VARCHAR(15) NOT NULL ,
NAME VARCHAR(12) NOT NULL ,
COST VARCHAR(50) NULL ,
TYPE TINYINT(1) NOT NULL ,
CODE VARCHAR(5) NOT NULL ,
STATUS VARCHAR(15) NOT NULL,
DATE TIMESTAMP DEFAULT 0 ,
SERVICE_ID VARCHAR(20) NOT NULL
)
ENGINE=ARCHIVE partition by range(UNIX_TIMESTAMP(DATE))(partition p20110104 values less than(UNIX_TIMESTAMP('2011-01-05')), partition p20110105 values less than maxvalue);

ALTER TABLE SAMPLE ADD CONSTRAINT US_SAMPLE UNIQUE (SESSION_ID, NAME, COST, TYPE, CODE, STATUS, DATE, SERVICE_ID);

Thanks
-Ramesh-