diff options
author | Tomáš Ehrlich <tomas.ehrlich@gmail.com> | 2018-03-01 08:55:05 +0100 |
---|---|---|
committer | Tim Graham <timograham@gmail.com> | 2018-03-01 10:24:14 -0500 |
commit | fa352626c2a80bcdcd0fc6492b5fd5130490f05e (patch) | |
tree | 52004cfda1e319a800b4550cc3296ad683b0bec4 /tests/expressions_window | |
parent | ba4a9862407c8e8574c60b9f911f6b09aff1fa12 (diff) | |
download | django-fa352626c2a80bcdcd0fc6492b5fd5130490f05e.tar.gz |
Fixed #29172 -- Fixed crash with Window expression in a subquery.
Diffstat (limited to 'tests/expressions_window')
-rw-r--r-- | tests/expressions_window/tests.py | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/tests/expressions_window/tests.py b/tests/expressions_window/tests.py index e61516b4b6..7ade53f429 100644 --- a/tests/expressions_window/tests.py +++ b/tests/expressions_window/tests.py @@ -650,6 +650,19 @@ class WindowFunctionTests(TestCase): salary=Window(expression=Sum(Value(10000), order_by=F('pk').asc())), ) + def test_window_expression_within_subquery(self): + subquery_qs = Employee.objects.annotate( + highest=Window(FirstValue('id'), partition_by=F('department'), order_by=F('salary').desc()) + ).values('highest') + highest_salary = Employee.objects.filter(pk__in=subquery_qs) + self.assertSequenceEqual(highest_salary.values('department', 'salary'), [ + {'department': 'Accounting', 'salary': 50000}, + {'department': 'Sales', 'salary': 55000}, + {'department': 'Marketing', 'salary': 40000}, + {'department': 'IT', 'salary': 60000}, + {'department': 'Management', 'salary': 100000} + ]) + def test_invalid_start_value_range(self): msg = "start argument must be a negative integer, zero, or None, but got '3'." with self.assertRaisesMessage(ValueError, msg): |