MySQL Forums
Forum List  »  Partitioning

Re: Why partition can not support auto_increment field now?
Posted by: Glenn Sontheimer
Date: May 19, 2008 01:46PM

The problem is actually the way that the auto_increment field works ( or actually does not work properly). The following does not work. The so-called "auto_increment" field does not actually auto increment. The id values are duplicated, which kind of defeats the purpose of an auto_increment field, no? Any thoughts on this one?

CREATE TABLE t1 (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
currTime DATETIME,
name VARCHAR(10),
CONSTRAINT PK_t1 PRIMARY KEY (currTime, id)
)ENGINE = myISAM
PARTITION BY LINEAR KEY(currTime)
PARTITION p2 VALUES LESS THAN (MAXVALUE)
PARTITIONS 100;

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Why partition can not support auto_increment field now?
6143
May 19, 2008 01:46PM


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.