ID #1135

Timestamp defined "ON UPDATE CURRENT_TIMESTAMP" updates incorrectly.

It has been reported that with MySQL 5.1.x and the INNODB storage engine the "ON UPDATE CURRENT_TIMESTAMP" clause for TIMESTAMP types is not functional! Sometimes such timestamp for a row will update even if there is no change in any other column.

Refer to:

MyISAM tables work as expected/as documented. It is not known if any 3rd party engines are affected.

Probably all MySQL 5.1 versions before 5.1.21 are affected by this bug.

Tags: -

Related entries:

You can comment this FAQ