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

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 bug

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

> 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 e