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 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 followed by 32 ones. SQLite deals > with 64-bit > integers. > > Igor Tandetnik > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to > [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------