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
61
|
##########################################################################
# Test script to test ALTER TABLE ADD/DROP COLUMN ... ALGORITHM=INSTANT
# for a table with
# - No key defined.
# - PK defined.
# - Secondary index defined.
##########################################################################
--echo ##############################################
--echo # Test instant ADD/DROP COLUMN for REDUNDANT format
--echo ##############################################
let $row_format = REDUNDANT;
# Test without any index
let $clust_index=;
let $sec_index=;
--source suite/innodb/include/instant_ddl_basic.inc
# Test with clustered index
let $clust_index=, PRIMARY KEY (c1);
--source suite/innodb/include/instant_ddl_basic.inc
# Test with secondary index
let $sec_index=, KEY (c2);
--source suite/innodb/include/instant_ddl_basic.inc
--echo ############################################
--echo # Test instant ADD/DROP COLUMN for DYNAMIC format
--echo ############################################
let $row_format = DYNAMIC;
# Test without any index
let $clust_index=;
let $sec_index=;
--source suite/innodb/include/instant_ddl_basic.inc
# Test with clustered index
let $clust_index=, PRIMARY KEY (c1);
--source suite/innodb/include/instant_ddl_basic.inc
# Test with secondary index
let $sec_index=, KEY (c2);
--source suite/innodb/include/instant_ddl_basic.inc
--echo ############################################
--echo # Test instant ADD/DROP COLUMN for COMPACT format
--echo ############################################
let $row_format = COMPACT;
# Test without any index
let $clust_index=;
let $sec_index=;
--source suite/innodb/include/instant_ddl_basic.inc
# Test with clustered index
let $clust_index=, PRIMARY KEY (c1);
--source suite/innodb/include/instant_ddl_basic.inc
# Test with secondary index
let $sec_index=, KEY (c2);
--source suite/innodb/include/instant_ddl_basic.inc
|
