Documentation Source Text

View Ticket
Ticket UUID: be1b855b0507be6ce0b37349fc0707e6368db77c
Title: decimal field converted to int still returns digits after decimal point
Status: Closed Type: Code_Defect
Severity: Important Priority: Immediate
Subsystem: Resolution: Rejected
Last Modified: 2009-03-18 13:32:44
Version Found In: 3.6.11
I created a table in the past with a XYZ field as numeric(8,2) and had 3 rows with XYZ values 5, 10 and 20.75 Then I changed the design by making XYZ int. Now values are shown as 5, 10 and 20 but SELECT Sum(XYZ) still returns 35.75 instead of 35

drh added on 2009-03-18 13:32:44:
This ticketing system is for reporting bugs against the documentation for SQLite. To report bugs against SQLite code, please visit Note, however, that your issue is probably not a bug. You really should ask about it on the SQLite mailing list first.