CREATE TABLE t1 ( id INT PRIMARY KEY, val LONGBLOB ); INSERT INTO t1 (id,val) VALUES (1,REPEAT('a',13)); BEGIN; UPDATE t1 SET val = REPEAT('b',10000) WHERE id=1; ROLLBACK; DROP TABLE t1;