Bug #31652 Duplicate partition names in examples
Submitted: 16 Oct 2007 20:39 Modified: 17 Oct 2007 15:44
Reporter: Shane Bester Email Updates:
Status: Closed
Category:Server: Docs Severity:S3 (Non-critical)
Version:5.1, 5.2 OS:Any
Assigned to: Jon Stephens Target Version:
Triage: D4 (Minor)

[16 Oct 2007 20:39] Shane Bester 
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/'
);
[16 Oct 2007 21:28] Shane Bester 
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
[17 Oct 2007 6:47] Valeriy Kravchuk 
Thank you for a reasonable documentation request.
[17 Oct 2007 15:44] Jon Stephens 
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.