enterprise-support team mailing list archive

[Sveta Smirnova <sveta@xxxxxxxxxxxxx>]

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