Bug #23486 table listing for viewing all tables under a schema always show a blank list
Submitted: 20 Oct 2006 3:46 Modified: 23 Oct 2006 12:19
Reporter: Chun Yu Liu Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.2.4 rc OS:Windows (Windows XP)
Assigned to: Vladimir Kolesnikov CPU Architecture:Any

[20 Oct 2006 3:46] Chun Yu Liu 
Description:
I tried to use the quote symbol '`' to name a table. I created a table by the following statement(in the How to repeat). The table listing for viewing tables of schema does not work. It always show a blank list. But, when I use the Query Browser to query tables, it works. Tables before I created that table and that table are both work.

How to repeat:
CREATE TABLE `jnj`.`qu``ted` (
  `ab` INTEGER UNSIGNED NOT NULL DEFAULT NULL AUTO_INCREMENT,
  PRIMARY KEY(`ab`)
)
ENGINE = InnoDB;
[20 Oct 2006 6:32] Sveta Smirnova 
Thank you for the report.

Verified as described.
[23 Oct 2006 12:19] Vladimir Kolesnikov 
Hi!

Thanks for the report, but this bug will not be fixed in near future. Try to avoid using the ` char in table names and in other identifiers. You can use the ' char instead. That works perfect with GUI tools.