SQLyog MySQL Admin FAQ - Timestamp defined "ON UPDATE CURRENT

SQLyog MySQL Admin FAQ

Navigation

2 users online | 2 Guests and 0 Registered

Latest FAQs

SQLyog Version History (2014-06-08 10:22)
I get error 1130 "Host is not allowed to ... (2014-01-30 12:21)
About CHUNKs and BULKs (2014-01-09 11:53)
SQLyog is a client for the MySQL server - ... (2013-08-04 04:48)
Problems creating a functional DSN on 64 bit Windows. ... (2013-07-22 08:34)

Sticky FAQs

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:

You can comment this FAQ