1CREATE TABLE t1 (f2 VARCHAR (32), f4 LONGBLOB, f5 TEXT) ENGINE=HEAP;
2INSERT INTO t1 VALUES ('a', NULL, NULL),
3('b' , REPEAT('a' , 593338), REPEAT('a', 800));
4UPDATE t1 SET f2 = 'c' WHERE f4 = 'd';
5SELECT LENGTH(f2), LENGTH(f4), LENGTH(f5) FROM t1;
6LENGTH(f2)	LENGTH(f4)	LENGTH(f5)
71	NULL	NULL
81	593338	800
9DROP TABLE t1;
10