1--source ../include/quick_mode_2_init.inc 2--echo 3--echo this test is for MDEV-16520 4--echo 5--echo drop and create databases 6--connection master_1 7--disable_warnings 8CREATE DATABASE auto_test_local; 9USE auto_test_local; 10 11--connection child2_1 12SET @old_log_output = @@global.log_output; 13SET GLOBAL log_output = 'TABLE,FILE'; 14CREATE DATABASE auto_test_remote; 15USE auto_test_remote; 16 17--connection child2_2 18SET @old_log_output = @@global.log_output; 19SET GLOBAL log_output = 'TABLE,FILE'; 20CREATE DATABASE auto_test_remote2; 21USE auto_test_remote2; 22--enable_warnings 23 24--echo 25--echo create table and insert 26 27--connection child2_1 28--disable_query_log 29echo CHILD2_1_CREATE_TABLES; 30eval $CHILD2_1_CREATE_TABLES; 31--enable_query_log 32TRUNCATE TABLE mysql.general_log; 33 34--connection child2_2 35--disable_query_log 36echo CHILD2_2_CREATE_TABLES; 37eval $CHILD2_2_CREATE_TABLES; 38--enable_query_log 39TRUNCATE TABLE mysql.general_log; 40 41--connection master_1 42--disable_query_log 43echo CREATE TABLE tbl_a ( 44 pkey int NOT NULL, 45 PRIMARY KEY (pkey) 46) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_1; 47echo CREATE TABLE tbl_b ( 48 pkey int NOT NULL, 49 PRIMARY KEY (pkey) 50) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_2; 51eval CREATE TABLE tbl_a ( 52 pkey int NOT NULL, 53 PRIMARY KEY (pkey) 54) $MASTER_1_ENGINE $MASTER_1_CHARSET $MASTER_1_COMMENT_2_1; 55eval CREATE TABLE tbl_b ( 56 pkey int NOT NULL, 57 PRIMARY KEY (pkey) 58) $MASTER_1_ENGINE $MASTER_1_CHARSET $MASTER_1_COMMENT_2_2; 59--enable_query_log 60INSERT INTO tbl_a (pkey) VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 61INSERT INTO tbl_a (pkey) VALUES (10),(11),(12),(13),(14),(15),(16),(17),(18),(19); 62INSERT INTO tbl_a (pkey) VALUES (20),(21),(22),(23),(24),(25),(26),(27),(28),(29); 63INSERT INTO tbl_b (pkey) VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 64INSERT INTO tbl_b (pkey) VALUES (10),(11),(12),(13),(14),(15),(16),(17),(18),(19); 65INSERT INTO tbl_b (pkey) VALUES (20),(21),(22),(23),(24),(25),(26),(27),(28),(29); 66 67--echo 68--echo select test 1 69 70--connection child2_1 71TRUNCATE TABLE mysql.general_log; 72 73--connection child2_2 74TRUNCATE TABLE mysql.general_log; 75 76--connection master_1 77SELECT a.pkey FROM tbl_a a, tbl_b b WHERE a.pkey = b.pkey; 78 79--connection child2_1 80--replace_regex /tmp_spider_bka_0x[0-9a-f]*/tmp_spider_bka_xxxx/ 81eval $CHILD2_1_SELECT_ARGUMENT1; 82eval $CHILD2_1_SELECT_TABLES; 83 84--connection child2_2 85--replace_regex /tmp_spider_bka_0x[0-9a-f]*/tmp_spider_bka_xxxx/ 86eval $CHILD2_2_SELECT_ARGUMENT1; 87eval $CHILD2_2_SELECT_TABLES; 88 89--connection master_1 90eval $MASTER_1_SET_QUICK_PAGE_BYTE_6; 91 92--echo 93--echo select test 2 94 95--connection child2_1 96TRUNCATE TABLE mysql.general_log; 97 98--connection child2_2 99TRUNCATE TABLE mysql.general_log; 100 101--connection master_1 102SELECT a.pkey FROM tbl_a a, tbl_b b WHERE a.pkey = b.pkey; 103 104--connection child2_1 105--replace_regex /tmp_spider_bka_0x[0-9a-f]*/tmp_spider_bka_xxxx/ 106eval $CHILD2_1_SELECT_ARGUMENT1; 107eval $CHILD2_1_SELECT_TABLES; 108 109--connection child2_2 110--replace_regex /tmp_spider_bka_0x[0-9a-f]*/tmp_spider_bka_xxxx/ 111eval $CHILD2_2_SELECT_ARGUMENT1; 112eval $CHILD2_2_SELECT_TABLES; 113 114--connection master_1 115eval $MASTER_1_SET_QUICK_PAGE_BYTE_0; 116 117--echo 118--echo select test 3 119 120--connection child2_1 121TRUNCATE TABLE mysql.general_log; 122 123--connection child2_2 124TRUNCATE TABLE mysql.general_log; 125 126--connection master_1 127SELECT a.pkey FROM tbl_a a, tbl_b b WHERE a.pkey = b.pkey; 128 129--connection child2_1 130--replace_regex /tmp_spider_bka_0x[0-9a-f]*/tmp_spider_bka_xxxx/ 131eval $CHILD2_1_SELECT_ARGUMENT1; 132eval $CHILD2_1_SELECT_TABLES; 133 134--connection child2_2 135--replace_regex /tmp_spider_bka_0x[0-9a-f]*/tmp_spider_bka_xxxx/ 136eval $CHILD2_2_SELECT_ARGUMENT1; 137eval $CHILD2_2_SELECT_TABLES; 138 139--echo 140--echo deinit 141--disable_warnings 142--connection master_1 143DROP DATABASE IF EXISTS auto_test_local; 144 145--connection child2_1 146DROP DATABASE IF EXISTS auto_test_remote; 147SET GLOBAL log_output = @old_log_output; 148 149--connection child2_2 150DROP DATABASE IF EXISTS auto_test_remote2; 151SET GLOBAL log_output = @old_log_output; 152 153--enable_warnings 154--source ../include/quick_mode_2_deinit.inc 155--echo 156--echo end of test 157