On 15 Jun 2012, at 5:32am, Etienne <ejlist-sql...@yahoo.fr> wrote:
> That said... the rounding error ITSELF is not the point.
>
> The problem is: the "real" rounding error depends here on the shell (SQLite
> or JSDB) calling the SQLite library.
Yes. Different languages use different ways to hide the fact that they can't
hide the 0.1. There's nothing you can do about this.
> If I submit twice the same input (e.g. 99990.1) to the same "black box" (e.g.
> SQLite library - same compiler options etc.), I am just waiting for the same
> (fake) result. IT was determinist... so far.
Here is your original text:
>>>> R:\>sqlite NUL "select 99990.1;"
>>>> 99990.1
>>>>
>>>>
>>>> JSDB (www.jsdb.org) output:
>>>>
>>>> js>var db = new SQLite();
>>>> js>db.exec("select 99990.1", function(r){writeln(r)});
>>>> 99990.1=99990.1000000001
>>>> true
You are not doing the same thing both times. One time you are writing the
result using SQLite. The other time you are writing the result using a
'writeln()' command. There is no 'writeln()' command in SQLite.
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
