mirror of
https://github.com/MariaDB/server.git
synced 2025-02-09 23:24:11 +01:00
50 lines
1.4 KiB
Text
50 lines
1.4 KiB
Text
###################################################################################
|
|
# This test cases evaluates the mixture of non-transactional and transcational
|
|
# tables. For further details, please, read WL#2687 and WL#5072.
|
|
###################################################################################
|
|
--source include/have_binlog_format_statement.inc
|
|
--source include/have_innodb.inc
|
|
# MDEV-31790 FIXME: This test is extremely slow
|
|
--source include/not_msan.inc
|
|
--source include/master-slave.inc
|
|
|
|
let $engine_type=Innodb;
|
|
let $database_name=test;
|
|
--source include/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
|