On Monday, September 03, 2007 Nuno Lucas wrote: > This made me to remember there was a bug some time ago about the > rounding algorithm (but can't remember at what version it was fixed), > so I just tested it.
> "official" amalgamated sqlite 3.4.0 downloaded from the site some time ago: > SQLite version 3.4.0 > Enter ".help" for instructions > sqlite> select round(98926650.5, 1) ; > 98926650.5 > So it seems SQLite is already doing the right job. > Maybe some OS specific error? Wasn't there some discussion earlier > about the Microsoft compiler not using the full double precision by > default? On WinXP SQLite version 3.4.2 Enter ".help" for instructions sqlite> select round(98926650.5, 1); 98926650.5000001 My results above are using the sqlite3.exe from http://www.sqlite.org. I belive this is compiled with gcc, but I don't know what version. However, if I compile from sources, I get C:\Dev\sqlite\sqlite-3.4.2\bld>.\sqlite3 SQLite version 3.4.2 Enter ".help" for instructions sqlite> select round(98926650.5, 1); 98926650.5 I am using: $ gcc --version gcc.exe (GCC) 3.4.5 (mingw special) e -- Doug Currie Londonderry, NH, USA ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
