Re: [sqlite] SQLite lets selecting a column that is not in the Group by clause

2010-06-11 Thread Jay A. Kreibich
On Fri, Jun 11, 2010 at 11:30:43AM +0200, Benoit Mortgat scratched on the wall: > select col1, col2 from foo group by col1; > > 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?A > > Is this a feature, a known

Re: [sqlite] SQLite lets selecting a column that is not in the Group by clause

2010-06-11 Thread Pavel Ivanov
> 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? It's sort of a "feature" of SQLite. It's

[sqlite] SQLite lets selecting a column that is not in the Group by clause

2010-06-11 Thread Benoit Mortgat
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