sqlite> create table test (Qty DECIMAL(10,2));
sqlite> insert into test values(1059.79);
sqlite> insert into test values(-1050);
sqlite> insert into test values(83.58);
sqlite> insert into test values(130.51);
sqlite> insert into test values(-5);
sqlite> insert into test values(-136.68);
sqlite> insert into test values(-2.6);
sqlite> insert into test values(-75);
sqlite> insert into test values(-4.6);
sqlite> select sum(Qty) FROM TEST;
-6.21724893790088e-14
Given that I explicitly specified DECIMAL(10,2) as the field type, why is the sum not 0?
Aucun commentaire:
Enregistrer un commentaire