Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 CREATE SCHEMA IF NOT EXISTS mysqlslap;
5 USE mysqlslap;
6 CREATE TABLE t1 (id INT primary key auto_increment, name VARCHAR(64)) ENGINE=MyISAM;
7 FLUSH TABLE t1;
8 SELECT COUNT(*) FROM t1;
9 COUNT(*)
10 5000
11 connection slave;
12 use mysqlslap;
13 SELECT COUNT(*) FROM t1;
14 COUNT(*)
15 5000
16 connection master;
17 truncate table t1;
18 insert delayed into t1 values(10, "my name");
19 flush table t1;
20 insert delayed into t1 values(10, "is Bond"), (20, "James Bond");
21 flush table t1;
22 select * from t1;
23 id name
24 10 my name
25 20 James Bond
26 connection slave;
27 select * from t1;
28 id name
29 10 my name
30 20 James Bond
31 connection master;
32 delete from t1 where id!=10;
33 insert delayed into t1 values(20, "is Bond"), (10, "James Bond");
34 flush table t1;
35 select * from t1;
36 id name
37 10 my name
38 20 is Bond
39 connection slave;
40 select * from t1;
41 id name
42 10 my name
43 20 is Bond
44 connection master;
45 USE test;
46 DROP SCHEMA mysqlslap;
47 connection slave;
48 use test;
49 connection master;
50 CREATE TABLE t1(a int, UNIQUE(a));
51 INSERT DELAYED IGNORE INTO t1 VALUES(1);
52 INSERT DELAYED IGNORE INTO t1 VALUES(1);
53 flush table t1;
54 select * from t1;
55 a
56 1
57 connection slave;
58 On slave
59 select * from t1;
60 a
61 1
62 connection master;
63 drop table t1;
64 connection slave;
65 connection master;
66 End of 5.0 tests
67 include/rpl_end.inc