SQLite has never "allowed" queries to have a GROUP BY clause
unless there is an aggregate function in the result set. I
belive the documentation says as much.
Maybe it does somewhere else, but the Syntax page, under Select, says:
"The GROUP BY clauses causes one or more rows of the result to be combined into a single row of output. This is especially useful when the result contains aggregate functions."
A stronger statement seems appropriate.
Gerry Snyder
