Edit File: rpl_bug26395.result
include/master-slave.inc [connection master] ==== Initialize ==== [on master] CREATE TABLE tinnodb (a INT) ENGINE = INNODB; SHOW CREATE TABLE tinnodb; Table Create Table tinnodb CREATE TABLE `tinnodb` ( `a` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 set @old_debug= @@debug; set @@debug= 'd,do_not_write_xid'; ==== Test ==== INSERT INTO tinnodb VALUES (1); SELECT * FROM tinnodb ORDER BY a; a 1 [on slave] include/sync_slave_io_with_master.inc ==== Verify results on slave ==== include/stop_slave.inc SELECT "" AS Slave_IO_State; Slave_IO_State SELECT "" AS Last_SQL_Error; Last_SQL_Error SELECT "" AS Last_IO_Error; Last_IO_Error SELECT * FROM tinnodb ORDER BY a; a ==== Clean up ==== [on master] DROP TABLE tinnodb; set @@debug= @old_debug; [on slave] DROP TABLE tinnodb; include/rpl_end.inc
Back to File Manager