Bug #11685 SHOW TABLES; doesn't update Com_show_tables
Submitted: 1 Jul 2005 11:08 Modified: 26 Jul 2005 22:29
Reporter: Tobias Asplund
Status: Closed
Category:Server Severity:S3 (Non-critical)
Version:5.0.7 OS:Microsoft Windows (Windows/FreeBSD)
Assigned to: Sergey Gluhov Target Version:

[1 Jul 2005 11:08] Tobias Asplund 
Description:
SHOW TABLES doesn't correctly increment the counter Com_show_tables from the SHOW STATUS
output (see below)

How to repeat:
mysql> SHOW GLOBAL STATUS LIKE 'Com_sh%tables';
+----------------------+-------+
| Variable_name        | Value |
+----------------------+-------+
| Com_show_open_tables | 0     |
| Com_show_tables      | 0     |
+----------------------+-------+
2 rows in set (0.00 sec)

mysql> SHOW TABLES;
+-----------------+
| Tables_in_world |
+-----------------+
| City            |
| Country         |
| CountryLanguage |
| capitals        |
+-----------------+
4 rows in set (0.01 sec)

mysql> SHOW GLOBAL STATUS LIKE 'Com_sh%tables';
+----------------------+-------+
| Variable_name        | Value |
+----------------------+-------+
| Com_show_open_tables | 0     |
| Com_show_tables      | 0     |
+----------------------+-------+
2 rows in set (0.01 sec)
[7 Jul 2005 11:10] 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/26754
[13 Jul 2005 8:59] Alexander Barkov 
Ok to push.
[13 Jul 2005 10:24] 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/26979
[13 Jul 2005 10:28] Sergey Gluhov 
Fixed in 5.0.10
[26 Jul 2005 22:29] Paul DuBois 
Noted in 5.0.10 changelog.