News for hackers. Stuff that matters.
Re:Distinct on: a confusing, unique and useful feature in Po... by Groxx on Friday March 20, 2020 @07:52PM (#22642955)
Huh. It has been enabled on every system I've touched so far, didn't realize it wasn't on by default. TIL
Re:Distinct on: a confusing, unique and useful feature in Po... by Groxx on Saturday March 21, 2020 @06:35PM (#22650818)
It'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.ht... vs https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.ht...