Bug #61840 mysqldbcopy copying routines

• Submitted: 12 Jul 2011 19:20
• Modified: 9 Jul 2012 19:14
• Reporter: Samitha Dharmarathna
• Status: Closed
• 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.