Another random boundary case: SQLite's RANDOM() won't generate the minimum i64 value, because: i64 MIN: −2⁶³ i64 MAX: 2⁶³-1 Since RANDOM() is used with ABS(), that floor value is lopped off. (Can you imagine if it weren't, and you got a bug 1 in every 2⁶⁴ calls?)<a href="https://sqlite.org/lang_corefunc.html#random" rel="nofollow">https://sqlite.org/lang_corefunc.html#random<a href="https://sqlite.org/forum/forumpost/4c0b09747a670652" rel="nofollow">https://sqlite.org/forum/forumpost/4c0b09747a670652
Rendello · · focus · HN ↗
<a href="https://sqlite.org/lang_corefunc.html#random" rel="nofollow">https://sqlite.org/lang_corefunc.html#random
<a href="https://sqlite.org/forum/forumpost/4c0b09747a670652" rel="nofollow">https://sqlite.org/forum/forumpost/4c0b09747a670652