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.
bvaug...@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 bvaug...@dev1:/etc/mysql$ cat /proc/version Linux version 2.6.27-11-generic (bui...@yellow) (gcc version 4.3.2 (Ubuntu 4.3.2-1ubuntu11) ) #1 SMP Wed Apr 1 20:53:41 UTC 2009 bvaug...@dev1:/etc/mysql$ mysql --version mysql Ver 14.12 Distrib 5.0.67, for debian-linux-gnu (x86_64) using readline 5.2 bvaug...@dev1:/etc/mysql$ sudo ./debian-start Checking for corrupt, not cleanly closed and upgrade needing tables. bvaug...@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 Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
