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