Bug #19147 mysqlshow INFORMATION_SCHEMA does not work

• Submitted: 17 Apr 2006 20:48
• Modified: 15 Aug 2006 5:46
• Reporter: Andreas Krueger
• Status: Closed
• Category: Server
• Severity: S3 (Non-critical)
• Version: 5.0.17-nt/5.0BK/5.1BK
• OS: Microsoft Windows (Windows XP Home SP2/Linux)
• Assigned to: Jim Winstead

[17 Apr 2006 20: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 22:11] Miguel Solorzano

Thank you for the bug report.

[22 Jul 2006 5: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 13:05] Magnus Svensson

Patch looks fine to me as well.

[3 Aug 2006 18:45] Magnus Svensson

Pushed to 5.0.25

[3 Aug 2006 19: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 23:05] Konstantin Osipov

Merged into 5.1.12

[15 Aug 2006 5:46] Paul DuBois

Noted in 5.1.12 changelog.