Hello I am running the last version on SQLite (precompiled 3.6.23.1 binary release for Windows as found on http://www.sqlite.org/sqlite-3_6_23_1.zip) command line. Here is the input:
create temporary table foo(col1 text, col2 text); insert into foo values('a','b'); insert into foo values('a','c'); insert into foo values('b','d'); insert into foo values('b','e'); .mode select col1, col2 from foo group by col1; a|c b|e As you can see, that last query does not result in any error, however col2 should not be selectable if not in the group by clause? Is this a feature, a known bug or an unknown one? If this is a feature, is there a pragma to forbid such a syntax? Have a nice day -- Benoit Mortgat 20, avenue Marcel Paul 69200 Vénissieux, France +33 6 17 15 41 58 +33 4 27 11 61 23 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users