On 8 Jul 2018, at 7:19am, Cecil Westerhof <cldwester...@gmail.com> wrote:

> ABS(RANDOM()) / CAST(1.4E18 AS INTEGER)

Don't divide by a number like 1.4e18 in an 18-digit INTEGER calculation and 
expect to get sensible answers.

Use the conventional

    CAST(RANDOM() * 7) AS INTEGER

or whatever spread you want.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to