[Bug 310211] Re: MySQL table check fails in ANSI mode

[nairbv]

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 at 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 at dev1:/etc/mysql$ cat /proc/version
Linux version 2.6.27-11-generic (buildd at yellow) (gcc version 4.3.2 (Ubuntu 4.3.2-1ubuntu11) ) #1 SMP Wed Apr 1 20:53:41 UTC 2009
bvaughan at dev1:/etc/mysql$ mysql --version
mysql  Ver 14.12 Distrib 5.0.67, for debian-linux-gnu (x86_64) using readline 5.2

bvaughan at dev1:/etc/mysql$ sudo ./debian-start 
Checking for corrupt, not cleanly closed and upgrade needing tables.
bvaughan at 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?

-- 
MySQL table check fails in ANSI mode
https://bugs.launchpad.net/bugs/310211
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.