MOON
Server: Apache/2.2.34 (Unix) mod_ssl/2.2.34 OpenSSL/0.9.8e-fips-rhel5 mod_bwlimited/1.4 FrontPage/5.0.2.2635
System: Linux server.asjudinet.com 2.6.32-042stab141.3 #1 SMP Fri Nov 15 22:45:34 MSK 2019 i686
User: asjudine (504)
PHP: 5.2.17
Disabled: NONE
Upload Files
File: //usr/share/mysql-test/suite/binlog/t/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
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;