Debian Codegraph @

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

raw
1 --source include/have_debug.inc
2
3 CREATE TABLE t1 (a INT, b INT);
4
5 INSERT INTO t1 VALUES(0, 1), (1, 2);
6 SELECT * FROM t1;
7
8 SET SESSION DEBUG="+d,ib_truncate_fail_after_rename";
9 --error ER_GET_ERRNO
10 TRUNCATE TABLE t1;
11 CHECK TABLE t1;
12 SHOW CREATE TABLE t1;
13 SELECT * FROM t1;
14
15 INSERT INTO t1 VALUES(0, 1), (1, 2);
16 SELECT * FROM t1;
17
18 SET SESSION DEBUG="-d,ib_truncate_fail_after_rename";
19 SET SESSION DEBUG="+d,ib_truncate_fail_after_delete";
20 --error ER_GET_ERRNO
21 TRUNCATE TABLE t1;
22 CHECK TABLE t1;
23 SHOW CREATE TABLE t1;
24 SELECT * FROM t1;
25
26 INSERT INTO t1 VALUES(0, 1), (1, 2);
27 SELECT * FROM t1;
28
29 SET SESSION DEBUG="-d,ib_truncate_fail_after_delete";
30 SET SESSION DEBUG="+d,ib_truncate_fail_after_create_new_table";
31 --error ER_GET_ERRNO
32 TRUNCATE TABLE t1;
33 CHECK TABLE t1;
34 SHOW CREATE TABLE t1;
35 SELECT * FROM t1;
36
37 SET SESSION DEBUG="-d,ib_truncate_fail_after_create_new_table";
38 TRUNCATE TABLE t1;
39 CHECK TABLE t1;
40 SHOW CREATE TABLE t1;
41 SELECT * FROM t1;
42
43 DROP TABLE t1;
44
45
46
47 CREATE TABLE t1 (
48 a INT NOT NULL AUTO_INCREMENT,
49 b INT NOT NULL,
50 PRIMARY KEY (a)
51 )
52 ENGINE=InnoDB
53 PARTITION BY RANGE (a)
54 PARTITIONS 3
55 (PARTITION P1 VALUES LESS THAN (5),
56 PARTITION P2 VALUES LESS THAN (20),
57 PARTITION p3 VALUES LESS THAN MAXVALUE);
58 INSERT INTO t1 VALUES(0, 1), (0, 2), (0, 3), (0, 4), (0, 5), (0, 6), (0, 7);
59 SELECT count(*) FROM t1;
60
61 SET SESSION DEBUG="+d,ib_truncate_fail_after_rename";
62 --error ER_GET_ERRNO
63 ALTER TABLE t1 TRUNCATE PARTITION p2;
64 CHECK TABLE t1;
65 SHOW CREATE TABLE t1;
66 SELECT count(*) FROM t1;
67
68 SET SESSION DEBUG="-d,ib_truncate_fail_after_rename";
69 SET SESSION DEBUG="+d,ib_truncate_fail_after_delete";
70 --error ER_GET_ERRNO
71 ALTER TABLE t1 TRUNCATE PARTITION p2;
72 CHECK TABLE t1;
73 SHOW CREATE TABLE t1;
74 SELECT count(*) FROM t1;
75
76 SET SESSION DEBUG="-d,ib_truncate_fail_after_delete";
77 SET SESSION DEBUG="+d,ib_truncate_fail_after_create_new_table";
78 --error ER_GET_ERRNO
79 ALTER TABLE t1 TRUNCATE PARTITION p2;
80 CHECK TABLE t1;
81 SHOW CREATE TABLE t1;
82 SELECT count(*) FROM t1;
83
84 SET SESSION DEBUG="-d,ib_truncate_fail_after_create_new_table";
85 ALTER TABLE t1 TRUNCATE PARTITION p2;
86 CHECK TABLE t1;
87 SHOW CREATE TABLE t1;
88 SELECT count(*) FROM t1;
89
90 DROP TABLE t1;