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