MySQL Bugs: #15438: show table status doesn't report update

Bug #15438	show table status doesn't report update_time on innodb
Submitted:	2 Dec 2005 14:18	Modified:	15 Mar 2006 23:38
Reporter:	Jrme Despatis (Candidate Quality Contributor)	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	5.0.13	OS:	Linux (Linux)
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
Hi

I don't understand, i do SHOW TABLE STATUS like 'foo' to get the Update_time of a table

It works on a MyISAM table, but i get NULL on a InnoDB table... Howerver, i don't see any restriction on the table engine in the documentation :
http://dev.mysql.com/doc/refman/5.0/en/show-table-status.html

Same thing when i try to get this time with 
SELECT UPDATE_TIME FROM INFORMATION_SCHEMA.TABLES WHERE table_name='foo'

2 possibilities: 
1/ there's a bug with innoDB table
2/ the documentation is not precise enough

Thanks

How to repeat:
The description is selft explanatory

Create a myisam table, create a innodb table

SHOW TABLE STATUS like 'foo'  works

Thank you for a problem report. There is a (verified) feature request for InnoDB to keep that column updated (http://bugs.mysql.com/bug.php?id=2681). 

But you are right, that documentation should be updated and reflect this limitation of the SHOW TABLE STATUS statement for InnoDB tables.

Duplicate of Bug#18229.