summaryrefslogtreecommitdiff
path: root/django/db/backends
AgeCommit message (Collapse)Author
2020-01-20Changed re-raising an exception to use bare raise syntax where appropriate.Jon Dufresne
2020-01-03Fixed #31133 -- Fixed crash when subtracting against a subquery annotation.Simon Charette
The subtract_temporals() database operation was not handling expressions returning SQL params in mixed database types. Regression in 35431298226165986ad07e91f9d3aca721ff38ec. Thanks Reupen Shah for the report.
2019-12-23Fixed #31106 -- Fixed migrations crash on PostgreSQL 10+ when adding FK ↵Mariusz Felisiak
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.
2019-12-16Fixed #31088 -- Added support for websearch searching in SearchQuery.James Turk
2019-12-16Fixed #31076 -- Fixed dbshell crash on Windows with Python < 3.8.Zeynel Özdemir
subprocess.run()'s args parameter accepts path-like objects on Windows since Python 3.8.
2019-12-11Refs #28373 -- Stopped setting tzinfo in typecast_timestamp().Sergey Fedoseev
Unnecessary since cef3f2d3c64055c9fc1757fd61dba24b557a2add. When USE_TZ=True, conn_tznames is always passed to methods that use typecast_timestamp(). Therefore, it can return naive datetimes.
2019-12-04Fixed #23524 -- Allowed DATABASES['TIME_ZONE'] option on PostgreSQL.Aymeric Augustin
2019-12-04Refs #23524 -- Unified BaseDatabaseWrapper.timezone.Aymeric Augustin
There was a special case in this property to return None when the database backend supports time zone. However, only the PostgreSQL backend supports time zones and it never uses this property.
2019-11-21Fixed #30413 -- Fixed test database signature on SQLite when test database ↵Farhaan Bukhsh
name is provided. Previously, the same signature was created for multiple in-memory databases on SQLite when they had tests databases names DATABASES['TEST']['NAME'].
2019-11-21Refs #25367 -- Moved conditional expression wrapping to the Exact lookup.Simon Charette
2019-11-20Fixed #25388 -- Added an option to allow disabling of migrations during test ↵Jon Dufresne
database creation.
2019-11-19Fixed #30987 -- Added models.PositiveBigIntegerField.Caio Ariede
2019-11-18Replaced unnecessary str()/bytes() calls with literals.Jon Dufresne
2019-11-18Fixed #30986 -- Fixed queryset crash when filtering against boolean RawSQL ↵Mariusz Felisiak
expressions on Oracle.
2019-11-08Fixed #30961 -- Fixed spaces in columns list SQL generated for indexes.Hannes Ljungberg
2019-11-07Fixed #30943 -- Added BloomIndex to django.contrib.postgres.Nick Pope
2019-11-07Refs #29983 -- Added support for using pathlib.Path in all settings.Jon Dufresne
2019-11-05Fixed DatabaseFeatures.has_select_for_update_nowait on MariaDB 10.3+.Mariusz Felisiak
Thanks Kola Erinoso for the report.
2019-11-04Refs #13312 -- Simplified handling of nulls ordering on MySQL.Nick Pope
MySQL & MariaDB support the standard IS NULL and IS NOT NULL so the same workaround used for NULLS FIRST and NULLS LAST that is used for SQLite < 3.30.0 can be used. Thanks Simon Charette for the discussion.
2019-10-31Refs #23576 -- Disabled MySQL multi-alias deletion path on MariaDB 10.3.2+.Simon Charette
2019-10-29Fixed #30899 -- Lazily compiled import time regular expressions.Hasan Ramezani
2019-10-24Refs #30897 -- Added support for ANALYZE option to Queryset.explain() on ↵Nick Pope
MariaDB and MySQL 8.0.18+.
2019-10-24Refs #30897 -- Added support for TREE format to Queryset.explain() on MySQL ↵Nick Pope
8.0.16+.
2019-10-24Fixed #23576 -- Implemented multi-alias fast-path deletion in MySQL backend.Simon Charette
This required moving the entirety of DELETE SQL generation to the compiler where it should have been in the first place and implementing a specialized compiler on MySQL/MariaDB. The MySQL compiler relies on the "DELETE table FROM table JOIN" syntax for queries spanning over multiple tables.
2019-10-24Fixed DatabaseFeatures.update_can_self_select on MariaDB 10.3.2+.Mariusz Felisiak
2019-10-24Fixed #30903 -- Fixed migrations crash on PostgreSQL when adding Index with ↵Hannes Ljungberg
opclasses and ordering.
2019-10-23Refs #30897 -- Added test for SETTINGS option to Queryset.explain() on ↵Nick Pope
PostgreSQL 12+.
2019-10-17Refs #28816 -- Prevented silencing data loss when decreasing ↵Hasan Ramezani
CharField.max_length for ArrayField.base_field on PostgreSQL.
2019-10-16Fixed #30885 -- Dropped support for MariaDB 10.1.Mariusz Felisiak
2019-10-15Fixed #30859 -- Fixed DatabaseFeatures.supports_aggregate_filter_clause on ↵Mariusz Felisiak
SQLite 3.30.1+.
2019-10-09Refs #26608 -- Fixed DatabaseFeatures.supports_frame_range_fixed_distance on ↵Mariusz Felisiak
SQLite 3.28+, MariaDB 10.2+, and MySQL 8.0.2+.
2019-10-02Fixed #30821 -- Added ExtractIsoWeekYear database function and iso_week_day ↵Anatol Ulrich
lookup.
2019-10-01Fixed typo in BulkInsertMapper constant name.Mariusz Felisiak
2019-10-01Fixed #30510 -- Fixed crash of QuerySet.bulk_create() with mixed-length ↵Ahmet Kucuk
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.
2019-09-25Fixed #30800 -- Fixed migrations crash when altering a field with custom ↵Mariusz Felisiak
db_type(). Regression in 1378d665a1c85897d951f2ca9618b848fdbba2e7.
2019-09-24Refs #29444 -- Removed redundant ↵Mariusz Felisiak
DatabaseFeatures.can_return_multiple_columns_from_insert. Unnecessary since b31e63879eb5d9717e9f890401f7222e4f00c910.
2019-09-24Fixed #29444 -- Allowed returning multiple fields from INSERT statements on ↵Johannes Hoppe
Oracle.
2019-09-20Fixed #30786 -- Used CONVERT_TZ to check if the time zone definitions are ↵Andrew
installed on MySQL. Replaced a timezone check in the MySQL backend with one that doesn't require access to the mysql.time_zone database.
2019-09-11Fixed #30591 -- Fixed recreation of foreign key constraints on MySQL when ↵Adnan Umer
altering type of referenced unique field. Thanks Mariusz Felisiak for tests and Matthijs Kooijman for investigation and initial patch.
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-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-03Refs #29444 -- Made db.backends.oracle.utils.InsertVar use str as default.Johannes Hoppe
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-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>