Bug #85314 Error in PARTITION BY RANGE COLUMNS example
Submitted: 6 Mar 2017 3:04 Modified: 7 Mar 2017 14:50
Reporter: Roel Van de Paar (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S1 (Critical)
Version:5.5+ OS:Any
Assigned to: Jon Stephens CPU Architecture:Any

[6 Mar 2017 3:04] Roel Van de Paar 
Description:
The example CREATE TABLE in 'How to repeat' below, taken from the manual at: https://dev.mysql.com/doc/refman/5.7/en/create-table.html

Produces;
ERROR 1493 (HY000): VALUES LESS THAN value must be strictly increasing for each partition

Perhaps there were changes. 

How to repeat:
CREATE TABLE rc (
    a INT NOT NULL,
    b INT NOT NULL
)
PARTITION BY RANGE COLUMNS(a,b) (
    PARTITION p0 VALUES LESS THAN (10,5),
    PARTITION p1 VALUES LESS THAN (20,10),
    PARTITION p2 VALUES LESS THAN (MAXVALUE,15),
    PARTITION p3 VALUES LESS THAN (MAXVALUE,MAXVALUE)
);

Suggested fix:
Fix manual
[6 Mar 2017 5:11] Umesh Shastry 
Hello Roel,

Thank you for the report and feedback.

Thanks,
Umesh
[7 Mar 2017 14:50] Jon Stephens 
Fixed in 5.5+ docs, in mysqldoc rev 51104.

Closed.