On 30/04/2011 3:36 PM, Stephan Beal wrote: > On Sat, Apr 30, 2011 at 2:45 PM, Black, Michael (IS) <[email protected] >> wrote: >> 3.75 on Redhat 5.6 does not have a problem. >> I get >> >> 8.88 >> 16.88 >> 32.88 >> 64.88 >> > Same on Ubuntu 11.04 x86/64 w/ sqlite3 3.7.4. > > Fixed in 3.7.5 maybe? I don't think so (at least not netbsd):
$ uname -a NetBSD maggi 5.1_RC1 NetBSD 5.1_RC1 (GENERIC) #0: Mon May 10 09:58:36 MEST 2010 thilo@maggi:/new.home/mnt3/users/BSD/NetBSD/obj.50rc2/sys/arch/i386/compile/GENERIC i386 bash-4.0$ sqlite3 SQLite version 3.7.5 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .mode line sqlite> select round(2.875,2),round(4.875,2),round(8.875,2), round(16.875,2), round(32.875,2), round(64.875,2),round(128.875,2); round(2.875,2) = 2.87 round(4.875,2) = 4.87 round(8.875,2) = 8.88 round(16.875,2) = 16.87 round(32.875,2) = 32.88 round(64.875,2) = 64.87 round(128.875,2) = 128.88 > It would seem to be platform-dependent. Yes thilo _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
