1# 2# Bug#34300 Tinyblob & tinytext fields corrupted after export/import and alter in 5.1 3# 4SET @@global.max_allowed_packet=16777216; 5connect newconn, localhost, root,,; 6CREATE TABLE bug34300 ( 7f4 TINYTEXT, 8f6 MEDIUMTEXT, 9f8 TINYBLOB 10) ENGINE=InnoDB; 11INSERT INTO bug34300 VALUES ('xxx', repeat('a', 8459264), 'zzz'); 12SELECT f4, f8 FROM bug34300; 13f4 f8 14xxx zzz 15ALTER TABLE bug34300 ADD COLUMN (f10 INT); 16SELECT f4, f8 FROM bug34300; 17f4 f8 18xxx zzz 19# Cleanup 20DROP TABLE bug34300; 21