Re: [sqlite] SQLite 3.1.0 Group By problem

[Kurt Welgehausen]

> SELECT a FROM [table] GROUP BY a;
> Error Message in Sqlite 3.1.0 alpha: "SQL error: GROUP BY may only be
> used on aggregate queries"
> ... Hope this can be fixed.

The behavior in 3.1 is correct. It makes no sense to write
'select c from t group by c'. If you want to get distinct
values of c, write 'select distinct c ... '.

Regards