MySQL bugs that affect SQLyog

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: http://bugs.mysql.com/bug.php?id=29310

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:

Last update: 2007-07-04 05:45
Author: Peter Laursen
Revision: 1.0

Digg it! Print this record Send to a friend Show this as PDF file
Propose a translation for Propose a translation for
Please rate this entry:

Average rating: 0 out of 5 (0 Votes )

completely useless 1 2 3 4 5 most valuable

You can comment on this entry