summaryrefslogtreecommitdiff
path: root/tests/postgres_tests
AgeCommit message (Collapse)Author
2021-09-17Fixed #32492 -- Added TrigramWordSimilarity() and TrigramWordDistance() on ↵Nikita Marchant
PostgreSQL.
2021-07-26Fixed #32906 -- Added docs and tests for using key and index lookups on ↵abhiabhi94
JSONBAgg results. Co-authored-by: Mariusz Felisiak <felisiak.mariusz@gmail.com>
2021-07-19Refs #10929 -- Deprecated forced empty result value for PostgreSQL aggregates.Nick Pope
This deprecates forcing a return value for ArrayAgg, JSONBAgg, and StringAgg when there are no rows in the query. Now that we have a ``default`` argument for aggregates, we want to revert to returning the default of ``None`` which most aggregate functions return and leave it up to the user to decide what they want to be returned by default.
2021-07-19Fixed #10929 -- Added default argument to aggregates.Nick Pope
Thanks to Simon Charette and Adam Johnson for the reviews.
2021-07-06Fixed #32776 -- Added support for Array subqueries on PostgreSQL.Hannes Ljungberg
2021-06-30Fixed #32786 -- Moved subquery ordering clearing optimization to the _in lookup.Hannes Ljungberg
Co-Authored-By: Simon Charette <charette.s@gmail.com>
2021-06-29Refs #26430 -- Added tests for PostgreSQL-specific aggregates on ↵Mariusz Felisiak
EmptyQuerySets and used subTest().
2021-06-28Removed unnecessary json.loads() call in test_json_agg_empty().Nick Pope
2021-06-28Ensured that empty result test for JSONBAgg executes a query.Nick Pope
Use of QuerySet.none() will cause the EmptyQuerySet aggregation optimisation to be used. Change the test to be implemented like the other tests for empty results in this file.
2021-06-28Corrected test method and variable names for JSONBAgg.Nick Pope
This is probably a hangover from when the aggregate function was originally called JSONAgg during development.
2021-06-22Refs #32858, Refs #32392 -- Restored using :: shortcut syntax in Cast() on ↵Mariusz Felisiak
PostgreSQL. This partly reverts commit fdfbc66331292def201c9344e3cd29fbcbcd076a unnecessary since b69b0c3fe871167a0ca01bb439508e335143801f.
2021-06-22Fixed #32858 -- Fixed ExclusionConstraint crash with index transforms in ↵Lucidiot
expressions.
2021-06-08Fixed #31653 -- Added AddConstraintNotValid()/ValidateConstraint() ↵Sanskar Jaiswal
operations for PostgreSQL.
2021-05-24Refs #24121 -- Improved Value.__repr__().Mariusz Felisiak
2021-02-23Fixed #30916 -- Added support for functional unique constraints.Hannes Ljungberg
Thanks Ian Foote and Mariusz Felisiak for reviews.
2021-02-19Fixed #32458 -- Made __repr__() for Index and BaseConstraint subclasses more ↵Hannes Ljungberg
consistent.
2021-01-29Fixed #32392 -- Fixed ExclusionConstraint crash with Cast() in expressions.Tilman Koschnick
2021-01-19Fixed #32357 -- Dropped support for PostgreSQL 9.6 and PostGIS 2.3.Mariusz Felisiak
2021-01-14Refs #12990 -- Removed django.contrib.postgres.forms.JSONField per ↵Mariusz Felisiak
deprecation timeline.
2021-01-14Refs #12990 -- Removed ↵Mariusz Felisiak
django.contrib.postgres.fields.jsonb.KeyTransform/KeyTextTransform. Per deprecation timeline.
2021-01-14Refs #12990 -- Removed django.contrib.postgres.fields.JSONField per ↵Mariusz Felisiak
deprecation timeline.
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-03Refs #27095 -- Fixed test_contained_by_including_F_object when run in reverse.Mariusz Felisiak
Tests should not rely on auto PKs. Test regression in 33403bf80f635577a18426bc99c8a65e31fd8dfa.
2020-11-27Fixed #25534, Fixed #31639 -- Added support for transform references in ↵Ian Foote
expressions. Thanks Mariusz Felisiak and Simon Charette for reviews.
2020-11-26Refs #27095 -- Allowed (non-nested) arrays containing expressions for ↵Hannes Ljungberg
ArrayField lookups.
2020-11-26Added test for ArrayField's __contains lookup with subqueries.Hannes Ljungberg
2020-11-04Fixed #32169 -- Added distinct support to JSONBAgg.Artur Beltsov
2020-10-21Fixed #32046 -- Added CreateCollation/RemoveCollation operations for PostgreSQL.Tom Carrick
2020-10-14Refs #32096 -- Fixed ExclusionConstraint crash with JSONField key transforms ↵Mariusz Felisiak
in expressions. Regression in 6789ded0a6ab797f0dcdfa6ad5d1cfa46e23abcd.
2020-10-14Refs #32096 -- Fixed crash of ArrayAgg/StringAgg/JSONBAgg with ordering over ↵Mariusz Felisiak
JSONField key transforms. Regression in 6789ded0a6ab797f0dcdfa6ad5d1cfa46e23abcd. Thanks Igor Jerosimić for the report.
2020-10-14Refs #32096 -- Added test for ArrayAgg over JSONField key transforms.Mariusz Felisiak
2020-08-19Fixed #31902 -- Fixed crash of ExclusionConstraint on expressions with params.Maxim Petrov
2020-07-31Refs #27996 -- Fixed postgres_tests crash if not running with PostgreSQL.Mariusz Felisiak
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-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-21Refs #31720 -- Defined default output_field of BoolAnd() and BoolOr() ↵David Chorpash
aggregate functions.
2020-07-15Refs #30446 -- Removed unnecessary Value(..., output_field) in docs and tests.Simon Charette
2020-06-24Defined output_field of Func() in ↵Simon Charette
test_grouping_by_annotations_with_array_field_param(). output_field cannot be automatically determined because the first argument passed to ARRAY_LEN is an ArrayField and the second one is an integer.
2020-06-16Fixed #31709 -- Added support for opclasses in ExclusionConstraint.Hannes Ljungberg
2020-06-16Fixed #31702 -- Added support for PostgreSQL opclasses in UniqueConstraint.Hannes Ljungberg
2020-06-13Fixed #31691 -- Added ordering support to JSONBAgg.John Parton
2020-06-12Fixed #31649 -- Added support for covering exclusion constraints on ↵Hannes Ljungberg
PostgreSQL 12+.
2020-06-04Fixed #30913 -- Added support for covering indexes on PostgreSQL 11+.Hannes Ljungberg
2020-06-03Refs #31615 -- Added EXISTS clauses to extension operations.Adam Johnson
2020-05-28Fixed #31468 -- Allowed specifying migration filename in Operation.Adam Johnson
This adds also suggested filename for many built-in operations.
2020-05-27Fixed #31615 -- Made migrations skip extension operations if not needed.Frantisek Holop
- Don't try to create an existing extension. - Don't try to drop a nonexistent extension.
2020-05-27Used not installed extension in CreateExtension() tests.Frantisek Holop
uuid-ossp was already installed.
2020-05-19Fixed #31601 -- Fixed SearchHeadlineTests on PostgresSQL 9.6.18+, 10.13+, ↵Hannes Ljungberg
11.8+, and 12.3+.
2020-05-14Fixed #31579 -- Dropped support for PostgreSQL 9.5 and PostGIS 2.2.Mariusz Felisiak
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>
generated by cgit v1.3 (git 2.53.0) at 2026-07-04 12:36:35 +0000