Bug #9716 SHOW TABLE STATUS FROM `information_schema` doesn't show number of rows
Submitted: 7 Apr 2005 13:38 Modified: 11 Jun 2005 1:47
Reporter: MySQL-Front Team Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.0.3-beta OS:Windows (Windows XP)
Assigned to: Paul DuBois CPU Architecture:Any

[7 Apr 2005 13:38] MySQL-Front Team 
Description:
SHOW TABLE STATUS FROM `information_schema`;

... shows "NULL" in the column "Rows" for each table.

How to repeat:
SHOW TABLE STATUS FROM `information_schema`;
[7 Apr 2005 13:58] MySQL Verification Team 
Verified with Windows 5.0.4 BK:

*************************** 15. row ***************************
           Name: KEY_COLUMN_USAGE
         Engine: MEMORY
        Version: 0
     Row_format: Fixed
           Rows: NULL
 Avg_row_length: 4058
    Data_length: 0
Max_data_length: 16767656
   Index_length: 0
      Data_free: 0
 Auto_increment: NULL
    Create_time: NULL
    Update_time: NULL
     Check_time: NULL
      Collation: utf8_general_ci
       Checksum: NULL
 Create_options: max_rows=4134
        Comment:
15 rows in set (0.05 sec)
[10 Jun 2005 7:59] Sergei Glukhov 
It's not a bug it's expected behavoiur. 
We should add something about
this situation to manual.

Note from PeterG:
In Section 22.1.2 The INFORMATION_SCHEMA TABLES Table
http://dev.mysql.com/doc/mysql/en/tables-table.html
I believe one could say:

"The TABLE_ROWS column is NULL if the table itself
is in the INFORMATION_SCHEMA database."
[10 Jun 2005 8:27] MySQL-Front Team 
Sorry, but I think this is a bug - even if you have problems to solve it!
[11 Jun 2005 1:47] Paul DuBois 
In the section on the TABLES table, I've added
a note that TABLE_ROWS is NULL for
INFORMATION_SCHEMA tables.
[11 Jun 2005 5:42] MySQL-Front Team 
Thank you for documenting the bug!

It's a very!!! bad handling of bugs. Other developers prefer to fix bugs instead of documenting it...