Bug #73861 The wrong catalog is selected when adding a table to EER Diagram in Workbench

• Submitted: 9 Sep 2014 13:38
• Modified: 10 Sep 2014 10:55
• Reporter: Ian Lewis
• Status: Verified
• Category: MySQL Workbench: Modeling
• Severity: S3 (Non-critical)
• Version: 6.1.7.1 (build 1788), 6.2.2
• OS: MacOS
• CPU Architecture: Any
• Tags: EER, modeling, workbench

[9 Sep 2014 13:38] Ian Lewis

Description:
Assumes multiple catalogs available.

When adding a new table to an EER diagram in Workbench tables are always added to the default catalog schema. Unless, that is, the user discovers the narrow bar that appears at the top of the diagram window which allows for selection of the appropriate catalog.

It is too easy to add a new table to the wrong schema then have to move, and possibly lose, it in the process.

Annoyances
========
1. Associating a diagram with a catalog (other than default) is not implemented very effectively. The diagram's properties should allow for the selection of a catalog other than default.

2. The narrow bar above the EER Diagram window showing the choice of catalogs is not prominent enough 

3. the choice of catalog does not seem to be permanently associated with the diagram.

How to repeat:
Add multiple catalogs.

Create a diagram and all tables will be added to default catalog unless changed.

Create several diagrams and schemas and try to keep track of which diagram goes with which schema.

Suggested fix:
Allow for a catalog to be associated with a diagram 'permanently'.

[10 Sep 2014 10:55] MySQL Verification Team

Thank you for the report.
I'm able to see this issue on Win7 with 6.2.2.

Try the steps as provided by reporter

- Add multiple catalogs.
- Create a diagram and all tables will be added to default catalog unless changed.

- Create several diagrams and schema's and try to keep track of which diagram goes with which schema.

Thanks,
Umesh