1--source ../include/checksum_table_with_quick_mode_3_init.inc 2--echo 3--echo this test is for MDEV-16279 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--enable_warnings 18 19--echo 20--echo create table and insert 21 22--connection child2_1 23--disable_query_log 24echo CHILD2_1_CREATE_TABLES; 25eval $CHILD2_1_CREATE_TABLES; 26--enable_query_log 27TRUNCATE TABLE mysql.general_log; 28 29--connection master_1 30--disable_query_log 31echo CREATE TABLE tbl_a ( 32 pkey int NOT NULL, 33 PRIMARY KEY (pkey) 34) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT_2_1; 35eval CREATE TABLE tbl_a ( 36 pkey int NOT NULL, 37 PRIMARY KEY (pkey) 38) $MASTER_1_ENGINE $MASTER_1_CHARSET $MASTER_1_COMMENT_2_1; 39--enable_query_log 40INSERT INTO tbl_a (pkey) VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); 41INSERT INTO tbl_a (pkey) VALUES (10),(11),(12),(13),(14),(15),(16),(17),(18),(19); 42INSERT INTO tbl_a (pkey) VALUES (20),(21),(22),(23),(24),(25),(26),(27),(28),(29); 43FLUSH TABLES; 44 45--echo 46--echo select test 1 47 48--connection child2_1 49TRUNCATE TABLE mysql.general_log; 50 51--connection master_1 52CHECKSUM TABLE tbl_a EXTENDED; 53 54--connection child2_1 55eval $CHILD2_1_SELECT_ARGUMENT1; 56eval $CHILD2_1_SELECT_TABLES; 57 58--echo 59--echo deinit 60--disable_warnings 61 62--connection master_1 63DROP DATABASE IF EXISTS auto_test_local; 64 65--connection child2_1 66DROP DATABASE IF EXISTS auto_test_remote; 67SET GLOBAL log_output = @old_log_output; 68 69--enable_warnings 70--source ../include/checksum_table_with_quick_mode_3_deinit.inc 71--echo 72--echo end of test 73