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
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
|
--source ../include/init_vp.inc
let $MASTER_1_COMMENT_2_1=
COMMENT='default_database "auto_test_remote"'
CONNECTION='table_name_list "ta_r ta_r_2"';
let $MASTER_1_COMMENT2_2_1=
COMMENT='default_database "auto_test_remote"'
CONNECTION='table_name_list "ta_r_no_idx"';
#let $MASTER_1_COMMENT_P_2_1=
# COMMENT='default_database "auto_test_remote"'
# CONNECTION='table_name_list "ta_r2 ta_r2_2"';
#If you apply the patch, you can use table partitioning test.
let $MASTER_1_COMMENT_P_2_1=
COMMENT='default_database "auto_test_remote2"'
CONNECTION='table_name_list "ta_r2 ta_r2_2"'
PARTITION BY KEY(a) (
PARTITION pt1 COMMENT='default_database "auto_test_remote"',
PARTITION pt2 COMMENT='table_name_list "ta_r3 ta_r3_2"'
);
#let $MASTER_1_COMMENT2_P_2_1=
# COMMENT='default_database "auto_test_remote"'
# CONNECTION='table_name_list "ta_r2 ta_r2_2"';
#If you apply the patch, you can use table partitioning test.
let $MASTER_1_COMMENT2_P_2_1=
COMMENT='default_database "auto_test_remote2"'
CONNECTION='table_name_list "ta_r2 ta_r2_2"'
PARTITION BY RANGE(a) (
PARTITION pt1 VALUES LESS THAN (4)
COMMENT='default_database "auto_test_remote"',
PARTITION pt2 VALUES LESS THAN MAXVALUE
COMMENT='table_name_list "ta_r3 ta_r3_2"'
);
let $MASTER_1_COMMENT3_2_1=
COMMENT='default_database "auto_test_remote"'
CONNECTION='table_name_list "ta_r_auto_inc ta_r_auto_inc_2"';
#let $MASTER_1_COMMENT3_P_2_1=
# COMMENT='default_database "auto_test_remote"'
# CONNECTION='table_name_list "ta_r_int ta_r_int_2"';
#If you apply the patch, you can use table partitioning test.
let $MASTER_1_COMMENT3_P_2_1=
CONNECTION='table_name_list "ta_r_int ta_r_int_2"'
PARTITION BY LIST(MOD(a, 2)) (
PARTITION pt1 VALUES IN (0)
COMMENT='default_database "auto_test_remote"',
PARTITION pt2 VALUES IN (1)
COMMENT='default_database "auto_test_remote2"'
);
let $MASTER_1_COMMENT4_2_1=
COMMENT='default_database "auto_test_remote"'
CONNECTION='table_name_list "ta_r_int ta_r_int_2"';
let $MASTER_1_COMMENT5_2_1=
COMMENT='default_database "auto_test_remote"'
CONNECTION='table_name_list "ta_r_3"';
let $MASTER_1_COMMENT_FT_2_1=
COMMENT='default_database "auto_test_remote"'
CONNECTION='table_name_list "ft_r ft_r_2"';
let $MASTER_1_COMMENT2_FT_P_2_1=
COMMENT='default_database "auto_test_remote2"'
CONNECTION='table_name_list "ft_r2 ft_r2_2"'
PARTITION BY RANGE(a) (
PARTITION pt1 VALUES LESS THAN (4)
COMMENT='default_database "auto_test_remote"',
PARTITION pt2 VALUES LESS THAN MAXVALUE
COMMENT='table_name_list "ft_r3 ft_r3_2"'
);
let $MASTER_1_COMMENT_GM_2_1=
COMMENT='default_database "auto_test_remote"'
CONNECTION='table_name_list "gm_r gm_r_2"';
let $MASTER_1_COMMENT2_GM_P_2_1=
COMMENT='default_database "auto_test_remote2"'
CONNECTION='table_name_list "gm_r2 gm_r2_2"'
PARTITION BY RANGE(a) (
PARTITION pt1 VALUES LESS THAN (4)
COMMENT='default_database "auto_test_remote"',
PARTITION pt2 VALUES LESS THAN MAXVALUE
COMMENT='table_name_list "gm_r3 gm_r3_2"'
);
let $MASTER_1_COMMENT_LOCK1=
COMMENT 'tnl "auto_test_remote.t1_1 auto_test_remote2.t1_2"';
let $MASTER_1_COMMENT_LOCK2=
COMMENT 'tnl "auto_test_remote2.t2_1 auto_test_remote.t2_2"';
let $MASTER_1_COMMENT_INCREMENT1_1=
COMMENT='tnl "t1_1", default_database "auto_test_remote"';
let $MASTER_1_COMMENT_INCREMENT1_P_1=
PARTITION BY LIST(MOD(id, 2)) (
PARTITION pt1 VALUES IN (0)
COMMENT='tnl "t1_1", default_database "auto_test_remote"',
PARTITION pt2 VALUES IN (1)
COMMENT='tnl "t1_2", default_database "auto_test_remote2"'
);
let $MASTER_1_COMMENT_TEXT_PK1_1=
COMMENT 'tnl "t1", default_database "auto_test_remote"';
let $MASTER_1_COMMENT_TEXT_KEY1_1=
COMMENT 'tnl "t1", default_database "auto_test_remote"';
let $MASTER_1_CHECK_DIRECT_UPDATE_STATUS=
SHOW STATUS LIKE 'Vp_direct_update';
let $MASTER_1_CHECK_DIRECT_DELETE_STATUS=
SHOW STATUS LIKE 'Vp_direct_delete';
let $MASTER_1_CHECK_DIRECT_ORDER_LIMIT_STATUS=
SHOW STATUS LIKE 'Vp_direct_order_limit';
let $MASTER_1_CHECK_DIRECT_AGGREGATE_STATUS=
SHOW STATUS LIKE 'Vp_direct_aggregate';
let $MASTER_1_AUTO_INCREMENT_INCREMENT1=
SET SESSION AUTO_INCREMENT_INCREMENT = 1;
let $MASTER_1_AUTO_INCREMENT_INCREMENT2=
SET SESSION AUTO_INCREMENT_INCREMENT = 777;
let $MASTER_1_AUTO_INCREMENT_OFFSET1=
SET SESSION AUTO_INCREMENT_OFFSET = 1;
let $MASTER_1_AUTO_INCREMENT_OFFSET2=
SET SESSION AUTO_INCREMENT_OFFSET = 777;
let $MASTER_1_AUTO_INCREMENT_OFFSET3=
SET SESSION AUTO_INCREMENT_OFFSET = 1;
let $MASTER_1_AUTO_INCREMENT_OFFSET4=
SET SESSION AUTO_INCREMENT_OFFSET = 777;
|
