--- Joe Wilson <[EMAIL PROTECTED]> wrote: > --- Olaf Schmidt <[EMAIL PROTECTED]> wrote: > > On what OS have you tested? > > If on windows, was it a GCC-compile or a MS-VC-compile? > > Running the GCC cross-compiled sqlite3.exe from > http://www.sqlite.org/sqlite-3_3_17.zip on Windows > (well, wine on Linux): > > SQLite version 3.3.17 > Enter ".help" for instructions > sqlite> select round(0.95, 1); > 0.9 > > What result does the sqlite3.exe from the above link give > you on your machine?
This is interesting... on the same P4 machine rebooted into Windows 2000 using the _same_ sqlite3.exe binary from http://www.sqlite.org/sqlite-3_3_17.zip I get a different result: SQLite version 3.3.17 Enter ".help" for instructions sqlite> select round(0.95, 1); 1.0 But when the code is compiled from source under MinGW on Windows using gcc version 3.4.2 (mingw-special), I get the same result as Linux: > gcc -I. -I.. sqlite3.c src/shell.c -o sqlite3.exe > ./sqlite3.exe SQLite version 3.3.17 Enter ".help" for instructions sqlite> select round(0.95, 1); 0.9 Cygwin gcc version 3.4.4 (cygming special) also produces a 0.9 result. I can't reproduce the rounding difference when I compile from source code. What flags and gcc compiler version was used to build the Windows sqlite3.exe in http://www.sqlite.org/sqlite-3_3_17.zip ? ____________________________________________________________________________________ No need to miss a message. Get email on-the-go with Yahoo! Mail for Mobile. Get started. http://mobile.yahoo.com/mail ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
