Bug #48114 Cannot create table with one partition
Submitted: 16 Oct 2009 13:27 Modified: 15 Jan 2010 16:37
Reporter: Nag Haravu Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:5.1.18 OSS OS:Windows
Assigned to: Johannes Taxacher CPU Architecture:Any
Tags: table partition

[16 Oct 2009 13:27] Nag Haravu
Description:
Create a table. Go to partitioning tab and enable partitioning. The partitioning count starts from 2. Even if I manually change it to 1, it saves it as 2; you can see this by right-clicking the table in the tables list and copying SQL script to clipboard.

I realize it may not make much sense to have a single partition. But, my application requires creating a single LIST-based partition at DB creation time, and adding additional partitions dynamically.

If MySQL allows creation of single partition, why do we want to enforce these artificial restrictions in the workbench?

How to repeat:
See instructions in description field

Suggested fix:
Allow creation of single partition
[16 Dec 2009 16:32] Mike Lischke
Fixed in 5.2
[6 Jan 2010 14:14] Alfredo Kojima
This has been fixed recently.
[13 Jan 2010 17:26] Johannes Taxacher
fix confirmed. will be included in 5.2.12
[15 Jan 2010 16:37] Tony Bedford
An entry has been added to the 5.2.12 changelog:

In the Partitioning tab of the Alter Schema dialog, it was not possible to create a single partition. If a partition count of 1 was specified this was actually set to 2 in the generated DDL.