Bug #69546 Object info window not refreshed after schema refresh

• Submitted: 21 Jun 2013 21:13
• Modified: 27 Jun 2013 20:06
• Reporter: George Brooks
• Status: Duplicate
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: Workbench 6.0.2 beta
• OS: Windows (Win7 Pro 32-bit)
• Assigned to: Juan Rene Ramirez Monarrez
• CPU Architecture: Any

[21 Jun 2013 21:13] George Brooks

Description:
After dropping a column from a table in SQL editor, the table's object information is not updated even after using the Refresh icon.

How to repeat:
do command:
CREATE  TABLE `test` (
  `id` INT NOT NULL AUTO_INCREMENT ,
  `colA` VARCHAR(45) NULL ,
  `colB` INT NULL ,
  PRIMARY KEY (`id`) );
  
  in connection tab
  select table test in Navigation window
  object info shows columns as above
  
do command:
  alter table test drop column colB;
  
  in Navigator, click on Refresh icon
  click on table other than test.
  click on table test.
  object info shows columns including colB

[21 Jun 2013 22:13] MySQL Verification Team

Thank you for the bug which version are you using?. Thanks.

[21 Jun 2013 22:21] George Brooks

OOPS.  Workbench 6.0.2 beta

g

[21 Jun 2013 22:51] MySQL Verification Team

I couldn't repeat on Win7 64-bit. Are you able to provide screenshots of every step you did?. Thanks.

[21 Jun 2013 23:57] George Brooks

I've attached a zip file with a sequence of steps.

t0.jpg: initial state with schema, no test table
t1.jpg: after creating test table, clicking on refresh icon, clicking on test table
t2.jpg: after dropping table, clicking on refresh, clicking on table other than test, clicking on test table
t3.jpg: sql editor with desc table after above.

Hope this helps.  g

[22 Jun 2013 0:30] George Brooks

Sequence of jpgs showing issue

Attachment: refresh_bug.zip (application/x-zip, text), 95.12 KiB.

[25 Jun 2013 7:45] MySQL Verification Team

Hello George,

Thank you for the bug report. Verified as described on 5.2.47, 6.0.2.
Object browser shows column removed but Information window's object Info doesn't reflect the changes made to the table.

Thanks,
Umesh

[25 Jun 2013 7:48] MySQL Verification Team

6.0.2 screenshot

Attachment: 69546.png (image/png, text), 57.65 KiB.

[25 Jun 2013 7:49] MySQL Verification Team

5.2.47 screenshot

Attachment: 69546_5247.png (image/png, text), 137.60 KiB.

[27 Jun 2013 20:06] Juan Rene Ramirez Monarrez

This bug is a duplicate with bug #68988.
Version 6.04 will contain the fix.

Thanks for submitting the bug report!