All- Ok, after pulling down source for v3.2.2, building and running the same test, everything now behaves as one would expect (ie one line of output being 3000000000000);
So, whatever caused the issue, it appears to be have been addressed post-v3.2.1. Thanks to everyone for the help/input. sdm ----------------------------------------- Stephen D. Miller Software & Networking Solutions Consultant ThinkGear, Inc. (888) 5-THINKGEAR / www.thinkgear.com >-----Original Message----- >From: Clark Christensen [mailto:[EMAIL PROTECTED] >Sent: Wednesday, June 29, 2005 11:17 AM >To: [email protected] >Subject: Re: [sqlite] Comparator bug? Overflow? > > > >--- "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 > >
