MySQL Bugs: #3558: Foreign keys: ON UPDATE/ON DELETE SET DEFAULT

Bug #3558	Foreign keys: ON UPDATE/ON DELETE SET DEFAULT
Submitted:	25 Apr 2004 17:13	Modified:	26 Apr 2006 12:26
Reporter:	Federico Razzoli (OCA)	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: DDL	Severity:	S4 (Feature request)
Version:	5	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Mysql should support the Sql Standard "SET DEFAULT" constraint.

How to repeat:
n/a

Suggested fix:
n/a

If you mean 'ON UPDATE SET DAFAULT' and 'ON DELETE SET DEFAULT' clauses for foreigh keys, then yes, they are still not supported by InnoDB (http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.html). It is a reasonable feature request.