#16592: In MySQL, table names in unmanaged intermediate models are being lower
cased
----------------------+----------------------------------------------
Reporter: jsdalton | Owner: nobody
Type: Bug | Status: new
Milestone: | Component: Database layer (models, ORM)
Version: SVN | Severity: Normal
Keywords: mysql | Triage Stage: Unreviewed
Has patch: 0 | Easy pickings: 0
UI/UX: 0 |
----------------------+----------------------------------------------
This is an obscure error, but it's causing an error in the MySQL (InnoDB)
test suite when the entire suite is run. The error can be replicated as
follows:
{{{
$ ./runtests.py --settings=testproject.settings unmanaged_models
proxy_model_inheritance
Creating test database for alias 'default'...
Creating test database for alias 'other'...
...E
======================================================================
ERROR: test_table_exists
(modeltests.proxy_model_inheritance.tests.ProxyModelInheritanceTests)
----------------------------------------------------------------------
Traceback (most recent call last):
File
"/Users/jsdalton/webs/testproject/src/django/tests/modeltests/proxy_model_inheritance/tests.py",
line 25, in setUp
call_command('syncdb', verbosity=0)
File
"/Users/jsdalton/webs/testproject/src/django/django/core/management/__init__.py",
line 166, in call_command
return klass.execute(*args, **defaults)
File
"/Users/jsdalton/webs/testproject/src/django/django/core/management/base.py",
line 220, in execute
output = self.handle(*args, **options)
File
"/Users/jsdalton/webs/testproject/src/django/django/core/management/base.py",
line 351, in handle
return self.handle_noargs(**options)
File
"/Users/jsdalton/webs/testproject/src/django/django/core/management/commands/syncdb.py",
line 121, in handle_noargs
custom_sql = custom_sql_for_model(model, self.style, connection)
File
"/Users/jsdalton/webs/testproject/src/django/django/core/management/sql.py",
line 150, in custom_sql_for_model
app_dir =
os.path.normpath(os.path.join(os.path.dirname(models.get_app(model._meta.app_label).__file__),
'sql'))
File
"/Users/jsdalton/webs/testproject/src/django/django/db/models/loading.py",
line 151, in get_app
raise ImproperlyConfigured("App with label %s could not be found" %
app_label)
ImproperlyConfigured: App with label unmanaged_models could not be found
----------------------------------------------------------------------
Ran 4 tests in 2.080s
FAILED (errors=1)
Destroying test database for alias 'default'...
Destroying test database for alias 'other'...
}}}
In brief, the syncdb command is hiccoughing in the proxy_model_inheritance
test because the previously installed model `Intermediate` (from
unmanaged_model) is not getting filtered properly. The reason it is not
getting filtered properly is that the db_table specified in the model
definition is "D01" but the MySQL table name is "d01". In Postegres and
other backends, the table name is correct as "D01".
I'm digging around trying to find where this is happening but I don't know
this part of the code base very well. If anyone has a lead let me know and
I'd be happy to put together a patch.
--
Ticket URL: <https://code.djangoproject.com/ticket/16592>
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 post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/django-updates?hl=en.
