django.git/django/db/models/sql, branch stable/3.0.x django http://cgit.adnoto.dev/django.git/atom?h=stable%2F3.0.x 2020-10-29T10:33:52Z [3.0.x] Fixed #32152 -- Fixed grouping by subquery aliases. 2020-10-29T10:33:52Z Christian Klus christianklus@gmail.com 2020-10-27T18:13:10Z urn:sha1:b0a6798de59151163b94d1c0ccf0d010a3d46ac2 Regression in 42c08ee46539ef44f8658ebb1cbefb408e0d03fe. Thanks Simon Charette for the review. Backport of 4ac2d4fa42e1659f328c35b6b8d4761b3419c11a from master [3.0.x] Fixed #31866 -- Fixed locking proxy models in QuerySet.select_for_update(of=()). 2020-08-11T10:31:50Z Daniel Hillier daniel.hillier@gmail.com 2020-08-08T05:17:36Z urn:sha1:784ed4ada112753c35dd7c6b85686ad1d935b65d Backport of 60626162f76f26d32a38d18151700cb041201fb3 from master [3.0.x] Fixed #31664 -- Reallowed using non-expressions having filterable attribute as rhs in queryset filters. 2020-06-08T07:20:08Z Nicolas Baccelli nicolas.baccelli@abc-culture.fr 2020-06-05T19:01:39Z urn:sha1:2b2500021b502318866e605f6c031f122703fe4b Regression in 4edad1ddf6203326e0be4bdb105beecb0fe454c4. Backport of b38d44229ff185ad156bcb443d6db0db7ae3eb98 from master [3.0.x] Fixed #31584 -- Fixed crash when chaining values()/values_list() after Exists() annotation and aggregation on Oracle. 2020-05-14T13:11:18Z Mariusz Felisiak felisiak.mariusz@gmail.com 2020-05-14T13:07:08Z urn:sha1:92acf1022fb13a7a8b1ff7cdfe72c21050c1e4e7 Oracle requires the EXISTS expression to be wrapped in a CASE WHEN in the GROUP BY clause. Regression in efa1908f662c19038a944129c81462485c4a9fe8. Backport of 3a941230c85b2702a5e1cd97e17251ce21057efa from master [3.0.x] Fixed #31568 -- Fixed alias reference when aggregating over multiple subqueries. 2020-05-14T08:26:16Z Simon Charette charette.s@gmail.com 2020-05-14T04:14:48Z urn:sha1:49bbf6570d9f0880b836f741d79e4cdb6e061ea2 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 Simon Charette charette.s@gmail.com 2020-05-14T03:38:29Z urn:sha1:afceb2241ba84dfafe59de326cdc9c01963ddefb 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 Hasan Ramezani hasan.r67@gmail.com 2020-04-04T18:55:20Z urn:sha1:22a2e97fc30487af89d7c34b753853e7b510083d 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 Hasan Ramezani hasan.r67@gmail.com 2020-03-19T18:54:36Z urn:sha1:72652bcb1b29710d23c3e6f872046d4aedc58665 Regression in fb3f034f1c63160c0ff13c609acd01c18be12f80. Thanks Holovashchenko Vadym for the report. Backport of 10866a10fe9f0ad3ffdf6f93823aaf4716e6f27c from master [3.0.x] Fixed #31246 -- Fixed locking models in QuerySet.select_for_update(of=()) for related fields and parent link fields with multi-table inheritance. 2020-02-11T20:36:05Z Abhijeet Viswa abhijeetviswa@gmail.com 2020-02-08T04:52:09Z urn:sha1:8faaaf4e719531f2fd7f390a8af33ef2458f5427 Partly regression in 0107e3d1058f653f66032f7fd3a0bd61e96bf782. Backport of 1712a76b9dfda1ef220395e62ea87079da8c9f6c from master [3.0.x] Fixed #31217 -- Made QuerySet.values()/values_list() group by not selected annotations with aggregations used in order_by(). 2020-02-03T06:48:53Z Mariusz Felisiak felisiak.mariusz@gmail.com 2020-02-03T06:48:11Z urn:sha1:673444da5e721c0d23809076c5d5d74224457d23 Regression in 59b4e99dd00b9c36d56055b889f96885995e4240. Thanks Jon Dufresne for the report and Simon Charette for the review. Backport of 6b178a3e930f72069f3cda2e6a09d1b320fc09ec from master