1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
|
# There are two variations of the test:
# 1. Create multiple tables and preform test queries
# 2. Create multiple tables, restart mysqld and perform test queries
# 3. BUG 31215415 - shutdown right after trying to rebuild discarded partition
#
# Have a look at include/discarded_partition.inc for more details
--echo # Testing discarded partitions without restart
--let $discarded_partition_option = PREPARE
--source suite/innodb/include/discarded_partition.inc
--let $discarded_partition_option = SELECT_TEST
--source suite/innodb/include/discarded_partition.inc
--let $discarded_partition_option = REBUILD_PARTITION_TEST
--source suite/innodb/include/discarded_partition.inc
--let $discarded_partition_option = CREATE_SECONDARY_INDEX_TEST
--source suite/innodb/include/discarded_partition.inc
--let $discarded_partition_option = DROP_TEST
--source suite/innodb/include/discarded_partition.inc
--echo # Testing discarded partitions with restart
--let $discarded_partition_option = PREPARE
--source suite/innodb/include/discarded_partition.inc
--source include/restart_mysqld.inc
--let $discarded_partition_option = SELECT_TEST
--source suite/innodb/include/discarded_partition.inc
--let $discarded_partition_option = REBUILD_PARTITION_TEST
--source suite/innodb/include/discarded_partition.inc
--let $discarded_partition_option = CREATE_SECONDARY_INDEX_TEST
--source suite/innodb/include/discarded_partition.inc
--let $discarded_partition_option = DROP_TEST
--source suite/innodb/include/discarded_partition.inc
--echo # Test shutdown just after rebuild partition
--let $discarded_partition_option = PREPARE
--source suite/innodb/include/discarded_partition.inc
--error ER_TABLESPACE_DISCARDED
ALTER TABLE partitions.t1 REBUILD PARTITION p0;
--source include/restart_mysqld.inc
--let $discarded_partition_option = DROP_TEST
--source suite/innodb/include/discarded_partition.inc
--disable_query_log
call mtr.add_suppression("\\[Warning\\].* Tablespace .*, name '.*', file '.*' is missing");
call mtr.add_suppression("\\[Warning\\].* Tablespace for table `.*`\\.`.*` /\\* Partition `.*` \\*/ is set as discarded");
call mtr.add_suppression("\\[Warning\\].* Cannot calculate statistics for table `.*`.`.*` /\\* Partition `.*` \\*/ because the \\.ibd file is missing\\. Please refer to http://dev\\.mysql\\.com/doc/refman/8.0/en/innodb-troubleshooting\\.html for how to resolve the issue");
--enable_query_log
|
