Bug in mysql 5.0.27 - make update

[oricon]

hello,
in mysql 5.0.2x is a bug. http://bugs.mysql.com/bug.php?id=8392

please make a update to v5.0.3. it is important for me!

my site is on siteground170.com.

thanks!

[sgforumadmin]

Hello,

The bug you have mentioned is not present on the SQL version we are running - 5.0.27

We have made a simple test to prove that:

mysql> show variables where Variable_name = 'version';
+---------------+---------------------+
| Variable_name | Value |
+---------------+---------------------
| version | 5.0.27-standard-log |
+---------------+---------------------+
1 row in set (0.00 sec)

mysql> CREATE TABLE `foo` ( `LOGID` int(10) unsigned NOT NULL auto_increment, `MID` int(10) unsigned NOT NULL default '0', `Datum` timestamp(10) NOT NULL, `Query` blob NOT NULL, PRIMARY KEY (`LOGID`) );


mysql> INSERT INTO foo ( LOGID, MID, Datum, Query ) VALUES ( '0', '1', now(), ' ');
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO foo ( LOGID, MID, Datum, Query ) VALUES ( '2', '2', now(), ' ');
Query OK, 1 row affected (0.00 sec)

mysql> DELETE from foo WHERE LOGID > 0 ORDER BY foo.LOGID;
Query OK, 2 rows affected (0.00 sec)