diff options
Diffstat (limited to 'mysql-test/r/rpl_row_trig002.result')
| -rw-r--r-- | mysql-test/r/rpl_row_trig002.result | 69 |
1 files changed, 0 insertions, 69 deletions
diff --git a/mysql-test/r/rpl_row_trig002.result b/mysql-test/r/rpl_row_trig002.result deleted file mode 100644 index 794104db750..00000000000 --- a/mysql-test/r/rpl_row_trig002.result +++ /dev/null @@ -1,69 +0,0 @@ -stop slave; -drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; -reset master; -reset slave; -drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9; -start slave; -DROP TRIGGER test.t2_ai; -DROP TABLE IF EXISTS test.t1; -DROP TABLE IF EXISTS test.t2; -DROP TABLE IF EXISTS test.t3; -CREATE TABLE test.t2 (value CHAR(30),domain_id INT, mailaccount_id INT, program CHAR(30),keey CHAR(30),PRIMARY KEY(domain_id)); -CREATE TABLE test.t3 (value CHAR(30),domain_id INT, mailaccount_id INT, program CHAR(30),keey CHAR(30),PRIMARY KEY(domain_id)); -CREATE TABLE test.t1 (id INT,domain CHAR(30),PRIMARY KEY(id)); -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'| -INSERT INTO test.t1 VALUES (1, 'example.com'),(2, 'mysql.com'),(3, 'earthmotherwear.com'), (4, 'yahoo.com'),(5, 'example.com'); -SELECT * FROM test.t1 ORDER BY id; -id domain -1 example.com -2 mysql.com -3 earthmotherwear.com -4 yahoo.com -5 example.com -SELECT * FROM test.t1 ORDER BY id; -id domain -1 example.com -2 mysql.com -3 earthmotherwear.com -4 yahoo.com -5 example.com -INSERT INTO test.t3 VALUES ('Yes', 5, NULL, 'spamfilter','scan_incoming'); -INSERT INTO test.t3 VALUES ('Yes', 1, NULL, 'spamfilter','scan_incoming'); -INSERT INTO test.t2 VALUES ('Yes', 1, NULL, 'spamfilter','scan_incoming'); -select * from test.t2; -value domain_id mailaccount_id program keey -Yes 1 NULL spamfilter scan_incoming -select * from test.t3; -value domain_id mailaccount_id program keey -No 5 NULL spamfilter scan_incoming -Yes 1 NULL spamfilter scan_incoming -select * from test.t2; -value domain_id mailaccount_id program keey -Yes 1 NULL spamfilter scan_incoming -select * from test.t3; -value domain_id mailaccount_id program keey -No 5 NULL spamfilter scan_incoming -Yes 1 NULL spamfilter scan_incoming -DELETE FROM test.t1 WHERE id = 1; -SELECT * FROM test.t1 ORDER BY id; -id domain -2 mysql.com -3 earthmotherwear.com -4 yahoo.com -5 example.com -SELECT * FROM test.t1 ORDER BY id; -id domain -2 mysql.com -3 earthmotherwear.com -4 yahoo.com -5 example.com -SELECT * FROM test.t1 ORDER BY id; -id domain -2 mysql.com -3 earthmotherwear.com -4 yahoo.com -5 example.com -DROP TRIGGER test.t2_ai; -DROP TABLE test.t1; -DROP TABLE test.t2; -DROP TABLE test.t3; |