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: | |
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
[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...