3 ms·
But not by default. It's related to ONLY_FULL_GROUP_BY. More here: https://dev.mysql.com/doc/refman/8.0/en/group-by-handling.html https://dev.mysql.com/doc/ref
by bfoks 7y ago
But not by default. It's related to ONLY_FULL_GROUP_BY.
More here: https://dev.mysql.com/doc/refman/8.0/en/group-by-handling.html https://dev.mysql.com/doc/refman/8.0/en/group-by-handling.ht...
- Groxx 7y agoHuh. It has been enabled on every system I've touched so far, didn't realize it wasn't on by default. TIL
- Groxx 7y agoIt's entirely possible I've mostly touched 5.6 systems, now that I think about it. Looks like this changed in 5.7(.5 specifically): https://dev.mysql.com/doc/refman/5.6/en/group-by-handling.html https://dev.mysql.com/doc/refman/5.6/en/group-by-handling.ht... vs https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.ht...