2016-11-11 11:01 GMT+01:00 Cecil Westerhof <cldwester...@gmail.com>:
> 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.
It even gets stranger. When I use:
SELECT *
, randomiser * 1000
, randomiser * 1000
, randomiser * 1000
, randomiser * 1000
, randomiser * 1000
FROM (
SELECT abs(random()) / 10000000000000000 AS randomiser
FROM proverbs
)
LIMIT 5;
I get:
453|75000|900000|772000|823000|51000
93|572000|825000|881000|339000|681000
223|213000|726000|456000|688000|772000
565|359000|771000|674000|547000|26000
114|822000|188000|576000|635000|229000
--
Cecil Westerhof
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
