migrations icon indicating copy to clipboard operation
migrations copied to clipboard

Published 20 hours ago • verified publisher icon nextras

Foregin_check=0 changes the sql result.

Open hrach opened this issue 9 years ago • 1 comments

We set foreign_key_checks = 0 and that's have some consequences.

Running migrations with ON DELETE RESTRICT produces table with ON DELETE NO ACTION. In MySQL they are identical, still, I see this as a bug.

Also, disabled foreign_key_check may lead to hard-to-catch errors and we should not enable it by default. A migration can enable it by itself. So, I suggest removing it.

hrach avatar Dec 02 '15 07:12 hrach

unfortunately removing it would be a BC break, maybe wait for 4.0?

JanTvrdik avatar Dec 03 '15 22:12 JanTvrdik