Debian Codegraph @

mysql-test/suite/rpl/r/rpl_gtid_misc.result

raw
1 include/master-slave.inc
2 [connection master]
3 *** MDEV-6403: Temporary tables lost at STOP SLAVE in GTID mode if master has not rotated binlog since restart ***
4 connection master;
5 CREATE TABLE t1 (a INT PRIMARY KEY);
6 connection slave;
7 connection slave;
8 include/stop_slave.inc
9 SET sql_log_bin= 0;
10 INSERT INTO t1 VALUES (1);
11 SET sql_log_bin= 1;
12 connection master;
13 CREATE TEMPORARY TABLE t2 LIKE t1;
14 INSERT INTO t2 VALUE (1);
15 INSERT INTO t1 SELECT * FROM t2;
16 DROP TEMPORARY TABLE t2;
17 connection slave;
18 START SLAVE;
19 include/wait_for_slave_sql_error.inc [errno=1062]
20 STOP SLAVE IO_THREAD;
21 SET sql_log_bin= 0;
22 DELETE FROM t1 WHERE a=1;
23 SET sql_log_bin= 1;
24 include/start_slave.inc
25 SELECT * FROM t1 ORDER BY a;
26 a
27 1
28 connection master;
29 DROP TABLE t1;
30 include/rpl_end.inc