Richard Hipp wrote: > What does this query return? > > SELECT count(*) FROM ipIndex > WHERE minD1 <= 1220818432 and 1220818432 <= maxD1 > AND minD2 <= 2120561472 and 2120561472 <= maxD2 > AND minD3 <= 1685398080 and 1685398080 <= maxD3 > AND minD4 <= 1685755328 and 1685755328 <= maxD4 > AND minD5 <= 538331072 and 538331072 <= maxD5;
Hm, it returns 1645. This indicates a bug (the max expected value is 128). I'm now highly suspicious of my mathematical reasoning or my code. I'll take a look. Thanks, Richard! Eric _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users