MySQL Bugs: #23742: DB names escaped with backslash when underscore in db name

Bug #23742	DB names escaped with backslash when underscore in db name
Submitted:	28 Oct 2006 7:06	Modified:	30 Oct 2006 11:02
Reporter:	Dean Layton-James	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.2.4 rc	OS:	Windows (Win XP Pro SP2)
Assigned to:		CPU Architecture:	Any
Tags:	administrator, backslash, comma, escape, mysql administrator

Description:
I'm running MySQL Administrator v 1.2.4 rc.

if a database name contains a backslash then an escape character (backslash \) appears in the db name under the user admin schema privileges tab.

How to repeat:
To recreate:

1. create a database using mysql administrator, the db name should contain a backslash e.g. myaccount_db

2. create a new user in mysql db and click apply changes

3. click the schema privileges tab 

4. in the schemata column the database name will show as myaccount\_db

Suggested fix:
modify source code to strip slashes before displaying dm names in schemata column

Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

See also bug #22592

Ok sorry folks I miss stated the problem as I was logging the bug in a hurry.

I wrote 'backslash' instead of 'underscore' so here is a corrected bug report...

I'm running MySQL Administrator v 1.2.4 rc.

if a database name contains an _UNDERSCORE_ then an escape character (backslash \) appears in the db name under the user admin -> schema privileges tab.

To recreate:

1. create a new database using mysql administrator, the db name should contain an _UNDERSCORE_ e.g. myaccount_db

2. create a new user in mysql db and click apply changes

3. click the schema privileges tab of the user dialog

4. in the schemata column the database name will show as myaccount\_db instead of myaccount_db (notice the backslash before the underscore)

not the most important bug report I know but still a bug in the interface (presentation) code none the less.

regards

Dean

Please read comments for the bug #22592