Re: [sqlite] round ?

[Nicolas Martin]

Oops,
i didn't check cvstrack
Many thanks !
Nicolas
D. Richard Hipp wrote:

On Thu, 2005-07-28 at 08:37 +0200, Nicolas Martin wrote:

Some strange effect of the round expression :

sqlite> select round(1-0.5);
0
sqlite> select round(2-0.5);
2

See http://www.sqlite.org/cvstrac/tktview?tn=1316.  The
problem results from inconsistent behavior in platform
printf() functions.  The fix was for SQLite to always use
it's own internal printf() function.