MySQL Bugs: #58495: mysqldump doesn't export backslash correctly

Bug #58495	mysqldump doesn't export backslash correctly
Submitted:	25 Nov 2010 14:26	Modified:	25 Nov 2010 15:16
Reporter:	Roland Bali	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: mysqldump Command-line Client	Severity:	S2 (Serious)
Version:	5.0, 5.1, 5.5	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	backslash, Backup, mysqldump, restore

Description:
I have a view with a backslash string literal (probably not be a good idea in the first place, but that's beside the point :)).

When doing a backup using mysqldump the exported view isn't exported as it was defined which makes it impossible to restore the backup.

How to repeat:
This is the original view:

CREATE OR REPLACE VIEW v_customer_suggestions(id, name, lft, rgt, external_id, date_created, last_updated, path) AS
SELECT	child.id AS id,
		child.name AS name,
		child.lft AS lft,
		child.rgt AS rgt,
		child.external_id AS external_id,
		child.date_created AS date_created,
		child.last_updated AS last_updated,
		GROUP_CONCAT(parent.name ORDER BY parent.depth SEPARATOR '\\\\') AS path
FROM v_customers_with_depth parent,
     v_customers_with_depth child
WHERE child.lft BETWEEN parent.lft AND parent.rgt
GROUP BY child.id;

When looking at the view exported by mysqldump the '\\\\' part is replaced by '\'.

Many thanks for writing a bug  report.

I tested on different OS with MySQL 5.0, 5.1 and 5.5.

Verified as described.

You just will get a single backslash out instead of 4 backslashes.

I wonder if this is a bug with 'mysqldump' or if it is a bug with the server (ie: SHOW CREATE returns wrong) ?

This is *not* a client/mysqldump bug. SHOW CREATE VIEW returns a single backslash in SEPERATOR.