Hi Simon,

Once again, I really do not care of the accuracy.

I KNOW 0.1 CAN NOT BE STORED EXACTLY IN A REAL VARIABLE.

I just try to figure out why the SAME CODE (sqlite3 library) with the SAME 
INPUT gives DIFFERENT RESULTS (no matter how accurate/exact they individually 
are!) when linked to different shells.


Etienne


----- Original message -----
From: Simon Slavin <slav...@bigfraud.org>
To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
Subject: Re: [sqlite] VERY weird rounding error: details
Date: Sat, 16 Jun 2012 18:13:29 +0100


On 16 Jun 2012, at 5:41pm, Etienne <ejlist-sql...@yahoo.fr> wrote:

> 19913:   realvalue *= 0.1;

This operation cannot be correctly executed while holding the value in a real 
variable.  You will get inconsistent results.  Please read the reference I gave 
earlier for an explanation of why it is pointless trying to get perfect 
accuracy while handling a value of 0.1 in a real variable.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to