1--source ../include/quick_mode_1_init.inc
2--echo
3--echo drop and create databases
4--connection master_1
5--disable_warnings
6CREATE DATABASE auto_test_local;
7USE auto_test_local;
8if ($USE_CHILD_GROUP2)
9{
10  --connection child2_1
11  if ($USE_GENERAL_LOG)
12  {
13    SET @old_log_output = @@global.log_output;
14    SET GLOBAL log_output = 'TABLE,FILE';
15  }
16  CREATE DATABASE auto_test_remote;
17  USE auto_test_remote;
18  --connection child2_2
19  if ($USE_GENERAL_LOG)
20  {
21    SET @old_log_output = @@global.log_output;
22    SET GLOBAL log_output = 'TABLE,FILE';
23  }
24  CREATE DATABASE auto_test_remote2;
25  USE auto_test_remote2;
26}
27--enable_warnings
28
29--echo
30--echo create table and insert
31if ($USE_CHILD_GROUP2)
32{
33  if (!$OUTPUT_CHILD_GROUP2)
34  {
35    --disable_query_log
36    --disable_result_log
37  }
38  --connection child2_1
39  if ($OUTPUT_CHILD_GROUP2)
40  {
41    --disable_query_log
42    echo CHILD2_1_CREATE_TABLES;
43  }
44  eval $CHILD2_1_CREATE_TABLES;
45  if ($OUTPUT_CHILD_GROUP2)
46  {
47    --enable_query_log
48  }
49  if ($USE_GENERAL_LOG)
50  {
51    TRUNCATE TABLE mysql.general_log;
52  }
53  --connection child2_2
54  if ($OUTPUT_CHILD_GROUP2)
55  {
56    --disable_query_log
57    echo CHILD2_2_CREATE_TABLES;
58  }
59  eval $CHILD2_2_CREATE_TABLES;
60  if ($OUTPUT_CHILD_GROUP2)
61  {
62    --enable_query_log
63  }
64  if ($USE_GENERAL_LOG)
65  {
66    TRUNCATE TABLE mysql.general_log;
67  }
68  if (!$OUTPUT_CHILD_GROUP2)
69  {
70    --enable_query_log
71    --enable_result_log
72  }
73}
74--connection master_1
75--disable_query_log
76echo CREATE TABLE tbl_a (
77    pkey int NOT NULL,
78    PRIMARY KEY (pkey)
79) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_1;
80echo CREATE TABLE tbl_b (
81    pkey int NOT NULL,
82    PRIMARY KEY (pkey)
83) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_2;
84eval CREATE TABLE tbl_a (
85    pkey int NOT NULL,
86    PRIMARY KEY (pkey)
87) $MASTER_1_ENGINE $MASTER_1_CHARSET $MASTER_1_COMMENT_2_1;
88eval CREATE TABLE tbl_b (
89    pkey int NOT NULL,
90    PRIMARY KEY (pkey)
91) $MASTER_1_ENGINE $MASTER_1_CHARSET $MASTER_1_COMMENT_2_2;
92--enable_query_log
93INSERT INTO tbl_a (pkey) VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
94INSERT INTO tbl_a (pkey) VALUES (10),(11),(12),(13),(14),(15),(16),(17),(18),(19);
95INSERT INTO tbl_a (pkey) VALUES (20),(21),(22),(23),(24),(25),(26),(27),(28),(29);
96INSERT INTO tbl_b (pkey) VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
97INSERT INTO tbl_b (pkey) VALUES (10),(11),(12),(13),(14),(15),(16),(17),(18),(19);
98INSERT INTO tbl_b (pkey) VALUES (20),(21),(22),(23),(24),(25),(26),(27),(28),(29);
99
100--echo
101--echo select test 1
102if ($USE_CHILD_GROUP2)
103{
104  if (!$OUTPUT_CHILD_GROUP2)
105  {
106    --disable_query_log
107    --disable_result_log
108  }
109  --connection child2_1
110  if ($USE_GENERAL_LOG)
111  {
112    TRUNCATE TABLE mysql.general_log;
113  }
114  --connection child2_2
115  if ($USE_GENERAL_LOG)
116  {
117    TRUNCATE TABLE mysql.general_log;
118  }
119  if (!$OUTPUT_CHILD_GROUP2)
120  {
121    --enable_query_log
122    --enable_result_log
123  }
124}
125--connection master_1
126SELECT a.pkey FROM tbl_a a, tbl_b b WHERE a.pkey = b.pkey;
127if ($USE_CHILD_GROUP2)
128{
129  if (!$OUTPUT_CHILD_GROUP2)
130  {
131    --disable_query_log
132    --disable_result_log
133  }
134  --connection child2_1
135  if ($USE_GENERAL_LOG)
136  {
137    --replace_regex /tmp_spider_bka_0x[0-9a-f]*/tmp_spider_bka_xxxx/
138    eval $CHILD2_1_SELECT_ARGUMENT1;
139  }
140  eval $CHILD2_1_SELECT_TABLES;
141  --connection child2_2
142  if ($USE_GENERAL_LOG)
143  {
144    --replace_regex /tmp_spider_bka_0x[0-9a-f]*/tmp_spider_bka_xxxx/
145    eval $CHILD2_2_SELECT_ARGUMENT1;
146  }
147  eval $CHILD2_2_SELECT_TABLES;
148  if (!$OUTPUT_CHILD_GROUP2)
149  {
150    --enable_query_log
151    --enable_result_log
152  }
153}
154
155--connection master_1
156eval $MASTER_1_SET_QUICK_PAGE_BYTE_6;
157
158--echo
159--echo select test 2
160if ($USE_CHILD_GROUP2)
161{
162  if (!$OUTPUT_CHILD_GROUP2)
163  {
164    --disable_query_log
165    --disable_result_log
166  }
167  --connection child2_1
168  if ($USE_GENERAL_LOG)
169  {
170    TRUNCATE TABLE mysql.general_log;
171  }
172  --connection child2_2
173  if ($USE_GENERAL_LOG)
174  {
175    TRUNCATE TABLE mysql.general_log;
176  }
177  if (!$OUTPUT_CHILD_GROUP2)
178  {
179    --enable_query_log
180    --enable_result_log
181  }
182}
183--connection master_1
184SELECT a.pkey FROM tbl_a a, tbl_b b WHERE a.pkey = b.pkey;
185if ($USE_CHILD_GROUP2)
186{
187  if (!$OUTPUT_CHILD_GROUP2)
188  {
189    --disable_query_log
190    --disable_result_log
191  }
192  --connection child2_1
193  if ($USE_GENERAL_LOG)
194  {
195    --replace_regex /tmp_spider_bka_0x[0-9a-f]*/tmp_spider_bka_xxxx/
196    eval $CHILD2_1_SELECT_ARGUMENT1;
197  }
198  eval $CHILD2_1_SELECT_TABLES;
199  --connection child2_2
200  if ($USE_GENERAL_LOG)
201  {
202    --replace_regex /tmp_spider_bka_0x[0-9a-f]*/tmp_spider_bka_xxxx/
203    eval $CHILD2_2_SELECT_ARGUMENT1;
204  }
205  eval $CHILD2_2_SELECT_TABLES;
206  if (!$OUTPUT_CHILD_GROUP2)
207  {
208    --enable_query_log
209    --enable_result_log
210  }
211}
212
213--connection master_1
214eval $MASTER_1_SET_QUICK_PAGE_BYTE_0;
215
216--echo
217--echo select test 3
218if ($USE_CHILD_GROUP2)
219{
220  if (!$OUTPUT_CHILD_GROUP2)
221  {
222    --disable_query_log
223    --disable_result_log
224  }
225  --connection child2_1
226  if ($USE_GENERAL_LOG)
227  {
228    TRUNCATE TABLE mysql.general_log;
229  }
230  --connection child2_2
231  if ($USE_GENERAL_LOG)
232  {
233    TRUNCATE TABLE mysql.general_log;
234  }
235  if (!$OUTPUT_CHILD_GROUP2)
236  {
237    --enable_query_log
238    --enable_result_log
239  }
240}
241--connection master_1
242SELECT a.pkey FROM tbl_a a, tbl_b b WHERE a.pkey = b.pkey;
243if ($USE_CHILD_GROUP2)
244{
245  if (!$OUTPUT_CHILD_GROUP2)
246  {
247    --disable_query_log
248    --disable_result_log
249  }
250  --connection child2_1
251  if ($USE_GENERAL_LOG)
252  {
253    --replace_regex /tmp_spider_bka_0x[0-9a-f]*/tmp_spider_bka_xxxx/
254    eval $CHILD2_1_SELECT_ARGUMENT1;
255  }
256  eval $CHILD2_1_SELECT_TABLES;
257  --connection child2_2
258  if ($USE_GENERAL_LOG)
259  {
260    --replace_regex /tmp_spider_bka_0x[0-9a-f]*/tmp_spider_bka_xxxx/
261    eval $CHILD2_2_SELECT_ARGUMENT1;
262  }
263  eval $CHILD2_2_SELECT_TABLES;
264  if (!$OUTPUT_CHILD_GROUP2)
265  {
266    --enable_query_log
267    --enable_result_log
268  }
269}
270
271--echo
272--echo deinit
273--disable_warnings
274--connection master_1
275DROP DATABASE IF EXISTS auto_test_local;
276if ($USE_CHILD_GROUP2)
277{
278  --connection child2_1
279  DROP DATABASE IF EXISTS auto_test_remote;
280  if ($USE_GENERAL_LOG)
281  {
282    SET GLOBAL log_output = @old_log_output;
283  }
284  --connection child2_2
285  DROP DATABASE IF EXISTS auto_test_remote2;
286  if ($USE_GENERAL_LOG)
287  {
288    SET GLOBAL log_output = @old_log_output;
289  }
290}
291--enable_warnings
292--source ../include/quick_mode_1_deinit.inc
293--echo
294--echo end of test
295