MySQL Bugs: #49380: Drop down for partition count is limited and misleading

Bug #49380	Drop down for partition count is limited and misleading
Submitted:	2 Dec 2009 22:55	Modified:	15 Jan 2010 14:46
Reporter:	Todd Farmer (OCA)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S2 (Serious)
Version:	5.2.10 r4680	OS:	Linux
Assigned to:	Alfredo Kojima	CPU Architecture:	Any

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.

Screenshot

Attachment: SP32-20091202-144749.gif (image/gif, text), 61.58 KiB.

this is a duplicate of Bug #46969

Either this or #46969 needs to be addressed as a non-feature request.  Allowing entry of "11" but silently changing that to "2" in the resulting DDL script is a bug, and not discussed at all in #46969.

Bug #46969 is marked as duplicate of this bug here.

Fixed linux table editor to allow input of any value for partition count.

Fixed to display previously set values correctly

this has been fixed. fix will be included in version 5.2.12

An entry has been added to the 5.2.12 changelog:

In the Partitioning tab of the alter table dialog it was possible to enter a number greater than 10 into the Partition Count textfield. However, when these changes were applied the DDL generated substituted any value entered that was greater than 10 with the value 2.