Bug #5036 mysqlshow is missing a column
Submitted: 13 Aug 2004 21:11 Modified: 23 Mar 2005 18:42
Reporter: Paul DuBois
Status: Closed
Category:Client Severity:S3 (Non-critical)
Version:5.0.2 OS:Any (Any)
Assigned to: Jim Winstead Target Version:

[13 Aug 2004 21: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 10: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 15: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 19: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 5:53] Alexander Barkov 
Ok to push.
[23 Mar 2005 2:54] Jim Winstead 
Pushed, will be in 5.0.4.
[23 Mar 2005 18:42] Paul DuBois 
Noted in 5.0.4 changelog.