Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 connection slave;
4 include/stop_slave_sql.inc
5 connection master;
6 CALL mtr.add_suppression("Statement is unsafe because it uses a system function that may return a different value on the slave");
7 create table t1 (i int);
8 insert into t1 values (1),(2);
9 insert into t1 values (3),(4);
10 insert into t1 select i+20+0*sleep(1) from t1 where i=1;
11 Warnings:
12 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave
13 flush logs;
14 insert into t1 values (5),(6);
15 insert into t1 values (7),(8);
16 insert into t1 values (9),(10);
17 insert into t1 values (11),(12);
18 insert into t1 values (13),(14);
19 insert into t1 values (15),(16);
20 connection slave;
21 set global slave_parallel_threads = 1;
22 start slave until master_log_file='MASTER_FILE', master_log_pos=MASTER_POS;
23 drop table t1;
24 include/stop_slave_io.inc
25 set global slave_parallel_threads = DEFAULT;
26 connection master;
27 drop table t1;
28 include/rpl_end.inc