Debian Codegraph @

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

raw
1 call mtr.add_suppression("InnoDB: Operating system error number ");
2 call mtr.add_suppression("InnoDB: (Error number \\d+ means|If you are|Cannot open datafile) ");
3 call mtr.add_suppression("InnoDB: Ignoring tablespace for test/t ");
4 call mtr.add_suppression("InnoDB: Table test/t .* does not exist");
5 CREATE TABLE t (a SERIAL) ENGINE=InnoDB;
6 INSERT INTO t() VALUES();
7 SHOW CREATE TABLE t;
8 Table Create Table
9 t CREATE TABLE `t` (
10 `a` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
11 UNIQUE KEY `a` (`a`)
12 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
13 # restart
14 SELECT * FROM t;
15 ERROR HY000: Got error 194 "Tablespace is missing for a table" from storage engine InnoDB
16 TRUNCATE TABLE t;
17 ERROR HY000: Got error 194 "Tablespace is missing for a table" from storage engine InnoDB
18 DROP TABLE t;