Debian Codegraph @

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

raw
1 #
2 # Bug #27852003 LOG::ALLOC_LOB_PAGE MAY FAIL AND RETURN NULLPTR
3 # BUT IT IS NOT HANDLED
4 #
5 CREATE TABLE t1 (f1 INT PRIMARY KEY, f2 LONGBLOB);
6 SET DEBUG = '+d,innodb_alloc_lob_page_failed';
7 INSERT INTO t1 VALUES (1, REPEAT('x', 81920));
8 ERROR HY000: The table 't1' is full
9 SET DEBUG = '-d,innodb_alloc_lob_page_failed';
10 CHECK TABLE t1;
11 Table Op Msg_type Msg_text
12 test.t1 check status OK
13 CREATE TABLE t2 (f1 INT PRIMARY KEY, f2 LONGBLOB);
14 SET DEBUG = '+d,innodb_lob_data_page_alloc_failed';
15 INSERT INTO t2 VALUES (1, REPEAT('x', 81920));
16 ERROR HY000: The table 't2' is full
17 SET DEBUG = '-d,innodb_lob_data_page_alloc_failed';
18 CHECK TABLE t2;
19 Table Op Msg_type Msg_text
20 test.t2 check status OK
21 CREATE TABLE t3 (f1 INT PRIMARY KEY, f2 LONGBLOB);
22 SET DEBUG = '+d,innodb_lob_alloc_node_page_failed';
23 INSERT INTO t3 VALUES (1, REPEAT('x', 163840));
24 ERROR HY000: The table 't3' is full
25 SET DEBUG = '-d,innodb_lob_alloc_node_page_failed';
26 CHECK TABLE t3;
27 Table Op Msg_type Msg_text
28 test.t3 check status OK
29 FLUSH TABLES t1 FOR EXPORT;
30 UNLOCK TABLES;
31 FLUSH TABLES t2 FOR EXPORT;
32 UNLOCK TABLES;
33 FLUSH TABLES t3 FOR EXPORT;
34 UNLOCK TABLES;
35 DROP TABLE t1;
36 DROP TABLE t2;
37 DROP TABLE t3;