#34659: mysql backend creates queries using CONVERT_TZ even when this is not
supported
----------------------------------------------+------------------------
Reporter: Klaas van Schelven | Owner: nobody
Type: Uncategorized | Status: new
Component: Uncategorized | Version: 4.2
Severity: Normal | Keywords:
Triage Stage: Unreviewed | Has patch: 0
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
----------------------------------------------+------------------------
To test whether a mysql server has the zoninfo database loaded (feature
name: `has_zoneinfo_database`), the [following
code](https://github.com/django/django/blob/1fe0b167af3611cca79e8a8092ee929312193c6f/django/db/backends/mysql/base.py#L410)
is run:
```
CONVERT_TZ('2001-01-01 01:00:00', 'UTC', 'UTC') IS NOT NULL
```
However, this test is not actually used (i.e. there is no condition on the
feature being True) when [generating
sql](https://github.com/django/django/blob/main/django/db/backends/mysql/operations.py#L94),
despite the fact that the generated sql contains something that we know
will evaluate to `NULL`
This shows up when filtering like so:
```
Foo.objects(some_datetimefield__date="2023-06-16")
```
which evaluates to the empty queryset, despite there being such objects.
`USE_TZ = True`, obviously
--
Ticket URL: <https://code.djangoproject.com/ticket/34659>
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 view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/01070188c473cf46-c760e3b3-6076-449e-a1b9-039c015318f2-000000%40eu-central-1.amazonses.com.
