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: | |
| 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
[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.