django.git/django/db/models/sql/query.py, branch 3.1.6 django http://cgit.adnoto.dev/django.git/atom?h=3.1.6 2020-10-29T10:30:53Z [3.1.x] Fixed #32152 -- Fixed grouping by subquery aliases. 2020-10-29T10:30:53Z Christian Klus christianklus@gmail.com 2020-10-27T18:13:10Z urn:sha1:ab951d242e3de232c7fc9a2f6facfd6aa95f5fe2 Regression in 42c08ee46539ef44f8658ebb1cbefb408e0d03fe. Thanks Simon Charette for the review. Backport of 4ac2d4fa42e1659f328c35b6b8d4761b3419c11a from master [3.1.x] Fixed #31664 -- Reallowed using non-expressions having filterable attribute as rhs in queryset filters. 2020-06-08T07:18:32Z Nicolas Baccelli nicolas.baccelli@abc-culture.fr 2020-06-05T19:01:39Z urn:sha1:83749dca7a292e966352278e2fd45bce09c1994f Regression in 4edad1ddf6203326e0be4bdb105beecb0fe454c4. Backport of b38d44229ff185ad156bcb443d6db0db7ae3eb98 from master [3.1.x] Fixed #31568 -- Fixed alias reference when aggregating over multiple subqueries. 2020-05-14T08:26:05Z Simon Charette charette.s@gmail.com 2020-05-14T04:14:48Z urn:sha1:3913acdb29d09109ec82ce789b592e6281aa7be9 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.1.x] Fixed #31566 -- Fixed aliases crash when chaining values()/values_list() after annotate() with aggregations and subqueries. 2020-05-14T06:39:21Z Simon Charette charette.s@gmail.com 2020-05-14T03:38:29Z urn:sha1:8cb87a3f7c413b9943a5a73e156716067267b182 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 Fixed #31426 -- Added proper field validation to QuerySet.order_by(). 2020-04-06T08:19:49Z Simon Charette charette.s@gmail.com 2020-04-05T19:45:06Z urn:sha1:513948735b799239f3ef8c89397592445e1a0cd5 Resolve the field reference instead of using fragile regex based string reference validation. Refs #7098 -- Deprecated passing raw column aliases to order_by(). 2020-04-06T08:01:02Z Simon Charette charette.s@gmail.com 2020-04-05T19:32:54Z urn:sha1:98ea4f0f4696221f00e111f1d623452002192e6c Now that order_by() has expression support passing RawSQL() can achieve the same result. This was also already supported through QuerySet.extra(order_by) for years but this API is more or less deprecated at this point. Fixed #31420 -- Fixed crash when filtering subquery annotation against a SimpleLazyObject. 2020-04-06T05:11:29Z Hasan Ramezani hasan.r67@gmail.com 2020-04-04T18:55:20Z urn:sha1:4237050684427db45ea834fe89d9e11c0520201e Thanks Simon Charette for the solution and analysis. Fixed #31377 -- Disabled grouping by aliases on QuerySet.values()/values_list() when they collide with field names. 2020-03-25T08:13:46Z Hasan Ramezani hasan.r67@gmail.com 2020-03-19T18:54:36Z urn:sha1:10866a10fe9f0ad3ffdf6f93823aaf4716e6f27c Regression in fb3f034f1c63160c0ff13c609acd01c18be12f80. Thanks Holovashchenko Vadym for the report. Refs #31136 -- Made QuerySet.values()/values_list() group only by selected annotation. 2020-01-15T08:32:42Z Mariusz Felisiak felisiak.mariusz@gmail.com 2020-01-15T08:32:42Z urn:sha1:59b4e99dd00b9c36d56055b889f96885995e4240 Regression in 0f843fdd5b9b2f2307148465cd60f4e1b2befbb4. Fixed #31136 -- Disabled grouping by aliases on QuerySet.values()/values_list(). 2020-01-04T19:49:11Z Mariusz Felisiak felisiak.mariusz@gmail.com 2020-01-04T19:49:11Z urn:sha1:0f843fdd5b9b2f2307148465cd60f4e1b2befbb4 Regression in fb3f034f1c63160c0ff13c609acd01c18be12f80. Thanks Sigurd Ljødal for the report.