| Bug #64395 | MySQL Workbench does not show partitions under the Partitioning tab | ||
|---|---|---|---|
| Submitted: | 21 Feb 2012 10:39 | Modified: | 4 Jul 2012 20:04 |
| Reporter: | Nick Levett | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Workbench: SQL Editor | Severity: | S3 (Non-critical) |
| Version: | 5.2.37 | OS: | Any (Mac OS X 10.7.3, Windows XP) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | partition, partitioning | ||
[21 Feb 2012 11:09]
Valeriy Kravchuk
What version of server, 5.x.y, are you working with? I've got error: Error Code: 1075. Incorrect table definition; there can be only one auto column and it must be defined as a key when tried to execute your CREATE TABLE while connected to MySQL server 5.5.21.
[21 Feb 2012 11:23]
Nick Levett
Apologies, this was a standalone table which I put partitioning on afterwards. The audit_id was a PRIMARY_KEY but I removed it, leaving the increment. Removing the AUTO_INCREMENT from the CREATE statement will execute correctly. I'm using MySQL 5.5.15-log on CentOS.
[21 Feb 2012 11:29]
Valeriy Kravchuk
OK, I've created the table like this:
CREATE TABLE `audit` (
`audit_id` int(11) NOT NULL AUTO_INCREMENT,
`audit_type_id` int(11) NOT NULL DEFAULT '0',
`audit_timestamp` datetime NOT NULL,
`user_id` int(11) DEFAULT NULL,
`active_flag` char(1) DEFAULT '1',
KEY (audit_id)
) ENGINE=MyISAM
PARTITION BY RANGE (TO_DAYS(audit_timestamp))
(PARTITION part0 VALUES LESS THAN (TO_DAYS('2012-03-01 00:00:00')) COMMENT = '2012/02',
PARTITION part1 VALUES LESS THAN (TO_DAYS('2012-04-01 00:00:00')) COMMENT = '2012/03',
PARTITION part2 VALUES LESS THAN (TO_DAYS('2012-05-01 00:00:00')) COMMENT = '2012/04',
PARTITION part35 VALUES LESS THAN MAXVALUE);
for correctness (note KEY added) and simplicity. Indeed, Partitioning tab is empty for it. Verified on Windows XP.
[18 May 2012 9:47]
Nick Levett
Any updates on this, I'm still getting it in 5.2.40? The partitioning feature is a little pointless if you cannot see tables with partitions or modify them...
[4 Jul 2012 20:04]
Alfredo Kojima
duplicate of bug #60235
Description: I've partitioned a table with 36 partitions, however in the Alter Table view the Partitioning tab appears as if there are no partitions and it's not enabled. How to repeat: CREATE TABLE `audit` ( `audit_id` int(11) NOT NULL AUTO_INCREMENT, `audit_type_id` int(11) NOT NULL DEFAULT '0', `audit_timestamp` datetime NOT NULL, `user_id` int(11) DEFAULT NULL, `active_flag` char(1) DEFAULT '1' ) ENGINE=MyISAM PARTITION BY RANGE (TO_DAYS(audit_timestamp)) (PARTITION part0 VALUES LESS THAN (TO_DAYS('2012-03-01 00:00:00')) COMMENT = '2012/02', PARTITION part1 VALUES LESS THAN (TO_DAYS('2012-04-01 00:00:00')) COMMENT = '2012/03', PARTITION part2 VALUES LESS THAN (TO_DAYS('2012-05-01 00:00:00')) COMMENT = '2012/04', PARTITION part3 VALUES LESS THAN (TO_DAYS('2012-06-01 00:00:00')) COMMENT = '2012/05', PARTITION part4 VALUES LESS THAN (TO_DAYS('2012-07-01 00:00:00')) COMMENT = '2012/06', PARTITION part5 VALUES LESS THAN (TO_DAYS('2012-08-01 00:00:00')) COMMENT = '2012/07', PARTITION part6 VALUES LESS THAN (TO_DAYS('2012-09-01 00:00:00')) COMMENT = '2012/08', PARTITION part7 VALUES LESS THAN (TO_DAYS('2012-10-01 00:00:00')) COMMENT = '2012/09', PARTITION part8 VALUES LESS THAN (TO_DAYS('2012-11-01 00:00:00')) COMMENT = '2012/10', PARTITION part9 VALUES LESS THAN (TO_DAYS('2012-12-01 00:00:00')) COMMENT = '2012/11', PARTITION part10 VALUES LESS THAN (TO_DAYS('2013-01-01 00:00:00')) COMMENT = '2012/12', PARTITION part11 VALUES LESS THAN (TO_DAYS('2013-02-01 00:00:00')) COMMENT = '2013/01', PARTITION part12 VALUES LESS THAN (TO_DAYS('2013-03-01 00:00:00')) COMMENT = '2013/02', PARTITION part13 VALUES LESS THAN (TO_DAYS('2013-04-01 00:00:00')) COMMENT = '2013/03', PARTITION part14 VALUES LESS THAN (TO_DAYS('2013-05-01 00:00:00')) COMMENT = '2013/04', PARTITION part15 VALUES LESS THAN (TO_DAYS('2013-06-01 00:00:00')) COMMENT = '2013/05', PARTITION part16 VALUES LESS THAN (TO_DAYS('2013-07-01 00:00:00')) COMMENT = '2013/06', PARTITION part17 VALUES LESS THAN (TO_DAYS('2013-08-01 00:00:00')) COMMENT = '2013/07', PARTITION part18 VALUES LESS THAN (TO_DAYS('2013-09-01 00:00:00')) COMMENT = '2013/08', PARTITION part19 VALUES LESS THAN (TO_DAYS('2013-10-01 00:00:00')) COMMENT = '2013/09', PARTITION part20 VALUES LESS THAN (TO_DAYS('2013-11-01 00:00:00')) COMMENT = '2013/10', PARTITION part21 VALUES LESS THAN (TO_DAYS('2013-12-01 00:00:00')) COMMENT = '2013/11', PARTITION part22 VALUES LESS THAN (TO_DAYS('2014-01-01 00:00:00')) COMMENT = '2013/12', PARTITION part23 VALUES LESS THAN (TO_DAYS('2014-02-01 00:00:00')) COMMENT = '2014/01', PARTITION part24 VALUES LESS THAN (TO_DAYS('2014-03-01 00:00:00')) COMMENT = '2014/02', PARTITION part25 VALUES LESS THAN (TO_DAYS('2014-04-01 00:00:00')) COMMENT = '2014/03', PARTITION part26 VALUES LESS THAN (TO_DAYS('2014-05-01 00:00:00')) COMMENT = '2014/04', PARTITION part27 VALUES LESS THAN (TO_DAYS('2014-06-01 00:00:00')) COMMENT = '2014/05', PARTITION part28 VALUES LESS THAN (TO_DAYS('2014-07-01 00:00:00')) COMMENT = '2014/06', PARTITION part29 VALUES LESS THAN (TO_DAYS('2014-08-01 00:00:00')) COMMENT = '2014/07', PARTITION part30 VALUES LESS THAN (TO_DAYS('2014-09-01 00:00:00')) COMMENT = '2014/08', PARTITION part31 VALUES LESS THAN (TO_DAYS('2014-10-01 00:00:00')) COMMENT = '2014/09', PARTITION part32 VALUES LESS THAN (TO_DAYS('2014-11-01 00:00:00')) COMMENT = '2014/10', PARTITION part33 VALUES LESS THAN (TO_DAYS('2014-12-01 00:00:00')) COMMENT = '2014/11', PARTITION part34 VALUES LESS THAN (TO_DAYS('2015-01-01 00:00:00')) COMMENT = '2014/12', PARTITION part35 VALUES LESS THAN MAXVALUE); Execute above statement in a SQL Editor tab. Find table in the Schemas list and right click and select Alter Table... Select the Partitioning tab. The Enable Partitioning checkbox is unticked and the data grid below is empty.