Bug #69689 innodb update_time column from information_schema.tables not update
Submitted: 8 Jul 2013 11:41 Modified: 8 Jul 2013 13:42
Reporter: Didier Wiroth Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:5.6 OS:Any
Assigned to: CPU Architecture:Any
Tags: innodb, not updated, Update_time

[8 Jul 2013 11:41] Didier Wiroth 
Description:
When updating, inserting or deleting rows in an innodb db/schema the update_time column is not updated in the information_schema.tables table.

How to repeat:
a) create an innodb database f.ex. test 
b) create a table xyz in the test db.
c) insert/update/delete values into the xyz table.
d) select update_time from information_schema.tables where table_schema = 'test'; 

update_time is always NULL.
[8 Jul 2013 13:23] Hartmut Holzgraefe 
Expected behavior for 5.6 and before, will only change with 5.7?

See also http://comments.gmane.org/gmane.comp.db.mysql.general/112102
[8 Jul 2013 13:36] MySQL Verification Team 
Hello Didier.

Thank you for the bug report. 
Verified as described on 5.6.12.

Thanks,
Umesh
[8 Jul 2013 13:38] MySQL Verification Team 
Thank you for the bug report, duplicate of Bug #14374
Also, see Bug #69673
[8 Jul 2013 13:38] Hartmut Holzgraefe 
Duplicate of http://bugs.mysql.com/bug.php?id=14374