Debian Codegraph @

mysql-test/suite/binlog/r/binlog_mysqlbinlog_intvar.result

raw
1 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. *");
2 RESET MASTER;
3 CREATE TABLE t1 (i INT);
4 CREATE TABLE t2 (j INT PRIMARY KEY AUTO_INCREMENT);
5 SET @foo = 1;
6 INSERT INTO t1 VALUES (@foo);
7 INSERT INTO t1 VALUES (rand() * 10);
8 Warnings:
9 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 replica.
10 INSERT INTO t2 VALUES();
11 DROP TABLE t1;
12 DROP TABLE t2;
13 RESET MASTER;
14 include/assert.inc [The t1 table should have two entries.]
15 include/assert.inc [The t2 table should have one entry.]
16 DROP TABLE t1;
17 DROP TABLE t2;
18 RESET MASTER;