Skip navigation links

MySQL Forums :: Archive Storage Engine :: Unique key issue with Archive Engine


Advanced Search

Unique key issue with Archive Engine
Date: February 17, 2011 07:57AM

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-

Options: ReplyQuote


Subject Views Written By Posted
Unique key issue with Archive Engine 4281 Rameshkumar Venkatachalam 02/17/2011 07:57AM
Re: Unique key issue with Archive Engine 2488 Rameshkumar Venkatachalam 02/17/2011 08:18AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.