5 ms·
You say ONLY_FULL_GROUP_BY was late added. But there are posts talking about this setting in 2002.
by taligent 14y ago
You say ONLY_FULL_GROUP_BY was late added. But there are posts talking about this setting in 2002.
- zzzeek 14y agobut only added in version 5 (I was using it back with version 3 in the late 90s): http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html#sqlmode_only_full_group_by http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html#... > Do not permit queries for which the select list or (as of MySQL 5.0.23) HAVING list refers to nonaggregated columns that are not named in the GROUP BY clause.
- HarrisonFisk 14y agoYou 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#sqlmode_only_full_group_by http://dev.mysql.com/doc/refman/4.1/en/server-sql-mode.html#...
- zzzeek 14y agothe point is, it's outrageous MySQL even does GROUP BY this way and that doing it the "correct" way is not even the default.