MySQL Bugs: #40739: SHOW TABLE STATUS does not report Create

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:	None
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

Description:
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
 Create_options: 
        Comment: 
1 row in set (0.00 sec)

How to repeat:
show table status

Suggested fix:
-

For index_length see bug #40848.
For schema version of the bug see #40740

Still exists in ndb-7.0.x