Re: Why partition can not support auto_increment field now?

[Jonathan Stephens]

mysql> SHOW VARIABLES LIKE '%version%';
+-------------------------+---------------------+
| Variable_name           | Value               |
+-------------------------+---------------------+
| protocol_version        | 10                  |
| version                 | 5.1.23-rc-debug     |
| version_comment         | Source distribution |
| version_compile_machine | x86_64              |
| version_compile_os      | suse-linux-gnu      |
+-------------------------+---------------------+
5 rows in set (0.00 sec)

mysql> CREATE TABLE t1 (
    ->   id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
    ->   name VARCHAR(10)
    -> ) 
    -> PARTITION BY RANGE(id) (
    ->   PARTITION p0 VALUES LESS THAN (10),
    ->   PARTITION p1 VALUES LESS THAN (20),
    ->   PARTITION p2 VALUES LESS THAN (MAXVALUE)
    -> );
Query OK, 0 rows affected (0.04 sec)

Seems to be working pretty well here. Can you be more specific about the nature of your problem? What's the CREATE statement that's failing for you?

Jon Stephens
MySQL Documentation Team @ Oracle

MySQL Dev Zone
MySQL Server Documentation
Oracle