Error 1064 on selects from Information Schema if routine name has '\0'
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
||||
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
Triaged
|
Medium
|
Unassigned | |||
5.6 |
Triaged
|
Medium
|
Unassigned | |||
5.7 |
Triaged
|
Medium
|
Unassigned |
Bug Description
Description:
When db in table mysql.proc contains symbol '\0' all selects from INFORMATION_
How to repeat:
create procedure p1() begin end;
SELECT * From information_
update mysql.proc set db='test\0' where db='test';
SELECT * From information_
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.
tags: | added: upstream |
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PS-1679