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?
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 dev1:/etc/ mysql$ cat /proc/version dev1:/etc/ mysql$ mysql --version
Linux dev1 2.6.27-11-generic #1 SMP Wed Apr 1 20:53:41 UTC 2009 x86_64 GNU/Linux
bvaughan@
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@
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 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
Checking for corrupt, not cleanly closed and upgrade needing tables.
bvaughan@
(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?