MySQL Bugs: #62566: Duplicate partition name in CREATE ... PARTITION BY example

Bug #62566	Duplicate partition name in CREATE ... PARTITION BY example
Submitted:	28 Sep 2011 21:25	Modified:	28 Sep 2011 21:39
Reporter:	Hartmut Holzgraefe	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:		OS:	Any
Assigned to:	Paul DuBois	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
The example showing DATA_DIR and INDEX_DIR for partitions uses the partition name "p2000" twice, the 2nd one should be "p2002" instead

How to repeat:
try to use example CREATE statement, get

ERROR 1517 (HY000): Duplicate partition name p2000

Suggested fix:
replace last PARTITION line

  PARTITION p2000 VALUES IN (1998, 2002, 2006)

with

  PARTITION p2002 VALUES IN (1998, 2002, 2006)

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.