Bug #25081 SHOW FULL TABLES on table with latin chars in name fails
Submitted: 14 Dec 2006 22:12 Modified: 15 Mar 2007 5:32
Reporter: Mark Matthews
Status: Closed
Category:Server: Charsets Severity:S3 (Non-critical)
Version:5.1-bk OS:Linux (RHEL4)
Assigned to: Alexander Barkov Target Version:

[14 Dec 2006 22: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 22:30] Miguel Solorzano 
Thank you for the bug report.

mysql> show full tables;
+----------------+------------+
| Tables_in_test | Table_type |
+----------------+------------+
| été          | ERROR      |
[11 Jan 2007 11: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 12:28] Sergey Gluhov 
ok to push
[23 Jan 2007 11: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 9:20] Andrei Elkin 
pushed to 5.1.17-beta
[15 Mar 2007 5: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.