[sqlite] SQLITE_DEFAULT_FILE_PERMISSIONS

s is extra work so it would be helpful to know why this design decision was taken. -jonathan -- Jonathan H N Chin | deputy computer | Newton Institute, Cambridge, UK <jc...@newton.ac.uk> | systems manager | tel/fax: +44 1223 767091/330508 ___ sqlit

[sqlite] sqlite3: floating point behaviour has changed

uname -m i686 $ dpkg -l sqlite3 | awk '/^.i/{print $3}' 3.5.9-3 $ echo 'select 1219441430151/2.0, 1219441430151/20.0;' | sqlite3 609720715075.5| -jonathan -- Jonathan H N Chin, 2 dan | deputy computer | Newton Institute, Cambridge, UK <[EMAI

Re: [sqlite] sqlite3: floating point behaviour has changed

or a problem with the build? [...] > $ cat /etc/debian_version > lenny/sid > $ uname -m > i686 > $ dpkg -l sqlite3 | awk '/^.i/{print $3}' > 3.5.9-3 > $ echo 'select 1219441430151/2.0, 1219441430151/20.0;' | sqlite3 > 609720715075.5| -jonathan -- Jonathan

Re: [sqlite] select foo,count(foo) -> segmentation fault

c) should have been more like: create table dhcp (ip, mac); select count(ip) as b from t group by mac having b>1; But this is no longer sqlite-specific. Thus I need to find an SQL reference (or textbook)... 8^) -jonathan -- Jonathan H N Chin, 2 dan | deputy computer | N

Re: [sqlite] select foo,count(foo) -> segmentation fault

g. Thanks. Sounds like the problem has already been fixed. Guess I'll just have to wait for debian to catch up. In the meantime I'd better look for an SQL reference... -jonathan -- Jonathan H N Chin, 2 dan | deputy computer | Newton Institute, Cambridge, UK <[EMAIL PROTECTED]> | system

Re: [sqlite] blocking - busy_timeout vs database is locked(5)

I should perhaps note that there are only around fifty accesses in any given five minute interval, so it is not as if anything is being overloaded. -jonathan -- Jonathan H N Chin, 2 dan | deputy computer | Newton Institute, Cambridge, UK <[EMAIL PROTECTED]> | systems mangler | tel/fa

[sqlite] blocking - busy_timeout vs database is locked(5)

ccesses block/retry when the database is busy? -jonathan -- Jonathan H N Chin, 2 dan | deputy computer | Newton Institute, Cambridge, UK <[EMAIL PROTECTED]> | systems mangler | tel/fax: +44 1223 767091/330508 "respondeo etsi mutabor" --Rosenstock-Huessy

Re: [sqlite] preventing text to integer conversion of bind variables in perl

quot;, "11"); $db->do( qq[REPLACE INTO t VALUES(?,?);], undef, "k4", "10"); ' sqlite3 test 'select * from t;' sqlite3 test 'select * from t order by v;' then I get: k1|9 k2|8 k3|11 k4|10 k4|10 k3|11 k2|8 k1|9

Re: [sqlite] preventing text to integer conversion of bind variables in perl

passed in. One could use a prepare, bind_param, execute sequence, but that would seem to defeat the point of having the do() shortcut in the first place. -jonathan -- Jonathan H N Chin, 2 dan | deputy computer | Newton Institute, Cambridge, UK <[EMAIL PROTECTED]> | systems mangler | tel/fax: