Re: [sqlite] Fill empty space with random

2018-10-15 Thread thilo jeremias
> > In the simple case, the VFS that the sqlite Db is mounted in is encrypted > with a long key. The key has cycles at 4096(A) and 16(B1-Bn) bytes > (4096/16 = 256 cycles of Bn); such that each sector is masked with > A^B1(256x), A^B2(256x), ... all together there is no repetition because the > c

[sqlite] sqlite3 ltrim behaviour bug or feature?

2011-01-14 Thread 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

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

2011-04-30 Thread Thilo Jeremias
On 30/04/2011 3:36 PM, Stephan Beal wrote: > On Sat, Apr 30, 2011 at 2:45 PM, Black, Michael (IS) > 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