-------------------------------------------------------------------- FreeBSD 9.1-RELEASE #0 r243826: Tue Dec 4 06:55:39 UTC 2012 r...@obrian.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC i386
%sqlite3 :memory: SQLite version 3.7.15.1 2012-12-19 20:39:10 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> CREATE TABLE t (a text, b real, c int); sqlite> select 4.40035364203128e+118; 4.40035364203128e+118 sqlite> select 4.400353642031278e+118; 4.40035364203128e+118 sqlite> select 4.400353642031274e+118; 4.40035364203127e+118 sqlite> select 4.400353642031275e+118; 4.40035364203127e+118 <--- should by 4.40035364203128e+118 sqlite> select 4.400353642031276e+118; 4.40035364203128e+118 sqlite> select 4.40035364203127786031058909193863e+118; 4.40035364203128e+118 sqlite> insert into t values(4.40035364203127786031058909193863e+118,4.40035364203127786031058909193863e+118,1); sqlite> select * from t; 4.40035364203128e+118|4.40035364203128e+118|1 sqlite> -------------------------------------------------------------------- FreeBSD 9.1-RELEASE #0 r243825: Tue Dec 4 09:23:10 UTC 2012 r...@farrell.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC amd64 %sqlite3 :memory: SQLite version 3.7.14.1 2012-10-04 19:37:12 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> select 4.400353642031275e+118; 4.40035364203128e+118 <--- is the correct result sqlite> -------------------------------------------------------------------- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users