1
#multi delete replication bugs
4
source include/master-slave.inc;
6
#BUG#11139 - improper wild-table and table rules
7
#checking for multi deletes with an alias
11
create database mysqltest_from;
15
create database mysqltest_to;
21
drop table if exists a;
23
CREATE TABLE a (i INT);
24
INSERT INTO a VALUES(1);
25
DELETE alias FROM a alias WHERE alias.i=1;
27
insert into a values(2),(3);
28
delete a alias FROM a alias where alias.i=2;
39
create table t1 (a int primary key);
40
create table t2 (a int);
42
insert into t1 values (1);
43
insert into t2 values (1);
45
delete t1.* from t1, t2 where t1.a = t2.a;
52
# BUG#3461 would cause sync to fail
62
drop database mysqltest_from;
65
drop database mysqltest_to;