Debian Codegraph @

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

raw
1 --source include/have_debug.inc
2 --source include/not_valgrind.inc
3 --source include/not_crashrep.inc
4 --source include/big_test.inc
5
6 --disable_query_log
7 call mtr.add_suppression("Checksum mismatch in datafile");
8 call mtr.add_suppression("\\[ERROR\\] Could not find a valid tablespace file for");
9 --enable_query_log
10
11 LET $innodb_ddl_log_crash_reset_debug_orig = `SELECT @@innodb_ddl_log_crash_reset_debug`;
12
13 CREATE TABLESPACE ts1 ADD DATAFILE 'data1.ibd';
14 CREATE TABLESPACE ts2 ADD DATAFILE 'data2.ibd';
15
16 let $table_name= t1;
17
18 let $create_statement= CREATE TABLE $table_name
19 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2
20 PARTITION BY RANGE(a) PARTITIONS 3
21 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
22 PARTITION p2 VALUES LESS THAN (5),
23 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
24
25 let $insert_statement= INSERT INTO t1 VALUES (1, "Filler1", 1),
26 (2, "filler2", 2), (3, "FILLER3", 3), (4, "Filler4", 4), (5, "5", 5),
27 (6, "filler6", 6);
28
29
30 let $test_free= 1;
31 let $test_delete= 0;
32 let $test_rename= 0;
33 let $test_drop= 0;
34 let $crash_statement= ALTER TABLE $table_name ADD INDEX(b), TABLESPACE=innodb_system;
35 --source ../mysql-test/suite/innodb/include/ddl_crash_statement.inc
36
37
38 let $test_free= 1;
39 let $test_delete= 1;
40 let $test_rename= 0;
41 let $test_drop= 0;
42 let $crash_statement= ALTER TABLE $table_name DROP INDEX c, TABLESPACE=ts1;
43 --source ../mysql-test/suite/innodb/include/ddl_crash_statement.inc
44
45
46 let $test_free= 1;
47 let $test_delete= 0;
48 let $test_rename= 0;
49 let $test_drop= 0;
50 let $crash_statement= ALTER TABLE $table_name DROP INDEX c, TABLESPACE=innodb_file_per_table;
51 --source ../mysql-test/suite/innodb/include/ddl_crash_statement.inc
52
53
54 let $test_free= 1;
55 let $test_delete= 1;
56 let $test_rename= 0;
57 let $test_drop= 0;
58 let $create_statement= CREATE TABLE $table_name
59 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB
60 PARTITION BY RANGE(a) PARTITIONS 3
61 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1,
62 PARTITION p2 VALUES LESS THAN (5),
63 PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table);
64 let $crash_statement= ALTER TABLE $table_name DROP INDEX c, TABLESPACE=ts1;
65 --source ../mysql-test/suite/innodb/include/ddl_crash_statement.inc
66
67
68 DROP TABLESPACE ts1;
69 DROP TABLESPACE ts2;
70
71 eval SET GLOBAL innodb_ddl_log_crash_reset_debug = $innodb_ddl_log_crash_reset_debug_orig;
72