Bug #5036 mysqlshow is missing a column
Submitted: 13 Aug 2004 19:11 Modified: 23 Mar 2005 17:42
Reporter: Paul DuBois Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:5.0.2 OS:Any (Any)
Assigned to: Jim Winstead CPU Architecture:Any

[13 Aug 2004 19:11] Paul DuBois 
Description:
In MySQL 5.0.2, SHOW TABLES output has an additional column.
However, mysqlshow db_name continues to show only the table/view
name and not the second column.

% ./mysql test ;
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 22 to server version: 5.0.2-alpha-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show tables;
+----------------+------------+
| Tables_in_test | table_type |
+----------------+------------+
| t              | BASE TABLE |
| v              | VIEW       |
+----------------+------------+
2 rows in set (0.06 sec)

mysql> quit
Bye
ice ...mysql/50002/bin% ./mysqlshow test
Database: test
+--------+
| Tables |
+--------+
| t      |
| v      |
+--------+

How to repeat:
See above.
[7 Sep 2004 8:52] Victor Vagin 
subj: bk commit - 5.0 tree (vva:1.1725) BUG#5036

ChangeSet
  1.1725 04/09/07 00:19:37 vva@eagle.mysql.r18.ru +4 -0
  added option show_table_type to mysqlshow 
  to show new column as in show tables..
  fixed Bug #5036 "mysqlshow is missing a column"
[3 Feb 2005 14:12] Alexander Barkov 
Victor, 

Please check the result file: mysqltest.result.
You forgot to include it into your patch.
Please send the patch for review again as soon
as it is fixed.

Thanks!
[15 Mar 2005 18: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/23051
[16 Mar 2005 4:53] Alexander Barkov 
Ok to push.
[23 Mar 2005 1:54] Jim Winstead 
Pushed, will be in 5.0.4.
[23 Mar 2005 17:42] Paul DuBois 
Noted in 5.0.4 changelog.