Hi all,
It's a documented quirk that sqlite allows the inclusion of
non-aggregate, non-group by columns in an agregate query:
https://sqlite.org/quirks.html#aggregate_queries_can_contain_non_aggregate_result_columns_that_are_not_in_the_group_by_clause
The benefits aside, it's not "standard sql", or at a minimum most other
databases do not allow it. Could a pragma or build-time flag be added
to enforce "standard" behavior, i.e., raising an error rather than
handling it as currently documented?
-J
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users