#19702: mysql backend: 'SHOW TABLE STATUS WHERE name=...' not compatible with
MySQL
4
----------------------------------------------+--------------------
Reporter: matf@… | Owner: nobody
Type: Bug | Status: new
Component: Database layer (models, ORM) | Version: 1.4
Severity: Normal | Keywords: mysql
Triage Stage: Unreviewed | Has patch: 1
Easy pickings: 1 | UI/UX: 0
----------------------------------------------+--------------------
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.
--
Ticket URL: <https://code.djangoproject.com/ticket/19702>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
