Bug #19147 mysqlshow INFORMATION_SCHEMA does not work
Submitted: 17 Apr 2006 18:48 Modified: 15 Aug 2006 3:46
Reporter: Andreas Krueger Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.17-nt/5.0BK/5.1BK OS:Windows (Windows XP Home SP2/Linux)
Assigned to: Jim Winstead CPU Architecture:Any

[17 Apr 2006 18:48] Andreas Krueger 
Description:
In contrast to the output, when other databases are specified as the 1st and only argument of mysqlshow on the command line client

mysqlshow INFORMATION_SCHEMA

does not display the tables comprised by the specified database.

How to repeat:
C:\>mysqlshow INFORMATION_SCHEMA
Wildcard: INFORMATION_SCHEMA
+--------------------+
|     Databases      |
+--------------------+
| information_schema |
+--------------------+

C:\>mysqlshow INFORMATION_SCHEMA *
Database: INFORMATION_SCHEMA  Wildcard: %
+---------------------------------------+
|                Tables                 |
+---------------------------------------+
| CHARACTER_SETS                        |
| COLLATIONS                            |
| COLLATION_CHARACTER_SET_APPLICABILITY |
| COLUMNS                               |
| COLUMN_PRIVILEGES                     |
| KEY_COLUMN_USAGE                      |
| ROUTINES                              |
| SCHEMATA                              |
| SCHEMA_PRIVILEGES                     |
| STATISTICS                            |
| TABLES                                |
| TABLE_CONSTRAINTS                     |
| TABLE_PRIVILEGES                      |
| TRIGGERS                              |
| VIEWS                                 |
| USER_PRIVILEGES                       |
+---------------------------------------+

C:\>mysqlshow world
Database: world
+------------------+
|      Tables      |
+------------------+
| capital          |
| capital_full     |
| city             |
| country          |
| countrycopy      |
| countrylanguage  |
| europe           |
| surfacecontinent |
+------------------+

C:\>mysqlshow --version
mysqlshow  Ver 9.5 Distrib 5.0.17, for Win32 (ia32)

Suggested fix:
Recognize the argument 'INFORMATION_SCHEMA' as a fully specified (no wildcards) database name and display equivalent to SHOW TABLES FROM INFORMATION_SCHEMA.
[17 Apr 2006 20:11] MySQL Verification Team 
Thank you for the bug report.
[22 Jul 2006 3:21] 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/9442
[31 Jul 2006 11:05] Magnus Blåudd 
Patch looks fine to me as well.
[3 Aug 2006 16:45] Magnus Blåudd 
Pushed to 5.0.25
[3 Aug 2006 17:52] Paul DuBois 
Noted in 5.0.25 changelog.

For mysqlshow, if a database name argument contains wildcard
characters (such as `_') but matches a single database name exactly,
treat the name as a literal name. This allows a command such as
mysqlshow information_schema to work without having to escape the
wildcard character.
[14 Aug 2006 21:05] Konstantin Osipov 
Merged into 5.1.12
[15 Aug 2006 3:46] Paul DuBois 
Noted in 5.1.12 changelog.