id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
27441	MySQL backend output for 'DROP COLUMN' uses undocumented SQL	Adam Johnson	Adam Johnson	"Django's default SchemaEditor outputs `DROP COLUMN ... CASCADE`. When inspecting the SQL for a migration I saw this and wondered what the `CASCADE` means - it's not documented on MySQL ( http://dev.mysql.com/doc/refman/5.7/en/alter-table.html ), but I discovered it is a no-op added for compatibility with e.g. postgres where it does mean something. I added this to the MariaDB documentation ( https://mariadb.com/kb/en/mariadb/alter-table/ ) because it's editable, but it's not going to get added to the MySQL documentation any time soon.

Since it's potentially confusing and a no-op, I think Django shouldn't output `CASCADE` on MySQL."	Cleanup/optimization	closed	Migrations	1.10	Normal	fixed			Ready for checkin	1	0	0	0	0	0