Debian Codegraph @

mysql-test/suite/innodb/r/innodb-wl5522-1.result

raw
1 call mtr.add_suppression("InnoDB: Unable to import tablespace .* because it already exists. Please DISCARD the tablespace before IMPORT.");
2 CREATE DATABASE testdb_wl5522;
3 CREATE TABLE testdb_wl5522.t1 (c1 INT ) ENGINE = Innodb;
4 INSERT INTO testdb_wl5522.t1 VALUES (1),(123),(331);
5 SELECT c1 FROM testdb_wl5522.t1;
6 c1
7 1
8 123
9 331
10 FLUSH TABLES testdb_wl5522.t1 FOR EXPORT;
11 SELECT * FROM testdb_wl5522.t1 ORDER BY c1;
12 c1
13 1
14 123
15 331
16 backup: t1
17 UNLOCK TABLES;
18 DROP TABLE testdb_wl5522.t1;
19 CREATE TABLE testdb_wl5522.t1 (c1 INT ) ENGINE = Innodb;
20 ALTER TABLE testdb_wl5522.t1 DISCARD TABLESPACE;
21 restore: t1 .ibd and .cfg files
22 ALTER TABLE testdb_wl5522.t1 IMPORT TABLESPACE;
23 SELECT * FROM testdb_wl5522.t1 ORDER BY c1;
24 c1
25 1
26 123
27 331
28 DROP TABLE testdb_wl5522.t1;
29 CREATE TABLE testdb_wl5522.t1 (
30 col1 BIT(1),
31 col2 BOOLEAN,
32 col3 TINYINT,
33 col4 SMALLINT,
34 col5 MEDIUMINT,
35 col6 INT,
36 col7 BIGINT,
37 col8 FLOAT (14,3) ,
38 col9 DOUBLE (14,3),
39 col10 VARCHAR(20),
40 col11 TEXT ,
41 col12 ENUM('a','b','c'),
42 col13 TEXT,
43 col14 CHAR(20),
44 col15 VARBINARY (400),
45 col16 BINARY(40),
46 col17 BLOB (400),
47 col18 INT NOT NULL PRIMARY KEY,
48 col19 DATE,
49 col20 DATETIME,
50 col21 TIMESTAMP,
51 col22 TIME,
52 col23 YEAR ) ENGINE = Innodb;
53 CREATE INDEX idx1 ON testdb_wl5522.t1(col18);
54 CREATE INDEX prefix_idx ON testdb_wl5522.t1(col14 (10));
55 CREATE UNIQUE INDEX idx2 ON testdb_wl5522.t1(col12);
56 CREATE UNIQUE INDEX idx3 ON testdb_wl5522.t1(col8);
57 INSERT INTO testdb_wl5522.t1 VALUES
58 (1,1,-128,32767,-8388608,2147483647,-9223372036854775808, 92233720368.222,
59 -92233720368.222,'aaa', + 'aaaaaaaaaa','b','bbbbb','ccccc',
60 REPEAT('d',40),REPEAT('d',40),REPEAT('d',40),1,'1000-01-01',
61 '3000-12-31 23:59:59.99','1990-01-01 00:00:01.00',
62 '01:59:59.00','1901');
63 INSERT INTO testdb_wl5522.t1 VALUES
64 (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
65 NULL,NULL,NULL,3,NULL,NULL,NULL,NULL,NULL);
66 INSERT INTO testdb_wl5522.t1 VALUES (NULL,NULL,NULL,NULL,NULL,NULL,NULL,
67 NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
68 ERROR 23000: Column 'col18' cannot be null
69 INSERT INTO testdb_wl5522.t1 VALUES (NULL,NULL,NULL,NULL,NULL,NULL,NULL,
70 NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL);
71 ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
72 FLUSH TABLES testdb_wl5522.t1 WITH READ LOCK;
73 SELECT COUNT(*) FROM testdb_wl5522.t1;
74 COUNT(*)
75 2
76 backup: t1
77 UNLOCK TABLES;
78 DROP TABLE testdb_wl5522.t1;
79 CREATE TABLE testdb_wl5522.t1 (
80 col1 BIT(1),
81 col2 BOOLEAN,
82 col3 TINYINT,
83 col4 SMALLINT,
84 col5 MEDIUMINT,
85 col6 INT,
86 col7 BIGINT,
87 col8 FLOAT (14,3) ,
88 col9 DOUBLE (14,3),
89 col10 VARCHAR(20),
90 col11 TEXT,
91 col12 ENUM('a','b','c'),
92 col13 TEXT,
93 col14 CHAR(20) ,
94 col15 VARBINARY (400) ,
95 col16 BINARY(40),
96 col17 BLOB (400) ,
97 col18 INT NOT NULL PRIMARY KEY,
98 col19 DATE ,
99 col20 DATETIME ,
100 col21 TIMESTAMP ,
101 col22 TIME,
102 col23 YEAR ) ENGINE = Innodb;
103 CREATE INDEX idx1 ON testdb_wl5522.t1(col18);
104 CREATE INDEX prefix_idx ON testdb_wl5522.t1(col14 (10));
105 CREATE UNIQUE INDEX idx2 ON testdb_wl5522.t1(col12);
106 CREATE UNIQUE INDEX idx3 ON testdb_wl5522.t1(col8);
107 ALTER TABLE testdb_wl5522.t1 DISCARD TABLESPACE;
108 restore: t1 .ibd and .cfg files
109 ALTER TABLE testdb_wl5522.t1 IMPORT TABLESPACE;
110 CHECK TABLE testdb_wl5522.t1;
111 Table Op Msg_type Msg_text
112 testdb_wl5522.t1 check status OK
113 SELECT COUNT(*) FROM testdb_wl5522.t1;
114 COUNT(*)
115 2
116 DROP TABLE testdb_wl5522.t1;
117 CREATE TABLE testdb_wl5522.t1 (
118 col_1_varbinary VARBINARY (4000) ,
119 col_2_varchar VARCHAR (4000),
120 col_3_text TEXT (4000),
121 col_4_blob BLOB (4000),
122 col_5_text TEXT (4000),
123 col_6_varchar VARCHAR (4000),
124 col_7_binary BINARY (255)
125 ) ROW_FORMAT=DYNAMIC ENGINE = Innodb;
126 INSERT INTO testdb_wl5522.t1 VALUES(
127 REPEAT('a', 4000),REPEAT('o', 4000),REPEAT('a', 4000), REPEAT('o', 4000),
128 REPEAT('a', 4000),REPEAT('a', 4000),REPEAT('a', 255));
129 SELECT col_1_varbinary = REPEAT("a", 4000),
130 col_2_varchar = REPEAT("o", 4000) ,
131 col_3_text = REPEAT("a", 4000) ,
132 col_4_blob = REPEAT("o", 4000) ,
133 col_5_text = REPEAT("a", 4000) ,
134 col_6_varchar = REPEAT("a", 4000) ,
135 col_7_binary = REPEAT("a", 255)
136 FROM testdb_wl5522.t1;
137 col_1_varbinary = REPEAT("a", 4000) col_2_varchar = REPEAT("o", 4000) col_3_text = REPEAT("a", 4000) col_4_blob = REPEAT("o", 4000) col_5_text = REPEAT("a", 4000) col_6_varchar = REPEAT("a", 4000) col_7_binary = REPEAT("a", 255)
138 1 1 1 1 1 1 1
139 FLUSH TABLES testdb_wl5522.t1 FOR EXPORT;
140 backup: t1
141 UNLOCK TABLES;
142 DROP TABLE testdb_wl5522.t1;
143 CREATE TABLE testdb_wl5522.t1 (
144 col_1_varbinary VARBINARY (4000) ,
145 col_2_varchar VARCHAR (4000),
146 col_3_text TEXT (4000),
147 col_4_blob BLOB (4000),
148 col_5_text TEXT (4000),
149 col_6_varchar VARCHAR (4000),
150 col_7_binary BINARY (255)
151 ) ROW_FORMAT=DYNAMIC ENGINE = Innodb;
152 ALTER TABLE testdb_wl5522.t1 DISCARD TABLESPACE;
153 restore: t1 .ibd and .cfg files
154 ALTER TABLE testdb_wl5522.t1 IMPORT TABLESPACE;
155 SELECT col_1_varbinary = REPEAT("a", 4000) ,
156 col_2_varchar = REPEAT("o", 4000) ,
157 col_3_text = REPEAT("a", 4000) ,
158 col_4_blob = REPEAT("o", 4000) ,
159 col_5_text = REPEAT("a", 4000) ,
160 col_6_varchar = REPEAT("a", 4000) ,
161 col_7_binary = REPEAT("a", 255)
162 FROM testdb_wl5522.t1;
163 col_1_varbinary = REPEAT("a", 4000) col_2_varchar = REPEAT("o", 4000) col_3_text = REPEAT("a", 4000) col_4_blob = REPEAT("o", 4000) col_5_text = REPEAT("a", 4000) col_6_varchar = REPEAT("a", 4000) col_7_binary = REPEAT("a", 255)
164 1 1 1 1 1 1 1
165 DROP TABLE testdb_wl5522.t1;
166 CREATE TABLE testdb_wl5522.t1 (
167 col_1_int INT AUTO_INCREMENT,
168 col_2_varchar VARCHAR (20),
169 PRIMARY KEY (col_1_int)) ENGINE = Innodb;
170 INSERT INTO testdb_wl5522.t1 VALUES (1,'a1'),(2,'a2'),(3,'a3');
171 INSERT INTO testdb_wl5522.t1 (col_2_varchar) VALUES ('a4'),('a5'),('a6');
172 SELECT * FROM testdb_wl5522.t1 ORDER BY col_1_int;
173 col_1_int col_2_varchar
174 1 a1
175 2 a2
176 3 a3
177 4 a4
178 5 a5
179 6 a6
180 FLUSH TABLES testdb_wl5522.t1 FOR EXPORT;
181 backup: t1
182 UNLOCK TABLES;
183 DROP TABLE testdb_wl5522.t1;
184 CREATE TABLE testdb_wl5522.t1 (
185 col_1_int INT AUTO_INCREMENT,
186 col_2_varchar VARCHAR (20),
187 PRIMARY KEY (col_1_int)) ENGINE = Innodb;
188 ALTER TABLE testdb_wl5522.t1 DISCARD TABLESPACE;
189 restore: t1 .ibd and .cfg files
190 ALTER TABLE testdb_wl5522.t1 IMPORT TABLESPACE;
191 SELECT * FROM testdb_wl5522.t1 ORDER BY col_1_int;
192 col_1_int col_2_varchar
193 1 a1
194 2 a2
195 3 a3
196 4 a4
197 5 a5
198 6 a6
199 INSERT INTO testdb_wl5522.t1 VALUES (1,'a1');
200 ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
201 INSERT INTO testdb_wl5522.t1(col_2_varchar) VALUES ('a101'),('a102'),('a103');
202 SELECT * FROM testdb_wl5522.t1 ORDER BY col_1_int;
203 col_1_int col_2_varchar
204 1 a1
205 2 a2
206 3 a3
207 4 a4
208 5 a5
209 6 a6
210 7 a101
211 8 a102
212 9 a103
213 ALTER TABLE testdb_wl5522.t1 MODIFY col_1_int BIGINT;
214 SELECT * FROM testdb_wl5522.t1 ORDER BY col_1_int;
215 col_1_int col_2_varchar
216 1 a1
217 2 a2
218 3 a3
219 4 a4
220 5 a5
221 6 a6
222 7 a101
223 8 a102
224 9 a103
225 DROP TABLE testdb_wl5522.t1;
226 CREATE TABLE testdb_wl5522.t1 (
227 col_1_int INT,col_2_varchar VARCHAR (20),
228 PRIMARY KEY (col_2_varchar)) ENGINE = Innodb;
229 CREATE TABLE testdb_wl5522.t1_fk (
230 col_1_int INT,col_2_varchar VARCHAR (20),
231 PRIMARY KEY (col_1_int),
232 FOREIGN KEY (col_2_varchar) REFERENCES testdb_wl5522.t1(col_2_varchar)
233 ) ENGINE = Innodb;
234 INSERT INTO testdb_wl5522.t1 VALUES (1,'a1'),(2,'a2'),(3,'a3'),(4,'a4'),(5,'a5');
235 INSERT INTO testdb_wl5522.t1_fk VALUES (1,'a1'),(2,'a2'),(3,'a3');
236 SELECT * FROM testdb_wl5522.t1;
237 col_1_int col_2_varchar
238 1 a1
239 2 a2
240 3 a3
241 4 a4
242 5 a5
243 SELECT * FROM testdb_wl5522.t1_fk;
244 col_1_int col_2_varchar
245 1 a1
246 2 a2
247 3 a3
248 FLUSH TABLES testdb_wl5522.t1,testdb_wl5522.t1_fk FOR EXPORT;
249 backup: t1
250 backup: t1_fk
251 UNLOCK TABLES;
252 DROP TABLE testdb_wl5522.t1_fk,testdb_wl5522.t1;
253 CREATE TABLE testdb_wl5522.t1 (
254 col_1_int INT,col_2_varchar VARCHAR (20),
255 PRIMARY KEY (col_2_varchar)) ENGINE = Innodb;
256 CREATE TABLE testdb_wl5522.t1_fk (
257 col_1_int INT,col_2_varchar VARCHAR (20),
258 PRIMARY KEY (col_1_int),
259 FOREIGN KEY (col_2_varchar) REFERENCES testdb_wl5522.t1(col_2_varchar)
260 ) ENGINE = Innodb;
261 SET foreign_key_checks = 0;
262 ALTER TABLE testdb_wl5522.t1_fk DISCARD TABLESPACE;
263 ALTER TABLE testdb_wl5522.t1 DISCARD TABLESPACE;
264 SET foreign_key_checks = 1;
265 restore: t1 .ibd and .cfg files
266 restore: t1_fk .ibd and .cfg files
267 ALTER TABLE testdb_wl5522.t1 IMPORT TABLESPACE;
268 ALTER TABLE testdb_wl5522.t1_fk IMPORT TABLESPACE;
269 SELECT * FROM testdb_wl5522.t1;
270 col_1_int col_2_varchar
271 1 a1
272 2 a2
273 3 a3
274 4 a4
275 5 a5
276 SELECT * FROM testdb_wl5522.t1_fk;
277 col_1_int col_2_varchar
278 1 a1
279 2 a2
280 3 a3
281 INSERT INTO testdb_wl5522.t1_fk VALUES (100,'a100');
282 ERROR 23000: Cannot add or update a child row: a foreign key constraint fails (`testdb_wl5522`.`t1_fk`, CONSTRAINT `t1_fk_ibfk_1` FOREIGN KEY (`col_2_varchar`) REFERENCES `t1` (`col_2_varchar`))
283 SET AUTOCOMMIT = 0;
284 INSERT INTO testdb_wl5522.t1_fk VALUES (4,'a4'),(5,'a5');
285 ROLLBACK;
286 SELECT * FROM testdb_wl5522.t1_fk;
287 col_1_int col_2_varchar
288 1 a1
289 2 a2
290 3 a3
291 DROP TABLE testdb_wl5522.t1_fk,testdb_wl5522.t1;
292 SET AUTOCOMMIT = 1;
293 CREATE TABLE testdb_wl5522.t1 (
294 col_1_int int,col_2_varchar VARCHAR (20),
295 PRIMARY KEY (col_2_varchar)) ENGINE = Innodb;
296 SET AUTOCOMMIT = 0;
297 INSERT INTO testdb_wl5522.t1 VALUES (1,'a1'),(2,'a2');
298 SELECT * FROM testdb_wl5522.t1;
299 col_1_int col_2_varchar
300 1 a1
301 2 a2
302 COMMIT;
303 INSERT INTO testdb_wl5522.t1 VALUES (3,'a3'),(4,'a4');
304 ROLLBACK;
305 INSERT INTO testdb_wl5522.t1 VALUES (5,'a5'),(6,'a6');
306 COMMIT;
307 SELECT * FROM testdb_wl5522.t1 ORDER BY col_1_int;
308 col_1_int col_2_varchar
309 1 a1
310 2 a2
311 5 a5
312 6 a6
313 FLUSH TABLES testdb_wl5522.t1 FOR EXPORT;
314 backup: t1
315 UNLOCK TABLES;
316 DROP TABLE testdb_wl5522.t1;
317 CREATE TABLE testdb_wl5522.t1 (
318 col_1_int int,col_2_varchar VARCHAR (20),
319 PRIMARY KEY (col_2_varchar)) ENGINE = Innodb;
320 ALTER TABLE testdb_wl5522.t1 DISCARD TABLESPACE;
321 SET AUTOCOMMIT = 0;
322 restore: t1 .ibd and .cfg files
323 ALTER TABLE testdb_wl5522.t1 IMPORT TABLESPACE;
324 INSERT INTO testdb_wl5522.t1 VALUES (7,'a7'),(8,'a8');
325 COMMIT;
326 INSERT INTO testdb_wl5522.t1 VALUES (9,'a9'),(10,'a10');
327 ROLLBACK;
328 INSERT INTO testdb_wl5522.t1 VALUES (11,'a11'),(12,'a12');
329 COMMIT;
330 SELECT * FROM testdb_wl5522.t1 ORDER BY col_1_int;
331 col_1_int col_2_varchar
332 1 a1
333 2 a2
334 5 a5
335 6 a6
336 7 a7
337 8 a8
338 11 a11
339 12 a12
340 SET AUTOCOMMIT = 1;
341 DROP TABLE testdb_wl5522.t1;
342 CREATE TABLE testdb_wl5522.t1 ( i int ) ENGINE = Innodb;
343 INSERT INTO testdb_wl5522.t1 VALUES (100),(200),(300);
344 SELECT * FROM testdb_wl5522.t1 ORDER BY i;
345 i
346 100
347 200
348 300
349 FLUSH TABLES testdb_wl5522.t1 FOR EXPORT;
350 backup: t1
351 UNLOCK TABLES;
352 DROP TABLE testdb_wl5522.t1;
353 CREATE TABLE testdb_wl5522.t1 ( i int ) ENGINE = Innodb;
354 ALTER TABLE testdb_wl5522.t1 DISCARD TABLESPACE;
355 restore: t1 .ibd and .cfg files
356 ALTER TABLE testdb_wl5522.t1 IMPORT TABLESPACE;
357 SELECT * FROM testdb_wl5522.t1 ORDER BY i;
358 i
359 100
360 200
361 300
362 SET AUTOCOMMIT = 0;
363 INSERT INTO testdb_wl5522.t1 VALUES (101),(102),(103);
364 COMMIT;
365 SELECT * FROM testdb_wl5522.t1 ORDER BY i;
366 i
367 100
368 101
369 102
370 103
371 200
372 300
373 SET AUTOCOMMIT = 1;
374 DROP TABLE testdb_wl5522.t1;
375 CREATE TABLE testdb_wl5522.t1 ( i int ) ENGINE = Innodb;
376 INSERT INTO testdb_wl5522.t1 VALUES (100),(200),(300);
377 SELECT * FROM testdb_wl5522.t1 ORDER BY i;
378 i
379 100
380 200
381 300
382 FLUSH TABLES testdb_wl5522.t1 FOR EXPORT;
383 backup: t1
384 UNLOCK TABLES;
385 FLUSH TABLES testdb_wl5522.t1 FOR EXPORT;
386 UNLOCK TABLES;
387 DROP TABLE testdb_wl5522.t1;
388 CREATE TABLE testdb_wl5522.t1 ( i bigint) ENGINE = Innodb;
389 ALTER TABLE testdb_wl5522.t1 DISCARD TABLESPACE;
390 restore: t1 .ibd and .cfg files
391 ALTER TABLE testdb_wl5522.t1 IMPORT TABLESPACE;
392 ERROR HY000: Schema mismatch (Column i precise type mismatch, it's 0X408 in the table and 0X403 in the tablespace meta file)
393 unlink: t1.ibd
394 unlink: t1.cfg
395 DROP TABLE testdb_wl5522.t1;
396 CREATE TABLE testdb_wl5522.t1 ( i int ) ENGINE = Innodb;
397 ALTER TABLE testdb_wl5522.t1 DISCARD TABLESPACE;
398 restore: t1 .ibd and .cfg files
399 ALTER TABLE testdb_wl5522.t1 IMPORT TABLESPACE;
400 ALTER TABLE testdb_wl5522.t1 IMPORT TABLESPACE;
401 ERROR HY000: Tablespace for table 'testdb_wl5522/t1' exists. Please DISCARD the tablespace before IMPORT
402 SELECT * FROM testdb_wl5522.t1 ORDER BY i;
403 i
404 100
405 200
406 300
407 SET AUTOCOMMIT = 0;
408 INSERT INTO testdb_wl5522.t1 VALUES (101),(102),(103);
409 COMMIT;
410 SELECT * FROM testdb_wl5522.t1 ORDER BY i;
411 i
412 100
413 101
414 102
415 103
416 200
417 300
418 DROP TABLE testdb_wl5522.t1;
419 CREATE TABLE testdb_wl5522.t1 (i int) ENGINE = Innodb;
420 ALTER TABLE testdb_wl5522.t1 DISCARD TABLESPACE;
421 restore: t1 .ibd and .cfg files
422 ALTER TABLE testdb_wl5522.t1 IMPORT TABLESPACE;
423 DROP TABLE testdb_wl5522.t1;
424 SET AUTOCOMMIT = 1;
425 CREATE TABLE testdb_wl5522.t1 (c1 INT ) ENGINE = Innodb;
426 SET AUTOCOMMIT = 0;
427 INSERT INTO testdb_wl5522.t1 VALUES (1),(123),(331);
428 SELECT c1 FROM testdb_wl5522.t1;
429 c1
430 1
431 123
432 331
433 ROLLBACK;
434 FLUSH TABLES testdb_wl5522.t1 FOR EXPORT;
435 backup: t1
436 UNLOCK TABLES;
437 DROP TABLE testdb_wl5522.t1;
438 CREATE TABLE testdb_wl5522.t1 (c1 INT ) ENGINE = Innodb;
439 ALTER TABLE testdb_wl5522.t1 DISCARD TABLESPACE;
440 restore: t1 .ibd and .cfg files
441 ALTER TABLE testdb_wl5522.t1 IMPORT TABLESPACE;
442 SELECT * FROM testdb_wl5522.t1 ORDER BY c1;
443 c1
444 DROP TABLE testdb_wl5522.t1;
445 SET AUTOCOMMIT = 1;
446 CREATE TABLE testdb_wl5522.t1 (col_1 CHAR (255) ,
447 col_2 VARCHAR (255), col_3 VARCHAR (255),
448 col_4 VARCHAR (255),col_5 VARCHAR (255),
449 col_6 text (255), col_7 text (255),
450 col_8 text (255),col_9 text (255),
451 col_10 BLOB (255),col_11 BLOB (255),
452 col_12 BLOB (255), col_13 BLOB (255),
453 col_14 BLOB (255) , col_15 int ) ENGINE = innodb;
454 CREATE INDEX prefix_idx ON testdb_wl5522.t1(
455 col_1 (50),col_2 (50),col_3 (50),
456 col_4 (50),col_5 (50),col_6 (50),
457 col_7 (50),col_8 (50),col_9 (50),
458 col_10 (50),col_11 (50),col_12 (50),
459 col_13(50));
460 INSERT INTO testdb_wl5522.t1 VALUES (
461 REPEAT("col1_00001",10),REPEAT("col2_00001",10),REPEAT("col3_00001",10),
462 REPEAT("col4_00001",10),REPEAT("col5_00001",10),REPEAT("col6_00001",10),
463 REPEAT("col7_00001",10),REPEAT("col8_00001",10),REPEAT("col9_00001",10),
464 REPEAT("col10_00001",10),REPEAT("col11_00001",10),REPEAT("col12_00001",10),
465 REPEAT("col13_00001",10),REPEAT("col14_00001",10),1);
466 SELECT
467 col_1 = REPEAT("col1_00001",10),
468 col_2 = REPEAT("col2_00001",10),
469 col_3 = REPEAT("col3_00001",10),
470 col_4 = REPEAT("col4_00001",10),
471 col_5 = REPEAT("col5_00001",10),
472 col_6 = REPEAT("col6_00001",10),
473 col_7 = REPEAT("col7_00001",10),
474 col_8 = REPEAT("col8_00001",10),
475 col_9 = REPEAT("col9_00001",10),
476 col_10 = REPEAT("col10_00001",10),
477 col_11 = REPEAT("col11_00001",10),
478 col_12 = REPEAT("col12_00001",10),
479 col_13 = REPEAT("col13_00001",10),
480 col_14 = REPEAT("col14_00001",10),
481 col_15
482 FROM testdb_wl5522.t1;
483 col_1 = REPEAT("col1_00001",10) col_2 = REPEAT("col2_00001",10) col_3 = REPEAT("col3_00001",10) col_4 = REPEAT("col4_00001",10) col_5 = REPEAT("col5_00001",10) col_6 = REPEAT("col6_00001",10) col_7 = REPEAT("col7_00001",10) col_8 = REPEAT("col8_00001",10) col_9 = REPEAT("col9_00001",10) col_10 = REPEAT("col10_00001",10) col_11 = REPEAT("col11_00001",10) col_12 = REPEAT("col12_00001",10) col_13 = REPEAT("col13_00001",10) col_14 = REPEAT("col14_00001",10) col_15
484 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
485 FLUSH TABLES testdb_wl5522.t1 FOR EXPORT;
486 backup: t1
487 UNLOCK TABLES;
488 DROP TABLE testdb_wl5522.t1;
489 CREATE TABLE testdb_wl5522.t1 (col_1 CHAR (255) ,
490 col_2 VARCHAR (255), col_3 VARCHAR (255),
491 col_4 VARCHAR (255),col_5 VARCHAR (255),
492 col_6 text (255), col_7 text (255),
493 col_8 text (255),col_9 text (255),
494 col_10 BLOB (255),col_11 BLOB (255),
495 col_12 BLOB (255), col_13 BLOB (255),
496 col_14 BLOB (255) , col_15 int ) ENGINE = innodb;
497 CREATE INDEX prefix_idx ON testdb_wl5522.t1(
498 col_1 (50),col_2 (50),col_3 (50),
499 col_4 (50),col_5 (50),col_6 (50),
500 col_7 (50),col_8 (50),col_9 (50),
501 col_10 (50),col_11 (50),col_12 (50),
502 col_13(50));
503 ALTER TABLE testdb_wl5522.t1 DISCARD TABLESPACE;
504 restore: t1 .ibd and .cfg files
505 ALTER TABLE testdb_wl5522.t1 IMPORT TABLESPACE;
506 SELECT
507 col_1 = REPEAT("col1_00001",10),
508 col_2 = REPEAT("col2_00001",10),
509 col_3 = REPEAT("col3_00001",10),
510 col_4 = REPEAT("col4_00001",10),
511 col_5 = REPEAT("col5_00001",10),
512 col_6 = REPEAT("col6_00001",10),
513 col_7 = REPEAT("col7_00001",10),
514 col_8 = REPEAT("col8_00001",10),
515 col_9 = REPEAT("col9_00001",10),
516 col_10 = REPEAT("col10_00001",10),
517 col_11 = REPEAT("col11_00001",10),
518 col_12 = REPEAT("col12_00001",10),
519 col_13 = REPEAT("col13_00001",10),
520 col_14 = REPEAT("col14_00001",10),
521 col_15
522 FROM testdb_wl5522.t1;
523 col_1 = REPEAT("col1_00001",10) col_2 = REPEAT("col2_00001",10) col_3 = REPEAT("col3_00001",10) col_4 = REPEAT("col4_00001",10) col_5 = REPEAT("col5_00001",10) col_6 = REPEAT("col6_00001",10) col_7 = REPEAT("col7_00001",10) col_8 = REPEAT("col8_00001",10) col_9 = REPEAT("col9_00001",10) col_10 = REPEAT("col10_00001",10) col_11 = REPEAT("col11_00001",10) col_12 = REPEAT("col12_00001",10) col_13 = REPEAT("col13_00001",10) col_14 = REPEAT("col14_00001",10) col_15
524 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
525 DROP TABLE testdb_wl5522.t1;
526 CREATE TABLE testdb_wl5522.t1 (col_1 CHAR (255) ,
527 col_2 VARCHAR (255), col_3 VARCHAR (255),
528 col_4 VARCHAR (255),col_5 VARCHAR (255),
529 col_6 text (255), col_7 text (255),
530 col_8 text (255),col_9 text (255),
531 col_10 BLOB (255),col_11 BLOB (255),
532 col_12 BLOB (255), col_13 BLOB (255),
533 col_14 BLOB (255) , col_15 int ) ENGINE = innodb;
534 CREATE INDEX idx1 ON testdb_wl5522.t1(col_1);
535 CREATE INDEX idx2 ON testdb_wl5522.t1(col_2);
536 CREATE INDEX idx3 ON testdb_wl5522.t1(col_3);
537 CREATE INDEX idx4 ON testdb_wl5522.t1(col_4);
538 CREATE INDEX idx5 ON testdb_wl5522.t1(col_5);
539 CREATE INDEX idx6 ON testdb_wl5522.t1(col_6(255));
540 CREATE INDEX idx7 ON testdb_wl5522.t1(col_7(255));
541 CREATE INDEX idx8 ON testdb_wl5522.t1(col_8(255));
542 CREATE INDEX idx9 ON testdb_wl5522.t1(col_9(255));
543 CREATE INDEX idx10 ON testdb_wl5522.t1(col_10(255));
544 CREATE INDEX idx11 ON testdb_wl5522.t1(col_11(255));
545 CREATE INDEX idx12 ON testdb_wl5522.t1(col_12(255));
546 CREATE INDEX idx13 ON testdb_wl5522.t1(col_13(255));
547 CREATE INDEX idx14 ON testdb_wl5522.t1(col_14(255));
548 INSERT INTO testdb_wl5522.t1 VALUES (
549 REPEAT("col1_00001",10),REPEAT("col2_00001",10),REPEAT("col3_00001",10),
550 REPEAT("col4_00001",10),REPEAT("col5_00001",10),REPEAT("col6_00001",10),
551 REPEAT("col7_00001",10),REPEAT("col8_00001",10),REPEAT("col9_00001",10),
552 REPEAT("col10_00001",10),REPEAT("col11_00001",10),REPEAT("col12_00001",10),
553 REPEAT("col13_00001",10),REPEAT("col14_00001",10),1);
554 SELECT
555 col_1 = REPEAT("col1_00001",10),
556 col_2 = REPEAT("col2_00001",10),
557 col_3 = REPEAT("col3_00001",10),
558 col_4 = REPEAT("col4_00001",10),
559 col_5 = REPEAT("col5_00001",10),
560 col_6 = REPEAT("col6_00001",10),
561 col_7 = REPEAT("col7_00001",10),
562 col_8 = REPEAT("col8_00001",10),
563 col_9 = REPEAT("col9_00001",10),
564 col_10 = REPEAT("col10_00001",10),
565 col_11 = REPEAT("col11_00001",10),
566 col_12 = REPEAT("col12_00001",10),
567 col_13 = REPEAT("col13_00001",10),
568 col_14 = REPEAT("col14_00001",10),
569 col_15
570 FROM testdb_wl5522.t1;
571 col_1 = REPEAT("col1_00001",10) col_2 = REPEAT("col2_00001",10) col_3 = REPEAT("col3_00001",10) col_4 = REPEAT("col4_00001",10) col_5 = REPEAT("col5_00001",10) col_6 = REPEAT("col6_00001",10) col_7 = REPEAT("col7_00001",10) col_8 = REPEAT("col8_00001",10) col_9 = REPEAT("col9_00001",10) col_10 = REPEAT("col10_00001",10) col_11 = REPEAT("col11_00001",10) col_12 = REPEAT("col12_00001",10) col_13 = REPEAT("col13_00001",10) col_14 = REPEAT("col14_00001",10) col_15
572 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
573 FLUSH TABLES testdb_wl5522.t1 FOR EXPORT;
574 backup: t1
575 UNLOCK TABLES;
576 DROP TABLE testdb_wl5522.t1;
577 CREATE TABLE testdb_wl5522.t1 (col_1 CHAR (255) ,
578 col_2 VARCHAR (255), col_3 VARCHAR (255),
579 col_4 VARCHAR (255),col_5 VARCHAR (255),
580 col_6 text (255), col_7 text (255),
581 col_8 text (255),col_9 text (255),
582 col_10 BLOB (255),col_11 BLOB (255),
583 col_12 BLOB (255), col_13 BLOB (255),
584 col_14 BLOB (255) , col_15 int ) ENGINE = innodb;
585 CREATE INDEX idx1 ON testdb_wl5522.t1(col_1);
586 CREATE INDEX idx2 ON testdb_wl5522.t1(col_2);
587 CREATE INDEX idx3 ON testdb_wl5522.t1(col_3);
588 CREATE INDEX idx4 ON testdb_wl5522.t1(col_4);
589 CREATE INDEX idx5 ON testdb_wl5522.t1(col_5);
590 CREATE INDEX idx6 ON testdb_wl5522.t1(col_6(255));
591 CREATE INDEX idx7 ON testdb_wl5522.t1(col_7(255));
592 CREATE INDEX idx8 ON testdb_wl5522.t1(col_8(255));
593 CREATE INDEX idx9 ON testdb_wl5522.t1(col_9(255));
594 CREATE INDEX idx10 ON testdb_wl5522.t1(col_10(255));
595 CREATE INDEX idx11 ON testdb_wl5522.t1(col_11(255));
596 CREATE INDEX idx12 ON testdb_wl5522.t1(col_12(255));
597 CREATE INDEX idx13 ON testdb_wl5522.t1(col_13(255));
598 CREATE INDEX idx14 ON testdb_wl5522.t1(col_14(255));
599 ALTER TABLE testdb_wl5522.t1 DISCARD TABLESPACE;
600 restore: t1 .ibd and .cfg files
601 ALTER TABLE testdb_wl5522.t1 IMPORT TABLESPACE;
602 SELECT
603 col_1 = REPEAT("col1_00001",10),
604 col_2 = REPEAT("col2_00001",10),
605 col_3 = REPEAT("col3_00001",10),
606 col_4 = REPEAT("col4_00001",10),
607 col_5 = REPEAT("col5_00001",10),
608 col_6 = REPEAT("col6_00001",10),
609 col_7 = REPEAT("col7_00001",10),
610 col_8 = REPEAT("col8_00001",10),
611 col_9 = REPEAT("col9_00001",10),
612 col_10 = REPEAT("col10_00001",10),
613 col_11 = REPEAT("col11_00001",10),
614 col_12 = REPEAT("col12_00001",10),
615 col_13 = REPEAT("col13_00001",10),
616 col_14 = REPEAT("col14_00001",10),
617 col_15
618 FROM testdb_wl5522.t1;
619 col_1 = REPEAT("col1_00001",10) col_2 = REPEAT("col2_00001",10) col_3 = REPEAT("col3_00001",10) col_4 = REPEAT("col4_00001",10) col_5 = REPEAT("col5_00001",10) col_6 = REPEAT("col6_00001",10) col_7 = REPEAT("col7_00001",10) col_8 = REPEAT("col8_00001",10) col_9 = REPEAT("col9_00001",10) col_10 = REPEAT("col10_00001",10) col_11 = REPEAT("col11_00001",10) col_12 = REPEAT("col12_00001",10) col_13 = REPEAT("col13_00001",10) col_14 = REPEAT("col14_00001",10) col_15
620 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
621 SET AUTOCOMMIT = 0;
622 INSERT INTO testdb_wl5522.t1(col_15) VALUES (15000),(16000);
623 SELECT col_15 FROM testdb_wl5522.t1 WHERE col_15 > 11000;
624 col_15
625 15000
626 16000
627 ROLLBACK;
628 SELECT col_15 FROM testdb_wl5522.t1 WHERE col_15 > 11000;
629 col_15
630 INSERT INTO testdb_wl5522.t1(col_15) VALUES (15000),(16000);
631 COMMIT;
632 SELECT col_15 FROM testdb_wl5522.t1 WHERE col_15 > 11000;
633 col_15
634 15000
635 16000
636 ALTER TABLE testdb_wl5522.t1 DROP INDEX idx1;
637 ALTER TABLE testdb_wl5522.t1 DROP INDEX idx6;
638 ALTER TABLE testdb_wl5522.t1 DROP INDEX idx10;
639 SELECT
640 col_1 = REPEAT("col1_00001",10),
641 col_2 = REPEAT("col2_00001",10),
642 col_3 = REPEAT("col3_00001",10),
643 col_4 = REPEAT("col4_00001",10),
644 col_5 = REPEAT("col5_00001",10),
645 col_6 = REPEAT("col6_00001",10),
646 col_7 = REPEAT("col7_00001",10),
647 col_8 = REPEAT("col8_00001",10),
648 col_9 = REPEAT("col9_00001",10),
649 col_10 = REPEAT("col10_00001",10),
650 col_11 = REPEAT("col11_00001",10),
651 col_12 = REPEAT("col12_00001",10),
652 col_13 = REPEAT("col13_00001",10),
653 col_14 = REPEAT("col14_00001",10),
654 col_15
655 FROM testdb_wl5522.t1;
656 col_1 = REPEAT("col1_00001",10) col_2 = REPEAT("col2_00001",10) col_3 = REPEAT("col3_00001",10) col_4 = REPEAT("col4_00001",10) col_5 = REPEAT("col5_00001",10) col_6 = REPEAT("col6_00001",10) col_7 = REPEAT("col7_00001",10) col_8 = REPEAT("col8_00001",10) col_9 = REPEAT("col9_00001",10) col_10 = REPEAT("col10_00001",10) col_11 = REPEAT("col11_00001",10) col_12 = REPEAT("col12_00001",10) col_13 = REPEAT("col13_00001",10) col_14 = REPEAT("col14_00001",10) col_15
657 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
658 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 15000
659 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 16000
660 ALTER TABLE testdb_wl5522.t1 ADD INDEX idx1 (col_1);
661 ALTER TABLE testdb_wl5522.t1 ADD INDEX idx6 (col_1(255));
662 Warnings:
663 Note 1831 Duplicate index `idx6`. This is deprecated and will be disallowed in a future release
664 ALTER TABLE testdb_wl5522.t1 ADD INDEX idx10 (col_10(255));
665 SELECT
666 col_1 = REPEAT("col1_00001",10),
667 col_2 = REPEAT("col2_00001",10),
668 col_3 = REPEAT("col3_00001",10),
669 col_4 = REPEAT("col4_00001",10),
670 col_5 = REPEAT("col5_00001",10),
671 col_6 = REPEAT("col6_00001",10),
672 col_7 = REPEAT("col7_00001",10),
673 col_8 = REPEAT("col8_00001",10),
674 col_9 = REPEAT("col9_00001",10),
675 col_10 = REPEAT("col10_00001",10),
676 col_11 = REPEAT("col11_00001",10),
677 col_12 = REPEAT("col12_00001",10),
678 col_13 = REPEAT("col13_00001",10),
679 col_14 = REPEAT("col14_00001",10),
680 col_15
681 FROM testdb_wl5522.t1;
682 col_1 = REPEAT("col1_00001",10) col_2 = REPEAT("col2_00001",10) col_3 = REPEAT("col3_00001",10) col_4 = REPEAT("col4_00001",10) col_5 = REPEAT("col5_00001",10) col_6 = REPEAT("col6_00001",10) col_7 = REPEAT("col7_00001",10) col_8 = REPEAT("col8_00001",10) col_9 = REPEAT("col9_00001",10) col_10 = REPEAT("col10_00001",10) col_11 = REPEAT("col11_00001",10) col_12 = REPEAT("col12_00001",10) col_13 = REPEAT("col13_00001",10) col_14 = REPEAT("col14_00001",10) col_15
683 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
684 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 15000
685 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 16000
686 DROP TABLE testdb_wl5522.t1;
687 SET AUTOCOMMIT = 1;
688 CREATE TABLE testdb_wl5522.t1(col1 bit(1) ,
689 col2 boolean,col3 tinyint , col4 smallint ,
690 col5 mediumint ,col6 int , col7 bigint ,
691 col8 float (14,3) ,col9 double (14,3),
692 col10 VARCHAR(20) CHARACTER SET utf8 ,
693 col11 TEXT CHARACTER SET binary ,
694 col12 ENUM('a','b','c') CHARACTER SET binary,
695 col13 TEXT CHARACTER SET latin1 COLLATE latin1_general_cs ,
696 col14 CHAR(20) , col15 VARBINARY (400),
697 col16 BINARY(40), col17 BLOB (400),
698 col18 int not null primary key,
699 col19 DATE ,col20 DATETIME , col21 TIMESTAMP ,
700 col22 TIME , col23 YEAR ) ENGINE = Innodb;
701 CREATE TABLE testdb_wl5522.trigger_table ( i int ) ENGINE = Innodb;
702 CREATE TRIGGER testdb_wl5522.tri AFTER INSERT ON testdb_wl5522.t1
703 FOR EACH ROW INSERT INTO testdb_wl5522.trigger_table VALUES(NEW.col18);
704 CREATE OR REPLACE VIEW testdb_wl5522.VW1 AS SELECT * FROM testdb_wl5522.t1;
705 CREATE INDEX idx1 ON testdb_wl5522.t1(col18);
706 CREATE INDEX prefix_idx ON testdb_wl5522.t1(col14 (10));
707 CREATE UNIQUE INDEX idx2 ON testdb_wl5522.t1(col12);
708 CREATE UNIQUE INDEX idx3 ON testdb_wl5522.t1(col8);
709 INSERT INTO testdb_wl5522.t1 VALUES (
710 1,1,-128,32767,-8388608,2147483647,-9223372036854775808,92233720368.222,
711 -92233720368.222,'aaa','aaaaaaaaaa','b','bbbbb','ccccc',REPEAT('d',40),
712 REPEAT('d',40),REPEAT('d',40),1,'1000-01-01','3000-12-31 23:59:59.99',
713 '1990-01-01 00:00:01.00','01:59:59.00','1901');
714 INSERT INTO testdb_wl5522.t1 VALUES (
715 NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
716 NULL,NULL,3,NULL,NULL,NULL,NULL,NULL);
717 INSERT INTO testdb_wl5522.t1 VALUES (
718 NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
719 NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
720 ERROR 23000: Column 'col18' cannot be null
721 INSERT INTO testdb_wl5522.t1 VALUES (
722 NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
723 NULL,NULL,1,NULL,NULL,NULL,NULL,NULL);
724 ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
725 SELECT COUNT(*) FROM testdb_wl5522.t1;
726 COUNT(*)
727 2
728 SELECT * FROM testdb_wl5522.trigger_table;
729 i
730 1
731 3
732 SELECT COUNT(*) FROM testdb_wl5522.VW1;
733 COUNT(*)
734 2
735 FLUSH TABLES testdb_wl5522.t1 FOR EXPORT;
736 backup: t1
737 UNLOCK TABLES;
738 DROP TABLE testdb_wl5522.t1;
739 CREATE TABLE testdb_wl5522.t1(col1 bit(1) ,
740 col2 boolean,col3 tinyint , col4 smallint ,
741 col5 mediumint ,col6 int , col7 bigint ,
742 col8 float (14,3) ,col9 double (14,3),
743 col10 VARCHAR(20) CHARACTER SET utf8 ,
744 col11 TEXT CHARACTER SET binary ,
745 col12 ENUM('a','b','c') CHARACTER SET binary,
746 col13 TEXT CHARACTER SET latin1 COLLATE latin1_general_cs ,
747 col14 CHAR(20) , col15 VARBINARY (400),
748 col16 BINARY(40), col17 BLOB (400),
749 col18 int not null primary key,
750 col19 DATE ,col20 DATETIME , col21 TIMESTAMP ,
751 col22 TIME , col23 YEAR ) ENGINE = Innodb;
752 CREATE INDEX idx1 ON testdb_wl5522.t1(col18);
753 CREATE INDEX prefix_idx ON testdb_wl5522.t1(col14 (10));
754 CREATE UNIQUE INDEX idx2 ON testdb_wl5522.t1(col12);
755 CREATE UNIQUE INDEX idx3 ON testdb_wl5522.t1(col8);
756 ALTER TABLE testdb_wl5522.t1 DISCARD TABLESPACE;
757 restore: t1 .ibd and .cfg files
758 ALTER TABLE testdb_wl5522.t1 IMPORT TABLESPACE;
759 SELECT COUNT(*) FROM testdb_wl5522.t1;
760 COUNT(*)
761 2
762 SELECT * FROM testdb_wl5522.trigger_table;
763 i
764 1
765 3
766 SELECT COUNT(*) FROM testdb_wl5522.VW1;
767 COUNT(*)
768 2
769 INSERT INTO testdb_wl5522.t1(col18) VALUES (5);
770 SELECT * FROM testdb_wl5522.trigger_table;
771 i
772 1
773 3
774 UPDATE testdb_wl5522.t1 SET col18=10 WHERE col18=1;
775 SELECT COUNT(*) FROM testdb_wl5522.VW1;
776 COUNT(*)
777 3
778 SELECT COUNT(*) FROM testdb_wl5522.t1 WHERE col18=10;
779 COUNT(*)
780 1
781 ALTER TABLE testdb_wl5522.t1 ADD COLUMN col24 varbinary(40) default null;
782 INSERT INTO testdb_wl5522.t1(col18,col24) VALUES (6,REPEAT('a',10));
783 SELECT col24,col18 FROM testdb_wl5522.t1 WHERE col18 in (6,1,10) ORDER BY col18;
784 col24 col18
785 aaaaaaaaaa 6
786 NULL 10
787 ALTER TABLE testdb_wl5522.t1 DROP INDEX prefix_idx;
788 SELECT col18,col14 FROM testdb_wl5522.t1 WHERE col14 like '_ccc%';
789 col18 col14
790 10 ccccc
791 ALTER TABLE testdb_wl5522.t1 ADD INDEX prefix_idx (col24(10));
792 SELECT col18,col24 FROM testdb_wl5522.t1 WHERE col24 like '_a_a%';
793 col18 col24
794 6 aaaaaaaaaa
795 DROP TABLE testdb_wl5522.t1;
796 DROP DATABASE testdb_wl5522;
797 call mtr.add_suppression("Got error -1 when reading table '.*'");
798 call mtr.add_suppression("InnoDB: Error: tablespace id and flags in file '.*'.*");
799 call mtr.add_suppression("InnoDB: The table .* doesn't have a corresponding tablespace, it was discarded");
800 #
801 # MDEV-27882 Innodb - recognise MySQL-8.0 innodb flags and give a specific error message
802 #
803 #
804 CREATE TABLE `t1` (`i` int(11) NOT NULL, PRIMARY KEY (`i`) ) ENGINE=InnoDB;
805 FLUSH TABLES t1 FOR EXPORT;
806 backup: t1
807 UNLOCK TABLES;
808 ALTER TABLE t1 DISCARD TABLESPACE;
809 call mtr.add_suppression("InnoDB: unsupported MySQL tablespace");
810 ALTER TABLE t1 IMPORT TABLESPACE;
811 ERROR 42000: Table 't1' uses an extension that doesn't exist in this MariaDB version
812 DROP TABLE t1;
813 # End of 10.3 tests
814 #
815 # MDEV-29972 crash after "Unsupported meta-data version number"
816 #
817 call mtr.add_suppression("Index for table 't2' is corrupt");
818 CREATE TABLE t2 (i INT PRIMARY KEY) ENGINE=InnoDB;
819 ALTER TABLE t2 DISCARD TABLESPACE;
820 ALTER TABLE t2 IMPORT TABLESPACE;
821 ERROR 42000: This version of MariaDB doesn't yet support 'meta-data version'
822 ALTER TABLE t2 IMPORT TABLESPACE;
823 ERROR HY000: Index for table 't2' is corrupt; try to repair it
824 SELECT * FROM t2;
825 ERROR HY000: Tablespace has been discarded for table `t2`
826 DROP TABLE t2;
827 # End of 10.4 tests