#18247: filter and Decimal equality doesn't work -------------------------------------+------------------------------------- Reporter: elmopl@… | Owner: nobody Type: Bug | Status: reopened Component: Database layer | Version: 1.4 (models, ORM) | Resolution: Severity: Normal | Triage Stage: Keywords: decimal filter | Unreviewed Has patch: 0 | Needs documentation: 0 Needs tests: 0 | Patch needs improvement: 0 Easy pickings: 0 | UI/UX: 0 -------------------------------------+------------------------------------- Changes (by fengb):
* status: closed => reopened * resolution: invalid => Comment: Per http://article.gmane.org/gmane.comp.db.sqlite.general/75696 , SUM values should not have affinity so typecasting Decimal into a string will never return real values. I think changing the typecast of Decimal into float is "good enough". Internally, sqlite3 already represents these values as floats, and it would fix this bug. Otherwise, we would need separate casting engines depending on whether SUM is used. -- Ticket URL: <https://code.djangoproject.com/ticket/18247#comment:3> Django <https://code.djangoproject.com/> The Web framework for perfectionists with deadlines. -- You received this message because you are subscribed to the Google Groups "Django updates" group. To post to this group, send email to django-updates@googlegroups.com. To unsubscribe from this group, send email to django-updates+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-updates?hl=en.