Debian Codegraph @

mysql-test/suite/binlog/t/binlog_stm_ps.test

raw
1
2 # This test is to verify replication with PS
3
4 -- source include/have_binlog_format_statement.inc
5
6 disable_query_log;
7 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
8 enable_query_log;
9
10 -- disable_query_log
11 reset master; # get rid of previous tests binlog
12 -- enable_query_log
13
14 --disable_warnings
15 drop table if exists t1;
16 --enable_warnings
17 reset master;
18
19 #
20 # Bug #26842: master binary log contains invalid queries - replication fails
21 #
22 create table t1 (a int);
23 prepare s from "insert into t1 values (@a),(?)";
24 set @a=98; execute s using @a;
25 prepare s from "insert into t1 values (?)";
26 set @a=99; execute s using @a;
27 prepare s from "insert into t1 select 100 limit ?";
28 set @a=100; execute s using @a;
29 --let $mask_binlog_commit_events= 1
30 source include/show_binlog_events.inc;
31 --let $mask_binlog_commit_events= 0
32 drop table t1;