Re: [sqlite] Problem storing integers

2005-04-17 Thread D. Richard Hipp
On Sun, 2005-04-17 at 08:03 -0400, Ken & Deb Allen wrote: > When can we expect a 3.2.2 release that includes this correction? I am > working on a database that depends on 64-bit integer values. > You can pull down the latest code from CVS anytime you want. The CVS client is available for

Re: [sqlite] Problem storing integers

2005-04-17 Thread Ken & Deb Allen
When can we expect a 3.2.2 release that includes this correction? I am working on a database that depends on 64-bit integer values. -ken On 15-Apr-05, at 7:35 AM, D. Richard Hipp wrote: On Fri, 2005-04-15 at 10:53 +0100, Richard Boulton wrote: I'm running the latest sqlite 3.2.1 command line

RE: [sqlite] Problem storing integers

2005-04-15 Thread D. Richard Hipp
On Fri, 2005-04-15 at 10:53 +0100, Richard Boulton wrote: > > I'm running the latest sqlite 3.2.1 command line tool on Windows > > XP > > I've just run some older versions of the command line tool and the last time > the value 281474976710655 was stored correctly was 3.0.8 I was missing a >

RE: [sqlite] Problem storing integers

2005-04-15 Thread Richard Boulton
> I'm running the latest sqlite 3.2.1 command line tool on Windows > XP I've just run some older versions of the command line tool and the last time the value 281474976710655 was stored correctly was 3.0.8 I was missing a couple of releases after 3.0.8 but saw the unexpected behaviour start in

Re: [sqlite] Problem storing integers

2005-04-14 Thread Nuno Lucas
[15-04-2005 5:47, Gé Weijers escreveu] Same thing on Mac OSX. Must be a platform-independent issue. Same thing on v3.2.1 on linux (gentoo ebuild). It looks like a bug... ~Nuno Lucas Richard Boulton wrote: CREATE TABLE test (a INTEGER); INSERT INTO test VALUES(4294967295); INSERT INTO test

Re: [sqlite] Problem storing integers

2005-04-14 Thread Gé Weijers
Same thing on Mac OSX. Must be a platform-independent issue. Gé Richard Boulton wrote: >Hi, > >I'm running the latest sqlite 3.2.1 command line tool on Windows XP and have >noticed that I don't seem to be able to store 48bit integers anymore :-S > >CREATE TABLE test (a INTEGER); >INSERT INTO

[sqlite] Problem storing integers

2005-04-14 Thread Richard Boulton
Hi, I'm running the latest sqlite 3.2.1 command line tool on Windows XP and have noticed that I don't seem to be able to store 48bit integers anymore :-S CREATE TABLE test (a INTEGER); INSERT INTO test VALUES(4294967295); INSERT INTO test VALUES(1099511627775); INSERT INTO test