[Bug 706988] Re: Major Bug in MySQL 5.1.49 up to 5.1.52

[Koopee]

Upgraded to 11.04, where mysql version changed to 5.1.54. Works for now.

Perhaps you should consider upgrading mysql server in maverick
repositories. I think this is quite a nasty bug. It had been affecting
me and my application for months and took quite a few days to track
down.


mysql> select version();
+-----------------+
| version()       |
+-----------------+
| 5.1.54-1ubuntu4 |
+-----------------+
1 row in set (0.00 sec)

mysql> SELECT `units`.* FROM `units` INNER JOIN `units_users` ON `units`.id = `units_users`.unit_id WHERE (`units`.`id` = 72) AND ((`units_users`.user_id = 22)) LIMIT 1;
+----+------------+-------------------+------------+-------+------+-------+------+----------+--------------------+---------------------+---------------------+---------------------+----------------+--------------+------+
| id | company_id | name              | address_id | phone | fax  | email | www  | valid_to | created_by_user_id | modified_by_user_id | created_at          | updated_at          | receipt_number | lock_version | type |
+----+------------+-------------------+------------+-------+------+-------+------+----------+--------------------+---------------------+---------------------+---------------------+----------------+--------------+------+
| 72 |         22 | Company 1 |       NULL |       |      |       |      | NULL     |               NULL |                NULL | 2009-11-03 07:45:55 | 2010-08-25 20:32:29 |          69760 |        21722 | NULL |
+----+------------+-------------------+------------+-------+------+-------+------+----------+--------------------+---------------------+---------------------+---------------------+----------------+--------------+------+
1 row in set (0.00 sec)

mysql>

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-5.1 in Ubuntu.
https://bugs.launchpad.net/bugs/706988

Title:
  Major Bug in MySQL 5.1.49 up to 5.1.52