summaryrefslogtreecommitdiff
path: root/django/db
AgeCommit message (Collapse)Author
2019-12-30[3.0.x] Fixed #31071 -- Disabled insert optimization for primary keys with ↵Simon Charette
defaults when loading fixtures. Model.save_base() is called directly when loading fixtures and assumes existing rows will be updated. Branching of "raw" allows to maintain the optimization introduced in #29260 while supporting this edge case. Regression in 85458e94e38c20e57939947ee515a1a53689659f. Thanks Reupen Shah for the report. Backport of 5779cc938a34eb96815c7a40ded2c8f6c8087c58 from master
2019-12-23[3.0.x] Fixed #31106 -- Fixed migrations crash on PostgreSQL 10+ when adding ↵Mariusz Felisiak
FK constraints inline and changing data. This allows adding foreign key constraints inline and changing data in the same migration on PostgreSQL 10+. Regression in 738faf9da2a5cd03148a36375db80746c99c9623. Thanks Janne Rönkkö for the report and Simon Charette for the implementation idea and review. Backport of 22ce5d0031bd795ade081394043833e82046016c from master
2019-12-23[3.0.x] Fixed #31109 -- Disabled grouping by aliases on QuerySet.exists().Simon Charette
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
2019-12-19[3.0.x] Fixed #31094 -- Included columns referenced by subqueries in GROUP ↵Simon Charette
BY on aggregations. Thanks Johannes Hoppe for the report. Regression in fb3f034f1c63160c0ff13c609acd01c18be12f80. Co-authored-by: Mariusz Felisiak <felisiak.mariusz@gmail.com> Backport of 5a4d7285bd10bd40d9f7e574a7c421eb21094858 from master
2019-12-06[3.0.x] Fixed #31060 -- Reallowed window expressions to be used in ↵Alex Aktsipetrov
conditions outside of queryset filters. Regression in 4edad1ddf6203326e0be4bdb105beecb0fe454c4. Thanks utapyngo for the report. Backport of bf12273db4e53779546e2ac7b65c0ce8e3c8a640 from master.
2019-12-02[3.0.x] Fixed #30953 -- Made select_for_update() lock queryset's model when ↵Mariusz Felisiak
using "self" with multi-table inheritance. Thanks Abhijeet Viswa for the report and initial patch. Backport of 0107e3d1058f653f66032f7fd3a0bd61e96bf782 from master
2019-11-25[3.0.x] Fixed #27914 -- Fixed serialization of nested classes in migrations.John Bowen
Backport of 29d8198841ea39af44f3bc835d646e642d498475 from master
2019-11-18[3.0.x] Fixed #30986 -- Fixed queryset crash when filtering against boolean ↵Mariusz Felisiak
RawSQL expressions on Oracle. Backport of 8685e764efd2957085762d9249e07794d9a58dcb from master
2019-11-13[3.0.x] Fixed #30971 -- Prevented Query.resolve_lookup_value() from coercing ↵George Marshall
list values to tuples. Regression in 8a281aa7fe76a9da2284f943964a9413697cff1f. Backport of 8be79984dce7d819879a6e594ca69c5f95a08378 from master
2019-11-05[3.0.x] Fixed DatabaseFeatures.has_select_for_update_nowait on MariaDB 10.3+.Mariusz Felisiak
Thanks Kola Erinoso for the report. Backport of a20ea33ca66bafd38bfce1a73221384b8aa37170 from master
2019-11-04[3.0.x] Fixed #30931 -- Restored ability to override Model.get_FIELD_display().Carlton Gibson
Thanks Sergey Fedoseev for the implementation idea. Regression in a68ea231012434b522ce45c513d84add516afa60. Backport of 2d38eb0ab9f78d68c083a5b78b1eca39027b279a from master
2019-10-25[3.0.x] Fixed #30902 -- Added __str__() for model choice enums.Carlton Gibson
Allows expected behavior when cast to str, also matching behaviour of created instances with those fetched from the DB. Thanks to Simon Charette, Nick Pope, and Shai Berger for reviews. Backport of dbcd7b064e7278614f29fc45468d461e263d4da7 from master
2019-10-24[3.0.x] Fixed #30903 -- Fixed migrations crash on PostgreSQL when adding ↵Hannes Ljungberg
Index with opclasses and ordering. Backport of fa5f3291e7f2611d53e64ab481ebe951b0161791 from master
2019-10-14[3.0.x] Fixed #30868 -- Prevented unnecessary AlterField when renaming a ↵Simon Charette
referenced pk. Regression introduced by dcdd219ee1, refs #25817. Thanks Carlos E. C. Leite for the report and Mariusz for the bisect. Backport of 2839659b42ef80038152768b6cedae1016c59d90 from master
2019-10-11[3.0.x] Fixed #30854 -- Fixed QuerySet.select_related() with multiple ↵Hasan Ramezani
FilteredRelations. Backport of 6a75cea76a98c08bf2e20d787be9b14c2cd94860 from master.
2019-10-03[3.0.x] Refs #27914 -- Fixed serialization of nested enum.Enum classes in ↵Hasan Ramezani
migrations. Backport of 6452112640081ac8838147a8ba192c45879203d8 from master
2019-10-01[3.0.x] Fixed typo in BulkInsertMapper constant name.Mariusz Felisiak
Backport of 67e7dffe9543aff259f63c8f12d15642fe7be100 from master
2019-10-01[3.0.x] Fixed #30510 -- Fixed crash of QuerySet.bulk_create() with ↵Ahmet Kucuk
mixed-length texts on Oracle. Text with more than 4000 characters must be set to as a CLOB on Oracle what caused a mixed datatype error (ORA-01790) when shorter text appeared in the same operation. Backport of dc890bef5ad8e9fccce55f3e64af72103ea6e8c1 from master
2019-09-30[3.0.x] Fixed #30774 -- Made serialization in migrations use members names ↵Hasan Ramezani
for Enums. Backport of f0adf3b9b7a19cdee05368ff0c0c2d087f011180 from master
2019-09-27[3.0.x] Fixed #30798 -- Fixed Meta.ordering validation for pk of related fields.Hasan Ramezani
Regression in 440505cb2cadbe1a5b9fba246bcde6c04f51d07e. Backport of 95a11578ce41de1e152fe7d173f109e280aebd6d from master
2019-09-27[3.0.x] Refs #30798 -- Prevented chaining fields from the same related model ↵Hasan Ramezani
multiple times in model Meta.ordering. Backport of c7944628a1979453468d67818c63957532d396d8 from master
2019-09-25[3.0.x] Fixed #30800 -- Fixed migrations crash when altering a field with ↵Mariusz Felisiak
custom db_type(). Regression in 1378d665a1c85897d951f2ca9618b848fdbba2e7. Backport of 580e644f24f1c5ae5b94784fb73a9953a178fd26 from master
2019-09-24[3.0.x] Fixed #30796 -- Prevented select_related() from mutating a queryset ↵Simon Charette
on chaining. Thanks Darren Maki for the report. Backport of 37f8f293775d0b672da8ae369d9a4e17f1db7851 from master
2019-09-23[3.0.x] Fixed #13296 -- Fixed ordering by Options.order_with_respect_to ↵Hasan Ramezani
after deleting objects. Thanks Simon Meers for the original patch. Backport of f97bbad908df128189eff77d98af9a25ed1ecf23 from master
2019-09-20[3.0.x] Fixed #30771 -- Fixed exact lookup against queries with selected ↵James Timmins
columns. Use pre-existing select fields (and thereby GROUP BY fields) from subquery if they were specified, instead of always defaulting to pk. Thanks Aur Saraf for the report and Simon Charette for guidance. Backport of 0719edcd5fed56157ffb3323a8f634aa5e8f9a80 from master
2019-09-20[3.0.x] Fixed #30786 -- Used CONVERT_TZ to check if the time zone ↵Andrew
definitions are installed on MySQL. Replaced a timezone check in the MySQL backend with one that doesn't require access to the mysql.time_zone database. Backport of 3346b78a8a872286a245d1e77ef4718fc5e6be1a from master
2019-09-11[3.0.x] Fixed #30591 -- Fixed recreation of foreign key constraints on MySQL ↵Adnan Umer
when altering type of referenced unique field. Thanks Mariusz Felisiak for tests and Matthijs Kooijman for investigation and initial patch. Backport of 241deed2590bcb1d8c45271d44c86eaedfb57119 from master
2019-09-10Fixed #30754 -- Prevented inclusion of aliases in partial index conditions.Simon Charette
SQLite doesn't repoint table aliases in partial index conditions on table rename which breaks the documented table alteration procedure. Thanks Pēteris Caune for the report.
2019-09-09Fixed #28107 -- Added ↵Vojtech Bocek
DatabaseFeatures.allows_group_by_selected_pks_on_model() to allow enabling optimization for unmanaged models.
2019-09-09Refs #29444 -- Allowed returning multiple fields from INSERT statements on ↵Johannes Hoppe
PostgreSQL. Thanks Florian Apolloner, Tim Graham, Simon Charette, Nick Pope, and Mariusz Felisiak for reviews.
2019-09-09Refs #29444 -- Fixed DateField constructor in ↵Johannes Hoppe
db.backends.oracle.utils.InsertVar.
2019-09-09Fixed #30757 -- Added a system check to ensure max_length fits the longest ↵Nick Pope
choice.
2019-09-06Fixed DatabaseFeatures.can_introspect_check_constraints on MariaDB < ↵Mariusz Felisiak
10.2.22, 10.3.0 - 10.3.9. Regression in e2c6a0858d7d9ad85eda353076a5b46608b704a9.
2019-09-05Fixed #30750 -- Added support for check constraints on MySQL 8.0.16+.Mariusz Felisiak
2019-09-04Fixed #27910 -- Added enumeration helpers for use in Field.choices.Shai Berger
These classes can serve as a base class for user enums, supporting translatable human-readable names, or names automatically inferred from the enum member name. Additional properties make it easy to access the list of names, values and display labels. Thanks to the following for ideas and reviews: Carlton Gibson, Fran Hrženjak, Ian Foote, Mariusz Felisiak, Shai Berger. Co-authored-by: Shai Berger <shai@platonix.com> Co-authored-by: Nick Pope <nick.pope@flightdataservices.com> Co-authored-by: Mariusz Felisiak <felisiak.mariusz@gmail.com>
2019-09-03Fixed #30691 -- Made migrations autodetector find dependencies for foreign ↵Viktor Lomakin
keys altering.
2019-09-03Refs #29444 -- Made db.backends.oracle.utils.InsertVar use str as default.Johannes Hoppe
2019-09-02Fixed #30739 -- Fixed exclusion of multi-valued lookup against outer rhs.Simon Charette
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.
2019-09-02Refs #28442 -- Adjusted related lookups handling of expression rhs.Simon Charette
Expressions should never be prepared as other Lookup.get_prep_lookup implementations hint at by returning early on the presence of the resolve_expression attribute. The previous solution was only handling lookups against related fields pointing at AutoFields and would break for foreign keys to other fields. It was also causing bidirectional coupling between model fields and expressions which the method level import of OuterRef was a symptom of.
2019-08-29Refs #25367 -- Simplified OrderBy and Lookup by using Case() instead of ↵Mariusz Felisiak
RawSQL() on Oracle. Follow up to efa1908f662c19038a944129c81462485c4a9fe8.
2019-08-29Fixed #25367 -- Allowed boolean expressions in QuerySet.filter() and exclude().Matthew Schinckel
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 <hello@vanille.bid>
2019-08-27Fixed #30727 -- Made Subquery pickle without evaluating their QuerySet.Andrew Brown
Subquery expression objects, when pickled, were evaluating the QuerySet objects saved in its _constructor_args attribute.
2019-08-26Refs #30591 -- Fixed introspection of check and unique column constraints on ↵Mariusz Felisiak
MariaDB. Unnamed unique and check columns constraints have the same name as a column. Ensure uniqueness by using custom names. Thanks Adnan Umer for the report.
2019-08-23Replaced subprocess commands by run() wherever possible.Claude Paroz
2019-08-22Fixed #30712 -- Allowed BLOB/TEXT defaults on MySQL 8.0.13+.Nasir Hussain
2019-08-21Fixed #21039 -- Added AddIndexConcurrently/RemoveIndexConcurrently ↵Mads Jensen
operations for PostgreSQL. Thanks to Simon Charettes for review. Co-Authored-By: Daniel Tao <daniel.tao@gmail.com>
2019-08-20Fixed #29979, Refs #17337 -- Extracted AutoField field logic into a mixin ↵Nick Pope
and refactored AutoFields. This reduces duplication by allowing AutoField, BigAutoField and SmallAutoField to inherit from IntegerField, BigIntegerField and SmallIntegerField respectively. Doing so also allows for enabling the max_length warning check and minimum/maximum value validation for auto fields, as well as providing a mixin that can be used for other possible future auto field types such as a theoretical UUIDAutoField.
2019-08-19Fixed #29260 -- Skipped an UPDATE when adding a model instance with primary ↵Hasan Ramezani
key that has a default.
2019-08-18Refs #28428 -- Made FileField.upload_to support pathlib.Path.Claude Paroz
2019-08-17Fixed #29545 -- Fixed using filter lookups againts nested subquery expressions.Simon Charette
Made sql.Where resolve lhs of its child nodes. This is necessary to allow filter lookups against nested subquery expressions to properly resolve their OuterRefs to Cols. Thanks Oskar Persson for the simplified test case.