Bug #66232 Object Browser does not reflect proper column order after altering table columns

• Submitted: 6 Aug 2012 21:43
• Modified: 20 Sep 2012 19:56
• Reporter: Bob Dankert
• Status: Closed
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 5.2.41
• OS: Windows (W7 32)
• CPU Architecture: Any
• Tags: alter, column, Object Browser, sort, table

[6 Aug 2012 21:43] Bob Dankert

Description:
The object browser does not display the correct column order after altering a table to change the column order.  Click the refresh button does not update the column order either.

How to repeat:
1.  Create this table:
CREATE TABLE `test` (
  `id` int(11) NOT NULL,
  `a` varchar(45) DEFAULT NULL,
  `b` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;

2.  Alter the table through the Workbench alter table interface to move column `b` ahead of column `a`.  It should generate this SQL:
ALTER TABLE `test` CHANGE COLUMN `b` `b` VARCHAR(45) NULL DEFAULT NULL AFTER `id`;

3.  Look at the object browser, the table definition did not get updated.

Suggested fix:
Display the correct column order after an alter table is made which modifies the current order.

[7 Aug 2012 0:48] MySQL Verification Team

Thank you for the bug report. After that on my side WorkBench hangs if the database where was built the table test is defined as default database.

[28 Aug 2012 4:07] Alfredo Kojima

Bug #66559 is a duplicate

[20 Sep 2012 19:56] Philip Olson

Fixed as of the upcoming MySQL Workbench 5.2.44, and here's the changelog entry:

 The object browser would not update the column order after a
 table was altered.

Thank you for the bug report.