django.git/django/db/models/sql/compiler.py, branch 3.2.24 django http://cgit.adnoto.dev/django.git/atom?h=3.2.24 2021-04-27T08:35:42Z [3.2.x] Refs #32682 -- Fixed QuerySet.delete() crash on querysets with self-referential subqueries on MySQL. 2021-04-27T08:35:42Z Mariusz Felisiak felisiak.mariusz@gmail.com 2021-04-27T07:53:27Z urn:sha1:7ad7034054c10bfa919ceec4623fa7f30a68bba2 Backport of 4074f38e1dcc93b859bbbfd6abd8441c3bca36b3 from main [3.2.x] Fixed #32627 -- Fixed QuerySet.values()/values_list() crash on combined querysets ordered by unannotated columns. 2021-04-13T04:16:19Z Iuri de Silvio iurisilvio@gmail.com 2021-04-08T19:31:45Z urn:sha1:b245845575154905701a71d34a4d0c4d21f2f6b3 Backport of 9760e262f85ae57df39abe2799eff48a82b14474 from main Fixed #31496 -- Fixed QuerySet.values()/values_list() crash on combined querysets ordered by annotations. 2020-11-14T09:22:09Z David-Wobrock david.wobrock@gmail.com 2020-10-10T15:41:13Z urn:sha1:464a4c0c59277056b5d3c1132ac1b4c6085aee08 Fixed #31910 -- Fixed crash of GIS aggregations over subqueries. 2020-11-04T08:54:58Z Simon Charette charette.s@gmail.com 2020-11-03T21:50:10Z urn:sha1:c2d4926702045e342a668057f0a758eec9db9436 Regression was introduced by fff5186 but was due a long standing issue. AggregateQuery was abusing Query.subquery: bool by stashing its compiled inner query's SQL for later use in its compiler which made select_format checks for Query.subquery wrongly assume the provide query was a subquery. This patch prevents that from happening by using a dedicated inner_query attribute which is compiled at a later time by SQLAggregateCompiler. Moving the inner query's compilation to SQLAggregateCompiler.compile had the side effect of addressing a long standing issue with aggregation subquery pushdown which prevented converters from being run. This is now fixed as the aggregation_regress adjustments demonstrate. Refs #25367. Thanks Eran Keydar for the report. Fixed #32060 -- Added Random database function. 2020-10-02T04:58:03Z Nick Pope nick.pope@flightdataservices.com 2020-07-16T22:32:46Z urn:sha1:06c5d3fafc6aeb96387148726713b611aeba7fa1 Fixed #31916 -- Fixed combined queryset crash when combining with ordered combined querysets. 2020-09-17T06:26:06Z Hasan Ramezani hasan.r67@gmail.com 2020-09-17T06:26:06Z urn:sha1:a046bcadbee2dc0e6c889f82c08b5a21a32359ad Fixed #31965 -- Adjusted multi-table fast-deletion on MySQL/MariaDB. 2020-08-31T06:11:28Z Simon Charette charette.s@gmail.com 2020-08-30T07:00:15Z urn:sha1:f6405c0b8ef7aff513b105c1da68407a881a3671 The optimization introduced in 7acef095d73 did not properly handle deletion involving filters against aggregate annotations. It initially was surfaced by a MariaDB test failure but misattributed to an undocumented change in behavior that resulted in the systemic generation of poorly performing database queries in 5b83bae031. Thanks Anton Plotkin for the report. Refs #23576. Fixed #31792 -- Made Exists() reuse QuerySet.exists() optimizations. 2020-08-13T12:10:36Z Simon Charette charette.s@gmail.com 2020-08-13T03:16:22Z urn:sha1:51297a92324976a704279b567ec4f80bb92d7b60 The latter is already optimized to limit the number of results, avoid selecting unnecessary fields, and drop ordering if possible without altering the semantic of the query. Fixed #31866 -- Fixed locking proxy models in QuerySet.select_for_update(of=()). 2020-08-11T09:55:10Z Daniel Hillier daniel.hillier@gmail.com 2020-08-08T05:17:36Z urn:sha1:60626162f76f26d32a38d18151700cb041201fb3 Fixed #31657 -- Fixed ordering by attnames of self-referential ForeignKeys. 2020-06-10T09:14:26Z Hasan Ramezani hasan.r67@gmail.com 2020-06-07T14:50:47Z urn:sha1:037a624120b676858be4b93c4d0adda45916fd2a