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