From ebc4ee3369694e6dca5cf216d4176bdefd930fd6 Mon Sep 17 00:00:00 2001 From: Sergey Fedoseev Date: Fri, 22 Dec 2017 05:50:56 +0500 Subject: Refs #23941 -- Prevented incorrect rounding of DecimalField annotations on SQLite. --- tests/annotations/tests.py | 14 ++++++++++++++ 1 file changed, 14 insertions(+) (limited to 'tests/annotations') diff --git a/tests/annotations/tests.py b/tests/annotations/tests.py index aaf56e79ef..d2e2214db8 100644 --- a/tests/annotations/tests.py +++ b/tests/annotations/tests.py @@ -244,6 +244,20 @@ class NonAggregateAnnotationTestCase(TestCase): sum_rating=Sum('rating') ).filter(sum_rating=F('nope'))) + def test_decimal_annotation(self): + salary = Decimal(10) ** -Employee._meta.get_field('salary').decimal_places + Employee.objects.create( + first_name='Max', + last_name='Paine', + store=Store.objects.first(), + age=23, + salary=salary, + ) + self.assertEqual( + Employee.objects.annotate(new_salary=F('salary') / 10).get().new_salary, + salary / 10, + ) + def test_filter_decimal_annotation(self): qs = Book.objects.annotate(new_price=F('price') + 1).filter(new_price=Decimal(31)).values_list('new_price') self.assertEqual(qs.get(), (Decimal(31),)) -- cgit v1.3