Debian Codegraph @

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

raw
1 --source include/have_innodb_max_16k.inc
2
3 --echo #
4 --echo # Bug #19498877 LIMITATION ON BLOB SIZE IS TOO STRICT, BLOB CAN
5 --echo # BE 10% OF TOTAL REDO LOG SIZE
6 --echo #
7
8 SET GLOBAL max_allowed_packet = 100*1024*1024;
9
10 --echo # Connection big_packets:
11 connect(big_packets,localhost,root,,);
12 connection big_packets;
13
14 CREATE TABLE t1 (a BIGINT PRIMARY KEY, b LONGBLOB) ENGINE=InnoDB;
15
16 # Insert a few rows (it doesn't really matter how many). These transactions
17 # are committed once they are acked, so they should not be lost.
18 INSERT INTO t1 (a, b) VALUES (1, '1');
19 INSERT INTO t1 (a, b) VALUES (2, '2');
20 INSERT INTO t1 (a, b) VALUES (3, '3');
21 INSERT INTO t1 (a, b) VALUES (4, '4');
22 INSERT INTO t1 (a, b) VALUES (5, '5');
23
24 start transaction;
25 INSERT INTO t1 (a, b) VALUES (6, REPEAT('a', 6*1024*1024));
26
27 --echo # Connection default:
28 connection default;
29
30 # Wait for 300 seconds instead of the default 100
31 --let $wait_counter= 3000
32 --source include/kill_and_restart_mysqld.inc
33
34 --disconnect big_packets
35
36 # We should see (1,2,3,4,5) here.
37 SELECT a, b FROM t1;
38
39 SET GLOBAL max_allowed_packet = 100*1024*1024;
40
41 --echo # Connection big_packets:
42 connect(big_packets,localhost,root,,);
43
44 start transaction;
45 UPDATE t1 SET b = REPEAT('a', 6*1024*1024) WHERE a = 1;
46
47 --echo # Connection default:
48 connection default;
49
50 # Wait for 300 seconds instead of the default 100
51 --let $wait_counter= 3000
52 --source include/kill_and_restart_mysqld.inc
53
54 --echo # Connection default:
55 connection default;
56
57 --disconnect big_packets
58
59 # We should see (1,2,3,4,5) here.
60 SELECT a, b FROM t1;
61
62 # Clean up.
63 DROP TABLE t1;