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: Verified 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

[1 Aug 2017 7:39] Travis Dymond
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.
[1 Aug 2017 9:40] MySQL Verification Team
Hello Travis Dymond,

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

Thanks,
Umesh
[14 Mar 2018 12:18] Chiranjeevi Battula
http://bugs.mysql.com/bug.php?id=89841 marked as duplicate of this one.