[patch] magic-removal: MySQL does not support DROP CONSTRAINT
|Reported by:||Jan Rademaker <j.rademaker@…>||Owned by:||adrian|
|Component:||Core (Management commands)||Version:||magic-removal|
|Severity:||major||Keywords:||mysql constraint foreign|
|Has patch:||yes||Needs documentation:||no|
|Needs tests:||no||Patch needs improvement:||no|
Although MySQL 4 & 5 support ADD CONSTRAINT they don't support DROP CONSTRAINT. This causes manage sqlreset [app] and manage sqlclear [app] to produce invalid sql statements.
MySQL MaxDB, however, _does_ support DROP CONSTRAINT.
See #1082 also.
Change History (6)
comment:3 Changed 8 years ago by Geert Vanderkelen <geert@…>
- Keywords mysql constraint foreign added
- Severity changed from normal to major
- Summary changed from magic-removal: MySQL does not support DROP CONSTRAINT to [patch] magic-removal: MySQL does not support DROP CONSTRAINT