Debian Codegraph @

mysql-test/suite/innodb/r/blob_redo.result

raw
1 #
2 # Bug #19498877 LIMITATION ON BLOB SIZE IS TOO STRICT, BLOB CAN
3 # BE 10% OF TOTAL REDO LOG SIZE
4 #
5 SET GLOBAL max_allowed_packet = 100*1024*1024;
6 # Connection big_packets:
7 CREATE TABLE t1 (a BIGINT PRIMARY KEY, b LONGBLOB) ENGINE=InnoDB;
8 INSERT INTO t1 (a, b) VALUES (1, '1');
9 INSERT INTO t1 (a, b) VALUES (2, '2');
10 INSERT INTO t1 (a, b) VALUES (3, '3');
11 INSERT INTO t1 (a, b) VALUES (4, '4');
12 INSERT INTO t1 (a, b) VALUES (5, '5');
13 start transaction;
14 INSERT INTO t1 (a, b) VALUES (6, REPEAT('a', 6*1024*1024));
15 # Connection default:
16 # Kill and restart
17 SELECT a, b FROM t1;
18 a b
19 1 1
20 2 2
21 3 3
22 4 4
23 5 5
24 SET GLOBAL max_allowed_packet = 100*1024*1024;
25 # Connection big_packets:
26 start transaction;
27 UPDATE t1 SET b = REPEAT('a', 6*1024*1024) WHERE a = 1;
28 # Connection default:
29 # Kill and restart
30 # Connection default:
31 SELECT a, b FROM t1;
32 a b
33 1 1
34 2 2
35 3 3
36 4 4
37 5 5
38 DROP TABLE t1;