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.29 years ago |
Created: |
2009-03-06 17:18:10 16.32 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
drh added on 2009-03-18 13:32:44: |