MySQL Bugs: #31667: Error while restoring schema/table/view with a parentheses "(" in the name.

Bug #31667	Error while restoring schema/table/view with a parentheses "(" in the name.
Submitted:	17 Oct 2007 14:09	Modified:	28 Oct 2009 13:50
Reporter:	Kailashnath Ahir	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	1.2.12	OS:	Windows (XP Home Edition SP 2)
Assigned to:		CPU Architecture:	Any
Tags:	CHECKED, name, parentheses, restore

Description:
1. Created a schema "abc (hellow)". 
2. Did backup with MySQL Administrator 1.2.12. 
3. While using restore following error message popped

--- Error Message ---
Warning: Do not know how to handle this statement at line 21:
USE `abc (hellow)`;
Ignoring this statement. Please file a bug-report including the statement if this statement should be recognized.

Error while executing this query:DROP TABLE IF EXISTS `abc`;
The server has returned this error message:No database selected
MySQL Error.
-------------------

"mysql --version" command displays:
Ver 14.12 Distrib 5.0.45, for Win32 (ia32)

Note: I checked the same for views and tables with brackets in their names. The backup works fine but the restore encounters an error.

How to repeat:
1. Create a schema "abc (hellow)". 
2. Do a backup of schema with MySQL Administrator 1.2.12.
3. Restore the schema with MySQL Administrator 1.2.12.

Note: Error also occurs for views and tables with brackets in their name.

Thank you for the bug report.

I am sure this is working already in Workbench 5.2. I will test it.

Thank you for your bug report. This issue has been already fixed in our source repository of Workbench 5.2 and will be incorporated into the next release.