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
36751 Aggregation with an empty filter over a queryset with annotations crashes since Django 5.2.2 Rafael Urben Simon Charette "In Django 6.0, activating facets leads to an internal server error when the admin queryset contains certain annotations.
As an example, the following annotations lead to an error:
{{{
def get_queryset(self, request):
return (
super()
.get_queryset(request)
.annotate(
annotation_has_usable_password=Case(
When(
Q(password__isnull=False) & ~Q(password__startswith=""!""), then=Value(True)
),
default=Value(False),
output_field=BooleanField(),
),
)
)
}}}
The error observed seems to depend on the database backend:
- With sqlite3, I get 'NoneType' object has no attribute 'as_sql'
(triggered in template rendering at site-packages\django\contrib\admin\templates\admin\change_list.html, error at line 72)
- With mysql, I get When() supports a Q object, a boolean expression, or lookups as a condition.
(triggered in template rendering at site-packages\django\contrib\admin\templates\admin\change_list.html, error at line 72)
I have created a small gist with a minimal reproducer admin.py that triggers the error:
[https://gist.github.com/rafaelurben/670658ffe1a9cc0cfee45380e8f148a0]
The example works without an issue in Django 5.2.8 but fails on Django 6.0rc1 (tested in a new project with a new venv with sqlite and in an existing project with mysql).
I'm not sure if I have missed something in the Django 6.0 release notes, but this looks like a bug.
Traceback (sqlite):
{{{
Environment:
Request Method: GET
Request URL: http://localhost:8000/admin/auth/user/?_facets=True
Django Version: 6.0rc1
Python Version: 3.13.5
Installed Applications:
['django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.staticfiles',
'testapp']
Installed Middleware:
['django.middleware.security.SecurityMiddleware',
'django.contrib.sessions.middleware.SessionMiddleware',
'django.middleware.common.CommonMiddleware',
'django.middleware.csrf.CsrfViewMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.contrib.messages.middleware.MessageMiddleware',
'django.middleware.clickjacking.XFrameOptionsMiddleware']
Template error:
In template C:\Users\rafae\Coding\Django\reproducer_dj60_facets\.venv\Lib\site-packages\django\contrib\admin\templates\admin\change_list.html, error at line 72
'NoneType' object has no attribute 'as_sql'
62 :
{% translate 'Filter' %}
63 : {% if cl.is_facets_optional or cl.has_active_filters %}