1#multi delete replication bugs
2
3
4source include/master-slave.inc;
5
6#BUG#11139 - improper wild-table and table rules
7#checking for multi deletes with an alias
8
9connection master;
10set sql_log_bin=0;
11create database mysqltest_from;
12set sql_log_bin=1;
13
14connection slave;
15create database mysqltest_to;
16
17
18connection master;
19use mysqltest_from;
20--disable_warnings
21drop table if exists a;
22--enable_warnings
23CREATE TABLE a (i INT);
24INSERT INTO a VALUES(1);
25DELETE alias FROM a alias WHERE alias.i=1;
26SELECT * FROM a;
27insert into a values(2),(3);
28delete alias FROM a alias where alias.i=2;
29select * from a;
30sync_slave_with_master;
31
32use mysqltest_to;
33select * from a;
34
35# BUG#3461
36connection master;
37create table t1 (a int primary key);
38create table t2 (a int);
39
40insert into t1 values (1);
41insert into t2 values (1);
42
43delete t1.* from t1, t2 where t1.a = t2.a;
44
45save_master_pos;
46select * from t1;
47select * from t2;
48
49connection slave;
50# BUG#3461 would cause sync to fail
51sync_with_master;
52error 1146;
53select * from t1;
54error 1146;
55select * from t2;
56
57# cleanup
58connection master;
59set sql_log_bin=0;
60drop database mysqltest_from;
61set sql_log_bin=1;
62connection slave;
63drop database mysqltest_to;
64
65# End of 4.1 tests
66
67--source include/rpl_end.inc
68