Re: [sqlite] Re: Shouldn't this query work?

Hello Igor, Thanks. That was the problem. I had been doing 32 bit math on SQLite's 64 bit integers. Best regards, Kervin --- Igor Tandetnik <[EMAIL PROTECTED]> wrote: > Kervin L. Pierre > > wrote: > > I expected this script to work... > > > > create table testtable ( testcol int ); > > ins

[sqlite] Re: Shouldn't this query work?

Kervin L. Pierre wrote: I expected this script to work... create table testtable ( testcol int ); insert into testtable ( testcol ) values ( -2146369472 ) select * from testtable where ( testcol & 4294967295 ) = -2146369472 Note that 4294967295 in binary is all '1's. No, it's 32 zeros follo