- changed status to resolved
some group by queries not compatible with ONLY_FULL_GROUP_BY
Issue #420
resolved
ERROR 1055 (42000): Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'tripwire.groups.eveID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
The default config sets a sql_mode
that updates disables ONLY_FULL_GROUP_BY
so that these broken queries will execute. We should really just fix the queries.
This is low priority, but I'll do this at some point if nobody else does.
Comments (2)
-
-
Issue
#522was marked as a duplicate of this issue. - Log in to comment
fixed in 1.27