Debian Codegraph @

mysql-test/suite/rpl/t/rpl_insert.test

raw
1 --echo #
2 --echo # Bug#20821: INSERT DELAYED fails to write some rows to binlog
3 --echo #
4
5 --source include/not_embedded.inc
6 --source include/not_windows.inc
7 --source include/master-slave.inc
8
9 disable_query_log;
10 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
11 enable_query_log;
12
13 --disable_warnings
14 CREATE SCHEMA IF NOT EXISTS mysqlslap;
15 USE mysqlslap;
16 --enable_warnings
17
18 CREATE TABLE t1 (id INT, name VARCHAR(64)) ENGINE=MyISAM;
19
20 sync_slave_with_master;
21 connection master;
22
23 let $query = "INSERT DELAYED INTO t1 VALUES (1, 'Dr. No'), (2, 'From Russia With Love'), (3, 'Goldfinger'), (4, 'Thunderball'), (5, 'You Only Live Twice')";
24 --exec $MYSQL_SLAP --silent --concurrency=5 --iterations=200 --query=$query --delimiter=";"
25
26 # Wait until all the 5000 inserts has been inserted into the table
27 let $wait_condition= SELECT COUNT(*) = 5000 FROM mysqlslap.t1;
28 source include/wait_condition.inc;
29 SELECT COUNT(*) FROM mysqlslap.t1;
30
31 connection slave;
32 # Wait until all the 5000 inserts has been inserted into the table
33 let $wait_condition= SELECT COUNT(*) = 5000 FROM mysqlslap.t1;
34 source include/wait_condition.inc;
35 SELECT COUNT(*) FROM mysqlslap.t1;
36
37 --echo #
38 --echo # Cleanup
39 --echo #
40
41 connection master;
42 USE test;
43 DROP SCHEMA mysqlslap;
44 sync_slave_with_master;
45 --source include/rpl_end.inc