Debian Codegraph @

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

raw
1 #Windows has trouble creating files/directories with long names
2 --source include/not_windows.inc
3
4 --echo #
5 --echo # Bug#19419026 WHEN A TABLESPACE IS NOT FOUND, DO NOT REPORT "TABLE NOT FOUND"
6 --echo #
7
8 #Create database and tablename with all special characters
9
10 CREATE DATABASE `..................................................`;
11 USE `..................................................`;
12 CREATE TABLE `..................................................` (id int) engine=innodb;
13
14 --source include/shutdown_mysqld.inc
15
16 --remove_file $MYSQLTEST_VARDIR/mysqld.1/data/@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e/@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@002e@[email protected]
17
18 --source include/start_mysqld.inc
19
20 --disable_query_log
21 call mtr.add_suppression("\\[ERROR\\] .*MY-\\d+.* Operating system error number 2 in a file operation.");
22 call mtr.add_suppression("\\[ERROR\\] .*MY-\\d+.* The error means the system cannot find the path specified.");
23 call mtr.add_suppression("\\[ERROR\\] .*MY-\\d+.* If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.");
24 call mtr.add_suppression("\\[ERROR\\] .*MY-\\d+.* Failed to find tablespace for table `\.\.*`\.`\.\.*` in the cache.");
25 call mtr.add_suppression("\\[ERROR\\] .*MY-\\d+.* Cannot open datafile for read-only");
26 call mtr.add_suppression("\\[ERROR\\] .*MY-\\d+.* Could not find a valid tablespace file for");
27 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* Ignoring tablespace .* because it could not be opened");
28 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* Cannot calculate statistics for table `\.\.*`\.`\.\.*` because the \.ibd file is missing");
29 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* Tablespace .*, name '.*', file '.*' is missing!");
30 --enable_query_log
31
32 --error ER_TABLESPACE_MISSING
33 select * from `..................................................`;
34 DROP TABLE `..................................................`;
35 DROP DATABASE `..................................................`;
36
37 --echo #
38 --echo # Bug #26761960 TABLESPACE WITH SPECIAL CHARACTER MAY
39 --echo # BE NOT FOUND AFTER RESTART
40 --echo #
41
42 create database `test#_1`;
43 create table `test#_1`.t1(f1 int);
44 insert into `test#_1`.t1 values(1);
45 insert into `test#_1`.t1 select * from `test#_1`.t1;
46
47 --source include/kill_and_restart_mysqld.inc
48
49 insert into `test#_1`.t1 values(2);
50
51 drop table `test#_1`.t1;
52 drop database `test#_1`;