Bug #49379 Drop down for partition count is limited and misleading
Submitted: 2 Dec 2009 22:52 Modified: 2 Dec 2009 23:05
Reporter: Todd Farmer (OCA) Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:5.2.10 r4680 OS:Windows (XP)
Assigned to: CPU Architecture:Any

[2 Dec 2009 22:52] Todd Farmer 
Description:
The partitioning tab of the ALTER TABLE wizard has a drop-down for partition count, with values between 2 and 10 listed.  That could be somewhat limiting, and I tested what would happen if I needed to define 12 partitions.  The drop down allows you to write in a value of "12" (good), but when "Apply" is clicked, the resulting DDL appears to substitute in a "2" for whatever value has been specified:

ALTER TABLE `test`.`geom`  PARTITION BY KEY() PARTITIONS 2

How to repeat:
Try to create > 10 partitions.

Suggested fix:
Allow user-supplied partition count to exceed 10 and honor that in the resulting DDL.
[2 Dec 2009 23:05] Todd Farmer 
Suplicate of 49379, which contains screenshot.