Bug #45239 Global foreign key option not followed
Submitted: 1 Jun 2009 9:42 Modified: 29 Jul 2009 13:38
Reporter: Petr Burian Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.1.16 OS:Windows
Assigned to: CPU Architecture:Any
Tags: CHECKED, foreign key, regresssion

[1 Jun 2009 9:42] Petr Burian 
Description:
In global options (Tools -> Options -> Model) I have "On update: Cascade, on delete: No action". Every new foreign key doesn't follow this pre-setting and is always "On updated: no action, on delete: no action".

Nevermind what I set in global options, there is always No Action/No Action with every new foreign key.

It was working in 5.0.

How to repeat:
See description.
[2 Jun 2009 12:12] MySQL Verification Team 
Thank you for the bug report. I couldn't repeat this issue in Vista Home Premium 64-bit. Could you please provide the model file which presents that behavior?. Thanks in advance.
[2 Jun 2009 12:28] Petr Burian 
Simple .mwb to reproduce an error. I can reproduce it always in 5.1.12 (build 5478)

Attachment: workbench.mwb (application/octet-stream, text), 6.16 KiB.
[2 Jun 2009 12:29] Petr Burian 
Adding also screenshot of my global settings and foreign key options of certain table

Attachment: foreign-key.png (image/png, text), 32.47 KiB.
[2 Jul 2009 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[3 Jul 2009 5:32] Petr Burian 
The bug is still there and is very easy reproducable. Screenshot and mwb will included.

Start Workbench and open from Menu Tools -> Preferences -> Model. There is ON UPDATE:CASCADE, ON DELETE:SET NULL (see attachement rel-setup.png).

Now create tables 'main', 'a', 'b'. Pick 1:n Non-Identifying Relationship (1) and connect tables 'a' and 'main'.

Click table 'a', edit and go to Foreign Keys. Now click the 'fk_table_a_main' foreign key and you can see there is wrong relationship in Foreygn Key Options - ON UPDATE: NO ACTION, ON DELETE: NO ACTION (rel-edit.png). Beg your pardon but this is not what I have preset in global preferences.
[3 Jul 2009 5:33] Petr Burian 
Global relationship setup

Attachment: rel-setup.png (image/png, text), 12.12 KiB.
[3 Jul 2009 5:33] Petr Burian 
Wrongly created relationship in table editor

Attachment: rel-edit.png (image/png, text), 26.00 KiB.
[3 Jul 2009 5:33] Petr Burian 
Simple schema to reproduce the bug

Attachment: relation.mwb (application/octet-stream, text), 5.46 KiB.
[8 Jul 2009 8:55] Valeriy Kravchuk 
Verified just as described in your last comments, with 5.1.16 on Windows XP.
[29 Jul 2009 13:38] Alfredo Kojima 
This is a duplicate of bug #45393