[sqlite] order by not working in combination with random()

[Petite Abeille]

> On Aug 17, 2015, at 12:01 PM, Clemens Ladisch <clemens at ladisch.de> wrote:
> 
> Just because the ORDER BY clause refers to a column of the
> SELECT clause does not mean that the value is not computed
> a second time.

And yet:

with
DataSet( position, value )
as
(
  select  1 as position,
          random() as value
  union all
  select  DataSet.position + 1 as position,
          random() as value
  from    DataSet
  where   DataSet.position < 10
)
select    DataSet.value
from      DataSet

order by  DataSet.value;

-4870943077918547304
-4477154295778822007
-3065995363549703972
-2365142629623062778
-1659827499818666566
-422422602260941678
122478153305412750
2673926196199910076
2741194622440706627
4802559261241955862