Re: [sqlite] EXT :Re: BUG : round(x,y) not consistent

[Thilo Jeremias]

On 30/04/2011 3:36 PM, Stephan Beal wrote:
 On Sat, Apr 30, 2011 at 2:45 PM, Black, Michael (IS) michael.bla...@ngc.com
 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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite3 ltrim behaviour bug or feature?

[Thilo Jeremias]

Hi,
the following seems wrong to me:

bash-4.0# sqlite3
SQLite version 3.6.14.2
Enter .help for instructions
Enter SQL statements terminated with a ;


sqlite select ltrim(12300567,1230);
567
sqlite select ltrim(012300567,0123);
567
sqlite select ltrim(12300567,123);
00567
sqlite


Is the stripping of leading 0's intentional?
(or a bug in my netbsd port?)

How can I workaround this problem?


cheers thilo


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users