| Age | Commit message (Collapse) | Author | |
|---|---|---|---|
| 2021-11-12 | [4.0.x] Fixed #33279 -- Fixed handling time zones with "-" sign in names. | Can Sarigol | |
| Thanks yakimka for the report. Regression in fde9b7d35e4e185903cc14aa587ca870037941b1. Backport of 661316b066923493ff91d6d2aa92e463f595a6b1 from main. | |||
| 2021-10-18 | [4.0.x] Fixed #33194 -- Fixed migrations when altering a field with ↵ | Hannes Ljungberg | |
| functional indexes/unique constraints on SQLite. This adjusts Expressions.rename_table_references() to only update alias when needed. Regression in 83fcfc9ec8610540948815e127101f1206562ead. Co-authored-by: Simon Charette <charettes@users.noreply.github.com> Backport of 86971c40909430a798e4e55b140004c4b1fb02ff from main | |||
| 2021-10-01 | [4.0.x] Fixed #33160 -- Avoided suppressing query errors in _nodb_cursor() ↵ | Daniel Hahler | |
| on PostgreSQL. Backport of 98c8bf1ceeab5c68751c83555f82cff1a9120a67 from main | |||
| 2021-09-16 | Fixed #32365 -- Made zoneinfo the default timezone implementation. | Carlton Gibson | |
| Thanks to Adam Johnson, Aymeric Augustin, David Smith, Mariusz Felisiak, Nick Pope, and Paul Ganssle for reviews. | |||
| 2021-09-01 | Fixed #33080 -- Preserved nullability of textual fields on Oracle. | Mariusz Felisiak | |
| Thanks Matt Hoskins for the report. | |||
| 2021-08-31 | Fixed #33057 -- Fixed recreation of foreign key constraints in m2m tables ↵ | Mariusz Felisiak | |
| when altering type of referenced primary key on Oracle. | |||
| 2021-08-24 | Refs #10929 -- Allowed NowUTC SQL customization for third-party backends. | Tim Graham | |
| 2021-08-20 | Fixed #33017 -- Fixed storage engine introspection on MySQL. | Matjaz Gregoric | |
| This also improves performance on MySQL instances with a large number of databases, since querying the information_schema table can be very slow | |||
| 2021-08-20 | Optimized DatabaseSchemaEditor._field_should_be_indexed() on MySQL. | Matjaz Gregoric | |
| 2021-07-28 | Optimized BaseDatabaseSchemaEditor._effective_default() a bit, | Chris Jerdonek | |
| This eliminates an unneeded call to datetime.now() when field.get_internal_type() equals "DateTimeField". | |||
| 2021-07-27 | Refs #32962 -- Simplified NULL logic in ↵ | Chris Jerdonek | |
| BaseDatabaseSchemaEditor._iter_column_sql(). | |||
| 2021-07-27 | Fixed #32962 -- Consolidated string concatenations in ↵ | Chris Jerdonek | |
| BaseDatabaseSchemaEditor.column_sql(). | |||
| 2021-07-27 | Refs #32956 -- Changed "afterwards" to "afterward" in docs and comments. | David Smith | |
| This also removes unnecessary comments with the previous spelling. AP Stylebook has a short entry to advise the preferred spelling for "en-us". "Afterwards" is preferred in British English. | |||
| 2021-07-27 | Refs #32743 -- Fixed recreation of foreign key constraints when altering ↵ | Jordan Bae | |
| type of referenced primary key with MTI. Follow up to 325d7710ce9f6155bb55610ad6b4580d31263557. | |||
| 2021-07-26 | Fixed #32743 -- Added foreign key altering when altering type of referenced ↵ | David Wobrock | |
| primary key with MTI. | |||
| 2021-07-19 | Fixed #10929 -- Added default argument to aggregates. | Nick Pope | |
| Thanks to Simon Charette and Adam Johnson for the reviews. | |||
| 2021-07-09 | Fixed #27021 -- Allowed lookup expressions in annotations, aggregations, and ↵ | Ian Foote | |
| QuerySet.filter(). Thanks Hannes Ljungberg and Simon Charette for reviews. Co-authored-by: Mariusz Felisiak <felisiak.mariusz@gmail.com> | |||
| 2021-07-08 | Fixed #32908 -- Allowed select_for_update(skip_locked) on MariaDB 10.6+. | Mariusz Felisiak | |
| 2021-07-07 | Fixed inspectdb and schema tests on MariaDB 10.6+. | Mariusz Felisiak | |
| The utf8 character set (and related collations) is by default an alias for utf8mb3 on MariaDB 10.6+. | |||
| 2021-07-05 | Refs #32508 -- Raised ImproperlyConfigured/TypeError instead of using "assert". | Mateo Radman | |
| 2021-07-02 | Fixed #30934 -- Included database alias in django.db.backends log messages. | Nick Pope | |
| This is useful when working with database routing as you want to know where each query is being executed. Co-authored-by: David Winterbottom <david.winterbottom@gmail.com> | |||
| 2021-06-30 | Fixed #32786 -- Moved subquery ordering clearing optimization to the _in lookup. | Hannes Ljungberg | |
| Co-Authored-By: Simon Charette <charette.s@gmail.com> | |||
| 2021-06-10 | Fixed #32832 -- Fixed adding BLOB/TEXT nullable field with default on MySQL ↵ | Mariusz Felisiak | |
| 8.0.13+. Regression in d4ac23bee1c84d8e4610350202ac068fc90f38c0. Thanks Omkar Deshpande for the report. | |||
| 2021-06-01 | Fixed #32793 -- Fixed loss of precision for temporal operations with ↵ | Mariusz Felisiak | |
| DecimalFields on MySQL. Regression in 1e38f1191de21b6e96736f58df57dfb851a28c1f. Thanks Mohsen Tamiz for the report. | |||
| 2021-05-28 | Refs #32779 -- Changed ↵ | Hannes Ljungberg | |
| DatabaseSchemaEditor._unique_sql()/_create_unique_sql() to take fields as second parameter. | |||
| 2021-05-25 | Fixed #32780 -- Made Add/RemoveConstraint operations a noop for ↵ | Hannes Ljungberg | |
| covering/deferrable unique constraints on SQLite. | |||
| 2021-05-24 | Fixed #32777 -- Passed table reference as a string to ↵ | Hannes Ljungberg | |
| DatabaseSchemaEditor._index_columns(). | |||
| 2021-05-21 | Fixed #32503 -- Fixed altering BLOB/TEXT field to non-nullable with default ↵ | Yuekui Li | |
| on MySQL 8.0.13+. MySQL 8.0.13+ supports defaults for BLOB/TEXT but not in the ALTER COLUMN statement. Regression in 6b16c91157512587017e9178d066ed1a683e7795. Thanks Matt Westcott for the report. | |||
| 2021-05-12 | Fixed #32732 -- Removed usage of deprecated 'db' and 'passwd' connection ↵ | Nick Pope | |
| options in MySQL backend. The 'db' and 'passwd' connection options have been deprecated, use 'database' and 'password' instead (available since mysqlclient >= 1.3.8). This also allows the 'database' option in DATABASES['OPTIONS'] on MySQL. | |||
| 2021-05-11 | Fixed #32722 -- Fixed comparing to TruncTime() on Oracle. | Mariusz Felisiak | |
| 2021-05-07 | Fixed #32699 -- Fixed comparing to TruncTime() with 0 microseconds on MySQL. | Alex Hill | |
| 2021-04-30 | Fixed #32653 -- Made quoting names in the Oracle backend consistent with ↵ | Mariusz Felisiak | |
| db_table. | |||
| 2021-04-27 | Fixed #32687 -- Restored passing process’ environment to underlying tool ↵ | Konstantin Alekseev | |
| in dbshell on PostgreSQL. Regression in bbe6fbb8768e8fb1aecb96d51c049d7ceaf802d3. | |||
| 2021-04-27 | Fixed #32686 -- Removed unnecessary semicolon on collected multiline SQL for ↵ | Hannes Ljungberg | |
| RunSQL. | |||
| 2021-04-23 | Refs #32673 -- Fixed lookups crash when comparing against lookups on Oracle. | Mariusz Felisiak | |
| Follow up to 170b006ce82b0ecf26dc088f832538b747ca0115. | |||
| 2021-04-23 | Fixed #32673 -- Fixed lookups crash when comparing against lookups on ↵ | Simon Charette | |
| PostgreSQL. Regression in 3a505c70e7b228bf1212c067a8f38271ca86ce09. Nonlitteral right-hand-sides of lookups need to be wrapped in parentheses to avoid operator precedence ambiguities. Thanks Charles Lirsac for the detailed report. | |||
| 2021-04-20 | Refs #25287 -- Added support for multiplying and dividing DurationField by ↵ | Tobias Bengfort | |
| scalar values on SQLite. | |||
| 2021-04-20 | Refs #25287 -- Added _sqlite_prepare_dtdelta_param() hook. | Tobias Bengfort | |
| 2021-04-14 | Fixed #32645 -- Fixed QuerySet.update() crash when ordered by joined fields ↵ | Mariusz Felisiak | |
| on MySQL/MariaDB. Thanks Matt Westcott for the report. Regression in 779e615e362108862f1681f965ee9e4f1d0ae6d2. | |||
| 2021-04-12 | Fixed #32416 -- Made ThreadedWSGIServer close connections after each thread. | Chris Jerdonek | |
| ThreadedWSGIServer is used by LiveServerTestCase. | |||
| 2021-04-07 | Fixed #32501 -- Added support for returning fields from INSERT statements on ↵ | girishsontakke | |
| SQLite 3.35+. | |||
| 2021-03-30 | Fixed #32595 -- Fixed SchemaEditor.quote_value() crash with bytes. | Mariusz Felisiak | |
| 2021-03-29 | Fixed #31487 -- Added precision argument to Round(). | Nick Pope | |
| 2021-03-25 | Fixed #32582 -- Removed unnecessary dot in names of cloned test databases on ↵ | Girish Sontakke | |
| SQLite. | |||
| 2021-03-23 | Fixed #32573 -- Fixed bounds in __iso_year lookup optimization. | Florian Demmer | |
| 2021-03-23 | Fixed #32483 -- Fixed QuerySet.values()/values_list() on JSONField key ↵ | Mariusz Felisiak | |
| transforms with booleans on SQLite. Thanks Matthew Cornell for the report. | |||
| 2021-03-01 | Fixed #32456 -- Added dbshell support for specifying a password file on ↵ | Hasan Ramezani | |
| PostgreSQL. | |||
| 2021-02-26 | Refs #32292 -- Made dbshell do not use 'postgres' database when service name ↵ | Mariusz Felisiak | |
| is set. Regression in dcb3ad3319cad5c270a1856fd5f355e37cf9d474. | |||
| 2021-02-23 | Fixed #30916 -- Added support for functional unique constraints. | Hannes Ljungberg | |
| Thanks Ian Foote and Mariusz Felisiak for reviews. | |||
| 2021-02-23 | Fixed typo in django/db/backends/sqlite3/base.py comment. | Chris Jerdonek | |
