Bug #40739 SHOW TABLE STATUS does not report Create_time etc
Submitted: 14 Nov 2008 12:55 Modified: 28 Jan 2009 17:34
Reporter: Johan Andersson Email Updates:
Status: Verified Impact on me:
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S4 (Feature request)
Version:mysql-5.1-telco-7.0 OS:Any
Assigned to: CPU Architecture:Any

[14 Nov 2008 12:55] Johan Andersson
create_time, update_time, check_time are  NULL.
Should be set when:
1) create the table
2) when it is auto-discovered
3) alter the table

Perhaps also write a schema version so it is possible to verify on all mysql servers that they have the correct schema version and not just assume it!

Moreover, index length is null (this has been a bug back and forth since 2004).

mysql> show table status like '%taxrate%' \G
*************************** 1. row ***************************
           Name: taxrate
         Engine: ndbcluster
        Version: 10
     Row_format: Dynamic
           Rows: 10
 Avg_row_length: 100
    Data_length: 262144
Max_data_length: 0
   Index_length: 0
      Data_free: 0
 Auto_increment: NULL
    Create_time: NULL
    Update_time: NULL
     Check_time: NULL
      Collation: utf8_bin
       Checksum: NULL
1 row in set (0.00 sec)

How to repeat:
show table status

Suggested fix:
[19 Nov 2008 13:46] Hartmut Holzgraefe
For index_length see bug #40848.
For schema version of the bug see #40740
[18 May 2009 8:21] Hartmut Holzgraefe
Still exists in ndb-7.0.x