Comment 6 for bug 310211

Revision history for this message
nairbv (nairbv) wrote :

This affects more than just ansi mode... I'm having essentially the same issue when setting sql-mode="ONLY_FULL_GROUP_BY" in my.cnf, running ubuntu 8.10.

bvaughan@dev1:/etc/mysql$ uname -a
Linux dev1 2.6.27-11-generic #1 SMP Wed Apr 1 20:53:41 UTC 2009 x86_64 GNU/Linux
bvaughan@dev1:/etc/mysql$ cat /proc/version
Linux version 2.6.27-11-generic (buildd@yellow) (gcc version 4.3.2 (Ubuntu 4.3.2-1ubuntu11) ) #1 SMP Wed Apr 1 20:53:41 UTC 2009
bvaughan@dev1:/etc/mysql$ mysql --version
mysql Ver 14.12 Distrib 5.0.67, for debian-linux-gnu (x86_64) using readline 5.2

bvaughan@dev1:/etc/mysql$ sudo ./debian-start
Checking for corrupt, not cleanly closed and upgrade needing tables.
bvaughan@dev1:/etc/mysql$ ERROR 1140 (42000) at line 1: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

(that /etc/mysql/debian-start file is called when I run /etc/init.d/mysql start)

Will the fix also fix the group by queries, or is this fix only fixing the non-standard quotes?