| 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; |