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
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 ]
* Modifies debian-start.inc.sh to support ANSI mode (LP: #310211)
-- Dustin KirklandThu, 12 Feb 2009 14:39:
** 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
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://launchpadlibrari
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
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 bu
** 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 not