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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.055 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.