MySQL Bugs: #87269: Catalog Tree doesn't update after Synchronize Model

Bug #87269	Catalog Tree doesn't update after Synchronize Model
Submitted:	1 Aug 2017 7:39	Modified:	1 Aug 2017 9:40
Reporter:	Travis Dymond	Email Updates:
Status:	Won't Fix	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S3 (Non-critical)
Version:	6.3.9	OS:	Windows (Microsoft Windows 10 Home)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
When I create a table or view in the MySQL Command Line Client, and then synchronize the model, the catalog tree does not update with the new table(s) or view(s).  The model has to be re-opened before they will show.  This means that the table or view cannot be added to the EER diagram until the model is reloaded from its file.

How to repeat:
1) In the Command Line Client, (or goto #3 if you want to use an existing database)

  CREATE DATABASE test;
  USE test

2) Reverse engineer to get the empty schema into Workbench, create a new EER Diagram (also empty) and then save the Workbench file as test.mwb

3) Create a new table via the MySQL Command Line Client:

  CREATE TABLE test (
      id INT NOT NULL UNIQUE PRIMARY KEY AUTO_INCREMENT,
      name VARCHAR(45) NOT NULL
  );

3b) Enter a few records if desired; not necessary though

4) Run the Synchronize Model, choose the new "test" table and then choose "Update Model", so the arrow is pointing to the left.

5) Execute, save the file, and then look at the Catalog Tree in an EER Diagram.

- At this point the table shows under Tables in the model, but if you look at the EER Diagram in the Catalog Tree, you will only see the parent node for Tables with no children, no matter how many times you click on it:

    Test
        Tables
        Views
        Routine Groups

6) Now reload the test.mwb and only then will the Catalog Tree show the new "test" table.

    Test
        Tables
            Test
        Views
        Routine Groups

Suggested fix:
Debug code (or create it) to automatically refresh the Catalog Tree when a synchronization is performed, or provide a manual Refresh button, or element on a context menu.

Hello Travis Dymond,

Thank you for the report and reproducible steps.
Observed with WB 6.3.9 in Win7.

Thanks,
Umesh

http://bugs.mysql.com/bug.php?id=89841 marked as duplicate of this one.

Posted by developer:

This issue applies to the legacy MySQL Workbench 8.x implementation that is no longer supported or maintained.
MySQL Workbench 26.7 is a complete rewrite using a new technology stack and does not use the affected legacy implementation.
Therefore, this issue is not applicable to the current MySQL Workbench product and as such is closed.