Bug #6069 SHOW GRANTS hangs for table with a special name

• Submitted: 13 Oct 2004 17:15
• Modified: 8 Nov 2004 9:24
• Reporter: Peter Gulutzan
• Status: Closed
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0.2-alpha-debug
• OS: Linux (SuSE 8.2)
• Assigned to: Alexander Barkov
• CPU Architecture: Any

[13 Oct 2004 17:15] Peter Gulutzan

Description:
I have a table named L'éclipse (the third character in this name is lower case e acute). 
I can grant a privilege on this table to (anyone). 
When I say "SHOW GRANTS FOR (anyone)" the server hangs, I have to kill -9 to stop it. 
 

How to repeat:
mysql> create table `L'éclipse` (s1 int); 
Query OK, 0 rows affected (0.28 sec) 
 
mysql> grant select on `L'éclipse` to guilhem; 
Query OK, 0 rows affected (0.00 sec) 
 
mysql> select * from mysql.tables_priv; 
+------+-----+---------+------------+----------------+---------------------+------------+-------------+ 
| Host | Db  | User    | Table_name | Grantor        | Timestamp           | Table_priv | 
Column_priv | 
+------+-----+---------+------------+----------------+---------------------+------------+-------------+ 
| %    | db1 | guilhem | L'éclipse | root@localhost | 2004-10-13 11:09:36 | Select     |             
| 
+------+-----+---------+------------+----------------+---------------------+------------+-------------+ 
1 row in set (0.00 sec) 
 
mysql> show grants for guilhem;

[26 Oct 2004 8:47] Alexander Barkov

It was fixed in 4.1 quite long ago. Someone needs to merge
the changes into 5.0.

[8 Nov 2004 9:24] Alexander Barkov

The patch fixing this problem has been merged from 4.1.