News for hackers. Stuff that matters.
Re:MySQL - Do Not Pass This Way Again by HarrisonFisk on Sunday January 27, 2013 @03:11AM (#5123617)
You quote version 3.23, yet talk about subqueries which didn't get added until version 4.1.

ONLY_FULL_GROUP_BY was added in 4.0 but only applied to select list columns, the 5.0.23 mentioned above applies to the HAVING clause list not allowing them as well:

http://dev.mysql.com/doc/refman/4.1/en/server-sql-mode.html#...

Re:MySQL - Do Not Pass This Way Again by zzzeek on Sunday January 27, 2013 @09:10AM (#5124299)
the point is, it's outrageous MySQL even does GROUP BY this way and that doing it the "correct" way is not even the default.