Debian Codegraph @

mysql-test/suite/innodb/t/innodb_bug34300.test

raw
1 --echo #
2 --echo # Bug#34300 Tinyblob & tinytext fields currupted after export/import and alter in 5.1
3 --echo #
4
5
6 -- disable_query_log
7 call mtr.add_suppression("Warning: a long semaphore wait:");
8 call mtr.add_suppression("The age of the last checkpoint is");
9
10 # set packet size and reconnect
11 let $max_packet=`select @@global.max_allowed_packet`;
12 -- enable_query_log
13
14 SET @@global.max_allowed_packet=16777216;
15 --connect (newconn, localhost, root,,)
16
17 CREATE TABLE bug34300 (
18 f4 TINYTEXT,
19 f6 MEDIUMTEXT,
20 f8 TINYBLOB
21 ) ENGINE=InnoDB;
22
23 INSERT INTO bug34300 VALUES ('xxx', repeat('a', 8459264), 'zzz');
24
25 SELECT f4, f8 FROM bug34300;
26
27 ALTER TABLE bug34300 ADD COLUMN (f10 INT);
28
29 SELECT f4, f8 FROM bug34300;
30
31 --echo # Cleanup
32 DROP TABLE bug34300;
33
34 -- disable_query_log
35 EVAL SET @@global.max_allowed_packet=$max_packet;
36 -- enable_query_log
37