Bug #61840 mysqldbcopy copying routines
Submitted: 12 Jul 2011 19:20 Modified: 9 Jul 2012 19:14
Reporter: Samitha Dharmarathna Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Utilities Severity:S2 (Serious)
Version:5.2.34CE OS:Windows (Vista x64, XP 32-bit)
Assigned to: Assigned Account CPU Architecture:Any
Tags: mysqldbcopy, routines

[12 Jul 2011 19:20] Samitha Dharmarathna
Description:
When mysqldbcopy is used to copy a database, routines with '%' gets doubled in destination database, Even the routine header.
e.g. CREATE DEFINER=`root`@`%` PROCEDURE will be created in the destination as
CREATE DEFINER=`root`@`%%` PROCEDURE
Any statements used with % signs e.g. date formatting will have the same issue

How to repeat:
Create a routine in the source database with date format function e.g.
DATE_FORMAT(mydatetime, '%d/%m %H:%i') AS X

use mysqldbcopy to copy this database. Check the same routing in the destination database for routine header and the above line to see how the percentage marks are.
[13 Jul 2011 11:22] Valeriy Kravchuk
Thank you for the bug report. Verified just as described with Workbench 5.2.34.2 on Windows XP.
[9 Jul 2012 19:14] Chuck Bell
Fixed in Release 1.0.3.