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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.060 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.