Bug #75061 Remove unique key limitation of partition table

• Submitted: 1 Dec 2014 12:59
• Modified: 3 Dec 2014 17:31
• Reporter: Tim Smith
• Status: Not a Bug
• Category: MySQL Server: DDL
• Severity: S4 (Feature request)
• Version: 5.6.20/5.7
• OS: Any
• CPU Architecture: Any

[1 Dec 2014 12:59] Tim Smith

Description:
Please remove the unique key limitation of partition table documented at http://dev.mysql.com/doc/refman/5.6/en/partitioning-limitations-partitioning-keys-unique-k....

How to repeat:
As it is documented in the http://dev.mysql.com/doc/refman/5.6/en/partitioning-limitations-partitioning-keys-unique-k....

If the limitation is violated, we get
ERROR 1491 (HY000): A PRIMARY KEY must include all columns in the table's partitioning function
or 
ERROR 1503 (HY000): A PRIMARY KEY must include all columns in the table's partitioning function
message.

Suggested fix:
Remove the unique key limitation of partition table to make partition table easier to use and solve more performance issues. 

For example, please allow us to partition a table by non-unique datetime when the primary key is an auto-increment column.

[3 Dec 2014 17:31] MySQL Verification Team

This is not a feature request. Removing the described limitation would require a total re-design of the partition storage engine.