| Ticket Hash: | 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 16.30 years ago |
Created: |
2009-03-06 17:18:10 16.33 years ago |
| 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 <hr><i>drh added on 2009-03-18 13:32:44:</i><br> 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. | ||||