Bug #60235 Partitioning

• Submitted: 24 Feb 2011 15:07
• Modified: 27 Jul 2012 8:32
• Reporter: Sergejs Cukanovs
• Status: Closed
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 5.2.33, 5.2.31
• OS: Any (XP sp 2, Mac OS X)
• CPU Architecture: Any
• Tags: partitioning

[24 Feb 2011 15:07] Sergejs Cukanovs

Description:
HI

In SQL editor when I try to Alter table then I not see the partitions in partitionin tab.
I'm sure that in this table is partitions.
If using old version 5.2.22 revision 6091 then it work very well.

Sergejs

How to repeat:
To repeat the bug.
In SQL editor when I try to Alter table then I not see the partitions in partitionin tab.

[24 Feb 2011 15:14] Valeriy Kravchuk

Please, send complete CREATE TABLE statement for the partitioned table you have a problem with.

[24 Mar 2011 9:04] Sergejs Cukanovs

select table_name,partition_name,partition_ordinal_position as pos, partition_description as descr,table_rows
from information_schema.partitions where TABLE_SCHEMA='example' and partition_name is not null;

After this select I see all partitions, But problem is when I open in work Bench application  to see partitions what I have at moment I not see anything. Now I was installed the latest version and framework 4.0 this is 5.2.33 CE R7508 and problem still is.

[24 Mar 2011 9:09] Sergejs Cukanovs

example

Attachment: example.JPG (image/jpeg, text), 90.39 KiB.

[27 Mar 2011 16:12] Valeriy Kravchuk

Indeed, Partitioning tab does NOT show current partitioning scheme for table like:

create table tp(c1 int primary key) partition by hash(c1);

when I use Alter table from context menu, at least until Partitioning tab is used to define new partitioning scheme.

Verified with 5.2.33 on Mac OS X.

[27 Oct 2011 23:13] Chris Wagner

This still does not work in 5.2.35 CE against 5.5.13 server.

[4 Jul 2012 20:03] Alfredo Kojima

bug #64395 is a duplicate

[27 Jul 2012 8:32] Philip Olson

Fixed as of Workbench 5.2.41, and here's the changelog entry:

The Partitions tab within the 'Alter table' context menu would not show all
of the available partitions.