#29678: MySQL 8.0.12 manage.py inspectdb fails
-------------------------------------+-------------------------------------
Reporter: | Owner: nobody
SuilAmhain |
Type: | Status: new
Uncategorized |
Component: Core | Version: 2.1
(Management commands) |
Severity: Normal | Keywords:
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
Hi,
I have created a bunch of tables in MySQL 8.0.12 that I wished to import
into Django.
But I consistently receive this error when attempting to do so:
{{{
# The error was: (3719, "3719: 'utf8' is currently an alias for the
character set UTF8MB3, which will be replaced by UTF8MB4 in a future
release. Please consider using UTF8MB4 in order to be unambiguous.", None)
}}}
The problem is that the information_schema that is queried for table
information uses UTF8, which is an an alias of UTF8MB3.
MySQL has introduced a warning from MySQL 8 to encourage you to use
UTF8MB4 explicitly. inspectdb cannot deal with that warning.
I appreciate this may be regarded as a MySQL feature/bug.
Django is running these queries:
{{{
2018-08-15T23:25:41.500932Z 43 Query SELECT column_name,
referenced_table_name, referenced_column_name FROM
information_schema.key_column_usage WHERE table_name =
'django_content_type' AND table_schema = DATABASE() AND
referenced_table_name IS NOT NULL AND referenced_column_name IS NOT NULL
2018-08-15T23:25:41.511166Z 43 Query SHOW WARNINGS
}}}
The show warnings is the problem. I am very new to Django and cannot
workaround it.
--
Ticket URL: <https://code.djangoproject.com/ticket/29678>
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].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/053.3adc5e9353b2432506134b23f9ccfe77%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
