1 include/master-slave.inc
5 CREATE TABLE tinnodb (a INT) ENGINE = INNODB;
6 SHOW CREATE TABLE tinnodb;
8 tinnodb CREATE TABLE `tinnodb` (
9 `a` int(11) DEFAULT NULL
10 ) ENGINE=InnoDB DEFAULT CHARSET=latin1
11 set @old_debug= @@debug;
12 set @@debug= 'd,do_not_write_xid';
14 INSERT INTO tinnodb VALUES (1);
15 SELECT * FROM tinnodb ORDER BY a;
19 include/sync_slave_io_with_master.inc
20 ==== Verify results on slave ====
21 include/stop_slave.inc
22 SELECT "" AS Slave_IO_State;
25 SELECT "" AS Last_SQL_Error;
28 SELECT "" AS Last_IO_Error;
31 SELECT * FROM tinnodb ORDER BY a;
36 set @@debug= @old_debug;