django.git/tests/aggregation_regress/tests.py, branch main

Fixed #37047 -- Fixed crash in Query.orderby_issubset_groupby for descending and random order_by strings.

2026-04-19T08:03:11Z

Run this example: ```python User.objects.values("is_staff").annotate(latest=Max("date_joined")).order_by("-latest").count() ``` You should see the following exception: ``` django.core.exceptions.FieldError: Cannot resolve keyword '-latest' into field. ``` Regression in 2ce5cb0f7a4618dfdc5f5c10e53e2e9b9543d298.

Refs #36883 -- Split monolithic aggregation/lookup/queries tests.

2026-03-21T14:14:48Z

Fixed #36883 -- Split monolithic aggregation regression tests.

2026-01-26T15:37:11Z

Fixed #26434 -- Removed faulty clearing of ordering field when missing from explicit grouping.

2025-12-15T20:23:51Z

Co-authored-by: Simon Charette

Reverted "Fixed #26434 -- Removed faulty clearing of ordering field when missing from explicit grouping."

2025-10-28T15:40:01Z

This reverts commit ea3a71c2d09f8281d8a50ed20e40e1fb13db5cd9. The implementation was flawed, as self.group_by contains Cols, not aliases.

Fixed #26434 -- Removed faulty clearing of ordering field when missing from explicit grouping.

2025-10-27T19:11:19Z

Co-authored-by: Simon Charette

Refs #36500 -- Rewrapped long docstrings and block comments via a script.

2025-07-23T23:17:55Z

Rewrapped long docstrings and block comments to 79 characters + newline using script from https://github.com/medmunds/autofix-w505.

Applied Black's 2024 stable style.

2024-01-26T11:45:07Z

https://github.com/psf/black/releases/tag/24.1.0

Fixed #34176 -- Fixed grouping by ambiguous aliases.

2023-01-09T09:52:51Z

Regression in b7b28c7c189615543218e81319473888bc46d831. Refs #31377. Thanks Shai Berger for the report and reviews. test_aggregation_subquery_annotation_values_collision() has been updated as queries that are explicitly grouped by a subquery should always be grouped by it and not its outer columns even if its alias collides with referenced table columns. This was not possible to accomplish at the time 10866a10 landed because we didn't have compiler level handling of colliding aliases.

Refs #17144 -- Removed support for grouping by primary key.

2022-11-07T11:21:29Z

No core backend require the feature anymore as it was only added to support a MySQL'ism that has been deprecated since then.