Edit File: binlog_stm_ps.test
# This test is to verify replication with PS -- source include/not_embedded.inc -- source include/have_binlog_format_statement.inc disable_query_log; call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT"); enable_query_log; -- disable_query_log reset master; # get rid of previous tests binlog -- enable_query_log --disable_warnings drop table if exists t1; --enable_warnings reset master; # # Bug #26842: master binary log contains invalid queries - replication fails # create table t1 (a int); prepare s from "insert into t1 values (@a),(?)"; set @a=98; execute s using @a; prepare s from "insert into t1 values (?)"; set @a=99; execute s using @a; prepare s from "insert into t1 select 100 limit ?"; set @a=100; execute s using @a; source include/show_binlog_events.inc; drop table t1;
Back to File Manager