MySQL Bugs: #31652: Duplicate partition names in examples

Bug #31652	Duplicate partition names in examples
Submitted:	16 Oct 2007 20:39	Modified:	17 Oct 2007 15:44
Reporter:	Shane Bester (Platinum Quality Contributor)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	5.1, 5.2	OS:	Any
Assigned to:	Jon Stephens	CPU Architecture:	Any

Description:
The example on http://dev.mysql.com/doc/refman/5.1/en/partitioning-overview.html contains an error:

mysql> CREATE TABLE sales1 (
    ->     id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    ->     sales_date DATE NOT NULL DEFAULT '0000-00-00'
    -> ) ENGINE=InnoDB DEFAULT CHARSET=latin1
    -> PARTITION BY RANGE(id)
    -> (
    ->     PARTITION p0 VALUES LESS THAN (5000)
    ->         DATA DIRECTORY='d:/s1/data/'
    ->         INDEX DIRECTORY = 'd:/s1/idx/',
    ->
    ->     PARTITION p1 VALUES LESS THAN (10000)
    ->         DATA DIRECTORY='e:/s1/data/'
    ->         INDEX DIRECTORY = 'e:/s1/idx/',
    ->
    ->     PARTITION p1 VALUES LESS THAN MAXVALUE
    ->         DATA DIRECTORY='f:/s1/data/'
    ->         INDEX DIRECTORY = 'f:/s1/idx/'
    -> );
ERROR 1514 (HY000): Duplicate partition name p1
mysql>

How to repeat:
try the example:

CREATE TABLE sales1 (
    id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    sales_date DATE NOT NULL DEFAULT '0000-00-00'
) ENGINE=InnoDB DEFAULT CHARSET=latin1
PARTITION BY RANGE(id)
(
    PARTITION p0 VALUES LESS THAN (5000)
        DATA DIRECTORY='d:/s1/data/'
        INDEX DIRECTORY = 'd:/s1/idx/',

    PARTITION p1 VALUES LESS THAN (10000)
        DATA DIRECTORY='e:/s1/data/'
        INDEX DIRECTORY = 'e:/s1/idx/',

    PARTITION p1 VALUES LESS THAN MAXVALUE
        DATA DIRECTORY='f:/s1/data/'
        INDEX DIRECTORY = 'f:/s1/idx/'
);

another similar problem:
http://dev.mysql.com/doc/refman/5.1/en/partitioning-handling-nulls.html

mysql> CREATE TABLE t1 (
    -> c1 INT,
    -> c2 VARCHAR(20)
    -> )
    ->  PARTITION BY RANGE(c1) (
    ->  PARTITION p0 VALUES LESS THAN (-5),
    ->  PARTITION p1 VALUES LESS THAN (0),
    ->  PARTITION p1 VALUES LESS THAN (10),
    ->  PARTITION p2 VALUES LESS THAN MAXVALUE
    ->  );
ERROR 1514 (HY000): Duplicate partition name p1

Thank you for a reasonable documentation request.

Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.