[sqlite] Strange problem with using random with a table

[Cecil Westerhof]

When I execute the following query:
SELECT *
,      randomiser * 1000
FROM (
    SELECT abs(random()) / 10000000000000000 AS randomiser
);

I get normal results:
61|61000


But when I change it to:
SELECT *
,      randomiser * 1000
FROM (
    SELECT abs(random()) / 10000000000000000 AS randomiser
    FROM   proverbs
)
LIMIT 5;

I get very strange results:
382|606000
172|148000
144|592000
181|136000
123|469000

What could be happening here?

I am using SQLite version 3.8.10.2 on openSUSE Leap 42.1.

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