[Bug 310211] [NEW] MySQL table check fails in ANSI mode
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
[Bug 310211] [NEW] MySQL table check fails in ANSI mode
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 Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs