#23889: mysql warning: Calling a SQLCompiler directly is deprecated. Call
compiler.quote_name_unless_alias instead.
-------------------------------------+-------------------------------------
Reporter: collinanderson | Owner: nobody
Type: Bug | Status: new
Component: Database layer | Version: master
(models, ORM) | Resolution:
Severity: Normal | Triage Stage:
Keywords: | Unreviewed
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Description changed by collinanderson:
Old description:
> {{{
> Traceback:
> File "/home/collin/pop/django/core/handlers/base.py" in get_response
> 125. response = wrapped_callback(request,
> *callback_args, **callback_kwargs)
> File "/home/collin/pop/django/contrib/auth/decorators.py" in
> _wrapped_view
> 22. return view_func(request, *args, **kwargs)
> File "/home/collin/pop/resources/views.py" in home
> 79. cd = {c.id: c for c in collections}
> File "/home/collin/pop/django/db/models/query.py" in __iter__
> 161. self._fetch_all()
> File "/home/collin/pop/django/db/models/query.py" in _fetch_all
> 989. self._result_cache = list(self.iterator())
> File "/home/collin/pop/django/db/models/query.py" in iterator
> 289. for row in compiler.results_iter():
> File "/home/collin/pop/django/db/models/sql/compiler.py" in results_iter
> 725. for rows in self.execute_sql(MULTI):
> File "/home/collin/pop/django/db/models/sql/compiler.py" in execute_sql
> 811. sql, params = self.as_sql()
> File "/home/collin/pop/django/db/models/sql/compiler.py" in as_sql
> 112. where, w_params = self.compile(self.query.where)
> File "/home/collin/pop/django/db/models/sql/compiler.py" in compile
> 83. return node.as_sql(self, self.connection)
> File "/home/collin/pop/django/db/models/sql/where.py" in as_sql
> 105. sql, params = compiler.compile(child)
> File "/home/collin/pop/django/db/models/sql/compiler.py" in compile
> 83. return node.as_sql(self, self.connection)
> File "/home/collin/pop/django/db/models/sql/where.py" in as_sql
> 423. return query_compiler.as_subquery_condition(self.alias,
> self.columns, compiler)
> File "/home/collin/pop/django/db/backends/mysql/compiler.py" in
> as_subquery_condition
> 8. return '(%s) IN (%s)' % (', '.join('%s.%s' % (qn(alias),
> qn2(column)) for column in columns), sql), params
> File "/home/collin/pop/django/db/backends/mysql/compiler.py" in <genexpr>
> 8. return '(%s) IN (%s)' % (', '.join('%s.%s' % (qn(alias),
> qn2(column)) for column in columns), sql), params
> File "/home/collin/pop/django/db/models/sql/compiler.py" in __call__
> 58. RemovedInDjango20Warning, stacklevel=2)
> File "/home/collin/pop/settings_local.py" in new_warn
> 11. raise Exception(repr(args))
>
> Exception Type: Exception at /file-library/
> Exception Value: ('Calling a SQLCompiler directly is deprecated. Call
> compiler.quote_name_unless_alias instead.', <class
> 'django.utils.deprecation.RemovedInDjango20Warning'>)
> }}}
New description:
I'm using `queryset.prefetch(Prefetch('etc'))` on `mysql` on `master`.
{{{
Traceback:
File "/home/collin/pop/django/core/handlers/base.py" in get_response
125. response = wrapped_callback(request,
*callback_args, **callback_kwargs)
File "/home/collin/pop/django/contrib/auth/decorators.py" in _wrapped_view
22. return view_func(request, *args, **kwargs)
File "/home/collin/pop/resources/views.py" in home
79. cd = {c.id: c for c in collections}
File "/home/collin/pop/django/db/models/query.py" in __iter__
161. self._fetch_all()
File "/home/collin/pop/django/db/models/query.py" in _fetch_all
989. self._result_cache = list(self.iterator())
File "/home/collin/pop/django/db/models/query.py" in iterator
289. for row in compiler.results_iter():
File "/home/collin/pop/django/db/models/sql/compiler.py" in results_iter
725. for rows in self.execute_sql(MULTI):
File "/home/collin/pop/django/db/models/sql/compiler.py" in execute_sql
811. sql, params = self.as_sql()
File "/home/collin/pop/django/db/models/sql/compiler.py" in as_sql
112. where, w_params = self.compile(self.query.where)
File "/home/collin/pop/django/db/models/sql/compiler.py" in compile
83. return node.as_sql(self, self.connection)
File "/home/collin/pop/django/db/models/sql/where.py" in as_sql
105. sql, params = compiler.compile(child)
File "/home/collin/pop/django/db/models/sql/compiler.py" in compile
83. return node.as_sql(self, self.connection)
File "/home/collin/pop/django/db/models/sql/where.py" in as_sql
423. return query_compiler.as_subquery_condition(self.alias,
self.columns, compiler)
File "/home/collin/pop/django/db/backends/mysql/compiler.py" in
as_subquery_condition
8. return '(%s) IN (%s)' % (', '.join('%s.%s' % (qn(alias),
qn2(column)) for column in columns), sql), params
File "/home/collin/pop/django/db/backends/mysql/compiler.py" in <genexpr>
8. return '(%s) IN (%s)' % (', '.join('%s.%s' % (qn(alias),
qn2(column)) for column in columns), sql), params
File "/home/collin/pop/django/db/models/sql/compiler.py" in __call__
58. RemovedInDjango20Warning, stacklevel=2)
File "/home/collin/pop/settings_local.py" in new_warn
11. raise Exception(repr(args))
Exception Type: Exception at /file-library/
Exception Value: ('Calling a SQLCompiler directly is deprecated. Call
compiler.quote_name_unless_alias instead.', <class
'django.utils.deprecation.RemovedInDjango20Warning'>)
}}}
--
--
Ticket URL: <https://code.djangoproject.com/ticket/23889#comment:2>
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/072.b3d0ed0faa80b3650c6cf670f2022516%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
