summaryrefslogtreecommitdiff
path: root/tests/expressions_window/models.py
Commit message (Collapse)AuthorAgeFilesLines
* Refs #28333 -- Added partial support for filtering against window functions.Simon Charette2022-08-151-0/+7
| | | | | | | | | | | | | | | | | | | | Adds support for joint predicates against window annotations through subquery wrapping while maintaining errors for disjointed filter attempts. The "qualify" wording was used to refer to predicates against window annotations as it's the name of a specialized Snowflake extension to SQL that is to window functions what HAVING is to aggregates. While not complete the implementation should cover most of the common use cases for filtering against window functions without requiring the complex subquery pushdown and predicate re-aliasing machinery to deal with disjointed predicates against columns, aggregates, and window functions. A complete disjointed filtering implementation should likely be deferred until proper QUALIFY support lands or the ORM gains a proper subquery pushdown interface.
* Refs #33476 -- Reformatted code with Black.django-bot2022-02-071-2/+4
|
* Refs #32096 -- Added test for window expressions with JSONField key transforms.Mariusz Felisiak2020-10-141-0/+7
|
* Fixed #31723 -- Fixed window functions crash with DecimalField on SQLite.Hasan Ramezani2020-09-231-0/+1
| | | | Thanks Simon Charette for the initial patch.
* Removed unused __str__() methods in tests models.Mariusz Felisiak2020-04-301-3/+0
| | | Follow up to 6461583b6cc257d25880ef9a9fd7e2125ac53ce1.
* Refs #29095 -- Added test for using QuerySet.count() with window expressions ↵Christopher G Johnson2020-01-211-0/+5
| | | | | | ordered by related fields. Fixed in 3f32154f40a855afa063095e3d091ce6be21f2c5.
* Refs #29548 -- Fixed failing window tests on MariaDB 10.3.Tom Forbes2018-07-301-0/+1
|
* Fixed #26608 -- Added support for window expressions (OVER clause).Mads Jensen2017-09-181-0/+11
Thanks Josh Smeaton, Mariusz Felisiak, Sergey Fedoseev, Simon Charettes, Adam Chainz/Johnson and Tim Graham for comments and reviews and Jamie Cockburn for initial patch.