django.git/django/db/models/sql/compiler.py, branch 5.1.14

[5.1.x] Fixed #35643 -- Fixed a crash when ordering a QuerySet by a reference containing "__".

2024-08-02T19:22:05Z

Regression in b0ad41198b3e333f57351e3fce5a1fb47f23f376. Refs #34013. The initial logic did not consider that annotation aliases can include lookup or transform separators. Thanks Gert Van Gool for the report and Mariusz Felisiak for the review. Backport of a16f13a8661297eda12c4177bb01fa2e5b5ccc56 from main.

Refs #35356 -- Clarified select related with masked field logic.

2024-04-23T16:17:17Z

By always including related objects in the select mask via adjusting the defer logic (_get_defer_select_mask()), it becomes possible for select_related_descend() to treat forward and reverse relationships indistinctively. This work also simplifies and adds comments to select_related_descend() to make it easier to understand.

Fixed #35356 -- Deferred self-referential foreign key fields adequately.

2024-04-23T16:17:17Z

While refs #34612 surfaced issues with reverse one-to-one fields deferrals, it missed that switching to storing remote fields would break self-referential relationships. This change switches to storing related objects in the select mask instead of remote fields to prevent collisions when dealing with self-referential relationships that might have a different directional mask. Despite fixing #21204 introduced a crash under some self-referential deferral conditions, it was simply not working even before that as it aggregated the sets of deferred fields by model. Thanks Joshua van Besouw for the report and Mariusz Felisiak for the review.

Fixed #35294 -- Fixed TEXT format of QuerySet.explain() for long plans.

2024-03-15T05:58:14Z

co-authored-by: Gordon co-authored-by: Simon Charette

Fixed #35241 -- Cached model's full parent list.

2024-02-26T04:38:31Z

co-authored-by: Keryn Knight co-authored-by: Natalia <124304+nessita@users.noreply.github.com> co-authored-by: David Smith co-authored-by: Paolo Melchiorre

Applied Black's 2024 stable style.

2024-01-26T11:45:07Z

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

Fixed #34013 -- Added QuerySet.order_by() support for annotation transforms.

2023-12-12T04:51:33Z

Thanks Eugene Morozov and Ben Nace for the reports.

Fixed #35024 -- Fixed model instance creation crash on GeneratedField.output_field with backend converters.

2023-12-07T19:50:18Z

Regression in d9de74141e8a920940f1b91ed0a3ccb835b55729. This is a long standing issue, however it caused a crash of GeneratedFields for all output fields that have backend-specific converters when the RETURNING clause is not supported (MySQL and SQLite < 3.35). That's why severity was exacerbated.

Fixed #34967 -- Fixed queryset crash when grouping by constants on SQLite < 3.39.

2023-11-13T11:01:40Z

On SQLite < 3.39, this forces a GROUP BY clause with a HAVING clause when no grouping is specified. Co-authored-by: Simon Charette

Fixed #34580 -- Avoided unnecessary computation of selected expressions in SQLCompiler.

2023-05-22T03:47:29Z

Performance regression in 278881e37619278789942513916acafaa88d26f3. Co-authored-by: David Smith