Bug #92579 On Update/Delete not functioning
Submitted: 26 Sep 2018 13:00 Modified: 26 Sep 2018 13:20
Reporter: Bella Sdao Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S2 (Serious)
Version:8.0.12 OS:Microsoft Windows (Microsoft Windows 7 Enterprise Service Pack 1)
Assigned to: CPU Architecture:Any
Tags: on delete, ON UPDATE, WBBugReporter

[26 Sep 2018 13:00] Bella Sdao
Description:
----[For better reports, please attach the log file after submitting. You can find it in \\pcead001\UserData\pce_isabel\AppData\Roaming\MySQL\Workbench\log\wb.log]

continues to revert to 'restricted' settings after altering 'On Update' and 'On Delete' for foreign keys.

How to repeat:
ALTER TABLE `pharmadb`.`rxhistory` 
DROP FOREIGN KEY `medID`;
ALTER TABLE `pharmadb`.`rxhistory` 
ADD CONSTRAINT `medID`
  FOREIGN KEY (`medID`)
  REFERENCES `pharmadb`.`medication` (`medID`)
  ON DELETE NO ACTION
  ON UPDATE CASCADE;

click on Foreign Key under 'Foreign Key Name' on the 'edit table' screen.  Foreign Key Options will be set back to 'Restricted'.

Suggested fix:
Make modifications of Foreign Key Options 'On Update' and 'On Delete' stable after executing SQL?  It's critical to the system I'm implementing for my foreign keys to cascade update as it is an incredibly useful facet of DBdesign.
[26 Sep 2018 13:20] Miguel Solorzano
Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.