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

[25 Apr 2004 17:13] Federico Razzoli
Description:
Mysql should support the Sql Standard "SET DEFAULT" constraint.

How to repeat:
n/a

Suggested fix:
n/a
[26 Apr 2006 12:26] Valeriy Kravchuk
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.