Bug #11685 SHOW TABLES; doesn't update Com_show_tables
Submitted: 1 Jul 2005 9:08 Modified: 26 Jul 2005 20:29
Reporter: Tobias Asplund Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.7 OS:Microsoft Windows (Windows/FreeBSD)
Assigned to: Sergey Glukhov CPU Architecture:Any

[1 Jul 2005 9: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 9: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 6:59] Alexander Barkov
Ok to push.
[13 Jul 2005 8: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 8:28] Sergey Glukhov
Fixed in 5.0.10
[26 Jul 2005 20:29] Paul Dubois
Noted in 5.0.10 changelog.