Bug #22592 In "User Administrator", tables are duplicated when names contain underscores

• Submitted: 22 Sep 2006 14:40
• Modified: 2 Oct 2006 9:51
• Reporter: Hugo Vieira
• Status: Not a Bug
• Category: MySQL Administrator
• Severity: S3 (Non-critical)
• Version: 1.2.3rc
• OS: Windows (Windows)
• Assigned to: Mike Lischke
• CPU Architecture: Any

[22 Sep 2006 14:40] Hugo Vieira

Description:
When assigning privileges to a user in "User Administrator",
tables with names like "SYS_STATUS" appear duplicated with the following names:
SYS\_STATUS
SYS_STATUS

My MySQL server version is:
mysql  Ver 14.7 Distrib 4.1.13, for pc-linux-gnu (i686) using readline 5.0

How to repeat:
Create a table with a name containing underscores and try to assign privileges the a user.

[23 Sep 2006 1:46] MySQL Verification Team

Thank you for the bug report. Also schema names presents the same behavior.

[26 Sep 2006 8:36] Mike Lischke

How do you exactly create the privileges? Note: this part is a bit special because MySQL allows to use wildcards (%) and placeholders (_). So SYS_TABLE and SYS\_TABLE are two different things. The first assigns privileges to all objects like SYSQTABLE, SYS-TABLE etc, while the second one only allows SYS_TABLE. This is indicated by the mask character \. So if you want to assign privileges to only SYS_TABLE then use the mask character to tell MySQL your underscore is not a placeholder but part of the name.

[29 Sep 2006 11:19] Hugo Vieira

I haven't change any privileges yet with this version of MySQL Administrator.

I did it with 1.1.9 because with the new version I was not really sure what to change and if it was going to mess anything.

[2 Oct 2006 7:41] Mike Lischke

Well, actually this is not a bug, but intended behavior, since the server allows wildcards and placeholders and MA has to reflect this. I recommend that you play with that feature a bit more. Install an extra server on your system if you are afraid to mess things up. It's easy and done in only a couple of minutes.

[2 Oct 2006 9:51] Hugo Vieira

Yes, makes sence. 
I guess this issue can be closed but documented if not done yet.
Thanks Mike.

[22 Dec 2006 15:44] Milton Clark

Mike, I understand the need to specify the "\_" instead of just "_" in specifying names in commands (for database names, tables, etc.)  I don't understand the entries for schema/database privileges for a user.

In my case, we created a database, applicant_test.  When I list privileges for myself, I see entries for applicant_test and applicant\_test.  Based on the explanation, I understand what the second entry gives me, but I'm not sure what the first entry does for me.  Could you elaborate a bit.

Thanks, Mike,
Milton Clark
[e-mail]