On Tue, 2005-08-30 at 15:04 -0400, Ned Batchelder wrote:
> As near as I can tell, this line in printf.c (line 445):
>
> while( realvalue>10.0 && exp<=350 ){ realvalue *= 0.1; exp++; }
>
> should be:
>
> while( realvalue>=10.0 && exp<=350 ){ realvalue *= 0.1; exp++; }
>
, which is ':'.
--Ned.
http://nedbatchelder.com
-Original Message-
From: Bob Dankert [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 30 August, 2005 2:35 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Unlucky number for the ROUND function
Using the sqlite.exe 3.2.5 binary off the website with WinXP SP2
chelder.com
-Original Message-
From: Bob Dankert [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 30 August, 2005 2:35 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Unlucky number for the ROUND function
Using the sqlite.exe 3.2.5 binary off the website with WinXP SP2 here, I
get the "
o: <sqlite-users@sqlite.org>
Sent: Tuesday, August 30, 2005 11:35 AM
Subject: RE: [sqlite] Unlucky number for the ROUND function
Using the sqlite.exe 3.2.5 binary off the website with WinXP SP2 here, I
get the ":.0" result (less the quotes). I have tried this on a couple
mac
256.5680
f. 608.256.3780
-Original Message-
From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 30, 2005 1:08 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Unlucky number for the ROUND function
On Tue, 2005-08-30 at 12:46 -0500, Bob Dankert wrote:
> According to th
On Tue, 2005-08-30 at 12:46 -0500, Bob Dankert wrote:
> According to that, it rounds to the nearest even number. Shouldn't 9.95
> go to 10 then, and 9.85 go to 9.8?
>
> After additional testing with SQLite 3.2.2, I have the following
> results:
>
> Round(9.95,1) -> 9.9*Rounded Down*
>
8.256.5680
f. 608.256.3780
-Original Message-
From: Kervin L. Pierre [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 30, 2005 12:18 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Unlucky number for the ROUND function
Interesting...
Bankers' Rounding
http://blogs.msdn.com/ericlip
y, August 30, 2005 12:18 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Unlucky number for the ROUND function
Interesting...
Bankers' Rounding
http://blogs.msdn.com/ericlippert/archive/2003/09/26/53107.aspx
Brass Tilde wrote:
>>From: "Bob Dankert"
>
>
>>Using
Interesting...
Bankers' Rounding
http://blogs.msdn.com/ericlippert/archive/2003/09/26/53107.aspx
Brass Tilde wrote:
From: "Bob Dankert"
Using an older version which I compiled, I get 9.9, though it
seems it should round up to 10.0?
This may be dependent upon the math library linked
> From: "Bob Dankert"
> Using an older version which I compiled, I get 9.9, though it
> seems it should round up to 10.0?
This may be dependent upon the math library linked into the application
by the compiler used to build SQLite. Some libraries appear to now be
using so-called "banking
Hi,
On Windows XP testing for SQLite 3.2.5:
:.0 when using the sqlite3 executable downloaded
9.9 when running a program linked to an SQlite3 static library compiled by the
MinGW port of GCC 3.4.2
Eugene Wee
Edzard Pasma wrote:
I found a number where the ROUND () function goes wrong:
SQLite
[EMAIL PROTECTED]
> Sent: Tuesday, August 30, 2005 12:02 PM
> To: sqlite-users@sqlite.org
> 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 ge
gt;
> 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: sqlite-users@sqlite.org
&
-
From: Eric Bohlman [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 30, 2005 11:05 AM
To: sqlite-users@sqlite.org
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
>
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).
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
Sorry, it must be that I have bad luck today
Edzard Pasma
_
Tired of spam and viruses?
16 matches
Mail list logo