MySQL Forums
Forum List  »  Partitioning

Re: Why partition can not support auto_increment field now?
Posted by: Jonathan Stephens
Date: December 08, 2007 01:16AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Why partition can not support auto_increment field now?
3565
December 08, 2007 01:16AM


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.