Schema tool does not see difference between onDelete="NO ACTION" and onDelete="RESTRICT"

Details

Description

If database has ON DELETE CASCADE, schema tool detects change to NO ACTION and RESCRICT.
If database has ON DELETE RESCRICT, schema tool detects change only in case of CASCADE.
If database has ON DELETE NO ACTION, schema tool detect change only in case of CASCADE.

Benjamin Eberlei
added a comment - 31/Oct/10 7:33 AM Hm you are right, however for MySQL NO ACTION is the same as RESTRICT as stated by http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html

Steve Müller
added a comment - 28/Dec/13 8:26 PM Jan Obrátil As there internally is no difference between NO ACTION AND RESTRICT in MySQL I am closing this now. Doctrine generates the correct statements here when necessary.