blob bug

[@more@]

root@test 06:52:04>CREATE TABLE t4(c1 int,c2 int,c3 MEDIUMBLOB,PRIMARY KEY(c1)) engine=innodb;
Query OK, 0 rows affected (0.01 sec)

root@test 06:52:05>insert into t4 values(1, 2, REPEAT('b', 54903));
Query OK, 1 row affected (0.04 sec)

root@test 06:52:12>start transaction;
Query OK, 0 rows affected (0.00 sec)

root@test 06:52:18>update t4 set c1 = 3;
Query OK, 1 row affected (0.02 sec)
Rows matched: 1 Changed: 1 Warnings: 0

root@test 06:52:24>rollback;
Query OK, 0 rows affected (0.01 sec)

root@test 06:52:30>start transaction;
Query OK, 0 rows affected (0.00 sec)

root@test 06:52:37>update t4 set c1 = 3;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

root@test 06:52:41>rollback;
ERROR 2013 (HY000): Lost connection to MySQL server during query
悲剧了

ITPub博客

mysql bug 55981