[Bug 310211] Re: MySQL table check fails in ANSI mode
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 Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 310211] Re: MySQL table check fails in ANSI mode
** Changed in: mysql-dfsg-5.0 (Ubuntu) Assignee: (unassigned) = Dustin Kirkland (kirkland) Status: Confirmed = In Progress -- 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. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 310211] Re: MySQL table check fails in ANSI mode
This bug was fixed in the package mysql-dfsg-5.0 - 5.1.30really5.0.75-0ubuntu6 --- mysql-dfsg-5.0 (5.1.30really5.0.75-0ubuntu6) jaunty; urgency=low [ Andreas Olsson andr...@arrakis.se ] * Modifies debian-start.inc.sh to support ANSI mode (LP: #310211) -- Dustin Kirkland kirkl...@ubuntu.com Thu, 12 Feb 2009 14:39:04 -0600 ** Changed in: mysql-dfsg-5.0 (Ubuntu) Status: In Progress = Fix Released -- 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. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 310211] Re: MySQL table check fails in ANSI mode
Understood that patches should foremost be submitted to the development release of Ubuntu. Hence, here is a debdiff to Jaunty. I've run the same sql-mode tests mentioned above on a Jaunty system. ** Attachment added: mysql-dfsg-5.0_5.1.30really5.0.75-0ubuntu5.debdiff http://launchpadlibrarian.net/21875180/mysql-dfsg-5.0_5.1.30really5.0.75-0ubuntu5.debdiff -- 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. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 310211] Re: MySQL table check fails in ANSI mode
I'm attaching a debdiff which applies DonQuichotes modifications to debian-start.inc.sh. Above mentioned SQL query is the only thing being modified. It works well both with and without the ANSI sql mode. Just to be on the safe side I've also tested the new query against these sql modes: DB2, MAXDB, MSSQL, MYSQL323, MYSQL40, ORACLE, POSTGRESQL and TRADITIONAL. ** Attachment added: mysql-dfsg-5.0_5.0.67-0ubuntu7.debdiff http://launchpadlibrarian.net/21728727/mysql-dfsg-5.0_5.0.67-0ubuntu7.debdiff -- 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. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 310211] Re: MySQL table check fails in ANSI mode
I can confirm this problem in Intrepid. The changes done in the attached debian-start.inc.sh does seem to solve the problem. ** Changed in: mysql-dfsg-5.0 (Ubuntu) Status: New = Confirmed -- 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. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
[Bug 310211] Re: MySQL table check fails in ANSI mode
** Attachment added: Replacement for /usr/share/mysql/debian-start.inc.sh . Only quotation was changed. Full file, not a diff. http://launchpadlibrarian.net/20614241/debian-start.inc.sh -- 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. -- Ubuntu-server-bugs mailing list Ubuntu-server-bugs@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs