--- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote:
> When I type in exactly the same code, I get only a single > line of output (3000000000000) as you would expect. > -- > D. Richard Hipp <[EMAIL PROTECTED]> > > For what it's worth, I am able to duplicate the problem when copy/pasting from the original message: SQLite version 3.2.1 Enter ".help" for instructions sqlite> create table t(j integer primary key); sqlite> insert into t(j) values(1000000000000); sqlite> insert into t(j) values(2000000000000); sqlite> insert into t(j) values(3000000000000); sqlite> select * from t where j > 2000000000000; 1000000000000 2000000000000 3000000000000 sqlite> This is under Windows XP using the pre-compiled binaries downloaded from sqlite.org, and on Linux, also with 3.2.1. -Clark
