Bug #10018 use INFORMATION_SCHEMA works, but show tables in it returns error.
Submitted: 19 Apr 2005 22:40 Modified: 19 May 2005 1:21
Reporter: Konstantin Osipov (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version: OS:
Assigned to: Sergei Glukhov CPU Architecture:Any

[19 Apr 2005 22:40] Konstantin Osipov
Description:
When I use INFORMATION_SCHEMA (notice all-caps) it works, but subsequent SHOW TABLES returns error.

mysql> use information_schema;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+---------------------------------------+
| Tables_in_information_schema          |
+---------------------------------------+
| SCHEMATA                              |
| TABLES                                |
| COLUMNS                               |
| CHARACTER_SETS                        |
| COLLATIONS                            |
| COLLATION_CHARACTER_SET_APPLICABILITY |
| ROUTINES                              |
| STATISTICS                            |
| VIEWS                                 |
| USER_PRIVILEGES                       |
| SCHEMA_PRIVILEGES                     |
| TABLE_PRIVILEGES                      |
| COLUMN_PRIVILEGES                     |
| TABLE_CONSTRAINTS                     |
| KEY_COLUMN_USAGE                      |
+---------------------------------------+
15 rows in set (0.00 sec)

mysql> use INFORMATION_SCHEMA;
Database changed
mysql> show tables;
ERROR 12: Can't read dir of './INFORMATION_SCHEMA/' (Errcode: 2)

How to repeat:
See description.
[20 Apr 2005 5:46] 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/internals/24157
[6 May 2005 14:11] 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/internals/24626
[10 May 2005 10:16] 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/internals/24770
[10 May 2005 13:36] 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/internals/24780
[10 May 2005 13:40] Sergei Glukhov
Fixed in 5.0.6 tree
[19 May 2005 1:21] Paul Dubois
Noted in 5.0.6 changelog.