summaryrefslogtreecommitdiff
path: root/django/db/backends/sqlite3/features.py
AgeCommit message (Collapse)Author
2021-01-14Refs #26167 -- Changed default value of ↵Hannes Ljungberg
DatabaseFeatures.supports_expression_indexes to True.
2021-01-13Fixed #26167 -- Added support for functional indexes.Hannes Ljungberg
Thanks Simon Charette, Mads Jensen, and Mariusz Felisiak for reviews. Co-authored-by: Markus Holtermann <info@markusholtermann.eu>
2020-12-10Fixed #32178 -- Allowed database backends to skip tests and mark expected ↵Hasan Ramezani
failures. Co-authored-by: Tim Graham <timograham@gmail.com>
2020-12-02Fixed #32179 -- Added JSONObject database function.Artur Beltsov
2020-11-25Fixed #32224 -- Avoided suppressing connection errors in supports_json_field ↵Mariusz Felisiak
on SQLite.` Regression in 6789ded0a6ab797f0dcdfa6ad5d1cfa46e23abcd. Thanks Juan Garcia Alvite for the report.
2020-09-21Fixed #31777 -- Added support for database collations to Char/TextFields.Tom Carrick
Thanks Simon Charette and Mariusz Felisiak for reviews.
2020-08-11Fixed #21181 -- Added Collate database function.Tom Carrick
Thanks Simon Charette for reviews.
2020-07-28Fixed #31836 -- Dropped support for JSONField __contains and __contained_by ↵Mariusz Felisiak
lookups on SQLite. The current implementation works only for basic examples without supporting nested structures and doesn't follow "the general principle that the contained object must match the containing object as to structure and data contents, possibly after discarding some non-matching array elements or object key/value pairs from the containing object".
2020-07-22Fixed #31765 -- Disabled bundled SQLite renaming atomic references on macOS ↵Tom Forbes
10.15.
2020-06-04Refs #31630 -- Removed DatabaseFeatures.can_introspect_autofield.Tim Graham
2020-06-04Fixed #31630 -- Replaced introspection features with ↵Hasan Ramezani
DatabaseFeatures.introspected_field_types.
2020-05-08Fixed #12990, Refs #27694 -- Added JSONField model field.sage
Thanks to Adam Johnson, Carlton Gibson, Mariusz Felisiak, and Raphael Michel for mentoring this Google Summer of Code 2019 project and everyone else who helped with the patch. Special thanks to Mads Jensen, Nick Pope, and Simon Charette for extensive reviews. Co-authored-by: Mariusz Felisiak <felisiak.mariusz@gmail.com>
2020-04-21Fixed #31479 -- Added support to reset sequences on SQLite.Jon Dufresne
2020-03-18Fixed #31376 -- Optimized nulls ordering when possible on SQLite and MySQL.Simon Charette
Both backends order NULLs first on ascending ordering and last on descending ordering which makes ORDER BY IS (NOT)? NULL wasteful when asc(nulls_first) and desc(nulls_last) are used since it prevents indice usage.
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-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-08-02Fixed #30661 -- Added models.SmallAutoField.Nick Pope
2019-02-09Refs #30027 -- Enabled window function tests on SQLite 3.25+.Simon Charette
2019-01-30Fixed #30116 -- Dropped support for Python 3.5.Tim Graham
2019-01-29Fixed #30108 -- Allowed adding foreign key constraints in the same statement ↵Dan Tao
that adds a field.
2019-01-09Refs #23748 -- Added AutoField introspection for SQLite.Nick Pope
2018-12-26Refs #29547 -- Skipped an unsupported partial index test on older versions ↵Tim Graham
of SQLite. Follow up to e5b8626c0eb223cc3d643163882c5902c40ec972.
2018-12-24Fixed #30056 -- Added SQLite support for StdDev and Variance functions.Nick Pope
2018-12-22Fixed #30055 -- Dropped support for SQLite < 3.8.3.Tim Graham
2018-12-22Refs #29928 -- Added supports_pragma_foreign_key_check SQLite feature flag.Simon Charette
2018-12-22Refs #29928 -- Corrected SQLite's can_defer_constraint_checks feature flag.Simon Charette
2018-12-22Refs #29182 -- Corrected SQLite's supports_atomic_references_rename feature ↵Simon Charette
flag.
2018-12-22Refs #29547 -- Corrected SQLite's supports_partial_indexes feature flag.Simon Charette
2018-12-17Fixed #29928 -- Enabled deferred constraint checks on SQLite 3.20+.Simon Charette
Refs #11665, #14204. Thanks Michel Samia for the report.
2018-12-17Refs #29182 -- Stopped relying on legacy alter table semantic on SQLite 3.26+.Simon Charette
SQLite 3.26 changed the behavior of table and column renaming operations to repoint foreign key references even if foreign key checks are disabled. This makes the workarounds in place to simulate this behavior unnecessary on SQLite 3.26+. Refs #30033.
2018-12-06Fixed #29932 -- Fixed combining compound queries with sub-compound queries ↵Mariusz Felisiak
on SQLite and Oracle.
2018-10-29Fixed #29547 -- Added support for partial indexes.Mads Jensen
Thanks to Ian Foote, Mariusz Felisiak, Simon Charettes, and Markus Holtermann for comments and feedback.
2018-10-27Fixed #29763 -- Added support for column renaming on SQLite.Hampus Dunström
2018-10-25Refs #27025 -- Removed obsolete sqlite3 transaction management workaround ↵Tim Graham
for Python 3.6+. Obsolete per https://bugs.python.org/issue10740#msg274816.
2018-10-25Made DatabaseFeatures.uses_savepoints default to True.Tim Graham
2018-10-21Fixed #29870 -- Added DurationField introspection for Oracle and PostgreSQL.Mariusz Felisiak
Thanks Tim Graham for the review.
2018-10-01Fixed #29767 -- Made date-related casts work on SQLiteClaude Paroz
Thanks Rémy Hubscher for the report and Tim Graham and Simon Charette for the reviews.
2018-07-25Fixed #29563 -- Added result streaming for QuerySet.iterator() on SQLite.Andrew Brown
2018-06-25Fixed #29517 -- Added support for SQLite column check constraints on ↵Tim Graham
positive integer fields.
2017-12-01Fixed #28849 -- Fixed referenced table and column rename on SQLite.Simon Charette
Thanks Ramiro for the input and Tim for the review.
2017-10-03Refs #28584 -- Removed unused DatabaseFeatures.can_share_in_memory_db.Tim Graham
2017-10-03Fixed #28584 -- Dropped support for SQLite < 3.7.15.Tim Graham
2017-09-18Changed default value of DatabaseFeatures.has_bulk_insert to True.Mads Jensen
2017-09-06Replaced @cached_property with class attributes where possible.Sergey Fedoseev
2017-07-17Fixed #28391 -- Fixed Cast() with CharField and max_length on MySQL.Mariusz Felisiak
Thanks Tim Graham for the review.
2017-07-11Fixed #14204 -- Enforced SQLite foreign key constraints.Claude Paroz
Thanks Tim Graham for contributing to the patch and Simon Charette for advice and review.
2017-03-24Refs #21160 -- Replaced DatabaseFeatures.supports_1000_query_parameters by a ↵Mariusz Felisiak
DatabaseFeatures.max_query_params.
2017-02-28Refs #27656 -- Updated django.db docstring verbs according to PEP 257.Anton Samarchyan
2017-01-18Refs #23919 -- Removed six.PY2/PY3 usageClaude Paroz
Thanks Tim Graham for the review.