MySQL Bugs: #22126: PARTITION by RANGE should be HASH

Bug #22126	PARTITION by RANGE should be HASH
Submitted:	8 Sep 2006 19:40	Modified:	14 Sep 2006 9:15
Reporter:	Jonathan Miller	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	5.1	OS:	N/A
Assigned to:	Jon Stephens	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
This table can be partitioned by RANGE  using the id column as the partitioning key into 8 partitions by means of this statement:

ALTER TABLE t1
    PARTITION BY HASH(id)
    PARTITIONS 8;

I think they ment to say:

This table can be partitioned by HASH  using the id column as the partitioning key into 8 partitions by means of this statement:

How to repeat:
http://dev.mysql.com/doc/refman/5.1/en/alter-table.html

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.

Updated doc per submitter's report.