Bug #38764 Adding new relationship will not update active Table Editor
Submitted: 13 Aug 2008 9:12 Modified: 19 Dec 2013 18:50
Reporter: Martin Groh Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.0.24 OSS OS:Windows (Vista)
Assigned to: Mike Lischke CPU Architecture:Any
Tags: Adding relationship, table editor

[13 Aug 2008 9:12] Martin Groh
Description:
Adding new relationship (using the toolbar and EER diagram) will not add the new forging key column in the columns list, if the column list in the Table Editor that will be affected is already showing.

How to repeat:
See description.
[22 Aug 2008 13:54] MySQL Verification Team
Thank you for the bug report. It is possible for you to provide a screen-shot showing the behavior reported?. Thanks in advance.
[22 Aug 2008 14:13] Martin Groh
screenshot as requested

Attachment: bugWorkbench.png (image/png, text), 77.04 KiB.

[22 Aug 2008 14:15] Martin Groh
I added a screenshot, I hope this helps. The lack of re-rendering the list will by the way also occur when you delete a relationship.

Regards m
[3 Sep 2008 23:55] MySQL Verification Team
Thank you for the bug report.
[4 Sep 2008 13:23] Johannes Taxacher
right, theres a refresh missing. as soon as you focus the editor (via click or keyboard) the list is updated correctly (this is also true for the other tabs in table editor like Index and FKs)
[4 Sep 2008 13:44] Johannes Taxacher
this behaviour bears the possibility of crashing WB.
follow these instructions to reproduce:

- load attached testfile (or create your own with 3 tables each containing a single INT PK col and put them on a diagram)
- open the diagram
- open table-editor for table1 and switch to columns tab
- use rel.-tool 1 and create a connection from table1->table2
- use rel.-tool 1 again and create a conn. from table1->table3
notice that the columns haven't been added to the column list inside the editor
- klick in editors col-list to refresh the list
notice that only one of the two added columns will show up
- rightklick in the col-list and select "Refresh Grid"
now all columns show up as supposed
- delete both connections in the diagram (right-click on the lines -> delete)
again, the editor doesn't update and shows columns that have already been deleted
- now directly click the NN-Checkbox of the last column -> AV
if, instead of the last step, you click inside the blank area in the editor, the editor does update (deletes the non-existing cols) BUT it leaves the rows behind (the Checkboxes of all columns are still there). if you then click on one of the checkboxes in the last 2 rows the result is also an AV.
[4 Sep 2008 13:46] Johannes Taxacher
simple file containing 1 diagram and 3 tables to try this scenario

Attachment: testfile_38764.mwb (application/octet-stream, text), 4.35 KiB.

[8 Sep 2008 9:31] Mike Lischke
I'm sorry, but in order to fix this bug we'd need some infrastructure changes (auto update of plugins) which cannot be done in 5.0 anymore (since 5.1 is around the corner and we only do bug fixing in 5.0, no feature addition). Hence this is deferred to 5.1.