django.git/django/db/models/sql/query.py, branch 3.0.10

[3.0.x] Fixed #31664 -- Reallowed using non-expressions having filterable attribute as rhs in queryset filters.

2020-06-08T07:20:08Z

Regression in 4edad1ddf6203326e0be4bdb105beecb0fe454c4. Backport of b38d44229ff185ad156bcb443d6db0db7ae3eb98 from master

[3.0.x] Fixed #31568 -- Fixed alias reference when aggregating over multiple subqueries.

2020-05-14T08:26:16Z

691def10a0197d83d2d108bd9043b0916d0f09b4 made all Subquery() instances equal to each other which broke aggregation subquery pushdown which relied on object equality to determine which alias it should select. Subquery.__eq__() will be fixed in an another commit but Query.rewrite_cols() should haved used object identity from the start. Refs #30727, #30188. Thanks Makina Corpus for the report. Backport of adfbf653dc1c1d0e0dacc4ed46602d22ba28b004 from master

[3.0.x] Fixed #31566 -- Fixed aliases crash when chaining values()/values_list() after annotate() with aggregations and subqueries.

2020-05-14T06:40:40Z

Subquery annotation references must be resolved if they are excluded from the GROUP BY clause by a following .values() call. Regression in fb3f034f1c63160c0ff13c609acd01c18be12f80. Thanks Makina Corpus for the report. Backport of 42c08ee46539ef44f8658ebb1cbefb408e0d03fe from master

[3.0.x] Fixed #31420 -- Fixed crash when filtering subquery annotation against a SimpleLazyObject.

2020-04-06T06:15:51Z

Thanks Simon Charette for the solution and analysis. Backport of 4237050684427db45ea834fe89d9e11c0520201e from master

[3.0.x] Fixed #31377 -- Disabled grouping by aliases on QuerySet.values()/values_list() when they collide with field names.

2020-03-25T08:49:51Z

Regression in fb3f034f1c63160c0ff13c609acd01c18be12f80. Thanks Holovashchenko Vadym for the report. Backport of 10866a10fe9f0ad3ffdf6f93823aaf4716e6f27c from master

[3.0.x] Refs #31136 -- Made QuerySet.values()/values_list() group only by selected annotation.

2020-01-15T08:33:36Z

Regression in 0f843fdd5b9b2f2307148465cd60f4e1b2befbb4. Backport of 59b4e99dd00b9c36d56055b889f96885995e4240 from master

[3.0.x] Fixed #31136 -- Disabled grouping by aliases on QuerySet.values()/values_list().

2020-01-04T19:49:43Z

Regression in fb3f034f1c63160c0ff13c609acd01c18be12f80. Thanks Sigurd Ljødal for the report. Backport of 0f843fdd5b9b2f2307148465cd60f4e1b2befbb4 from master

[3.0.x] Fixed #31109 -- Disabled grouping by aliases on QuerySet.exists().

2019-12-23T08:24:37Z

Clearing the SELECT clause in Query.has_results was orphaning GROUP BY references to it. Thanks Thierry Bastian for the report and Baptiste Mispelon for the bisect. Regression in fb3f034f1c63160c0ff13c609acd01c18be12f80. Backport of 720de4d0441fcfdb543051389c70efbe66ed962a from master

[3.0.x] Fixed #31094 -- Included columns referenced by subqueries in GROUP BY on aggregations.

2019-12-19T10:10:33Z

Thanks Johannes Hoppe for the report. Regression in fb3f034f1c63160c0ff13c609acd01c18be12f80. Co-authored-by: Mariusz Felisiak Backport of 5a4d7285bd10bd40d9f7e574a7c421eb21094858 from master

[3.0.x] Fixed #31060 -- Reallowed window expressions to be used in conditions outside of queryset filters.

2019-12-06T14:28:23Z

Regression in 4edad1ddf6203326e0be4bdb105beecb0fe454c4. Thanks utapyngo for the report. Backport of bf12273db4e53779546e2ac7b65c0ce8e3c8a640 from master.