Debian Codegraph @

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

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 DROP TRIGGER test.t2_ai;
7 DROP TABLE IF EXISTS test.t1;
8 DROP TABLE IF EXISTS test.t2;
9 DROP TABLE IF EXISTS test.t3;
10 CREATE TABLE test.t2 (value CHAR(30),domain_id INT, mailaccount_id INT, program CHAR(30),keey CHAR(30),PRIMARY KEY(domain_id));
11 CREATE TABLE test.t3 (value CHAR(30),domain_id INT, mailaccount_id INT, program CHAR(30),keey CHAR(30),PRIMARY KEY(domain_id));
12 CREATE TABLE test.t1 (id INT,domain CHAR(30),PRIMARY KEY(id));
13 CREATE TRIGGER test.t2_ai AFTER INSERT ON test.t2 FOR EACH ROW UPDATE test.t3 ms, test.t1 d SET ms.value='No' WHERE ms.domain_id = (SELECT max(id) FROM test.t1 WHERE domain='example.com') AND ms.mailaccount_id IS NULL AND ms.program='spamfilter' AND ms.keey='scan_incoming'|
14 INSERT INTO test.t1 VALUES (1, 'example.com'),(2, 'mysql.com'),(3, 'earthmotherwear.com'), (4, 'yahoo.com'),(5, 'example.com');
15 SELECT * FROM test.t1 ORDER BY id;
16 id domain
17 1 example.com
18 2 mysql.com
19 3 earthmotherwear.com
20 4 yahoo.com
21 5 example.com
22 include/sync_slave_sql_with_master.inc
23 SELECT * FROM test.t1 ORDER BY id;
24 id domain
25 1 example.com
26 2 mysql.com
27 3 earthmotherwear.com
28 4 yahoo.com
29 5 example.com
30 INSERT INTO test.t3 VALUES ('Yes', 5, NULL, 'spamfilter','scan_incoming');
31 INSERT INTO test.t3 VALUES ('Yes', 1, NULL, 'spamfilter','scan_incoming');
32 INSERT INTO test.t2 VALUES ('Yes', 1, NULL, 'spamfilter','scan_incoming');
33 select * from test.t2;
34 value domain_id mailaccount_id program keey
35 Yes 1 NULL spamfilter scan_incoming
36 select * from test.t3 order by value;
37 value domain_id mailaccount_id program keey
38 No 5 NULL spamfilter scan_incoming
39 Yes 1 NULL spamfilter scan_incoming
40 include/sync_slave_sql_with_master.inc
41 select * from test.t2;
42 value domain_id mailaccount_id program keey
43 Yes 1 NULL spamfilter scan_incoming
44 select * from test.t3 order by value;
45 value domain_id mailaccount_id program keey
46 No 5 NULL spamfilter scan_incoming
47 Yes 1 NULL spamfilter scan_incoming
48 DELETE FROM test.t1 WHERE id = 1;
49 SELECT * FROM test.t1 ORDER BY id;
50 id domain
51 2 mysql.com
52 3 earthmotherwear.com
53 4 yahoo.com
54 5 example.com
55 SELECT * FROM test.t1 ORDER BY id;
56 id domain
57 2 mysql.com
58 3 earthmotherwear.com
59 4 yahoo.com
60 5 example.com
61 include/sync_slave_sql_with_master.inc
62 SELECT * FROM test.t1 ORDER BY id;
63 id domain
64 2 mysql.com
65 3 earthmotherwear.com
66 4 yahoo.com
67 5 example.com
68 DROP TRIGGER test.t2_ai;
69 DROP TABLE test.t1;
70 DROP TABLE test.t2;
71 DROP TABLE test.t3;
72 include/sync_slave_sql_with_master.inc
73 include/rpl_end.inc