Bug #110639 Schema shows tables but does not show hidden table

• Submitted: 9 Apr 2023 0:50
• Modified: 10 Apr 2023 12:49
• Reporter: Jeff Greenlee
• Status: Can't repeat
• Category: MySQL Workbench
• Severity: S3 (Non-critical)
• Version: 8.0.31
• OS: MacOS (Ventura Version 13.2.1)
• CPU Architecture: ARM
• Tags: WBBugReporter

[9 Apr 2023 0:50] Jeff Greenlee

Description:
----[For better reports, please attach the log file after submitting. You can find it in /Users/jeffgreenlee/Library/Application Support/MySQL/Workbench/log/wb.log]

When I create schemas,  MySql Workbench has a propensity to include an extra table usually called "Table1", which does not show in the schema diagram, but appears as a table in the side panel.  All efforts to remove the bogus table fail. Right clicking on a table in the side panel does not have an option to remove the table.   When Forward Engineering the schema, the bogus table shows up in the Script... forcing a user to remove that part,  WHY does it do this?  and How can I forcibly remove that table from the schema

How to repeat:
Create a simple Schema with 2 or more tables.  Name the tables something other than their default names.  Add some fields to the tables and then Save the Model. 
Forward engineer it.  More then likely you will encounter an error..at the end which has a section  that refers to "[Schema Name].table1 .  This section must be removed from the script in order to get a successful Forward Engineering outcome because the script "cannot find". the table.  
Also, if you refresh your schemas in the side panel and examine the tables in your new created schema, it will show that ghost table that doesn't exist.

Suggested fix:
Put in a routine  that will ensure the ERD schema showing in the graphic display actually Matches the one that is stored.

[10 Apr 2023 12:49] MySQL Verification Team

Hello Jeff Greenlee,

Thank you for the bug report.
I tried to reproduce your issue on windows 10 and MacOS with workbench 8.0.32 but I am not seeing any issues at my end. If you can provide more information, feel free to add it to this bug. Thanks.

Regards,
Ashwini Patil