Debian Codegraph @

mysql-test/suite/rpl_nogtid/t/rpl_stm_mixing_engines.test

raw
1 ###################################################################################
2 # This test cases evaluates the mixture of non-transactional and transcational
3 # tables. For further details, please, read WL#2687 and WL#5072.
4 ###################################################################################
5 --source include/have_binlog_format_statement.inc
6 --source include/set_privilege_checks_user_as_system_user.inc
7 --source include/master-slave.inc
8 --source include/force_myisam_default.inc
9 --source include/have_myisam.inc
10
11 let $engine_type=Innodb;
12 let $database_name=test;
13 --source extra/rpl_tests/rpl_mixing_engines.test
14
15 #
16 # BUG#49522: Replication problem with mixed MyISAM/InnoDB
17 #
18
19 --source include/rpl_reset.inc
20 -- connection master
21
22 CREATE TABLE `t1` (
23 `c1` int(10) unsigned NOT NULL AUTO_INCREMENT,
24 `c2` tinyint(1) unsigned DEFAULT NULL,
25 `c3` varchar(300) DEFAULT NULL,
26 `c4` int(10) unsigned NOT NULL,
27 `c5` int(10) unsigned DEFAULT NULL,
28 PRIMARY KEY (`c1`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;
29
30 --source include/sync_slave_sql_with_master.inc
31 ALTER TABLE `t1` Engine=InnoDB;
32
33 -- connection master
34 SET AUTOCOMMIT=0;
35
36 INSERT INTO t1 (c1,c2,c3,c4,c5) VALUES (1, 1, 'X', 1, NULL);
37 COMMIT;
38 ROLLBACK;
39 SET AUTOCOMMIT=1;
40
41 --source include/sync_slave_sql_with_master.inc
42
43 -- let $diff_tables= master:t1, slave:t1
44 -- source include/diff_tables.inc
45
46 -- connection master
47 DROP TABLE `t1`;
48 --source include/sync_slave_sql_with_master.inc
49
50 --source include/rpl_end.inc