MySQL Bugs: #115964: The partition name is different in the example and the description.

Bug #115964	The partition name is different in the example and the description.
Submitted:	30 Aug 1:18	Modified:	26 Nov 17:54
Reporter:	Makoto Oda	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	8.4	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	partioning, partition, partition table, partition by range

Description:
In Section 26.3.1 Management of RANGE and LIST Partitions, the partition name "n0" is used as an example of a REORGANIZE PARTITION statement. However, later in the description, it is described as "p0".

https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-range-list.html

How to repeat:
Always

Suggested fix:
I think "p0" in the text needs to be corrected to "n0".

Hello Makoto Oda,

Thank you for the report and feedback.

I assume you are referring to the below example:

``
ALTER TABLE members REORGANIZE PARTITION n0 INTO (
    PARTITION s0 VALUES LESS THAN (1960),
    PARTITION s1 VALUES LESS THAN (1970)
);

In effect, this command splits partition p0 into two new partitions s0 and s1. It also moves the data that was stored in p0 into the new partitions according to the rules embodied in the two PARTITION ... VALUES ... clauses, so that s0 contains only those records for which YEAR(dob) is less than 1960 and s1 contains those rows in which YEAR(dob) is greater than or equal to 1960 but less than 1970. ``

regards,
Umesh

Posted by developer:
 
Partitioning example updated.

Thank you for the bug report.