--source include/not_ndb_default.inc
--source include/have_innodb.inc
--source include/master-slave.inc
let $engine_type= "InnoDB";

sync_slave_with_master;
connection master;
SET AUTOCOMMIT = 1;

--disable_warnings
DROP DATABASE IF EXISTS mysqltest1;
--enable_warnings

CREATE DATABASE mysqltest1;
CREATE TEMPORARY TABLE mysqltest1.tmp (f1 BIGINT);
eval CREATE TABLE mysqltest1.t1 (f1 BIGINT) ENGINE=$engine_type;
# SHOW CREATE TABLE mysqltest1.t1;
SET AUTOCOMMIT = 0;

sync_slave_with_master;
--echo -------- switch to slave --------
connection slave;
# SHOW CREATE TABLE mysqltest1.t1;
SET AUTOCOMMIT = 1;

--echo -------- switch to master --------
connection master;
INSERT INTO mysqltest1.t1 SET f1= 1;
DROP TEMPORARY TABLE mysqltest1.tmp;
ROLLBACK;
--disable_abort_on_error
SHOW CREATE TABLE mysqltest1.tmp;
SELECT * FROM mysqltest1.t1;

sync_slave_with_master;
--echo -------- switch to slave --------
connection slave;
SELECT * FROM mysqltest1.t1;

--echo Do we have a simple straight forward statement based replication
--echo aka replication injects the statements executed on the master
--echo     just on the slave and gets a different content because
--echo     t1 (MyISAM on slave) is not affected by ROLLBACK ?
--echo -------- switch to master --------
connection master;
TRUNCATE mysqltest1.t1;
SELECT * FROM mysqltest1.t1;

sync_slave_with_master;
--echo -------- switch to slave --------
connection slave;
SELECT * FROM mysqltest1.t1;

--echo -------- switch to master --------
connection master;
INSERT INTO mysqltest1.t1 SET f1= 1;
INSERT INTO mysqltest1.t1 SET f1= 2;
SELECT * FROM mysqltest1.t1;
ROLLBACK;
SELECT * FROM mysqltest1.t1;

sync_slave_with_master;
--echo -------- switch to slave --------
connection slave;
SELECT * FROM mysqltest1.t1;
FLUSH LOGS;
SHOW BINLOG EVENTS IN 'slave-bin.000001';
SHOW BINLOG EVENTS IN 'slave-bin.000002';

--echo -------- switch to master --------
connection master;
FLUSH LOGS;
SHOW BINLOG EVENTS IN 'master-bin.000001';
SHOW BINLOG EVENTS IN 'master-bin.000002';

DROP DATABASE mysqltest1;
-- source include/master-slave-end.inc