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