rpl_row_insert_delayed.result 1.15 KB
Newer Older
1 2 3 4 5 6
stop slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
reset master;
reset slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
start slave;
7 8 9 10 11
CREATE SCHEMA IF NOT EXISTS mysqlslap;
USE mysqlslap;
select @@global.binlog_format;
@@global.binlog_format
ROW
12
CREATE TABLE t1 (id INT primary key auto_increment, name VARCHAR(64));
13 14 15 16 17 18 19 20
FLUSH TABLE t1;
SELECT COUNT(*) FROM t1;
COUNT(*)
5000
use mysqlslap;
SELECT COUNT(*) FROM t1;
COUNT(*)
5000
21 22
truncate table t1;
insert delayed into t1 values(10, "my name");
23
flush table t1;
24 25 26 27 28
insert delayed into t1 values(10, "is Bond"), (20, "James Bond");
flush table t1;
select * from t1;
id	name
10	my name
29
20	James Bond
30 31 32
select * from t1;
id	name
10	my name
33
20	James Bond
34 35 36 37 38 39 40 41 42 43 44
delete from t1 where id!=10;
insert delayed into t1 values(20, "is Bond"), (10, "James Bond");
flush table t1;
select * from t1;
id	name
10	my name
20	is Bond
select * from t1;
id	name
10	my name
20	is Bond
45 46
USE test;
DROP SCHEMA mysqlslap;
47 48 49 50 51 52 53 54 55 56 57 58 59 60
use test;
CREATE TABLE t1(a int, UNIQUE(a));
INSERT DELAYED IGNORE INTO t1 VALUES(1);
INSERT DELAYED IGNORE INTO t1 VALUES(1);
flush table t1;
select * from t1;
a
1
On slave
select * from t1;
a
1
drop table t1;
End of 5.0 tests