On Fri, Sep 6, 2013 at 10:00 AM, Hick Gunter <h...@scigames.at> wrote:

>
> My guess is that you have exceeded the range of a 32 bit integer
> (0x7FFFFFFF) which will be rendered as a negative number by the SQLite
> shell.
>

The shell works just fine with 64-bit signed integers:

SQLite version 3.8.0.1 2013-08-29 17:35:01
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> select 1024*1024*1024*1024*1024;
1125899906842624



-- 
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to