summaryrefslogtreecommitdiff
path: root/django/db/backends/sqlite3/features.py
AgeCommit message (Collapse)Author
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.
2017-01-18Refs #23919 -- Removed encoding preambles and future importsClaude Paroz
2016-11-28Fixed #27321 -- Added detection for table case name sensitivity on MySQL.Adam Chainz
2016-10-27Fixed #27327 -- Simplified time zone handling by requiring pytz.Tim Graham
2016-10-14Removed DatabaseFeatures.can_combine_inserts_with_and_without_auto_increment_pk.Tim Graham
Unused (always False) after 29132ebdef0e0b9c09e456b05f0e6a22f1106a4f.
2016-08-12Refs #20888 -- Added index order introspection.Akshesh
2016-06-21Fixed #26781 -- Made table name case change a noop on SQLite.Simon Charette
SQLite disgresses from the SQL standard by ignoring case of quoted identifiers. Thanks to laozzzi for the report and Tim for the review.
2016-02-26Fixed #24793 -- Unified temporal difference support.Simon Charette
2015-09-10Enabled parallel testing by default in runtests.py.Aymeric Augustin
2015-06-18Removed support for Python 3.3.Tim Graham
2015-01-27Fixed #24154 -- Backends can now check support for expressionsJosh Smeaton
2015-01-14Fixed #22603 -- Reorganized classes in django.db.backends.Tim Graham
generated by cgit v1.3 (git 2.53.0) at 2026-07-14 16:35:24 +0000