Bug #101743 document bug
Submitted: 25 Nov 2020 7:39 Modified: 26 Nov 2020 13:19
Reporter: Hyun Ho JUNG Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.6, 5.7, 8.0 OS:Any
Assigned to: CPU Architecture:Any

[25 Nov 2020 7:39] Hyun Ho JUNG 
Description:
https://dev.mysql.com/doc/refman/5.6/en/partitioning-limitations.html
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations.html
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations.html

Column index prefixes not supported for key partitioning

The comma is missing from the example statement

mysql> CREATE TABLE t2 (
    ->     a VARCHAR(10000),
    ->     b VARCHAR(25),
    ->     c VARCHAR(10),
    ->     PRIMARY KEY (a(10), b(5) c(2))
    -> ) PARTITION BY KEY() PARTITIONS 2;
ERROR 1503 (HY000): A PRIMARY KEY must include all columns in the table's partitioning function

    ->     PRIMARY KEY (a(10), b(5) c(2))
    missing comma(,)   b(5)  c(2)
                                           ^

How to repeat:
none

Suggested fix:
PRIMARY KEY (a(10), b(5), c(2))
[25 Nov 2020 7:44] MySQL Verification Team 
Hello Hyun Ho JUNG,

Thank you for the report and feedback.

regards,
Umesh
[26 Nov 2020 13:19] Stefan Hinz 
Typo fixed. Thanks for reporting!