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$
** 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,
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
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
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,
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
** 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