Debian Codegraph @

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

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