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/rpl/t/rpl_stm_mixing_engines.test
--source include/have_binlog_format_statement.inc
--source include/master-slave.inc
--source include/have_innodb.inc

--source extra/rpl_tests/rpl_mixing_engines.test

#
# BUG#49522: Replication problem with mixed MyISAM/InnoDB
#

--source include/rpl_reset.inc
-- connection master

CREATE TABLE `t1` ( 
  `c1` int(10) unsigned NOT NULL AUTO_INCREMENT, 
  `c2` tinyint(1) unsigned DEFAULT NULL, 
  `c3` varchar(300) DEFAULT NULL, 
  `c4` int(10) unsigned NOT NULL, 
  `c5` int(10) unsigned DEFAULT NULL, 
  PRIMARY KEY (`c1`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- sync_slave_with_master
ALTER TABLE `t1` Engine=InnoDB;

-- connection master
SET AUTOCOMMIT=0;

INSERT INTO t1 (c1,c2,c3,c4,c5) VALUES (1, 1, 'X', 1, NULL);
COMMIT;
ROLLBACK;
SET AUTOCOMMIT=1;

-- sync_slave_with_master

-- let $diff_tables= master:t1, slave:t1
-- source include/diff_tables.inc

-- connection master
DROP TABLE `t1`;
-- sync_slave_with_master

--source include/rpl_end.inc