MySQL Bugs: #92579: On Update/Delete not functioning

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:	Windows (Microsoft Windows 7 Enterprise Service Pack 1)
Assigned to:		CPU Architecture:	Any
Tags:	on delete, ON UPDATE, WBBugReporter

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.

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.