I can reproduce this behavior using 3.2.5 compiled with MS VC++ 7. 3.2.2 didn't produce consistent behavior cross-platform when rounding numbers that ended with .5, so yes, it should have rounded up to 10.0. :)
-Tom > -----Original Message----- > From: Bob Dankert [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 30, 2005 12:02 PM > To: [email protected] > Subject: RE: [sqlite] Unlucky number for the ROUND function > > Using the downloaded command-line tool for 3.2.5, I get the same :.0 > result. Using an older version which I compiled, I get 9.9, though it > seems it should round up to 10.0? > > Bob > > Envision Information Technologies > Associate > [EMAIL PROTECTED] > v. 608.256.5680 > f. 608.256.3780 > > > -----Original Message----- > From: Eric Bohlman [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 30, 2005 11:05 AM > To: [email protected] > Subject: Re: [sqlite] Unlucky number for the ROUND function > > Edzard Pasma wrote: > > I found a number where the ROUND () function goes wrong: > > > > SQLite version 3.2.5 > > Enter ".help" for instructions > > sqlite> select round (9.95, 1); > > :.0 > > I get 9.9 (running on Win98, compiled with MingW). >
