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
6767	Oracle backend treats DecimalFields as floats somewhere, losing precision	Matt Boersma	nobody	"This is really a cx_Oracle limitation.  One workaround Ian Kelly and I discussed is to set cursor.numbersAsStrings = True and then Do The Right Thing in converting from strings.  (The cx_Oracle rowfactory callback mechanism could be a nice way to handle this.)

{{{
#!python

>>> from foo.models import Address
>>> from decimal import Decimal
>>> a = Address(latitude=Decimal('-105.2513837814331'))
>>> a.save()
>>> a.latitude
Decimal(""-105.2513837814331"")
>>> b = Address.objects.get(pk=a.pk)
>>> b.latitude
Decimal(""-105.25138378143301000000000000000000000"")

}}}

Nothing in the test suite catches this!  We need to add a test for this before creating the fix."		closed	Database layer (models, ORM)	dev		fixed	oracle Oracle decimal float precision	Erin Kelly richard.davies@…	Accepted	0	0	0	0	0	0