Tiago Dionizio wrote:
Hi,
I am using a recent copy from CVS and tried this: (sorry for the quick and dirty test)
SQLite version 3.0.8 Enter ".help" for instructions sqlite> create table t(a); sqlite> insert into t values(1); sqlite> select a from t group by a; SQL error: GROUP BY may only be used on aggregate queries sqlite>
this behaviour was observed after check-in 2176
I believe that the query used above is perfectly valid. Is this the intended behaviour?
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. But prior to check-in 2176, the restriction was not fully enforced. Check-in 2176 added tougher enforcement of the restriction.
-- D. Richard Hipp -- [EMAIL PROTECTED] -- http://www.hwaci.com/drh/
