Commit message (Collapse) | Author | Age | Files | Lines | |
---|---|---|---|---|---|
* | Fixed #34368 -- Made subquery raise NotSupportedError when referencing outer ↵ | Simon Charette | 2023-02-27 | 1 | -0/+19 |
| | | | | | | | | window expression. Regression in f387d024fc75569d2a4a338bfda76cc2f328f627. Co-authored-by: Jannis Vajen <jvajen@gmail.com> | ||||
* | Refs #28477 -- Reduced complexity of aggregation over qualify queries. | Simon Charette | 2022-11-11 | 1 | -8/+14 |
| | |||||
* | Refs #33990 -- Renamed TransactionTestCase.assertQuerysetEqual() to ↵ | Gregor Gärtner | 2022-10-08 | 1 | -36/+36 |
| | | | | | | assertQuerySetEqual(). Co-Authored-By: Michael Howitz <mh@gocept.com> | ||||
* | Refs #28333 -- Fixed NonQueryWindowTests.test_invalid_filter() on databases ↵ | Mariusz Felisiak | 2022-08-29 | 1 | -14/+14 |
| | | | | that don't support window expressions. | ||||
* | Refs #28333 -- Added partial support for filtering against window functions. | Simon Charette | 2022-08-15 | 2 | -30/+287 |
| | | | | | | | | | | | | | | | | | | | | 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 -- Refactored code to strictly match 88 characters line length. | Mariusz Felisiak | 2022-02-07 | 1 | -1/+2 |
| | |||||
* | Refs #33476 -- Reformatted code with Black. | django-bot | 2022-02-07 | 2 | -661/+1097 |
| | |||||
* | Fixed #33304 -- Allowed passing string expressions to Window(order_by). | Simon Charette | 2021-11-23 | 1 | -4/+8 |
| | |||||
* | Fixed #32178 -- Allowed database backends to skip tests and mark expected ↵ | Hasan Ramezani | 2020-12-10 | 1 | -6/+1 |
| | | | | | failures. Co-authored-by: Tim Graham <timograham@gmail.com> | ||||
* | Fixed #25534, Fixed #31639 -- Added support for transform references in ↵ | Ian Foote | 2020-11-27 | 1 | -40/+57 |
| | | | | | | expressions. Thanks Mariusz Felisiak and Simon Charette for reviews. | ||||
* | Refs #32096 -- Added test for window expressions with JSONField key transforms. | Mariusz Felisiak | 2020-10-14 | 2 | -4/+42 |
| | |||||
* | Fixed #31723 -- Fixed window functions crash with DecimalField on SQLite. | Hasan Ramezani | 2020-09-23 | 2 | -1/+31 |
| | | | | Thanks Simon Charette for the initial patch. | ||||
* | Removed unused __str__() methods in tests models. | Mariusz Felisiak | 2020-04-30 | 1 | -3/+0 |
| | | | Follow up to 6461583b6cc257d25880ef9a9fd7e2125ac53ce1. | ||||
* | Simplified imports from django.db and django.contrib.gis.db. | Nick Pope | 2020-02-04 | 1 | -3/+2 |
| | |||||
* | Refs #29095 -- Added test for using QuerySet.count() with window expressions ↵ | Christopher G Johnson | 2020-01-21 | 2 | -0/+13 |
| | | | | | | ordered by related fields. Fixed in 3f32154f40a855afa063095e3d091ce6be21f2c5. | ||||
* | Fixed #31183 -- Added a feature flag for "<db> only supports UNBOUNDED ↵ | Tim Graham | 2020-01-20 | 1 | -7/+7 |
| | | | | together with PRECEDING and FOLLOWING". | ||||
* | Fixed #31060 -- Reallowed window expressions to be used in conditions ↵ | Alex Aktsipetrov | 2019-12-06 | 1 | -2/+18 |
| | | | | | | | | outside of queryset filters. Regression in 4edad1ddf6203326e0be4bdb105beecb0fe454c4. Thanks utapyngo for the report. | ||||
* | Relaxed some query ordering assertions in tests. | Tim Graham | 2019-11-18 | 1 | -1/+1 |
| | | | It accounts for differences seen on cockroachdb. | ||||
* | Fixed #30668 -- Made QuerySet.filter() raise NotSupportedError if any of ↵ | aaktsipetrov | 2019-08-02 | 1 | -2/+12 |
| | | | | source expressions is not filterable. | ||||
* | Fixed NonQueryWindowTests.test_unsupported_backend() on MySQL. | Mariusz Felisiak | 2019-05-03 | 1 | -6/+8 |
| | |||||
* | Fixed #29619 -- Added field names to some FieldErrors. | Hasan Ramezani | 2019-02-14 | 1 | -2/+10 |
| | |||||
* | Refs #26608 -- Added a database feature for fixed frame range distance support. | Simon Charette | 2019-02-09 | 1 | -2/+1 |
| | |||||
* | Fixed #30027 -- Errored out on Window function usage if unsupported. | Simon Charette | 2019-02-09 | 1 | -1/+7 |
| | |||||
* | Refs #30027 -- Enabled window function tests on SQLite 3.25+. | Simon Charette | 2019-02-09 | 1 | -0/+5 |
| | |||||
* | Refs #29851 -- Fixed test_subquery_row_range_rank() crash on MariaDB 10.2+. | Mariusz Felisiak | 2019-01-03 | 1 | -9/+9 |
| | | | Thanks Tom Forbes for the report. | ||||
* | Fixed #29851 -- Fixed crash of annotations with window expressions in Subquery. | Mariusz Felisiak | 2018-12-27 | 1 | -1/+30 |
| | |||||
* | Fixed #29847 -- Ensured proper ordering in queries. | Florian Apolloner | 2018-10-21 | 1 | -14/+4 |
| | | | | | | | | | Even though good databases tend to keep the result sorted by the/one window expression and the planners are smart enough to not resort if not required, it is not valid to rely on this. MariaDB specifically did return whatever order it wanted, which is completely okay. Now we sort towards the expected data for all databases. | ||||
* | Refs #29548 -- Fixed failing window tests on MariaDB 10.3. | Tom Forbes | 2018-07-30 | 2 | -27/+40 |
| | |||||
* | Fixed #29172 -- Fixed crash with Window expression in a subquery. | Tomáš Ehrlich | 2018-03-01 | 1 | -0/+13 |
| | |||||
* | Fixed #26608 -- Added support for window expressions (OVER clause). | Mads Jensen | 2017-09-18 | 3 | -0/+794 |
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. |