On 27 Aug 2015 at 18:49, Simon Slavin <slavins at bigfraud.org> wrote:
> On 27 Aug 2015, at 6:41pm, Domingo Alvarez Duarte <sqlite-mail at > dev.dadbiz.es> > wrote: > >> select random(), random() from blah order by random() >> >> >> >> Error ambiguous column "random()" near "order by". > > Thing is, that's not ambiguous. I don't really care how SQLite implements it, > but there is no excuse for generating such a ridiculous error message. Humph. Just tried that: Third-Mini% sqlite3 wiggy -- Loading resources from /Users/tim/.sqliterc SQLite version 3.8.11.1 2015-07-29 20:00:57 Enter ".help" for usage hints. sqlite> create table blah (i integer); sqlite> insert into blah values (1),(2),(3); sqlite> select * from blah; i ---------- 1 2 3 sqlite> select random(), random() from blah order by random(); random() random() -------------------- -------------------- -1160299830889587722 -7414485036625888028 -6378873629815772700 -1303234951729421433 -8825674707761070860 -5468899718757218165 sqlite> No error message. -- Cheers -- Tim