On 9 Sep 2015, at 8:56am, Domingo Alvarez Duarte <sqlite-mail at dev.dadbiz.es> wrote:
> SELECT a, random() as r FROM a WHERE r <> r; This is not valid SQL. You won't find any official SQL standard saying that 'r' can be referred to in the WHERE clause. You may find implementations of SQL where which will accept that command, and what those do is entirely up to whoever wrote them. If they have some sort of 'strict' option and you turn it on, they should instead produce an error message. Simon.