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

[Clemens Ladisch]

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