[Bug 310211] [NEW] MySQL table check fails in ANSI mode

DonQuichote 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"
(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
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 mailing list