This assumption is a bit naive :
In SQLite, this cannot happen because queries execute infinitely fast
(as far as the built-in date/time functions are concerned).
There is different cpus with different processing power, load variations, io
access latency, ...
Cheers !
?
> Wed Aug 26 2015 4:03:53 pm CEST CEST from "Clemens Ladisch"
><clemens at ladisch.de> Subject: Re: [sqlite] order by not working in
>combination with random()
>
> Graham Holden wrote:
>
>>And while "SELECT random() AS rr ORDER BY rr" is slightly contrived, the
>>example from J Decker:
>>
>> select ItemName,SoldDate, date('now','-1 month') as z from
>> SoldItemDetails order by
>> SoldDate<z desc,SoldDate asc;
>>
>> if it were to show the same behaviour (I haven't tested it) might break if
>>executed "around midnight"
>>
> In SQLite, this cannot happen because queries execute infinitely fast
> (as far as the built-in date/time functions are concerned).
>
>
> Regards,
> Clemens
> _______________________________________________
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
>
>
?
