Anyone?
On 10/16/2010 12:10 AM, Germán Herrera wrote: > Hi all > > I found the following strange behavior. It's rather easy to stumble upon > with: > > sqlite> create table a(id,name); > sqlite> insert into a values (1,'name1'); > sqlite> insert into a values (2,'name2'); > sqlite> select * from a; > 1|name1 > 2|name2 > sqlite> select count(*), name from a; > 2|name2 > sqlite> > > As you may know, both MySQL and SQL Server engines would refuse to run > the last query, indicating an error because not all columns come from > aggregate functions and there is no "group by" clause.. > > Is this left on purpose?, can this behavior be switched? (already > searched in the Documentation, and in the list of pragmas and couldn't > find anything). > > I'm kind of new in SQlite so please bare with my ignorance (and my poor > english ;-)). > > Thank you all for your help, and best wishes! > German _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
