Bug #46969 Partitions Limit

• Submitted: 28 Aug 2009 8:18
• Modified: 8 Dec 2009 12:31
• Reporter: Mustafa KIRIMLI
• Status: Duplicate
• Category: MySQL Workbench
• Severity: S4 (Feature request)
• Version: All
• OS: Any
• CPU Architecture: Any
• Tags: limit, partitions

[28 Aug 2009 8:18] Mustafa KIRIMLI

Description:
(first of all i can't speak English very well)
While creating partitions with workbench limit 10 is not enough.

How to repeat:
-create a table
-try to add more than 10 partition (partitions tab)

Suggested fix:
set up to more than 100

[28 Aug 2009 10:56] Valeriy Kravchuk

Thank you for the feature request. Indeed, even latest WB 5.2.2 limits number of partitions to 10.

[10 Sep 2009 11:32] Mustafa KIRIMLI

Primitive solution :
- Close WB
- Backup your *.mwb file 
- Open the file (*.mwb) with winrar
- Edit document.mwb.xml file with xml editors 
- Find and replace the values <value type="int" key="subpartitionCount">10</value> which is under your tables definition.
- Save and close all files

[11 Nov 2009 12:49] Susanne Ebrecht

This is not a feature request in my eyes it is a bug. A serious bug because you will get wrong  data and indexes if you need more then 10 partitions.

[3 Dec 2009 10:35] Johannes Taxacher

Bug #49380 has been marked as a duplicate of this one

[8 Dec 2009 12:31] Susanne Ebrecht

I will set this as duplicate of bug #49380. Because of the discussion there.