Description:
I’m using Mysql workbench 8.0.34 on MacOs Ventura 13.3.1(a)
I’ve noticed that when I create a EER Diagram, manually add tables to it and then use reverse engineering to add tables to the same schema, the diagram becomes corrupt when I reopen it. I first get a error like:
The model in file '/Users/erik/Desktop/test.mwb' contained a problem which was successfully recovered:
Table figure test2 is not attached to any database table and was deleted.
After that error, all tables that where present before reverse engineering are gone.
In this example, test2 was the table I added manually before reverse engineering.
How to repeat:
Steps to reproduce:
Create a schema and a table:
CREATE SCHEMA TestDb;
USE TestDb;
CREATE TABLE test1 (
kol1 INTEGER
)
Create a new EER diagram and manually add a table, called test2
Go to the “MySQL Model” tab and rename the scheme below “Physical Schemas” to “TestDb”
Choose Database -> Reverse engineer
Choose the test1 table and finish the wizard
If you go to the “MySQL Model” tab in mysql workbench, a first issue is already visible, the tabs below “Physical Schemas” now have empty labels
Save the diagram and close mysql workbench.
Reopen Mysql workbench and the EER Diagram, you will see the following error:
The model in file '/Users/erik/Desktop/corruption test.mwb' contained a problem which was successfully recovered: Table figure test2 is not attached to any database table and was deleted.
The result is that the table test2 is now gone from the diagram
Suggested fix:
Using the reverse engineering wizard should not have a impact on existing tables in the diagram, I would expect it to just add the new tables, but it seems to remove the existing tables from the tables shown in “Physical Schemas”
Description: I’m using Mysql workbench 8.0.34 on MacOs Ventura 13.3.1(a) I’ve noticed that when I create a EER Diagram, manually add tables to it and then use reverse engineering to add tables to the same schema, the diagram becomes corrupt when I reopen it. I first get a error like: The model in file '/Users/erik/Desktop/test.mwb' contained a problem which was successfully recovered: Table figure test2 is not attached to any database table and was deleted. After that error, all tables that where present before reverse engineering are gone. In this example, test2 was the table I added manually before reverse engineering. How to repeat: Steps to reproduce: Create a schema and a table: CREATE SCHEMA TestDb; USE TestDb; CREATE TABLE test1 ( kol1 INTEGER ) Create a new EER diagram and manually add a table, called test2 Go to the “MySQL Model” tab and rename the scheme below “Physical Schemas” to “TestDb” Choose Database -> Reverse engineer Choose the test1 table and finish the wizard If you go to the “MySQL Model” tab in mysql workbench, a first issue is already visible, the tabs below “Physical Schemas” now have empty labels Save the diagram and close mysql workbench. Reopen Mysql workbench and the EER Diagram, you will see the following error: The model in file '/Users/erik/Desktop/corruption test.mwb' contained a problem which was successfully recovered: Table figure test2 is not attached to any database table and was deleted. The result is that the table test2 is now gone from the diagram Suggested fix: Using the reverse engineering wizard should not have a impact on existing tables in the diagram, I would expect it to just add the new tables, but it seems to remove the existing tables from the tables shown in “Physical Schemas”