summaryrefslogtreecommitdiff
path: root/django/db/backends/oracle/features.py
Commit message (Collapse)AuthorAgeFilesLines
* Fixed #470 -- Added support for database defaults on fields.Ian Foote2023-05-121-0/+4
| | | | | | | | Special thanks to Hannes Ljungberg for finding multiple implementation gaps. Thanks also to Simon Charette, Adam Johnson, and Mariusz Felisiak for reviews.
* Fixed #16055 -- Fixed crash when filtering against char/text GenericRelation ↵David Wobrock2023-04-181-0/+3
| | | | relation on PostgreSQL.
* Fixed #34176 -- Fixed grouping by ambiguous aliases.Simon Charette2023-01-091-1/+1
| | | | | | | | | | | | | | | Regression in b7b28c7c189615543218e81319473888bc46d831. Refs #31377. Thanks Shai Berger for the report and reviews. test_aggregation_subquery_annotation_values_collision() has been updated as queries that are explicitly grouped by a subquery should always be grouped by it and not its outer columns even if its alias collides with referenced table columns. This was not possible to accomplish at the time 10866a10 landed because we didn't have compiler level handling of colliding aliases.
* Fixed #18468 -- Added support for comments on columns and tables.kimsoungryoul2022-12-281-0/+1
| | | | | | | | Thanks Jared Chung, Tom Carrick, David Smith, Nick Pope, and Mariusz Felisiak for reviews. Co-authored-by: Mariusz Felisiak <felisiak.mariusz@gmail.com> Co-authored-by: Nick Pope <nick@nickpope.me.uk>
* Refs #33308 -- Enabled explicit GROUP BY and ORDER BY aliases.Simon Charette2022-10-061-0/+1
| | | | | | | This ensures explicit grouping from using values() before annotating an aggregate function groups by selected aliases if supported. The GROUP BY feature is disabled on Oracle because it doesn't support it.
* Fixed #33768 -- Fixed ordering compound queries by nulls_first/nulls_last on ↵Simon Charette2022-10-051-0/+1
| | | | | | | | | | | MySQL. Columns of the left outer most select statement in a combined query can be referenced by alias just like by index. This removes combined query ordering by column index and avoids an unnecessary usage of RawSQL which causes issues for backends that specialize the treatment of null ordering.
* Fixed #33996 -- Fixed CheckConstraint validation on NULL values.David Sanders2022-09-131-0/+1
| | | | | | Bug in 667105877e6723c6985399803a364848891513cc. Thanks James Beith for the report.
* Refs #32786 -- Made query clear ordering when ordered combined queryset is ↵Mariusz Felisiak2022-06-271-5/+0
| | | | used in subquery on Oracle.
* Fixed #33796 -- Fixed ordered combined queryset crash when used in subquery ↵Mariusz Felisiak2022-06-271-0/+5
| | | | | | | | on PostgreSQL and MySQL. Thanks Shai Berger for the report. Regression in 30a01441347d5a2146af2944b29778fa0834d4be.
* Fixed #32234 -- Made inspectdb inform about composite primary keys.Anv3sh2022-06-011-0/+7
|
* Refs #27064 -- Added RenameIndex migration operation.David Wobrock2022-05-121-0/+1
|
* Fixed #33413 -- Made migrations propage collations to related fields.David Wobrock2022-05-021-0/+4
|
* Refs #33517 -- Prevented __second lookup from returning fractional seconds ↵nabil-rady2022-02-221-0/+6
| | | | on PostgreSQL.
* Fixed #33379 -- Added minimum database version checks.Hasan Ramezani2022-02-181-0/+1
| | | | Thanks Tim Graham for the review.
* Refs #33476 -- Refactored code to strictly match 88 characters line length.Mariusz Felisiak2022-02-071-5/+10
|
* Refs #33476 -- Reformatted code with Black.django-bot2022-02-071-22/+22
|
* Refs #33355 -- Added missing tests for database functions and expression on ↵Adam Johnson2021-12-221-0/+1
| | | | null values.
* Refs #33355 -- Fixed Trunc() with years < 1000 on SQLite.Adam Johnson2021-12-131-0/+5
| | | | | | Thanks to Nick Pope for spotting the bug in Code Review. Co-Authored-By: Nick Pope <nick@nickpope.me.uk>
* Removed unneeded supports_combined_alters feature flag on Oracle.Mariusz Felisiak2021-11-241-1/+0
| | | supports_combined_alters is False by default.
* Fixed #33228 -- Changed value of ↵Chinmoy2021-10-281-1/+0
| | | | BaseDatabaseFeatures.has_case_insensitive_like to False.
* Refs #10929 -- Allowed NowUTC SQL customization for third-party backends.Tim Graham2021-08-241-0/+1
|
* Fixed #32786 -- Moved subquery ordering clearing optimization to the _in lookup.Hannes Ljungberg2021-06-301-0/+1
| | | | Co-Authored-By: Simon Charette <charette.s@gmail.com>
* Fixed #32722 -- Fixed comparing to TruncTime() on Oracle.Mariusz Felisiak2021-05-111-4/+0
|
* Fixed #32699 -- Fixed comparing to TruncTime() with 0 microseconds on MySQL.Alex Hill2021-05-071-0/+4
|
* Refs #32673 -- Fixed lookups crash when comparing against lookups on Oracle.Mariusz Felisiak2021-04-231-4/+0
| | | Follow up to 170b006ce82b0ecf26dc088f832538b747ca0115.
* Fixed #32673 -- Fixed lookups crash when comparing against lookups on ↵Simon Charette2021-04-231-0/+4
| | | | | | | | | | | 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.
* Fixed #32390 -- Dropped support for Oracle 12.2 and 18c.Mariusz Felisiak2021-02-031-6/+1
|
* Refs #26167 -- Changed default value of ↵Hannes Ljungberg2021-01-141-1/+0
| | | | DatabaseFeatures.supports_expression_indexes to True.
* Fixed #26167 -- Added support for functional indexes.Hannes Ljungberg2021-01-131-0/+1
| | | | | | Thanks Simon Charette, Mads Jensen, and Mariusz Felisiak for reviews. Co-authored-by: Markus Holtermann <info@markusholtermann.eu>
* Fixed #32178 -- Allowed database backends to skip tests and mark expected ↵Hasan Ramezani2020-12-101-0/+22
| | | | | failures. Co-authored-by: Tim Graham <timograham@gmail.com>
* Fixed #32179 -- Added JSONObject database function.Artur Beltsov2020-12-021-0/+5
|
* Replaced @no_oracle skips with DatabaseFeatures.allows_group_by_lob.Tim Graham2020-10-221-0/+3
|
* Fixed #31777 -- Added support for database collations to Char/TextFields.Tom Carrick2020-09-211-1/+14
| | | | Thanks Simon Charette and Mariusz Felisiak for reviews.
* Fixed #21181 -- Added Collate database function.Tom Carrick2020-08-111-0/+5
| | | | Thanks Simon Charette for reviews.
* Fixed #31836 -- Dropped support for JSONField __contains and __contained_by ↵Mariusz Felisiak2020-07-281-0/+1
| | | | | | | | | | 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".
* Refs #31630 -- Removed DatabaseFeatures.can_introspect_autofield.Tim Graham2020-06-041-1/+0
|
* Fixed #31630 -- Replaced introspection features with ↵Hasan Ramezani2020-06-041-1/+13
| | | | DatabaseFeatures.introspected_field_types.
* Fixed #12990, Refs #27694 -- Added JSONField model field.sage2020-05-081-0/+1
| | | | | | | | | | | 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>
* Fixed #20581 -- Added support for deferrable unique constraints.Ian Foote2020-04-301-0/+1
|
* Simplified imports from django.db and django.contrib.gis.db.Nick Pope2020-02-041-1/+1
|
* Refs #29444 -- Removed redundant ↵Mariusz Felisiak2019-09-241-1/+0
| | | | | | DatabaseFeatures.can_return_multiple_columns_from_insert. Unnecessary since b31e63879eb5d9717e9f890401f7222e4f00c910.
* Fixed #29444 -- Allowed returning multiple fields from INSERT statements on ↵Johannes Hoppe2019-09-241-0/+1
| | | | Oracle.
* Refs #25367 -- Moved Oracle Exists() handling to contextual methods.Simon Charette2019-08-131-0/+1
| | | | | | | | | | | | | Oracle requires the EXISTS expression to be wrapped in a CASE WHEN in the following cases. 1. When part of a SELECT clause. 2. When part of a ORDER BY clause. 3. When compared against another expression in the WHERE clause. This commit moves the systematic CASE WHEN wrapping of Exists.as_oracle to contextual .select_format, Lookup.as_oracle, and OrderBy.as_oracle methods in order to avoid unnecessary wrapping.
* Refs #30172 -- Prevented removing a field's check or unique constraint from ↵Paveł Tyślacki2019-03-171-0/+1
| | | | removing Meta constraints.
* Refs #26608 -- Added a database feature for fixed frame range distance support.Simon Charette2019-02-091-0/+1
|
* Fixed #30157 -- Dropped support for Oracle 12.1.Mariusz Felisiak2019-02-061-13/+1
| | | Thanks Tim Graham for the review.
* Refs #29444 -- Renamed DatabaseFeatures.can_return_id* to be generic for ↵Johannes Hoppe2019-01-301-1/+1
| | | | other columns.
* Refs #28670 -- Fixed DatabaseFeatures.supports_slicing_ordering_in_compound ↵Mariusz Felisiak2018-12-101-0/+4
| | | | on Oracle.
* Refs #29722 -- Added introspection of materialized views for Oracle.Mariusz Felisiak2018-11-261-0/+1
| | | Thanks Tim Graham for the review.
* Fixed #29949 -- Refactored db introspection identifier converters.Mariusz Felisiak2018-11-211-1/+0
| | | | | | | | | Removed DatabaseIntrospection.table_name_converter()/column_name_converter() and use instead DatabaseIntrospection.identifier_converter(). Removed DatabaseFeatures.uppercases_column_names. Thanks Tim Graham for the initial patch and review and Simon Charette for the review.