Quoth "Black, Michael (IS)" <michael.bla...@ngc.com>, on 2011-03-04 21:55:01 
+0000:
> SQlite's random() is a pseudo-random (as are most all) so there is
> no collision until you get the same value back at which point it
> just repeats the whole sequence again.

Yes, it's a PRNG, but even if the total period is at least 2^64, that
doesn't guarantee no repeated 64-bit values unless the output reflects
the entire state, no?  ISTR SQLite using (A)RC4.

And that doesn't help between connections.

   ---> Drake Wilson
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to