Bug #25081 SHOW FULL TABLES on table with latin chars in name fails
Submitted: 14 Dec 2006 21:12 Modified: 15 Mar 2007 4:32
Reporter: Mark Matthews Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Charsets Severity:S3 (Non-critical)
Version:5.1-bk OS:Linux (RHEL4)
Assigned to: Alexander Barkov CPU Architecture:Any

[14 Dec 2006 21:12] Mark Matthews
Description:
This is from a regression test in the JDBC driver. Creating a table with latin characters in the name causes the output of SHOW FULL TABLES to have "ERROR" for the table type.

(this same table name works fine in 4.1 and 5.0, also note that in 5.1, it shows up okay in INFORMATION_SCHEMA.tables).

How to repeat:
create table `été` (field1 int);

show full tables;

(should show "ERROR" as table_type)
[14 Dec 2006 21:30] Miguel Solorzano
Thank you for the bug report.

mysql> show full tables;
+----------------+------------+
| Tables_in_test | Table_type |
+----------------+------------+
| été          | ERROR      |
[11 Jan 2007 10:24] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/17921
[11 Jan 2007 11:28] Sergei Glukhov
ok to push
[23 Jan 2007 10:32] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/18609
[8 Mar 2007 8:20] Andrei Elkin
pushed to 5.1.17-beta
[15 Mar 2007 4:32] Paul Dubois
Noted in 5.1.17 changelog.

Creating a table with latin characters in the name caused the output
of SHOW FULL TABLES to have ERROR for the table type.