[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 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
