Debian Codegraph @

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

raw
1 CREATE TABLE t1 (a INT, b INT);
2 INSERT INTO t1 VALUES(0, 1), (1, 2);
3 SELECT * FROM t1;
4 a b
5 0 1
6 1 2
7 SET SESSION DEBUG="+d,ib_truncate_fail_after_rename";
8 TRUNCATE TABLE t1;
9 ERROR HY000: Got error 168 - 'Unknown (generic) error from engine' from storage engine
10 CHECK TABLE t1;
11 Table Op Msg_type Msg_text
12 test.t1 check status OK
13 SHOW CREATE TABLE t1;
14 Table Create Table
15 t1 CREATE TABLE `t1` (
16 `a` int DEFAULT NULL,
17 `b` int DEFAULT NULL
18 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
19 SELECT * FROM t1;
20 a b
21 0 1
22 1 2
23 INSERT INTO t1 VALUES(0, 1), (1, 2);
24 SELECT * FROM t1;
25 a b
26 0 1
27 1 2
28 0 1
29 1 2
30 SET SESSION DEBUG="-d,ib_truncate_fail_after_rename";
31 SET SESSION DEBUG="+d,ib_truncate_fail_after_delete";
32 TRUNCATE TABLE t1;
33 ERROR HY000: Got error 168 - 'Unknown (generic) error from engine' from storage engine
34 CHECK TABLE t1;
35 Table Op Msg_type Msg_text
36 test.t1 check status OK
37 SHOW CREATE TABLE t1;
38 Table Create Table
39 t1 CREATE TABLE `t1` (
40 `a` int DEFAULT NULL,
41 `b` int DEFAULT NULL
42 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
43 SELECT * FROM t1;
44 a b
45 0 1
46 1 2
47 0 1
48 1 2
49 INSERT INTO t1 VALUES(0, 1), (1, 2);
50 SELECT * FROM t1;
51 a b
52 0 1
53 1 2
54 0 1
55 1 2
56 0 1
57 1 2
58 SET SESSION DEBUG="-d,ib_truncate_fail_after_delete";
59 SET SESSION DEBUG="+d,ib_truncate_fail_after_create_new_table";
60 TRUNCATE TABLE t1;
61 ERROR HY000: Got error 168 - 'Unknown (generic) error from engine' from storage engine
62 CHECK TABLE t1;
63 Table Op Msg_type Msg_text
64 test.t1 check status OK
65 SHOW CREATE TABLE t1;
66 Table Create Table
67 t1 CREATE TABLE `t1` (
68 `a` int DEFAULT NULL,
69 `b` int DEFAULT NULL
70 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
71 SELECT * FROM t1;
72 a b
73 0 1
74 1 2
75 0 1
76 1 2
77 0 1
78 1 2
79 SET SESSION DEBUG="-d,ib_truncate_fail_after_create_new_table";
80 TRUNCATE TABLE t1;
81 CHECK TABLE t1;
82 Table Op Msg_type Msg_text
83 test.t1 check status OK
84 SHOW CREATE TABLE t1;
85 Table Create Table
86 t1 CREATE TABLE `t1` (
87 `a` int DEFAULT NULL,
88 `b` int DEFAULT NULL
89 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
90 SELECT * FROM t1;
91 a b
92 DROP TABLE t1;
93 CREATE TABLE t1 (
94 a INT NOT NULL AUTO_INCREMENT,
95 b INT NOT NULL,
96 PRIMARY KEY (a)
97 )
98 ENGINE=InnoDB
99 PARTITION BY RANGE (a)
100 PARTITIONS 3
101 (PARTITION P1 VALUES LESS THAN (5),
102 PARTITION P2 VALUES LESS THAN (20),
103 PARTITION p3 VALUES LESS THAN MAXVALUE);
104 INSERT INTO t1 VALUES(0, 1), (0, 2), (0, 3), (0, 4), (0, 5), (0, 6), (0, 7);
105 SELECT count(*) FROM t1;
106 count(*)
107 7
108 SET SESSION DEBUG="+d,ib_truncate_fail_after_rename";
109 ALTER TABLE t1 TRUNCATE PARTITION p2;
110 ERROR HY000: Got error 168 - 'Unknown (generic) error from engine' from storage engine
111 CHECK TABLE t1;
112 Table Op Msg_type Msg_text
113 test.t1 check status OK
114 SHOW CREATE TABLE t1;
115 Table Create Table
116 t1 CREATE TABLE `t1` (
117 `a` int NOT NULL AUTO_INCREMENT,
118 `b` int NOT NULL,
119 PRIMARY KEY (`a`)
120 ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
121 /*!50100 PARTITION BY RANGE (`a`)
122 (PARTITION P1 VALUES LESS THAN (5) ENGINE = InnoDB,
123 PARTITION P2 VALUES LESS THAN (20) ENGINE = InnoDB,
124 PARTITION p3 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */
125 SELECT count(*) FROM t1;
126 count(*)
127 7
128 SET SESSION DEBUG="-d,ib_truncate_fail_after_rename";
129 SET SESSION DEBUG="+d,ib_truncate_fail_after_delete";
130 ALTER TABLE t1 TRUNCATE PARTITION p2;
131 ERROR HY000: Got error 168 - 'Unknown (generic) error from engine' from storage engine
132 CHECK TABLE t1;
133 Table Op Msg_type Msg_text
134 test.t1 check status OK
135 SHOW CREATE TABLE t1;
136 Table Create Table
137 t1 CREATE TABLE `t1` (
138 `a` int NOT NULL AUTO_INCREMENT,
139 `b` int NOT NULL,
140 PRIMARY KEY (`a`)
141 ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
142 /*!50100 PARTITION BY RANGE (`a`)
143 (PARTITION P1 VALUES LESS THAN (5) ENGINE = InnoDB,
144 PARTITION P2 VALUES LESS THAN (20) ENGINE = InnoDB,
145 PARTITION p3 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */
146 SELECT count(*) FROM t1;
147 count(*)
148 7
149 SET SESSION DEBUG="-d,ib_truncate_fail_after_delete";
150 SET SESSION DEBUG="+d,ib_truncate_fail_after_create_new_table";
151 ALTER TABLE t1 TRUNCATE PARTITION p2;
152 ERROR HY000: Got error 168 - 'Unknown (generic) error from engine' from storage engine
153 CHECK TABLE t1;
154 Table Op Msg_type Msg_text
155 test.t1 check status OK
156 SHOW CREATE TABLE t1;
157 Table Create Table
158 t1 CREATE TABLE `t1` (
159 `a` int NOT NULL AUTO_INCREMENT,
160 `b` int NOT NULL,
161 PRIMARY KEY (`a`)
162 ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
163 /*!50100 PARTITION BY RANGE (`a`)
164 (PARTITION P1 VALUES LESS THAN (5) ENGINE = InnoDB,
165 PARTITION P2 VALUES LESS THAN (20) ENGINE = InnoDB,
166 PARTITION p3 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */
167 SELECT count(*) FROM t1;
168 count(*)
169 7
170 SET SESSION DEBUG="-d,ib_truncate_fail_after_create_new_table";
171 ALTER TABLE t1 TRUNCATE PARTITION p2;
172 CHECK TABLE t1;
173 Table Op Msg_type Msg_text
174 test.t1 check status OK
175 SHOW CREATE TABLE t1;
176 Table Create Table
177 t1 CREATE TABLE `t1` (
178 `a` int NOT NULL AUTO_INCREMENT,
179 `b` int NOT NULL,
180 PRIMARY KEY (`a`)
181 ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
182 /*!50100 PARTITION BY RANGE (`a`)
183 (PARTITION P1 VALUES LESS THAN (5) ENGINE = InnoDB,
184 PARTITION P2 VALUES LESS THAN (20) ENGINE = InnoDB,
185 PARTITION p3 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */
186 SELECT count(*) FROM t1;
187 count(*)
188 4
189 DROP TABLE t1;