Re: Why partition can not support auto_increment field now?

[Glenn Sontheimer]

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;