summaryrefslogtreecommitdiff
path: root/django/db/backends
AgeCommit message (Collapse)Author
2021-03-30[3.2.x] Fixed #32595 -- Fixed SchemaEditor.quote_value() crash with bytes.Mariusz Felisiak
Backport of f6018c1e63a04e0c12e2ca759e76e05ccf5e09de from main
2021-02-17[3.2.x] Fixed #32453 -- Added introspection of unique constraint field ↵Hannes Ljungberg
ordering on SQLite. Co-authored-by: Mariusz Felisiak <felisiak.mariusz@gmail.com> Backport of 4d99375b46ad03fa4b4795319973046f438328c8 from master
2021-02-09[3.2.x] Fixed #32425 -- Fixed adding nullable field with default on MySQL.Jordan Bae
Thanks Simon Charette for the review. Backport of d4ac23bee1c84d8e4610350202ac068fc90f38c0 from master
2021-02-02[3.2.x] Fixed #32403 -- Fixed re-raising DatabaseErrors when using only ↵Mariusz Felisiak
'postgres' database. Thanks Kazantcev Andrey for the report. Regression in f48f671223a20b161ca819cf7d6298e43b8ba5fe. Backport of f131841c601b9d4884adcdb284b4213c2ad89231 from master
2021-01-26[3.2.x] Fixed #32369 -- Fixed adding check constraints with pattern lookups ↵Simon Charette
and expressions as rhs. This disables interpolation of constraint creation statements. Since Constraint.create_sql interpolates its parameters instead of deferring this responsibility to the backend connection it must disable connection level parameters interpolation. Backport of 42e8cf47c7ee2db238bf91197ea398126c546741 from master
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>
2021-01-11Fixed #32342 -- Added index order introspection on MySQL 8.0.1+.Mariusz Felisiak
2020-12-30Fixed #32303 -- Bumped minimum supported SQLite to 3.9.0.Mariusz Felisiak
2020-12-28Fixed #32158 -- Fixed loaddata crash on SQLite when table/column names are ↵Chinmoy Chakraborty
SQL keywords.
2020-12-23Refs #26167 -- Made DatabaseSchemaEditor._create_index_sql()'s fields ↵Hannes Ljungberg
argument optional and kwarg-only.
2020-12-11Refs #32178 -- Changed BaseDatabaseFeatures.django_test_expected_failures to ↵Hasan Ramezani
set().
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-11-19Fixed #32201 -- Removed obsolete isort:skip's.Seamus Quinn
Obsolete as of isort 5.
2020-11-11Fixed #31762 -- Made reloading the database for tests use the base manager.Hasan Ramezani
Co-authored-by: Eugene Kulak <kulak.eugene@gmail.com>
2020-10-30Refs #32061 -- Prevented password leak on MySQL dbshell crash.Simon Charette
The usage of the --password flag when invoking the mysql CLI has the potential of exposing the password in plain text if the command happens to crash due to the inclusion of args provided to subprocess.run(check=True) in the string representation of the subprocess.CalledProcessError exception raised on non-zero return code. Since this has the potential of leaking the password to logging facilities configured to capture crashes (e.g. sys.excepthook, Sentry) it's safer to rely on the MYSQL_PWD environment variable instead even if its usage is discouraged due to potential leak through the ps command on old flavors of Unix. Thanks Charlie Denton for reporting the issue to the security team. Refs #24999.
2020-10-29Refs #32061 -- Unified DatabaseClient.runshell() in db backends.Simon Charette
2020-10-22Replaced @no_oracle skips with DatabaseFeatures.allows_group_by_lob.Tim Graham
2020-10-21Fixed #32046 -- Added CreateCollation/RemoveCollation operations for PostgreSQL.Tom Carrick
2020-10-20Fixed #32120 -- Added DatabaseFeatures.indexes_foreign_keys.Tim Graham
2020-10-19Fixed #32108 -- Made transaction.on_commit() raise TypeError when callback ↵Herbert Poul
is not a callable.
2020-10-17Fixed #6517 -- Made dbshell use charset option on MySQL.manav014
Co-Authored-By: Mariusz Felisiak <felisiak.mariusz@gmail.com>
2020-10-15Fixed #25253 -- Made AlterField operation a noop when changing attributes ↵Çağıl Uluşahin
that don't affect the schema.
2020-10-14Fixed #31640 -- Made Trunc() truncate datetimes to Date/TimeField in a ↵David-Wobrock
specific timezone.
2020-10-06Fixed #32073 -- Skipped collation tests on PostgreSQL < 10.Mariusz Felisiak
PostgreSQL < 10 doesn't support ICU collations. Thanks Hannes Ljungberg for the report.
2020-10-02Fixed #32060 -- Added Random database function.Nick Pope
2020-09-23Fixed #32012 -- Made test database creation sync apps models when migrations ↵Mariusz Felisiak
are disabled. Thanks Jaap Roes 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-09-18Refs #21181 -- Corrected DatabaseFeatures.test_collations for Swedish collation.Tom Carrick
Previously, backends used different keys "swedish-ci" or "swedish_ci".
2020-09-15Added DatabaseIntrospection.index_default_access_method hook on the ↵Tim Graham
PostgreSQL backend. This hook is for the CockroachDB backend where the name is 'prefix'.
2020-09-09Fixed #31987 -- Fixed Cast() with DurationField on MySQL.Petr Čermák
2020-09-04Fixed #27417 -- Made RenameField operation a noop for field name case ↵Mariusz Felisiak
changes on Oracle. Field names are always uppercased in the Oracle backend. Changing case should be a noop to avoid database errors: "ORA-00957: duplicate column name".
2020-08-31Fixed #31965 -- Adjusted multi-table fast-deletion on MySQL/MariaDB.Simon Charette
The optimization introduced in 7acef095d73 did not properly handle deletion involving filters against aggregate annotations. It initially was surfaced by a MariaDB test failure but misattributed to an undocumented change in behavior that resulted in the systemic generation of poorly performing database queries in 5b83bae031. Thanks Anton Plotkin for the report. Refs #23576.
2020-08-28Fixed #31956 -- Fixed crash of ordering by JSONField with a custom decoder ↵Mariusz Felisiak
on PostgreSQL. Thanks Marc Debureaux for the report. Thanks Simon Charette, Nick Pope, and Adam Johnson for reviews.
2020-08-24Fixed #24533 -- Dropped PostgreSQL sequence and Oracle identity when ↵Tim Graham
migrating away from AutoField.
2020-08-14Fixed #31826 -- Made AlterField operation a noop when adding db_column.Iuri de Silvio
AlterField operation with adding a db_column is a noop if the column name is not changed.
2020-08-13Fixed #31825 -- Made RenameField operation a noop for fields with db_column.Iuri de Silvio
2020-08-11Fixed #21181 -- Added Collate database function.Tom Carrick
Thanks Simon Charette for reviews.
2020-07-30Bumped minimum isort version to 5.1.0.David Smith
Fixed inner imports per isort 5. isort 5.0.0 to 5.1.0 was unstable.
2020-07-30Refs #31829 -- Added ↵Tim Graham
DatabaseFeatures.json_key_contains_list_matching_requires_list. CockroachDB's behavior matches PostgreSQL.
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-28Refs #27996 -- Doc'd no extension required for RandomUUID() on PostgreSQL 13+.Nick Pope
https://www.postgresql.org/docs/13/functions-uuid.html https://www.postgresql.org/docs/13/pgcrypto.html#id-1.11.7.34.10.5
2020-07-27Fixed #31815 -- Fixed schema value encoding on PostgreSQL.Mariusz Felisiak
2020-07-22Fixed #31765 -- Disabled bundled SQLite renaming atomic references on macOS ↵Tom Forbes
10.15.
2020-07-20Fixed #17653 -- Allowed using zero as AutoFields value on MySQL if ↵Mariusz Felisiak
NO_AUTO_VALUE_ON_ZERO SQL mode is enabled.
2020-07-17Fixed #31731 -- Removed unreachable code for resetting sequences of ↵Ravindar Sharma
auto-created m2m tables in sequence_reset_sql(). Unreachable because f.remote_field.through is truthy for all m2m fields. Resetting sequences of auto-created m2m tables in sequence_reset_sql() is also unnecessary: - in sqlsequencereset since c39ec6dccb389fbb4047e44f5247e18bb76ae598 because auto-created tables are included in model_list, - in loaddata because there is no it need to reset sequences for models not loaded directly. - in create_default_site() because it doesn't have m2m fields.
2020-07-16Stopped adapting DecimalField values to strings on Oracle.Mariusz Felisiak
cx_Oracle handles decimal.Decimal. expressions_case.tests.CaseExpressionTests.test_update_decimal fails without this change. Follow up to 9c5c9bd7091b60fdccc405890dc4f44a8010e954.
2020-07-14Stopped adapting DecimalField values to strings on PostgreSQL.Simon Charette
The psycopg2 backend uses the type information to provide type hints.
generated by cgit v1.3 (git 2.53.0) at 2026-10-11 10:23:28 +0000