Debian Codegraph @

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

raw
1 ##########################################################################
2 # Test script to test ALTER TABLE ADD/DROP COLUMN ... ALGORITHM=INSTANT
3 # for a table with
4 # - No key defined.
5 # - PK defined.
6 # - Secondary index defined.
7 ##########################################################################
8
9 --echo ##############################################
10 --echo # Test instant ADD/DROP COLUMN for REDUNDANT format
11 --echo ##############################################
12 let $row_format = REDUNDANT;
13
14 # Test without any index
15 let $clust_index=;
16 let $sec_index=;
17 --source suite/innodb/include/instant_ddl_basic.inc
18
19 # Test with clustered index
20 let $clust_index=, PRIMARY KEY (c1);
21 --source suite/innodb/include/instant_ddl_basic.inc
22
23 # Test with secondary index
24 let $sec_index=, KEY (c2);
25 --source suite/innodb/include/instant_ddl_basic.inc
26
27 --echo ############################################
28 --echo # Test instant ADD/DROP COLUMN for DYNAMIC format
29 --echo ############################################
30 let $row_format = DYNAMIC;
31
32 # Test without any index
33 let $clust_index=;
34 let $sec_index=;
35 --source suite/innodb/include/instant_ddl_basic.inc
36
37 # Test with clustered index
38 let $clust_index=, PRIMARY KEY (c1);
39 --source suite/innodb/include/instant_ddl_basic.inc
40
41 # Test with secondary index
42 let $sec_index=, KEY (c2);
43 --source suite/innodb/include/instant_ddl_basic.inc
44
45 --echo ############################################
46 --echo # Test instant ADD/DROP COLUMN for COMPACT format
47 --echo ############################################
48 let $row_format = COMPACT;
49
50 # Test without any index
51 let $clust_index=;
52 let $sec_index=;
53 --source suite/innodb/include/instant_ddl_basic.inc
54
55 # Test with clustered index
56 let $clust_index=, PRIMARY KEY (c1);
57 --source suite/innodb/include/instant_ddl_basic.inc
58
59 # Test with secondary index
60 let $sec_index=, KEY (c2);
61 --source suite/innodb/include/instant_ddl_basic.inc