遇到的mysql bug

来源：互联网发布：三国志9威力加强版mac 编辑：程序博客网时间：2024/05/22 17:33

mysql版本5.5，在information_schema下的tables表时，发现create_time这列是空值，百思不得其解，后查询官方文档如下：

Prior to MySQL 5.7.8, for partitioned InnoDB tables, the CREATE_TIME column always showedNULL. This column shows the correct table creation time for such tables in MySQL 5.7.8 and later. (Bug #17299181, Bug #69990)
Beginning with MySQL 5.7.2, UPDATE_TIME displays a timestamp value for the lastUPDATE,INSERT, or DELETE performed on InnoDB tables that are not partitioned. Previously,UPDATE_TIME displayed a NULL value forInnoDB tables. For MVCC, the timestamp value reflects theCOMMIT time, which is considered the last update time. Timestamps are not persisted when the server is restarted or when the table is evicted from theInnoDB data dictionary cache.
The UPDATE_TIME column also shows this information for partitionedInnoDB tables in MySQL 5.7.8 and later. Previously this column was alwaysNULL for such tables. (Bug #17299181, Bug #69990)

0 0