Release notes and documentation don't mention queryset week_day breakage on mysql if you haven't loaded tzinfo

[Matt Austin]

When switching to Django 1.6b2, queries such as MyModel.objects.filter(start_at__week_day=1) started returning empty querysets. After investigation, it turned out I had to load tzinfo in to the database, as described at ​https://docs.djangoproject.com/en/1.6/ref/models/querysets/#database-time-zone-definitions. Although the release notes mention this is required for the new QuerySet.datetimes() functionality, there was nothing mentioning it was required for using week_day lookups.

As this could break previously working projects with Django 1.5, it should probably be made clear in the release notes and queryset documentation.

[anonymous]

I've added some notes for the requirement of database time zone definitions for day, month, and week_day lookups.

Pull request for master (will also need to be cherry-picked to stable-1.6.x / stable-1.7.x branches):
​https://github.com/django/django/pull/1620

[Aymeric Augustin]

Pull request looks good, I'll edit it a bit to provide the solution immediately instead of redirecting the user to another page.

This creates a bit of duplications but it's only two lines and it doesn't matter if it goes stale; the release notes only need to stay accurate while the release is supported.

[Aymeric Augustin <aymeric.augustin@…>]

In 9451d8d558e6dafa4e270c33608a291610ccf77d:

Fixed #21095 -- Documented new requirement for dates lookups.

Day, month, and week_day lookups now require time zone definitions in the database.

[Aymeric Augustin <aymeric.augustin@…>]

In a929adfd3b89056d83c34f729bedde78afec44db:

[1.6.x] Fixed #21095 -- Documented new requirement for dates lookups.

Day, month, and week_day lookups now require time zone definitions in the database.

Backport of 9451d8d from master.