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