← Back to branch summary

~stewart/drizzle/embedded-innodb-create-select-transaction-arrgh

« back to all changes in this revision

Viewing changes to mysql-test/suite/rpl/r/rpl_row_trig002.result

  • Committer: brian
  • Date: 2008-06-25 05:29:13 UTC
  • Revision ID: brian@localhost.localdomain-20080625052913-6upwo0jsrl4lnapl
clean slate

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/rpl/r/rpl_row_trig002.result
 
1
stop slave;
 
2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
 
3
reset master;
 
4
reset slave;
 
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
 
6
start slave;
 
7
DROP TRIGGER test.t2_ai;
 
8
DROP TABLE IF EXISTS test.t1;
 
9
DROP TABLE IF EXISTS test.t2;
 
10
DROP TABLE IF EXISTS test.t3;
 
11
CREATE TABLE test.t2 (value CHAR(30),domain_id INT, mailaccount_id INT, program CHAR(30),keey CHAR(30),PRIMARY KEY(domain_id));
 
12
CREATE TABLE test.t3 (value CHAR(30),domain_id INT, mailaccount_id INT, program CHAR(30),keey CHAR(30),PRIMARY KEY(domain_id));
 
13
CREATE TABLE test.t1 (id INT,domain CHAR(30),PRIMARY KEY(id));
 
14
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'|
 
15
INSERT INTO test.t1 VALUES (1, 'example.com'),(2, 'mysql.com'),(3, 'earthmotherwear.com'), (4, 'yahoo.com'),(5, 'example.com');
 
16
SELECT * FROM test.t1 ORDER BY id;
 
17
id      domain
 
18
1       example.com
 
19
2       mysql.com
 
20
3       earthmotherwear.com
 
21
4       yahoo.com
 
22
5       example.com
 
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;
 
37
value   domain_id       mailaccount_id  program keey
 
38
No      5       NULL    spamfilter      scan_incoming
 
39
Yes     1       NULL    spamfilter      scan_incoming
 
40
select * from test.t2;
 
41
value   domain_id       mailaccount_id  program keey
 
42
Yes     1       NULL    spamfilter      scan_incoming
 
43
select * from test.t3;
 
44
value   domain_id       mailaccount_id  program keey
 
45
No      5       NULL    spamfilter      scan_incoming
 
46
Yes     1       NULL    spamfilter      scan_incoming
 
47
DELETE FROM test.t1 WHERE id = 1;
 
48
SELECT * FROM test.t1 ORDER BY id;
 
49
id      domain
 
50
2       mysql.com
 
51
3       earthmotherwear.com
 
52
4       yahoo.com
 
53
5       example.com
 
54
SELECT * FROM test.t1 ORDER BY id;
 
55
id      domain
 
56
2       mysql.com
 
57
3       earthmotherwear.com
 
58
4       yahoo.com
 
59
5       example.com
 
60
SELECT * FROM test.t1 ORDER BY id;
 
61
id      domain
 
62
2       mysql.com
 
63
3       earthmotherwear.com
 
64
4       yahoo.com
 
65
5       example.com
 
66
DROP TRIGGER test.t2_ai;
 
67
DROP TABLE test.t1;
 
68
DROP TABLE test.t2;
 
69
DROP TABLE test.t3;