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