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

Reply via email to