Debian Codegraph @

mysql-test/suite/engines/funcs/r/rpl_multi_delete2.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 set sql_log_bin=0;
5 create database mysqltest_from;
6 set sql_log_bin=1;
7 connection slave;
8 create database mysqltest_to;
9 connection master;
10 use mysqltest_from;
11 drop table if exists a;
12 CREATE TABLE a (i INT);
13 INSERT INTO a VALUES(1);
14 DELETE alias FROM a alias WHERE alias.i=1;
15 SELECT * FROM a;
16 i
17 insert into a values(2),(3);
18 delete alias FROM a alias where alias.i=2;
19 select * from a;
20 i
21 3
22 connection slave;
23 use mysqltest_to;
24 select * from a;
25 i
26 3
27 connection master;
28 create table t1 (a int primary key);
29 create table t2 (a int);
30 insert into t1 values (1);
31 insert into t2 values (1);
32 delete t1.* from t1, t2 where t1.a = t2.a;
33 select * from t1;
34 a
35 select * from t2;
36 a
37 1
38 connection slave;
39 select * from t1;
40 ERROR 42S02: Table 'mysqltest_to.t1' doesn't exist
41 select * from t2;
42 ERROR 42S02: Table 'mysqltest_to.t2' doesn't exist
43 connection master;
44 set sql_log_bin=0;
45 drop database mysqltest_from;
46 set sql_log_bin=1;
47 connection slave;
48 drop database mysqltest_to;
49 include/rpl_end.inc