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