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