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 Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.41 OS:Windows (W7 32)
Assigned to: 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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.041 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.