diff options
Diffstat (limited to 'tests')
| -rw-r--r-- | tests/expressions_window/tests.py | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/tests/expressions_window/tests.py b/tests/expressions_window/tests.py index 027fc9c25c..3a02a36707 100644 --- a/tests/expressions_window/tests.py +++ b/tests/expressions_window/tests.py @@ -1587,6 +1587,25 @@ class WindowUnsupportedTests(TestCase): dense_rank=Window(expression=DenseRank()) ).get() + def test_filter_subquery(self): + qs = Employee.objects.annotate( + department_salary_rank=Window( + Rank(), partition_by="department", order_by="-salary" + ) + ) + msg = ( + "Referencing outer query window expression is not supported: " + "department_salary_rank." + ) + with self.assertRaisesMessage(NotSupportedError, msg): + qs.annotate( + employee_name=Subquery( + Employee.objects.filter( + age=OuterRef("department_salary_rank") + ).values("name")[:1] + ) + ) + class NonQueryWindowTests(SimpleTestCase): def test_window_repr(self): |