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
19702	mysql backend: 'SHOW TABLE STATUS WHERE name=...' not compatible with MySQL 4	matf@…	nobody	"django/db/backends/mysql/base.py executes ""SHOW TABLE STATUS WHERE Name='INTROSPECT_TEST'"" query.

""SHOW TABLE STATUS WHERE name='table_name'"" syntax was introduced in mysql 5.
See link: http://dev.mysql.com/doc/refman/5.0/en/show-table-status.html

Correct syntax that works with both MySQL 4 and MySQL 5 is ""SHOW TABLE STATUS LIKE 'table_name'""
See link: http://dev.mysql.com/doc/refman/4.1/en/show-table-status.html

Since django <= 1.4 is compatible with MySQL 4 this is a bug. This functionality is used in e.g. South database migration library."	Bug	closed	Database layer (models, ORM)	1.4	Normal	fixed	mysql		Unreviewed	1	0	0	0	1	0