summaryrefslogtreecommitdiff
path: root/tests/expressions_window
diff options
context:
space:
mode:
authorSimon Charette <charette.s@gmail.com>2019-01-15 21:39:05 -0600
committerTim Graham <timograham@gmail.com>2019-02-09 08:47:40 -0500
commitebd2fe186186800af343f0041a0904381b4dfc44 (patch)
treea44d72b318797fda2f6c00695c2e7297aa244dae /tests/expressions_window
parenteefc9550fd3b8011cc12069eb700df09f25cc4d9 (diff)
downloaddjango-ebd2fe186186800af343f0041a0904381b4dfc44.tar.gz
Refs #30027 -- Enabled window function tests on SQLite 3.25+.
Diffstat (limited to 'tests/expressions_window')
-rw-r--r--tests/expressions_window/tests.py5
1 files changed, 5 insertions, 0 deletions
diff --git a/tests/expressions_window/tests.py b/tests/expressions_window/tests.py
index 21aa2ecbf9..fa9bb2916b 100644
--- a/tests/expressions_window/tests.py
+++ b/tests/expressions_window/tests.py
@@ -537,6 +537,7 @@ class WindowFunctionTests(TestCase):
], transform=lambda row: (row.name, row.salary, row.department, row.hire_date, row.sum))
@skipIf(connection.vendor == 'postgresql', 'n following/preceding not supported by PostgreSQL')
+ @skipIf(connection.vendor == 'sqlite', 'n following/preceding not supported by SQLite')
def test_range_n_preceding_and_following(self):
qs = Employee.objects.annotate(sum=Window(
expression=Sum('salary'),
@@ -584,6 +585,10 @@ class WindowFunctionTests(TestCase):
('Brown', 'Sales', 53000, datetime.date(2009, 9, 1), 148000)
], transform=lambda row: (row.name, row.department, row.salary, row.hire_date, row.sum))
+ @skipIf(
+ connection.vendor == 'sqlite' and connection.Database.sqlite_version_info < (3, 27),
+ 'Nondeterministic failure on SQLite < 3.27.'
+ )
def test_subquery_row_range_rank(self):
qs = Employee.objects.annotate(
highest_avg_salary_date=Subquery(