Changes between Initial Version and Version 1 of Ticket #18247, comment 3
- Timestamp:
- Jul 11, 2012, 8:23:34 PM (12 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #18247, comment 3
initial v1 1 1 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. 2 2 3 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.3 I think changing the typecast of Decimal into float is "good enough". Internally, sqlite3 already represents these values as floats so I don't think there would be too detrimental to make it slightly more explicit. Otherwise, we would need separate casting engines depending on whether SUM is used.