summaryrefslogtreecommitdiff
path: root/django/db/backends/sqlite3/features.py
AgeCommit message (Collapse)Author
2022-12-08Fixed #34201 -- Bumped minimum supported SQLite to 3.21.0.Mariusz Felisiak
2022-11-28Refs #31169 -- Skipped test_get_test_db_clone_settings_not_supported on not ↵Mariusz Felisiak
in-memory SQLite database. multiprocessing's start method is checked only for in-memory SQLite databases.
2022-11-24Used DatabaseFeatures.django_test_skips to skip ↵Christophe Baldy
AssertNumQueriesUponConnectionTests tests.
2022-11-24Fixed #29062 -- Prevented possibility of database lock when using ↵baldychristophe
LiveServerTestCase with in-memory SQLite database. Thanks Chris Jerdonek for the implementation idea.
2022-11-08Fixed #10070 -- Added support for pyformat style parameters on SQLite.Ryan Cheley
Co-authored-by: Nick Pope <nick@nickpope.me.uk>
2022-11-01Refs #33768 -- Fixed ordering compound queries by NULLs on SQLite < 3.30.Simon Charette
The lack of support for native nulls last/first on SQLite 3.28 and 3.29 requires the compound query to be wrapped for emulation layer to work properly.
2022-06-01Fixed #32234 -- Made inspectdb inform about composite primary keys.Anv3sh
2022-02-18Fixed #33379 -- Added minimum database version checks.Hasan Ramezani
Thanks Tim Graham for the review.
2022-02-11Refs #32502 -- Avoided table rebuild when removing fields on SQLite 3.35.5+.Mariusz Felisiak
ALTER TABLE ... DROP COLUMN was introduced in SQLite 3.35+ however a data corruption issue was fixed in SQLite 3.35.5.
2022-02-07Refs #33476 -- Refactored code to strictly match 88 characters line length.Mariusz Felisiak
2022-02-07Refs #33476 -- Reformatted code with Black.django-bot
2022-01-19Fixed #31685 -- Added support for updating conflicts to QuerySet.bulk_create().sean_c_hsu
Thanks Florian Apolloner, Chris Jerdonek, Hannes Ljungberg, Nick Pope, and Mariusz Felisiak for reviews.
2021-12-27Refs #29517 -- Removed obsolete PositiveIntegerField test skip.Tim Graham
2021-12-10Fixed DatabaseFeatures.requires_literal_defaults on SQLite.Mariusz Felisiak
This flag is currently unused on SQLite because it doesn't support dropping a DEFAULT clause, however it requires literal defaults, rather than parameterized ones, so we can set it for clarity.
2021-12-07Fixed #31765 -- Enforced enhanced ALTER TABLE behavior for SQLite connections.Adam Johnson
2021-11-25Removed unneeded can_use_chunked_reads feature flag on SQLite.Mariusz Felisiak
Unneeded since c0e3c65b9d1b26cfc38137b7666ef0e108aab77f.
2021-11-02Fixed #33224 -- Removed ↵Hasan Ramezani
DatabaseFeatures.supports_mixed_date_datetime_comparisons.
2021-10-28Fixed #33228 -- Changed value of ↵Chinmoy
BaseDatabaseFeatures.has_case_insensitive_like to False.
2021-04-12Fixed #32416 -- Made ThreadedWSGIServer close connections after each thread.Chris Jerdonek
ThreadedWSGIServer is used by LiveServerTestCase.
2021-04-07Fixed #32501 -- Added support for returning fields from INSERT statements on ↵girishsontakke
SQLite 3.35+.
2021-03-29Fixed #31487 -- Added precision argument to Round().Nick Pope
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