Public bug reported:
Binary package hint: mysql-server-5.0
Due to non-standard escaping in /usr/share/mysql/debian-start.inc.sh the
sanity check fails if MySQL is running in ANSI mode. Text strings should
be enclosed in single quotes, as double quotes can mean strings (non-
standard mode) or identifiers (ANSI standard mode). Fixed that in
uploaded file (replacement for /usr/share/mysql/debian-start.inc.sh).
What happens is a bit hard to tell exactly, as it will only show during startup
and I searched the logs for 2 hours and could not find any log entry. However,
the querylog (which is on on my system) clearly showed the wrong quotation.
(snippet from the log)
6 Query select concat("select count(*) into
@discard from `",
TABLE_SCHEMA, "`.`", TABLE_NAME, "`")
from information_schema.TABLES where ENGINE="MyISAM"
(end snippet)
All the double quotes in this snippet should have been single quotes.
** Affects: mysql-dfsg-5.0 (Ubuntu)
Importance: Undecided
Status: New
--
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
