Re: [sqlite] non-aggregate columns in aggregate queries

On 6 Sep 2019, at 11:40pm, Jeff Rogers wrote: > 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? I think this is one of the things mentioned in

[sqlite] non-aggregate columns in aggregate queries

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