| 1 |
# |
| 2 |
# MDEV-29144 ER_TABLE_SCHEMA_MISMATCH or crash on DISCARD/IMPORT |
| 3 |
# |
| 4 |
call mtr.add_suppression("InnoDB: Unknown index id"); |
| 5 |
CREATE TABLE t (pk int PRIMARY KEY, c varchar(1024)) |
| 6 |
ENGINE=InnoDB CHARSET latin1; |
| 7 |
INSERT INTO t SELECT seq, 'x' FROM seq_1_to_100; |
| 8 |
connect con1,localhost,root,,test; |
| 9 |
BEGIN NOT ATOMIC |
| 10 |
DECLARE a INT DEFAULT 0; |
| 11 |
REPEAT |
| 12 |
SET a= a+1; |
| 13 |
UPDATE t SET c = 'xx' WHERE pk = a; |
| 14 |
UNTIL a = 100 |
| 15 |
END REPEAT; |
| 16 |
END |
| 17 |
$ |
| 18 |
connection default; |
| 19 |
ALTER TABLE t NOWAIT ADD INDEX (c); |
| 20 |
connection con1; |
| 21 |
connection default; |
| 22 |
FLUSH TABLE t FOR EXPORT; |
| 23 |
UNLOCK TABLES; |
| 24 |
DROP TABLE t; |
| 25 |
ALTER TABLE t DISCARD TABLESPACE; |
| 26 |
ALTER TABLE t IMPORT TABLESPACE; |
| 27 |
DROP TABLE t; |