id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
12239	Float is rounded to integer on queries on integer field	Adrian Andreias	nobody	"On queries (__gte, __lte) ran on an integer field with a float value to compare, the float value gets rounded to integer and this causes invalid results.

{{{
class Number(models.Model):
	val = models.IntegerField()

# Python 2.5.4 (r254:67916, Dec 23 2008, 15:10:54) [MSC v.1310 32 bit (Intel)] on win32
# Type ""help"", ""copyright"", ""credits"" or ""license"" for more information.
# (InteractiveConsole)

>>> n = Number(val=10)
>>> n.save()
>>> Number.objects.all()
[<Number: Number object>]
>>> Number.objects.filter(val__gte=10.1)
[<Number: Number object>]
>>> from django.db import connection
>>> connection.queries[-1]
{'time': '0.001', 'sql': 'SELECT ""t1_number"".""id"", ""t1_number"".""val"" FROM ""t1_number"" WHERE ""t1_number"".""val"" >= 10  LIMIT 21'}
>>> import django
>>> django.VERSION
(1, 1, 1, 'final', 0)

}}}"		closed	Database layer (models, ORM)	1.1		fixed	__gte, __lte, query rounding		Accepted	1	0	0	0	0	0