vendredi 11 septembre 2015

Unexpected behavior in SQLite query using random()

SELECT random() as r from my_tbl where r < 0 LIMIT 10

returns 10 numbers, but some are positive, which is not what I'd expect. Is this a bug in SQLite?

Aucun commentaire:

Enregistrer un commentaire