[sqlite] Problem storing integers

[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 VALUES(281474976710655);
INSERT INTO test VALUES(72057594037927935);
SELECT * FROM test;

Results in:

4294967295
1099511627775
-1
72057594037927935

i.e. 281474976710655 is stored as -1

Regards,
Rich