[Bug 310211] [NEW] MySQL table check fails in ANSI mode
xubuntu at w-p.dds.nl
Sun Dec 21 12:32:59 GMT 2008
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"
All the double quotes in this snippet should have been single quotes.
** Affects: mysql-dfsg-5.0 (Ubuntu)
MySQL table check fails in ANSI mode
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.
More information about the Ubuntu-server-bugs