Bug #25570 show full tables error

• Submitted: 12 Jan 2007 6:12
• Modified: 18 Jan 2007 6:41
• Reporter: ming lu
• Status: Duplicate
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 5.1.14
• OS: Linux (linux)
• Assigned to: Assigned Account
• CPU Architecture: Any

[12 Jan 2007 6:12] ming lu

Description:
If the table name include a blank character between two words, it will cause a error when you execute a statement like 'show full tables'

How to repeat:
create schema order;
use order;
create table `order details`(order_id int,category_id int,quantity double);
create table orders(id int,name varchar(20));
show full tables;

mysql> show full tables;
+----------------+------------+
| Tables_in_test | Table_type |
+----------------+------------+
| order details  | ERROR      | 
| orders         | BASE TABLE | 
+----------------+------------+
2 rows in set (0.00 sec)

The Table_type of 'order details' is 'ERROR'.

I find that you willn't get the 'order details' table when you call JDBC API's  DatabaseMeta.GetTables() function in this instance.

[12 Jan 2007 7:16] Sveta Smirnova

Thank you for the report.

Verified as described.

[18 Jan 2007 6:41] Sergei Glukhov

duplicated with bug#25081