| 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 | |||
| 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: | ||||