From e69a9920e2b69d9b765a81d9ebeedfdc938892f6 Mon Sep 17 00:00:00 2001 From: Mariusz Felisiak Date: Thu, 10 Aug 2023 05:33:13 +0200 Subject: Fixed non-deterministic order in SubqueryTests.test_slice_subquery_and_query. Slice on unordered subquery may be non-deterministic in some databases. --- tests/queries/tests.py | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/tests/queries/tests.py b/tests/queries/tests.py index 43cfd9b7c0..20665ab2cd 100644 --- a/tests/queries/tests.py +++ b/tests/queries/tests.py @@ -2373,18 +2373,18 @@ class SubqueryTests(TestCase): """ query = DumbCategory.objects.filter( id__in=DumbCategory.objects.order_by("-id")[0:2] - )[0:2] - self.assertEqual({x.id for x in query}, {3, 4}) + ).order_by("id")[0:2] + self.assertSequenceEqual([x.id for x in query], [3, 4]) query = DumbCategory.objects.filter( id__in=DumbCategory.objects.order_by("-id")[1:3] - )[1:3] - self.assertEqual({x.id for x in query}, {3}) + ).order_by("id")[1:3] + self.assertSequenceEqual([x.id for x in query], [3]) query = DumbCategory.objects.filter( id__in=DumbCategory.objects.order_by("-id")[2:] - )[1:] - self.assertEqual({x.id for x in query}, {2}) + ).order_by("id")[1:] + self.assertSequenceEqual([x.id for x in query], [2]) def test_related_sliced_subquery(self): """ -- cgit v1.3