mysqldump incorrect drop trigger

[Alexander]

mysql is allow to use trigger names that contains dots.
But when mysqldump generate sql file that contains triggers with dots it add something like this:

/*!50032 DROP TRIGGER IF EXISTS trigger.with.dots */;

It is incorrect sql statement. Name with dots must be in quotes:

/*!50032 DROP TRIGGER IF EXISTS `trigger.with.dots` */;

[Valerii Kravchuk (valerii-kravchuk)]

This is easy to confirm. Just create trigger like this in some database:

create database tri;
use tri;
create table t1(id int);
create trigger `trigger.with.dots` before insert on t1 for each row set @a=1;

and then dump with --add-drop-trigger option:

mysqldump --triggers --no-data --no-create-info --add-drop-trigger -uroot -proot -P3314 tri

to see these:

/*!50032 DROP TRIGGER IF EXISTS trigger.with.dots */;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 trigger `trigger.with.dots` before insert on t1 for each row set @a=1 */;;
...

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1656