Documentation Source Text

View Ticket
Login
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
Description:
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 http://www.sqlite.org/cvstrac/tktnew. Note, however, that your issue is probably not a bug. You really should ask about it on the SQLite mailing list first.