Public bug reported:
Description:
When db in table mysql.proc contains symbol '\0' all selects from
INFORMATION_SCHEMA.PARAMETERS fail with error "query 'SELECT * From
information_schema.PARAMETERS' failed: 1064: You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version for the
right syntax to use near '`test' at line 1"
How to repeat:
create procedure p1() begin end;
SELECT * From information_schema.PARAMETERS;
update mysql.proc set db='test\0' where db='test';
SELECT * From information_schema.PARAMETERS;
I don't know how such database was created in customer's environment
(maybe broken dump/restore), but having such invalid entries in
mysql.proc table should not affect Information Schema anyway.
** Affects: mysql-server
Importance: Unknown
Status: Unknown
** Affects: percona-server
Importance: Undecided
Status: Confirmed
** Affects: percona-server/5.5
Importance: Undecided
Status: Confirmed
** Affects: percona-server/5.6
Importance: Undecided
Status: Confirmed
** Tags: i62713
** Also affects: percona-server/5.5
Importance: Undecided
Status: New
** Also affects: percona-server/5.6
Importance: Undecided
Status: Confirmed
** Bug watch added: MySQL Bug System #79581
http://bugs.mysql.com/bug.php?id=79581
** Also affects: mysql-server via
http://bugs.mysql.com/bug.php?id=79581
Importance: Unknown
Status: Unknown
** Changed in: percona-server/5.5
Status: New => Confirmed
--
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1524507
Title:
Error 1064 on selects from Information Schema if routine name has '\0'
To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/1524507/+subscriptions
--
Mailing list: https://launchpad.net/~enterprise-support
Post to : [email protected]
Unsubscribe : https://launchpad.net/~enterprise-support
More help : https://help.launchpad.net/ListHelp
