Debian Codegraph @

mysql-test/suite/rpl/include/rpl_row_img.test

raw
1 # WL#5096
2 #
3 # Description
4 # ===========
5 #
6 # This test case checks replication between hosts with same index
7 # structure but may differ on engines.
8 #
9 # Usage
10 # =====
11 #
12 # Before including this file the following variables should be set:
13 # * $server_1_engine
14 # * $server_2_engine
15 # * $server_3_engine
16 #
17 # Example:
18 #
19 # -- let $server_1_engine= Falcon
20 # -- let $server_2_engine= MyISAM
21 # -- let $server_3_engine= InnoDB
22 #
23 # -- source suite/rpl/include/rpl_row_img.test
24 #
25
26 -- connection server_1
27
28 -- let $diff_table=test.t
29
30 let $i= 12;
31 while($i)
32 {
33 let $step= "";
34
35 -- connection server_1
36 SET SQL_LOG_BIN=0;
37
38 -- connection server_2
39 SET SQL_LOG_BIN=0;
40
41 -- connection server_3
42 SET SQL_LOG_BIN=0;
43
44 if ($i == 1) {
45 let $step= No keys;
46 --echo ******* TEST: $step
47 -- connection server_1
48 --eval CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1)) engine= $server_1_engine;
49 -- connection server_2
50 --eval CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1)) engine= $server_2_engine;
51 -- connection server_3
52 --eval CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1)) engine= $server_3_engine;
53
54 }
55 if ($i == 2)
56 {
57 let $step= One key;
58 --echo ******* TEST: $step
59 -- connection server_1
60 --eval CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1)) engine= $server_1_engine;
61 -- connection server_2
62 --eval CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1)) engine= $server_2_engine;
63 -- connection server_3
64 --eval CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1)) engine= $server_3_engine;
65
66 }
67 if ($i == 3)
68 {
69 let $step= One Composite key;
70 --echo ****** TEST: $step
71 -- connection server_1
72 --eval CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c2)) engine= $server_1_engine;
73 -- connection server_2
74 --eval CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c2)) engine= $server_2_engine;
75 -- connection server_3
76 --eval CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c2)) engine= $server_3_engine;
77 }
78 if ($i == 4)
79 {
80 let $step= One Unique key;
81 --echo ****** TEST: $step
82 -- connection server_1
83 --eval CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1)) engine= $server_1_engine;
84 -- connection server_2
85 --eval CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1)) engine= $server_2_engine;
86 -- connection server_3
87 --eval CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1)) engine= $server_3_engine;
88
89 }
90 if ($i == 5)
91 {
92 let $step= One Composite Unique key;
93 --echo ****** TEST: $step
94 -- connection server_1
95 --eval CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c2)) engine= $server_1_engine;
96 -- connection server_2
97 --eval CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c2)) engine= $server_2_engine;
98 -- connection server_3
99 --eval CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c2)) engine= $server_3_engine;
100
101 }
102 if ($i == 6)
103 {
104 let $step= One Primary key;
105 --echo ****** TEST: $step
106 -- connection server_1
107 --eval CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1)) engine= $server_1_engine;
108 -- connection server_2
109 --eval CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1)) engine= $server_2_engine;
110 -- connection server_3
111 --eval CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1)) engine= $server_3_engine;
112 }
113 if ($i == 7)
114 {
115 let $step= One Composite Primary Key;
116 --echo ****** TEST: $step
117 -- connection server_1
118 --eval CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c2)) engine= $server_1_engine;
119 -- connection server_2
120 --eval CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c2)) engine= $server_2_engine;
121 -- connection server_3
122 --eval CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c2)) engine= $server_3_engine;
123 }
124 if ($i == 8)
125 {
126 let $step= One Composite key with holes;
127 --echo ****** TEST: $step
128 -- connection server_1
129 --eval CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c3)) engine= $server_1_engine;
130 -- connection server_2
131 --eval CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c3)) engine= $server_2_engine;
132 -- connection server_3
133 --eval CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), key(c1,c3)) engine= $server_3_engine;
134 }
135 if ($i == 9)
136 {
137 let $step= One Composite Unique key with holes;
138 --echo ****** TEST: $step
139 -- connection server_1
140 --eval CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= $server_1_engine;
141 -- connection server_2
142 --eval CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= $server_2_engine;
143 -- connection server_3
144 --eval CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= $server_3_engine;
145 }
146 if ($i == 10)
147 {
148 let $step= One Composite Primary Key with holes;
149 --echo ****** TEST: $step
150 -- connection server_1
151 --eval CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c3)) engine= $server_1_engine;
152 -- connection server_2
153 --eval CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c3)) engine= $server_2_engine;
154 -- connection server_3
155 --eval CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), primary key(c1,c3)) engine= $server_3_engine;
156 }
157 if ($i == 11)
158 {
159 let $step= One Composite NOT NULL Unique key with holes;
160 --echo ****** TEST: $step
161 -- connection server_1
162 --eval CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= $server_1_engine;
163 -- connection server_2
164 --eval CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= $server_2_engine;
165 -- connection server_3
166 --eval CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= $server_3_engine;
167 }
168 if ($i == 12)
169 {
170 let $step= One Composite NOT NULL Unique key with holes in master, but NULLABLE on first slave;
171 --echo ****** TEST: $step
172 -- connection server_1
173 --eval CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= $server_1_engine;
174 -- connection server_2
175 --eval CREATE TABLE t (c1 int, c2 char(1), c3 char(1), c4 char(1), unique key(c1,c3)) engine= $server_2_engine;
176 -- connection server_3
177 --eval CREATE TABLE t (c1 int NOT NULL, c2 char(1), c3 char(1) NOT NULL, c4 char(1), unique key(c1,c3)) engine= $server_3_engine;
178 }
179
180 -- connection server_1
181 SET SQL_LOG_BIN=1;
182
183 -- connection server_2
184 SET SQL_LOG_BIN=1;
185
186 -- connection server_3
187 SET SQL_LOG_BIN=1;
188
189 -- connection server_1
190 INSERT INTO t VALUES (1, '1', '1', '1' );
191 INSERT INTO t VALUES (4, '4', '4', '4' );
192 INSERT INTO t VALUES (7, '7', '7', '7' );
193
194 INSERT INTO t VALUES (9, '9', '9', NULL );
195
196 INSERT INTO t VALUES (2, '1', '2', '2' );
197 INSERT INTO t VALUES (3, '1', '3', '2' );
198
199 -- source include/rpl_sync.inc
200
201 -- connection server_1
202 UPDATE t SET c4 = '7';
203
204 UPDATE t SET c4 = '5' WHERE c1 = 1;
205 UPDATE t SET c2 = '5' WHERE c1 = 1;
206 UPDATE t SET c1 = '5' WHERE c1 = 1;
207
208 UPDATE t SET c4 = '8' WHERE c2 = '4';
209 UPDATE t SET c1 = '8' WHERE c2 = '4';
210 UPDATE t SET c2 = '8' WHERE c2 = '4';
211
212 UPDATE t SET c3 = '0' WHERE c4 = NULL;
213 UPDATE t SET c2 = '0' WHERE c4 = '0';
214
215 UPDATE t SET c2 = '2' WHERE c4 = '2';
216
217 -- source include/rpl_sync.inc
218
219 -- let $diff_tables= server_1:$diff_table, server_2:$diff_table, server_3:$diff_table
220 -- source include/diff_tables.inc
221
222
223 -- connection server_1
224
225 DELETE FROM t WHERE c1 = 7;
226 DELETE FROM t WHERE c1 = 8;
227 DELETE FROM t;
228
229 -- source include/rpl_sync.inc
230
231 -- let $diff_tables= server_1:$diff_table, server_2:$diff_table, server_3:$diff_table
232 -- source include/diff_tables.inc
233
234 -- connection server_1
235
236 DROP TABLE t;
237
238 -- source include/rpl_sync.inc
239
240 dec $i;
241 }