Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 CREATE TABLE t1 (id INT PRIMARY KEY AUTO_INCREMENT, a INT, b INT, c INT,
4 UNIQUE (a), UNIQUE (b)) ENGINE=innodb;
5 INSERT INTO t1 (`a`,`c`) VALUES (1,1), (2,1) ON DUPLICATE KEY UPDATE c = 1;
6 # UNSAFE
7 INSERT INTO t1 (`a`,`c`) VALUES (3, 1),(2,1), (1,1) ON DUPLICATE KEY UPDATE c = a * 10 + VALUES(c);
8 SELECT * from t1;
9 id a b c
10 1 1 NULL 11
11 2 2 NULL 21
12 3 3 NULL 1
13 connection slave;
14 include/diff_tables.inc [master:t1,slave:t1]
15 connection master;
16 CREATE OR REPLACE TABLE t1 (a INT, b INT, c INT, UNIQUE (a), UNIQUE (b)) ENGINE=innodb;
17 INSERT INTO t1 VALUES (1,10,1);
18 # eligable for the statement format run unsafe warning
19 INSERT INTO t1 VALUES (2,20,2) ON DUPLICATE KEY UPDATE c = 100;
20 # not eligable: no warning in the statement format run
21 INSERT INTO t1 (`a`,`c`) VALUES (3, 1) ON DUPLICATE KEY UPDATE c = 99;
22 SELECT * from t1;
23 a b c
24 1 10 1
25 2 20 2
26 3 NULL 1
27 connection slave;
28 include/diff_tables.inc [master:t1,slave:t1]
29 connection master;
30 DROP TABLE t1;
31 connection slave;
32 include/rpl_end.inc