Changes between Version 1 and Version 2 of Ticket #18247, comment 3


Ignore:
Timestamp:
Aug 11, 2012, 5:05:03 PM (12 years ago)
Author:
fengb

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #18247, comment 3

    v1 v2  
    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.
     1Per http://article.gmane.org/gmane.comp.db.sqlite.general/75696 ,  aggregate functions should not have affinity so typecasting Decimal into a string will never have matching values.
    22
    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.
     3I 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 aggregation is used.
Back to Top