Debian Codegraph @

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

raw
1 --source include/have_innodb.inc
2 --source include/have_sequence.inc
3
4 --echo #
5 --echo # MDEV-29144 ER_TABLE_SCHEMA_MISMATCH or crash on DISCARD/IMPORT
6 --echo #
7
8 call mtr.add_suppression("InnoDB: Unknown index id");
9 CREATE TABLE t (pk int PRIMARY KEY, c varchar(1024))
10 ENGINE=InnoDB CHARSET latin1;
11 INSERT INTO t SELECT seq, 'x' FROM seq_1_to_100;
12
13 --connect (con1,localhost,root,,test)
14 --delimiter $
15 --send
16 BEGIN NOT ATOMIC
17 DECLARE a INT DEFAULT 0;
18 REPEAT
19 SET a= a+1;
20 UPDATE t SET c = 'xx' WHERE pk = a;
21 UNTIL a = 100
22 END REPEAT;
23 END
24 $
25 --delimiter ;
26
27 --connection default
28 --error 0,ER_LOCK_WAIT_TIMEOUT
29 ALTER TABLE t NOWAIT ADD INDEX (c);
30
31 --connection con1
32 --reap
33
34 --connection default
35
36 --let $datadir= `select @@datadir`
37
38 FLUSH TABLE t FOR EXPORT;
39 --let $create= query_get_value(SHOW CREATE TABLE t, Create Table, 1)
40 --copy_file $datadir/test/t.cfg $datadir/test/t.cfg.sav
41 --copy_file $datadir/test/t.ibd $datadir/test/t.ibd.sav
42 UNLOCK TABLES;
43
44 DROP TABLE t;
45 --disable_query_log
46 eval $create;
47 --enable_query_log
48
49 ALTER TABLE t DISCARD TABLESPACE;
50 --move_file $datadir/test/t.cfg.sav $datadir/test/t.cfg
51 --move_file $datadir/test/t.ibd.sav $datadir/test/t.ibd
52 ALTER TABLE t IMPORT TABLESPACE;
53
54 # Cleanup
55 DROP TABLE t;