Debian Codegraph @

mysql-test/suite/rpl/r/rpl_iodku,stmt.rdiff

raw
1 --- r/rpl_iodku.result
2 +++ r/rpl_iodku,stmt.reject
3 @@ -1,10 +1,15 @@
4 include/master-slave.inc
5 [connection master]
6 +call mtr.add_suppression("Unsafe statement written to the binary log using statement");
7 CREATE TABLE t1 (id INT PRIMARY KEY AUTO_INCREMENT, a INT, b INT, c INT,
8 UNIQUE (a), UNIQUE (b)) ENGINE=innodb;
9 INSERT INTO t1 (`a`,`c`) VALUES (1,1), (2,1) ON DUPLICATE KEY UPDATE c = 1;
10 +Warnings:
11 +Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT... ON DUPLICATE KEY UPDATE on a table with more than one UNIQUE KEY is unsafe
12 # UNSAFE
13 INSERT INTO t1 (`a`,`c`) VALUES (3, 1),(2,1), (1,1) ON DUPLICATE KEY UPDATE c = a * 10 + VALUES(c);
14 +Warnings:
15 +Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT... ON DUPLICATE KEY UPDATE on a table with more than one UNIQUE KEY is unsafe
16 SELECT * from t1;
17 id a b c
18 1 1 NULL 11
19 @@ -17,6 +22,8 @@
20 INSERT INTO t1 VALUES (1,10,1);
21 # eligable for the statement format run unsafe warning
22 INSERT INTO t1 VALUES (2,20,2) ON DUPLICATE KEY UPDATE c = 100;
23 +Warnings:
24 +Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT... ON DUPLICATE KEY UPDATE on a table with more than one UNIQUE KEY is unsafe
25 # not eligable: no warning in the statement format run
26 INSERT INTO t1 (`a`,`c`) VALUES (3, 1) ON DUPLICATE KEY UPDATE c = 99;
27 SELECT * from t1;