Bug #36798 | aggregate functions with columns and aggregate functions works (shouldn't?) | ||
---|---|---|---|
Submitted: | 19 May 2008 13:05 | Modified: | 12 Jun 2008 15:33 |
Reporter: | Tobias Asplund | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Documentation | Severity: | S2 (Serious) |
Version: | 5.1.23/5.1.24 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[19 May 2008 13:05]
Tobias Asplund
[10 Jun 2008 17:28]
Paul DuBois
Accounted for by this change? " In ORDER BY clauses, mixing aggregate functions and non-grouping columns is not allowed if the ONLY_FULL_GROUP_BY SQL mode is enabled. However, in some cases, no error was thrown because of insufficient checking. (Bug#27219) " http://dev.mysql.com/doc/refman/5.1/en/news-5-1-24.html