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 kervin-3GP3cpDhPzVWk0Htik3J/[EMAIL PROTECTED] wrote: I expected this script to work... create table

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

Kervin L. Pierre kervin-3GP3cpDhPzVWk0Htik3J/[EMAIL PROTECTED] 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