MySQL Bugs: #53885: Cannot add table to diagram because it is already there, but not visible

Bug #53885	Cannot add table to diagram because it is already there, but not visible
Submitted:	21 May 2010 13:22	Modified:	14 Jun 2010 10:36
Reporter:	Stephan Hodges	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	5.2.21 RC	OS:	Windows
Assigned to:	Alfredo Kojima	CPU Architecture:	Any

Description:
I have 6 diagrams for my database, with different subsets of tables.

I have one diagram "Contacts" with 12 visible tables, but when I select all and copy to a new diagram it says it is pasting 14 tables. Additionally, for example, the ccc_email table is marked as on the diagram (small black dot), but it is not visible on the diagram, and cannot be added. 

I've tried arrange all to see if it was placed off the screen, etc. but cannot get it to show the two extra tables. Also cannot find any way to make a table hidden or visible on a diagram.

How to repeat:
I don't know how to reproduce this, as it's just part of the model. I upgraded the model across several versions. I did attach a copy of the model to another bug report Bug #52619 which might help. Specifically the "contacts" diagram.

Hi Stephen, could you maybe provide an updated model showing the problem? The model in the referenced bug contains yet 5 still blank diagrams, so i don't know which tables are the affected ones.

Do you see the 14 (or only 12) tables listed in the "Layers" panel in sidebar? This Panel should list all objects visible on active diagram. This way you should also be able to locate the tables by right-clicking the item in the sidebar-panel and choosing "select in diagram" (this feature selects the object and also show it on canvas).

thanks in advance

I hadn't noticed the "layers" tab before. I had tried right clicking on the table name in the "Catalog" tab. I wish it had the "Select in Diagram" option there also!

Anyway, opening layers does show the civicrm_email table. I double clicked it which selected it in the diagram. At that point, a new symbol appeared in the diagram to the right of "civicrm_group_contact". (I will attach an exported image of this)

At that point, I was able to grab the handles on the object and make it larger, so that it showed up on the diagram.

Once expanded to "visibility", it isn't possible to grab the handles and shrink it down to invisibility.

I will attach the model with the matching tables. Sorry about that. Unfortunately, I clicked save after double clicking the civicrm_email table in the layer tab, so this attached model already shows the strange little icon, but it's at least smaller than would be possible after expanding it. Maybe that will be enough to put in code to catch this condition and automatically fix it, etc.

The exported image doesn't look exactly like the screen. It has an extra rectangular (blue) table icon and a "..." next to it which don't appear on the screen version.

Image showing the contacts panel with email table partially visible

Attachment: CiviCRM Contacts.png (image/png, text), 34.53 KiB.

We will wait for your files.

Your comment was timestamped 1 minute later than the second file upload, so I assume the comments just crossed each other.

No need to reply to this point, if you've already gotten the files, or see them now.

Problem described in your comment dated

[25 May 11:58] Stephan Hodges

is verified with the .mwb file uploaded on 32-bit XP SP3.

The real issue here is that the table shouldn't have been resizable to such a small size, which I can't repeat
 here. As a workaround, a sanity check has been added to loaded models so that tables that small will get autosized to its ideal size.

fix confirmed in repository

Sorry for the stupid question, but since "Target Version" only lists wb52, how do I know which actual version (RC or final) the fix appears in?

I was waiting for that to test it myself :)

An entry has been added to the 5.2.23 changelog:

An EER Diagram appeared to contain hidden tables. Although the diagram contained 12 tables, when a 'select all' was performed the user was informed that 14 tables were selected. It seemed that certain tables had been resized to be so small as to no longer be visible in the diagram.