New answers tagged group-by
1
vote
Disable MySQL ONLY_FULL_GROUP_BY while logging violations
If you:
Create a MariaDB replica from current data it will handle a MySQL 5.5, 5.6, 5.7 master easy enough (the same way as the MySQL docs say to provision a replica). Any MariaDB version, all ...
1
vote
Disable MySQL ONLY_FULL_GROUP_BY while logging violations
No, there is no feature of MySQL to produce a warning for queries that would violate ONLY_FULL_GROUP_BY.
Either the query fails if you have that mode enabled, or the query does not fail if you have ...
Top 50 recent answers are included
Related Tags
group-by × 752mysql × 296
postgresql × 148
sql-server × 133
join × 98
aggregate × 70
count × 64
oracle × 54
select × 46
query × 44
performance × 41
sum × 41
greatest-n-per-group × 40
order-by × 35
t-sql × 31
subquery × 31
optimization × 26
query-performance × 23
distinct × 23
mariadb × 22
window-functions × 22
index × 20
group-concatenation × 17
gaps-and-islands × 16
case × 14