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
