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

[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.

[3.0.x] Fixed #30971 -- Prevented Query.resolve_lookup_value() from coercing list values to tuples.

2019-11-13T08:20:50Z

Regression in 8a281aa7fe76a9da2284f943964a9413697cff1f. Backport of 8be79984dce7d819879a6e594ca69c5f95a08378 from master

[3.0.x] Fixed #30796 -- Prevented select_related() from mutating a queryset on chaining.

2019-09-24T07:47:21Z

Thanks Darren Maki for the report. Backport of 37f8f293775d0b672da8ae369d9a4e17f1db7851 from master

Fixed #30739 -- Fixed exclusion of multi-valued lookup against outer rhs.

2019-09-02T08:52:36Z

OuterRef right hand sides have to be nested, just like F rhs have to, during the subquery pushdown split_exclude performs to ensure they are resolved against the outer query aliases.

Fixed #25367 -- Allowed boolean expressions in QuerySet.filter() and exclude().

2019-08-29T07:45:29Z

This allows using expressions that have an output_field that is a BooleanField to be used directly in a queryset filters, or in the When() clauses of a Case() expression. Thanks Josh Smeaton, Tim Graham, Simon Charette, Mariusz Felisiak, and Adam Johnson for reviews. Co-Authored-By: NyanKiyoshi