On 8 Jul 2018, at 7:19am, Cecil Westerhof <[email protected]> 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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
