I've encountered strange behaviour which seems to be a bug in sqlite3. When a
perform the following query:
select random() as x from some_non_empty_table order by x desc limit 20;
I get something like:
-4348240540797173967
-8823092517172356709
4237024158005380173
897958093325532613
-6349939216731113298
-6415063730448487969
3795645810874245999
5300179442479885767
-5672114082066149676
5948675430181341494
8235388210609133476
-3432532690505250003
4994605130208883785
887168342793876131
-7629499224725069619
1835121064790921896
4264436532007779451
6778497606080791442
5700115471744620349
2216650647749644467
which clearly is NOT in descending order. Why is the order by clause not
working in this case?